You use this program to review and optionally re-distribute the quantities in the FIFO buckets displayed.
Actual costing uses the FIFO valuation architecture to track and process costs. The purpose of this program is to create entries in the FIFO table that relate back to the lots and/or serials.
The following panes are displayed in the Actual Costing Conversion Review program if you selected Actual costing > Batch serial:
This pane displays the batch serials 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 where an imbalance occurred between the serial quantity on hand and the serial transaction quantities.
When you highlight a serial, 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 quantity on hand and the serial transaction quantities.
This pane displays the actual cost buckets created by the Actual Costing Conversion Review program, based on the serial transaction records.
If more than one bucket exists for a serial 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. If they do not, then you will be unable to save your changes.
The following panes are displayed in the Actual Costing Conversion Review program if you selected Actual costing > Lot traceable:
This displays the 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 where an imbalance occurred between the lot quantity on hand and the lot transaction quantities.
When you highlight a lot, the cost bucket information is displayed in the Actual Cost Buckets pane.
This displays details of the adjustment records created where an imbalance occurred between the lot quantity on hand and the lot transaction quantities.
This pane displays the actual cost buckets created by the Actual Costing Conversion Review program, based on the lot transaction records.
If more than one bucket exists for a 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 lot. If they do not, then you will be unable to save your changes.
The processing phases performed by the Actual Costing Conversion Review program are as follows:
- Run an Inventory valuation on the item, storing the total value.
-
Process stock items as follows:
-
Create FIFO buckets according to the lot transaction file for Lot traceable items.
This applies if you selected the Actual costing > Lot traceable option (Inventory Setup).
-
Create FIFO buckets according to the serial transaction file for Batch serialised items only.
This applies if you selected the Actual costing > Batch serial option (Inventory Setup).
-
Process all Engineering Change Control (ECC) items, 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.
-
- Remove all existing Goods in Transit FIFO buckets and Transfer FIFO buckets at stock code level.
- Remove any existing FIFO buckets against the stock item.
-
Create new FIFO buckets as follows:
-
For each lot, batch serial and revision/release for ECC items where the item is not lot traceable (i.e. dummy lots exist):
-
Create a FIFO bucket for each positive Receipt, and Transfer In on the lot transaction table, recording the cost from the transaction and the receipt date.
-
Update the transaction with the new cost and bucket fields.
-
Create FIFO journals for tracking purposes.
-
-
-
Process the transactions again, 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.
It is important to note the following:
-
A bucket will not go negative.
If the issue quantity is greater than the quantity against the bucket, then the quantity in the bucket is subtracted from the issue quantity and then set to zero. This routine is repeated until the issue quantity is zero.
-
The new cost and bucket fields on the transaction are updated.
![[Note]](images/note.png)
If the transaction spans more than one bucket, then the average cost of the buckets used is the cost updated against the transaction record.
For transactions which cause the bucket quantities to increase, the FIFO bucket issue date must be equal to or greater than the Lot/Serial transaction date.
FIFO journals are created for tracking purposes.
-
-
Create Adjustment records (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.
- Once all buckets are processed, you can review these buckets and move quantities between buckets for a single lot/serial as required. The quantities must balance back to the Lot/Serial quantity on hand. FIFO journals are created for tracking purposes.
-
This program is automatically loaded when you select the Actual costing > Lot traceable or Actual costing > Batch serial options in the Inventory Setup program.