@Dennis Megaffin
Aggregate Inventory Transactions per Period
Explanation
This activity is used to update the system's statistical tables. The inventory statistics are based on inventory transactions, and the result is divided into statistical periods defined in the Statistic Periods window. Statistics are updated based on transactions that occur between the current date and previous activity date of updating inventory part statistics.
The Default feature enables you to use the default settings. Default settings are derived from the Database Tasks window set by the administrator.
Prerequisites
- Statistic periods must have been defined in the Statistic Periods window.
- An inventory part must have been created and transactions performed on the inventory part.
System Effects
- If statistics are being updated for a new inventory part, a new record will be inserted in the Inventory Value per Period window.
- If statistics are being updated for an existing inventory part, the existing record will be modified in the Inventory Value per Period window.
- These inventory part statistics will be used for MRP (Material Resource Planning) calculations.
- If you have scheduled the task as a background job, the task will be automatically performed based on the specified selection criteria.
- If the quantity in inventory is zero for an inventory part at the end of a period, the system evaluates that the inventory value is also zero on the detailed level that can be seen in the Inventory Value per Period/Value per Detail tab. If there is any remaining value left, it will be cleared by a ROUNDDIFF transaction after considering the number of days the part has been inactive for, according to the value in the inactive days for remaining stock setting on the applicable site. The ROUNDDIFF transaction is created with a date applied corresponding to the last date of the period where the quantity is zero and the number of inactive days is acceptable.