By using this website, you agree to our Terms of Use (click here)
I am trying to build a report which shows the Item, Shipped Qty and Total Amount of qty shipped
Item | Shipped Qty | Total Amt for qty shipped | Back Orders | Total Amt of backorders | Fill Rate %
* (BackOrders is a custom field named UsrBackOrders in SOShipment table on Shipments screen)
I also want to add a column for Fill Rate % which will show result of (BackOrders/ShippedQty) in %
Is there a better way to buid this report other than using report designer?
Sorry, I don't need the total amount column.
So now I have
Item | Shipped Qty | Backorders | Fill Rate %
How to Calculate Fill Rate%?
Fill rate % = (ShippedQty - Backorders)/ShippedQty *100
I figured out the formula for Fill Rate %, but the shipped qty column does not show the correct value. so could you please take a look at the attached report.
Was not able to attach the .rps file in the post because it said File type not allowed.
The Active Migration checkbox is not checked in the AP screen
Right, I need the RPX file, not the RPS file. What you attached says RPX, but I can tell by opening it that it's actually an RPS file.
Here is an explanation of the difference between RPS and RPX files in Report Designer:
https://www.augforums.com/acumatica-rps-versus-rpx-file-types/
Also, sorry about the Activate Migration Mode post. That was meant for another discussion Topic. I just deleted it so it won't be confusing for people reading this in the future.
Hey @sunwayfan,
It looks like you actually attached the .RPS file, not the .RPX file. Can you open the report in Report Designer and save as .RPX? That will get the correct file type.
Thanks @sunwayfan.
I took a look at the report and it seems fine to me. I realized that I can't actually run it because it requires the custom UsrBackOrders field that you mentioned above which I don't have.
Including a screenshot here so others reading this post can have a visual:
Are you getting a value populated in the BackOrder column (based on [SOShipment.UsrBackOrders])? Sometimes custom fields calculate on-the-fly in the screen so they don't actually have data when you query them directly in a report.
If you do get a value in the BackOrder column, I don't see any reason why the formula in your Fill Rate% shouldn't work. Reproducing it here for others reading this post:
=(([SOShipment.ShipmentQty] - [SOShipment.UsrBackOrders])/ [SOShipment.ShipmentQty]) *100
Yes I am getting values in the backorder column.
The issue is that the Shipped Qty values are not correct.
I compared the shipped qty column with the Shipment Summary report and the values weren't matching.
Ah, yes, that would do it. Without Sum(), you just get the first record, not a sum of all the records.
Congrats on getting it working!
Online Members
