End of day report adjustment cost

There is also {REPORT COST DETAILS:X} which will give you the Cost of a Product based on the related Inventory Items for the Product.

You will probably need to use both Cost and Consumption Reporting Tags and [=expression] formulas to compute the values you are looking for.

You can subtract the Physical Inventory (End of Day adjustment amounts) from the Consumption (Sold Items) from the Added quantity (Purchased Items) to get the difference between Predicted Inventory (consumption) and Physical Inventory (adjustments). Then multiply that by the Cost.

You can do very complex things with Reports and combinations of different Report Tags.

1 Like