Purge of Aged End of Year Inventory Positions (nwppurge)

Module Name

nwppurge.pc

Description

Purge of Aged End of Year Inventory Positions

Functional Area

Stock Ledger

Module Type

Admin

Module Technology

ProC

Catalog ID

RMS277

Wrapper Script

rmswrap.ksh

Schedule

Oracle Retail Merchandising Batch Schedule

Design Overview

This program purges the records from the table NWP after a certain amount of years have passed. The number of years is held in the configurable system level parameter NWP_RETENTION_PERIOD.

Restart/Recovery

Restart/recovery is not applicable, but the records will be committed based on the commit max counter setup in the restart control table.

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.