I am using this report to get how inventory has transacted for the day. It works fine but my challenge is how to get the same per ware house. Can someone help? [Inventory Consumption:2, 1,1, 1, 1, 1, 1, 1] >Item|Used|Unit|CloStock|OpStock|Added|Removed|Variance {REPORT CONSUMPTION DETAILS:C.Name.as…

Have a look here [image] Inventory Report Seperation V5 Question That Topic explicitly states that {REPORT INVENTORY} is hard-coded and only accepts a couple parameters. It will not work for your purpose. It is using the {REPORT CONSUMPTION DETAILS:X} Tag, in which you …

Don’t have much experiance in inventory reporting but would imagine as with other reports you would add the warehouse as a report constraint. Where you have consumption>0 you would append ‘AND wherehouse = x’

I am doing this and it does not work. [Inventory Consumption:2, 1,1, 1, 1, 1, 1, 1, 1] >Item|Used|Unit|CloStock|OpStock|Added|Removed|Variance {REPORT CONSUMPTION DETAILS:C.Name.asc,C.Consumption.Sum,C.Warehouse,C.Inventory.Sum,C.InStock.Sum,C.Added.Sum,C.Removed.Sum,[($5-($2+$4))],C.Prediction;0.0…

Is C.Warehouse definitely correct? Does it return value if its put as a column field? I’m on road atm but sure report expressions are single =

Thanks very much it has worked.

Inventory consumption report

V5 Question

JTRTech October 4, 2019, 1:05pm 5

Have a look here