Adding Inventory cost price to custom Material Usage report

  • 8 March 2022
  • 0 replies

Userlevel 4

Good day

I have a custom Material usage report I built based on a copy of the standard 

Historical Inventory Balance report. 

I am using the “Assembly Out” column which is my consumption as I only work with Assemblies. On the same report I would want to add a column depicts the current or historical material cost of an inventory item. I have tried to add the Last Cost field from the InventoryItem table but this does not bring any results.

What method can I use to have the cost price field reflecting the item cost on the report? 


0 replies

Be the first to 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 — 2024  Acumatica, Inc. All rights reserved