Inventory consumption report

V5 Question
1

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.asc,C.Consumption.Sum,C.Unit,C.Inventory.Sum,C.InStock.Sum,C.Added.Sum,C.Removed.Sum,[($5-($2+$4))];0.00;-0.00;0.00:C.Consumption>0}
2

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’

3

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.00;-0.00;0.00:C.Consumption>0 && C.Warehouse=="VIP_Store" }

any help?

4

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 =

5

Have a look here

1 Like
6

Thanks very much it has worked.