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?