Forum Discussion

RAJASEKAR-O's avatar
RAJASEKAR-O
Regular Visitor
9 months ago
Solved

Inventory FIFO Aging

hi Team 
   i wnat to Ageing The stock Based on FIFO 
table : F_Inventory 

ItemDOCIDIN_DOCDATEqtyTRTY
Surgical Mask45014930-01-2024400RCPT
Surgical Mask45016910-03-2024400RCPT
Surgical Mask45019508-08-2024250RCPT
Surgical Mask45023907-06-2024100RCPT
Surgical Mask45030823-07-2025100ISSU
Surgical Mask45031008-09-2024250ISSU
Surgical Mask45031401-01-2025250RCPT
Surgical Mask45033131-05-2024100RCPT
Surgical Mask45040230-01-2024200RCPT
Surgical Mask45041525-04-2024200RCPT
Surgical Mask45042001-03-2024150RCPT
Surgical Mask45044305-05-2025100RCPT
Surgical Mask45055130-01-2025300RCPT
Surgical Mask45058422-02-2024150RCPT
Surgical Mask45058904-02-2024100RCPT
Surgical Mask45059301-02-2024400RCPT
Surgical Mask45060525-04-2024300RCPT
Surgical Mask45062928-01-2024100RCPT
Surgical Mask45063503-07-2024150RCPT
Surgical Mask45089712-04-2024300RCPT
Surgical Mask45092721-05-2024300ISSU
Surgical Mask45094706-05-2025150RCPT
Surgical Mask45096504-04-2024300RCPT
Surgical Mask45097505-03-2024150ISSU
Surgical Mask45099506-06-2025250RCPT

i try but not comming correctly 

 



Need Help
Tips and Tricks
Tutorial Requests
  • DataNinja777's avatar
    DataNinja777
    9 months ago

    Hi RAJASEKAR-O  

     

    Your table currently accumulates only the receipt in transactions but doesn’t reflect the FIFO outflows. If you include issue data, you can calculate running totals by date to simulate FIFO. Also, note that FIFO is an inventory valuation method, so with quantity data only, you’ll get quantity aging rather than value-based results which FIFO is meant for in valuating Inventory.

3 Replies

  • DataNinja777's avatar
    DataNinja777
    Super User
    9 months ago

    Hi RAJASEKAR-O  

     

    Your table currently accumulates only the receipt in transactions but doesn’t reflect the FIFO outflows. If you include issue data, you can calculate running totals by date to simulate FIFO. Also, note that FIFO is an inventory valuation method, so with quantity data only, you’ll get quantity aging rather than value-based results which FIFO is meant for in valuating Inventory.

    • v-aatheeque's avatar
      v-aatheeque
      Community Support
      9 months ago

      Hi RAJASEKAR-O 

      Just checking in to see if the previous response helped resolve your issue. If not, feel free to share your questions and we’ll be glad to assist.

      • v-aatheeque's avatar
        v-aatheeque
        Community Support
        9 months ago

        Hi RAJASEKAR-O 

        We wanted to follow up to check if you’ve had an opportunity to review the previous responses. If you require further assistance, please don’t hesitate to let us know.