Open Forum

Expand all | Collapse all

Inventory 'Sequence' for FIFO

  • 1.  Inventory 'Sequence' for FIFO

    GPUG ALL STAR
    Posted 15 days ago
    If I'm posting a batch of inventory transactions, does anyone know why the 'Sequence' would be anything different than the order of the transactions?

    Ex.)
    Batch of inventory transactions are all on 9/3/20
    ADJ1
    ADJ2
    ADJ3

    When these get posted, we see the SEQUENCE (matters for FIFO) order them like.
    Seq 1 | ADJ2
    Seq 2 | ADJ3
    Seq 3 | ADJ1

    Doesn't make any sense. Anyone have $.02 on what might be happening here?
    Thanks in advance!
    Kyle

    ------------------------------
    Kyle Malone, CPA
    ⭐GPUG Allstar | Chapter Leader - Louisiana (New Orleans)
    GP Admin - CGB Enterprises, Inc.
    Lead Consultant/Blogger - https://alacarteGP.com
    Solugence | Find the software that FITS your business + integrates with GP. https://solugence.com
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Inventory 'Sequence' for FIFO

    TOP CONTRIBUTOR
    Posted 15 days ago
    The order or sequence as you say of transactions in the IV10000 is dex_row_time stamp, dex_row. Not IVDOCNBR.
    When posting a FIFO Perp Item with multiple transactions in the same  day, they will post by IVDOCNBR not the dex sequence in the IV10000.
    You could argue this is a bug and FIFO Perp should post by Dex_Row_Timestamp regardless of IVDOCNBR.

    ------------------------------
    Thaddeus Suter
    Retus, Inc
    HELOTES TX
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Inventory 'Sequence' for FIFO

    GPUG ALL STAR
    Posted 15 days ago
    Makes sense and led me to find that the user had multiple inventory transaction batches.

    They posted the batches w/ the higher transaction numbers in it BEFORE posting some of the other batches.

    Thank you!​

    ------------------------------
    Kyle Malone, CPA
    ⭐GPUG Allstar | Chapter Leader - Louisiana (New Orleans)
    GP Admin - CGB Enterprises, Inc.
    Lead Consultant/Blogger - https://alacarteGP.com
    Solugence | Find the software that FITS your business + integrates with GP. https://solugence.com
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role