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 ***