Noob Inventory Calculation Question

jgehling · May 30, 2019, 4:16pm

Good Morning!

I’m a systems/tech guy not an inventory/supply chain specialist by any degree so this may be a very basic question, but is there an out of the box field/ BO that accounts for reserved in the total inventory available? We basically want available inventory - reserved and I’m just wondering if there is already a field that has this calculation. This is all purchased inventory not from jobs.

I see the following:

but none mention the total - reserved. Should I just manually do the calculated column in a baq?

rbucek · May 30, 2019, 4:28pm

There’s an allocatedQty field in the partbin table

jgehling · May 30, 2019, 4:52pm

Thanks! I do have that one, but does that field also take into account reserved inventory? It doesn’t look like it does. Will I need to manually subtract reserved from this value to get the truly available inventory?

jkane · May 30, 2019, 4:52pm

Does your company use the Fulfillment Workbench? All of the calculations are there.

jgehling · May 30, 2019, 4:55pm

Yes we use it 24/7, but my user wants to see ATS (Available to Sell) in a dashboard. We already have OnHand/ Allocated fields from PartBin in the BAQ and a calculated field for “Available” that is: PartBin.OnhandQty - PartBin.AllocatedQty

Should I just also subtract reserved in this calculation?

jkane · May 30, 2019, 5:00pm

Yes, and if you use picking, subtract picking and picked.

jgehling · May 30, 2019, 5:01pm

Great Thanks!!