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
page. 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 page set by the administrator.
You can either update inventory part statistics directly, or schedule the task as a background
job.
Prerequisites
- Statistic periods must have been defined in the Statistic Periods page.
- 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 page.
- If statistics are being updated for an existing inventory part, the existing record will be modified in the
Inventory Value per Period page.
- 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.