BAQ Safety Stock

Kinetic ERP
1

Hello!

I have a BAQ where I am tying to isolate items that have safety stock.

I am not sure how to phrase the query I need: something like safety stock = true, or show items with safety stock greater than 0.

Can someone help?

Thank you

2

The Safety Stock field is in the PartPlant table, called PartPlant.SafetyQty, and is stored as an integer value, so “PartPlant.SafetyQty > 0” would be the appropriate phrase.

It also means you need to have the PartPlant table in your query.

2 Likes
3

Thank you!