Solved

Report Creation: Viewing Total Cost of a PO Receipt

  • 8 May 2021
  • 1 reply
  • 21 views

We are currently using the Landed Cost feature to accurately cost our inventory. The inventory valuation report shows the updated average cost of the item, but we would prefer a report that displays the total cost of each PO receipt, with the cost per item shown. This is particularly important because our costs shift each time we receive inventory.

Any tips on creating this report?

icon

Best answer by Neil Cantral 10 May 2021, 07:54

Using the POLandedCostReceiptLine table would be a good place to start. This provides the data from the Landed Cost Document Details. You could then group by POReceiptNbr and InventoryID to get a sum of all allocated amounts for that Receipt/Item.

You could then go a step further and create a second GI/report to drilldown into POLandedCostDetail grouping by things like landed cost code or vendor. This could help answer questions like “why is my landed cost increasing on this item? Increases from duty should be captured by now. Yep, it’s my freight costs.”

View original

1 reply

Userlevel 2
Badge +1

Using the POLandedCostReceiptLine table would be a good place to start. This provides the data from the Landed Cost Document Details. You could then group by POReceiptNbr and InventoryID to get a sum of all allocated amounts for that Receipt/Item.

You could then go a step further and create a second GI/report to drilldown into POLandedCostDetail grouping by things like landed cost code or vendor. This could help answer questions like “why is my landed cost increasing on this item? Increases from duty should be captured by now. Yep, it’s my freight costs.”

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2020  Acumatica, Inc. All rights reserved