REPORT CONSUMPTION Tag:C.Inventory

V5 Question
1

Continuing the discussion from REPORT CONSUMPTION Tag: Low Inventory Condition?:

I going to report this as an issue as I do not wish for it to get lost in the threads.

Currently @emre this is no way to address C.Inventory as an Expression in the Report Tag. From the linked posting the only solution is to use C.Instock but this is a fixed value which only is effected by End of Day counts. Most venues will only do counts once a week or even a month.

Your advice would be appreciated, thank you.

2

Inventory is not a database field. This is a helper so can’t be used directly inside expressions. Try C.GetPhysicalInventory() > 2 on expression part.

1 Like
3

SQL discussion…

4

Thank @emre

[Inventory Consumptions:1,1,1,1]
>Item|Warehouse|Inv|Instock
{REPORT CONSUMPTION DETAILS:C.Name,C.Warehouse,C.Inventory.asc,C.InStock:C.GetPhysicalInventory() < 2}

Works Great.

2 Likes