Uploading Legacy System On Hand Balances to Oracle FIFO Organizations
Hi,
I need to upload Inventory balances from a legacy system to Oracle which uses FIFO Costing method. What should be the upload mechanism in order to capture each item's historical receipt date and cost from the legacy system? Below is an sample.
Legacy System has an on hand balance worth Rs. 100,000.
| Item | Qty | Receipt Date | Unit Cost | Value |
|---|---|---|---|---|
| ITEM A | 100 | 01/01/2018 | 250 | 25,000 |
| ITEM A | 300 | 25/01/2018 | 200 | 60,000 |
| ITEM B | 100 | 26/01/2018 | 150 | 15,000 |
| TOTAL | 100,000 | |||
Following the upload of data from the legacy system to Oracle, a Transaction of ITEM A with a Qty of less than 100 should be issued at a unit cost of 250 (as per the FIFO Costing). How can I upload the on hand balances in order to cater this requirement.
0