Hello, I am filtering multiple items from the inventory report with {REPORT CONSUMPTION DETAILS}. So far added one condition but want to add another condition on the items I can see in the report.
[Consumption:2,1]
Item|Consumed
{REPORT CONSUMPTION DETAILS: C.Name.asc, C.Consumption.Sum: C.Consumption > 0}
More specifically, the string filters aren’t working. I want to add above condition and filter the items as well. What’s the mistake in this?
Best,
Junaid
Jesse
July 24, 2022, 3:42pm
#2
Try this:
[Consumption:2,1]
Item|Consumed
{REPORT CONSUMPTION DETAILS: C.Name.asc, C.Consumption.Sum:(PCN=Beef Patty) AND C.Consumption > 0}
Jesse
July 24, 2022, 3:54pm
#3
Then you can do some more advanced reports with something like this with pivot tables:
Jesse
July 24, 2022, 3:57pm
#4
Here is same pivot table with some formatting of the design.
Jesse
July 24, 2022, 3:58pm
#5
This is that report:
[!Inventory Consumption:2, 1,1, 1, 1, 1, 1, 1.1]
>Item|[N]Used|Unit|[N]Pred|[N]InStock|[N]Added|[N]Removed|Warehouse
{REPORT CONSUMPTION DETAILS:C.Name.asc,C.Consumption.Sum,C.Unit,C.Inventory.Sum,C.InStock.Sum,C.Added.Sum,C.Removed.Sum,C.Warehouse:C.Consumption>0}