FIFO item costing view by QTY

I would like some help to see if there's a way to view the current item costing and the associated bucket QTY.

We are having issues with the transaction cost of the top level item coming out at seemingly an erratic cost, therefore wanting to understand how the item cost/QTY is currently stored in the system.

The Item is set up as FIFO costing model.

  • 0

    Hello Peter, 

    You can view an item's FIFO quantity and cost via the I/C LIFO/FIFO Inquiry screen.

    One thing with FIFO Costing is the Offset Bucket.. when you Create a Shipment for a FIFO costed item and if that item has quantities/costs in the OFFSET bucket, then the costs will first come from the Offset Bucket.. 

    Regards,

    DCrampton

  • 0 in reply to DCrampton

    Hi,

    Thank you for the comment. I check the LIFO/FIFO Inquiry, there's no Offset bucket QTY listed for the assembly under question.

    Out of 10 transactions today, 3 transactions randomly pull the same item at a different cost (mostly at $38, but 3 transactions at $44). All receipts of inventory were consistent at ~$38. I have no clue what would cause such a +/- in the final transaction cost during shipment.

    Any suggestion would be much appreciated.

    Peter

  • 0 in reply to Peter PW Lee

    Hi Peter, 

    so is this a Component Item in the Assembly or the Master Bill of Material and by any chance was a Disassembly processed around the same time or shortly before the three incorrectly costed shipments?  

    I think at this point perhaps it is best to contact Customer Support and open a Support Ticket.. 

    Regards,

    DCrampton

  • 0 in reply to DCrampton

    Hi, 

    This is a component item in the assembly and the rest of the assembly cost looks normal except for this one item. No other/abnormal transactions noticed between the transactions that could suggest a cost impact. As you suggested, we are reaching out to customer support to further understand/ rectify this problem.

    One thought is to deplete the inventory at the problem location before adding new QTY, not sure if that would "force" the reset to the next receipt cost.

    Peter