End of Year Inventory Position Snapshot (nwpyearend)
|
Module Name |
nwpyearend.pc |
|
Description |
End of Year Inventory Position Snapshot |
|
Functional Area |
Stock Count |
|
Module Type |
Business Processing |
|
Module Technology |
ProC |
|
Catalog ID |
RMS278 |
|
Wrapper Script |
rmswrap_multi.ksh |
Design Overview
This program takes a snapshot of the item's stock position and cost at the end of the year. When the end of year NWP snapshot process runs, it takes a snapshot of stock and weighted average cost (WAC) for every item/location combination currently holding stock. If there is not a record already on the NWP table for an item/location/year combination in the snapshot, a new record is added for that item/location/year combination.
Restart/Recovery
The logical unit of work for this program is set at the location/item level. Threading is done by supplier using the v_restart_store_wh view to thread properly. The commit_max_ctr field should be set to prevent excessive rollback space usage, and to reduce the overhead of file I/O. The changes will be posted when the commit_max_ctr value is reached and the value of the counter is subject to change based on implementation.
Design Assumptions
-
NWP refers to 'Niederstwertprinzip' and is a legal German accounting financial inventory reporting requirement for calculating year-end inventory position based on the last receipt cost.
-
The NWP Indicator system parameter supports this German specific inventory reporting requirement. For German customers, this needs to be 'Y' to allow for the annual NWP calculations & processes.
-
This is not relevant for customers outside Germany.