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.