Definitive Calculation for "Available Qty"

Epicor ERP 10
1

According to table description notes in the BAQ Designer, the purpose of the [Erp.PartQty] table is:

… to summarize Part Quantities for ease in calculating Available Quantity.

Great.

So… how does one calculate “Available Quantity”, assuming that all of the parameters one needs to derive this value are contained within [Erp.PartQty]?

2

I always thought it was PartWhse.OnHandQty - PartWhse.DemandQty.

3

I agree with that, Jason.

Might anyone be able to validate the logic that @Jason_Woods and I have adopted?

4

Jason is correct. I am using extensively and very critical for the business to inform customers about available qty on hand…

5

Thanks for the supporting opinion, Arul.
I’ll stick with the logic that Jason has outlined.