Difference between revisions of "BPCS On Hand"
From MidrangeWiki
m |
m |
||
| Line 1: | Line 1: | ||
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. | 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. | + | [[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''''' = | '''''ON_HAND''''' = | ||
Revision as of 12:45, 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
Allocations are how much of the ON_HAND inventory and PLANNED new inventory is needed to meet requirements in the system. Thus AVAILABLE is any excess we might have for other new purposes.
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.
