This program is loaded automatically when you switch on actual costing by lots or batch serials (Inventory Setup).
Actual costing uses the FIFO valuation architecture to track and process costs. This program lets you optionally review and re-distribute lot or serial quantities.
|
This pane displays the batch serials (or lots) for stock codes/warehouses in a treeview structure.
The Adjustment column indicates whether an adjustment record was created by the Actual Costing Conversion Review program. Adjustments are created when an imbalance occurs between the serial (or lot) quantity on hand and the serial (or lot) transaction quantities.
When you highlight a serial (or lot) the cost bucket information is displayed in the Actual Cost Buckets pane.
This pane displays details of the adjustment records created where an imbalance occurred between the serial (or lot) quantity on hand and the serial (or lot) transaction quantities.
This pane displays the actual cost buckets created by the Actual Costing Conversion Review program, based on the serial (or lot) transaction records.
If more than one bucket exists for a serial (or lot) then you can move existing quantities from one bucket to another and save these changes. Note that the bucket quantities must still equal the quantity on hand against the serial (or lot) or you won't by able to save your changes.
Stock items are processed as follows:
FIFO buckets are created according to the serial transaction file for Batch serialised items.
This applies when the Actual costing > Batch serial option is enabled (Inventory Setup).
Engineering Change Control (ECC) items are processed (excluding batch serialized items, if Actual costing is enabled for batch serials).
All existing FIFO buckets are updated with the revision and/or release of all existing ECC-controlled items.
New FIFO buckets are created as follows:
For each lot, batch serial and revision/release for ECC-controlled items (where the item is not lot traceable, i.e. dummy lots exist):
A FIFO bucket is created for each positive receipt, and transfer-in on the lot transaction table, recording the cost from the transaction and the receipt date.
The transaction is updated with the new cost and bucket fields.
The transactions are reprocessed for the following transaction types: I - Issues, S - Sales, A - Adjustments (including physical adjustments), T - transfers, R - Receipts, D - Dispatch notes, starting at the oldest transaction and netting the buckets off with the transactions.
At this point, the issue date is updated.
|
For transactions which cause the bucket quantities to increase, the FIFO bucket issue date must be the same or later than the lot/serial transaction date.
Adjustment records are created (if required) after creating the buckets based on the lot/serial transactions. Variance journals are created if the transaction records do not balance with the lot/serial quantity on hand. The variance journal type is t and the reference is ActualCst.