Difference between revisions of "BPCS On Hand"
From MidrangeWiki
(On Hand start) |
(bold and italics) |
||
| Line 8: | Line 8: | ||
* minus month-to-date '''Issues''' | * minus month-to-date '''Issues''' | ||
* plus month-to-date '''Adjustments''' | * plus month-to-date '''Adjustments''' | ||
| + | |||
| + | '''''Available Inventory''''' = '''On hand''' minus ''allocations'' | ||
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. | 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. | ||
Revision as of 12:41, 27 May 2005
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
Available Inventory = On hand minus allocations
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.
