Sage 100

 View Only

  • 1.  Quantity Received Not Updated On PO

    Posted 02-03-2022 08:32
    Two or three times a month the quantity received field does not get updated on the PO after the receipt of goods.  The Quantity on hand does get updated.  There is a KB article about required fields not being populated that can cause this issue but this customer does not have any required fields.  This issue was just reported yesterday with a couple of example in each month going back several months.  The system is 2018 Advanced.  My first thought is to rebuild the PO header and detail tables.  Any other thoughts on the cause of this issue?

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------


  • 2.  RE: Quantity Received Not Updated On PO

    Posted 02-04-2022 09:05
    There is an article in the KB somewhere about this happening if the PO is open when posting the ROG. I've had this happen to a particular customer every so often & I have to go in & DFDM the qty received on the PO Details.

    ------------------------------
    Dana Young
    Lehman Wesley & Associates
    Lansing MI
    ------------------------------



  • 3.  RE: Quantity Received Not Updated On PO

    Posted 02-04-2022 09:53
    Thank you @Dana Young  I appreciate your comment.  If you run across the KB# please share it with me.  I have searched the KBs and opened case# 8009077190 with Sage.  Sage can't find a KB.  

    If the PO is open, there should be a record lock on it, which one would hope would generate an error message during the receipt of goods update.   It is possible that the code doesn't create an error it simply branches to the next line of code and doesn't update the record. 
    ​

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------

    Original Message


  • 4.  RE: Quantity Received Not Updated On PO

    Posted 02-04-2022 12:16
    I have recently started pushing customers to use the Inquiry screens when they are just looking stuff up.

    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    Asheville NC
    678.273.4010 ext 5
    ------------------------------

    Original Message


  • 5.  RE: Quantity Received Not Updated On PO

    Posted 02-04-2022 14:22
    Edited by Doug Higgs 02-04-2022 14:22
    @Phil McIntosh  That's a great recommendation.  Read the data into memory and don't expose an open file to the elements.​

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------

    Original Message


Related Content