Difference between revisions of "BPCS On Hand"
From MidrangeWiki
(On Hand start) |
m (Reverted edit of Rd37675559, changed back to last version by David) |
||
| (6 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| + | [[Category:BPCS]] | ||
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''''' = | ||
| Line 8: | Line 9: | ||
* 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''' | ||
| + | |||
| + | 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. | 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. | ||
Latest revision as of 20:14, 7 March 2006
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.
