BPCS On Hand

See Query for links to other tips and techniques we can use in Query, that may be of generic interest to anyone on the 400.

BPCS does not store On-Hand inventory in any one location in the BPCS files. We have to calculate it every time we need it.

ON_HAND =

• Opening Balance (for the fiscal month)
• plus month-to-date Receipts
• minus month-to-date Issues
• plus month-to-date Adjustments

There are files containing activity by item, item warehouse combination, item warehouse location lot and other combinations. So if you want the total on-hand in a facility, you have to combine the results for all the warehouses in that facillity.