Technical Blog Post
Abstract
Why is Inventory Issues and Transfers FIFO Unit Cost still showing Average after IV84504?
Body
Summary Paragraph
Just when you thought that the code defect IV84504 is resolved, the problem is still showing in the latest 7.6.0.3 IFIX 7.6.0.3-IFIX20160909-1505 at time of print.
It is fixed, there is detail about the calculation of FIFO and Average that is easily missed. I will provide an example to create data and the screens to identify the behavior. Let’s have a look …
Detailed Description
The code defect is this one:
IV84504 CURRENT BALANCE DOES NOT ALIGN WITH QUANTITY IN LIFO/FIFO TABLE
There we look at how the FIFO is calculated in Issues and Transfers and why the Unit Cost records as an Average and not as FIFO for those items.
After applying the TPAE IFIX and testing, the problem shows in the Issue and Transfers. Why?
At the end you can see how to create the data I am using in this screens. The step that we are looking at is this …
5. Inventory-> Issues and Transfers -> ELERISTORE
Transfer Out TAB -> Search Gregogy
6. GREGORY Item has Line Cost: 75 like customer
Line Cost: MATRECTRANS.LINECOST
With IV84504 fix, Issue and Transfer, Issue Type Unit Cost is 50 after transaction is done.
This is the part that seems incorrect at first:
In Issue and Transfer app, Issue Tab, Unit Cost is showing 77.78 (75 without tax). It's correct.
The Unit Cost "on the screen" is Averaged and READ only.
Because you never know what quantity user is going to enter at this point.
Once Save, all the transactions will be correct.
Here in Inventory -> Inventory -> Search FIFO Item GREGORY
Select Action -> View Inventory Transactions -> Issues & Returns Tab
Let’s summarise how I created the data to show the reproduction steps
*** START PREREQUISITE STEPS ***
1. Login with maxadmin//maxadmin
2. Go to Inventory -> Storerooms
a) create new storeroom:
Location: ELERISTORE (Eleri Test Storeroom for PMR)
3. Go to Inventory -> Item Master
a) create new Item
Item: GREGORY
Item Set: SET1
Lot Type: NOLOT
b) Select Action -> add Items to storeroom -> ELERISTORE-> OK
Now Expand on this window, fill in the Issue Cost Type: FIFO INVENTORY.COSTTYPE
c) change Item status to Active and check the
"Roll New Status to Organization and Inventory" check box.
4. Go to Purchasing - Purchase Order and create 2 new POs
a) create first PO
PO: 1105 PO1
Vendor: SKF
b) PO Lines Tab -> New Row -> add new PO Line:
Quantity: 5
Line: 1
Line Type: Item
Item: GREGORY
Order Unit: EACH
Conversion Factor: 1
Unit cost: 50
Line Cost: 250
Storeroom: ELERISTORE
Change the status to APPROVED
c) Created second PO:
PO: 1106 PO2
Vendor: SKF
d) PO Lines Tab -> New Row -> add new PO Line:
Quantity: 5
Line: 1
Line Type: Item
Item: GREGORY
Order Unit: EACH
Conversion Factor: 1
Unit cost: 100
Line Cost: 500
Storeroom: ELERISTORE
Change status to APPROVED
5. Go to Receiving application
Display the first PO 1105, click on Selected Ordered Items, check the Item and then on OK. Save.
Display the Second PO 1106, click on Selected Ordered Items, check the Item and then on OK. Save.
6. Go to Purchasing - Purchase Order and create one more PO.
PO: 1107 PO3
Vendor: SKF
add new PO Line -> New Row
Quantity: 6
Line: 1
Line Type: Item
Item: GREGORY
Order Unit: EACH
Conversion Factor: 1
Unit cost: 100
Line Cost: 600 (POLINE.LINECOST)
Storeroom: ELERISTORE
Change the status to APPROVED
7. Go to Inventory application, display the Item: GREGORY
Select Action -> Issue Current Item (ISSUECURRENTITEM.UNITCOST)
Verify UnitCost and LineCost
The Unit Cost is 75 as an Average not FIFO.
These are the reproduction steps for IV84504.
**** End of PREREQUISITE STEPS ***
UID
ibm11112163