Sage 100

 View Only
  • 1.  Zero quantity transactions post to Inventory Transaction History for backordered, zero quantity shipped items

    Posted 12-02-2025 11:00

    I've searched hi and low in here, and in Sage KB and release notes, and found nothing.

    Customer recently upgraded from 2021 to 2024.  When they invoice a sales order and some of the items do not ship at all and are backordered, those backordered items create zero quantity inventory transaction history records.  These items are FIFO valued and have zero quantity on hand in inventory overall.  Nice cluttering up of inventory transaction history that needs to stop!  Anyone else run into this?



    ------------------------------
    Jane Scanlan
    Partner
    Next Level Manufacturing Consulting Group
    ------------------------------


  • 2.  RE: Zero quantity transactions post to Inventory Transaction History for backordered, zero quantity shipped items

    Posted 12-02-2025 11:36

    Enhancements?



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 3.  RE: Zero quantity transactions post to Inventory Transaction History for backordered, zero quantity shipped items

    Posted 12-02-2025 11:56

    No enhancements @Kevin Moyes.  All vanilla.



    ------------------------------
    Jane Scanlan
    Partner
    Next Level Manufacturing Consulting Group
    ------------------------------



  • 4.  RE: Zero quantity transactions post to Inventory Transaction History for backordered, zero quantity shipped items

    Posted 12-02-2025 12:07

    You might check through DFDM to see if there are decimals not visible on the screen. 



    ------------------------------
    Bill Pfahnl
    Nims & Associates
    ------------------------------



  • 5.  RE: Zero quantity transactions post to Inventory Transaction History for backordered, zero quantity shipped items

    Posted 12-02-2025 12:08

    I just tried enabling this option in ABC, and tested... with a zero line showing up in the IM history too.



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 6.  RE: Zero quantity transactions post to Inventory Transaction History for backordered, zero quantity shipped items

    Posted 12-02-2025 12:23

    Thank you for the verification @Kevin Moyes.  My client doesn't even have the Retain Backordered Lines option checked on.  I'll log a case with Sage!



    ------------------------------
    Jane Scanlan
    Partner
    Next Level Manufacturing Consulting Group
    ------------------------------



  • 7.  RE: Zero quantity transactions post to Inventory Transaction History for backordered, zero quantity shipped items

    Posted 12-05-2025 17:03

    I received a response from Sage that this is a WAD!  Their explanation: 

    "If an item is on the invoice and not shipped a record for zero quantity will show in the transactions referencing the invoice. This makes it easy to have a record of unfulfilled orders at time of invoicing.  I tested this back to version 2017, and it works that same way. This would be an enhancement request if you wanted to see a change."

    I disagree that this is useful information, but am not going to argue with Sage, nor waste effort on an enhancement request. 



    ------------------------------
    Jane Scanlan
    Partner
    Next Level Manufacturing Consulting Group
    ------------------------------



  • 8.  RE: Zero quantity transactions post to Inventory Transaction History for backordered, zero quantity shipped items

    Posted 12-06-2025 09:13

    Then, there needs to be a setup option to not expose these 0.00 transactions on the transaction tab.
    And no wonder our clients have 1 Million Records in IM Transaction History; if they are writing every backorder into that file as a valid  0 quanitty, transaction.
    If it is so valuable to have, there should be a report to support reviewing this "record of unfilled shipments" designed and developed by Sage.  (SMH). 



    ------------------------------
    Madeline Stefanou
    RKL eSolutions, LLC
    ------------------------------



  • 9.  RE: Zero quantity transactions post to Inventory Transaction History for backordered, zero quantity shipped items

    Posted 12-08-2025 13:57

    Here's what I wrote back to Sage:

    I disagree with this functionality. By definition, a transaction is an instance of buying or selling something-which means an actual event has taken place. When nothing is issued from inventory, no sale has occurred, so calling this a "transaction" doesn't align with the concept of inventory activity. If the goal is to review backorder history, Invoice History Inquiry already provides meaningful information, including backordered quantities.

    If Sage's logic is to treat zero-shipped sales order lines as inventory transactions, then it raises the question: why don't unreceived PO lines also transact to inventory? The two situations are logically similar, yet they are handled inconsistently. As it stands, the behavior doesn't make sense.



    ------------------------------
    Jane Scanlan
    Partner
    Next Level Manufacturing Consulting Group
    ------------------------------