Sage 100

 View Only

  • 1.  Master Order Balance Recalculation

    Posted 03-28-2021 10:31
    is there a utility that will recalculate the Ordered to Date / Balance on a master PO?  I have a customer that has some POs that have hundreds of lines with incorrect Ordered to Date quantities.

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------


  • 2.  RE: Master Order Balance Recalculation

    Posted 03-28-2021 10:48
    I'm interested about the recomputation as well. 
    I found this KB which seems fairly recent though like almost all Sage KB entries does not specify what version(s) this issue may pertain to: 

    If you select a master order when creating a purchase Order and hit "Cancel" before/instead of hitting "Accept", that master order will be updated with a zero balance for all remaining lines.

    Sage Engineering is currently reviewing

    Work Around: Do not "Cancel" PO's with master PO's on them. Instead, hit "accept" on a Purchase order when creating it from a master order and then re-open it and "delete" it.



    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------



  • 3.  RE: Master Order Balance Recalculation

    Posted 03-28-2021 10:50
    Update: Should have read KB title - looks as if this is a 2020 issue though not positive if it is limited to 2020

    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------

    Original Message


  • 4.  RE: Master Order Balance Recalculation

    Posted 03-28-2021 11:01
    Thanks  @Wayne Schulz   Yes, I did see that KB.  This customer upgraded to 2020 PU1 two months ago so I am suspicious that this is what is causing the issue.  It would be great if there was a way to recalculate the balances.
    ​

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------

    Original Message


  • 5.  RE: Master Order Balance Recalculation

    Posted 03-28-2021 12:18

    I logged it to Sage a couple of weeks ago.  They were going to do testing to confirm the versions affected.  They told me no easy way to fix so I'm afraid DFDM it is.  


    They expect to issue the fix in July but may release a hot fix ahead of time.



    ------------------------------
    Mary Jo Krueger
    Senior Software Consultant
    CLA (CliftonLarsonAllen LLP)
    Appleton WI
    920-996-1176
    ------------------------------

    Original Message


  • 6.  RE: Master Order Balance Recalculation

    Posted 03-28-2021 14:31
    Thank you @Mary Jo Krueger  I hope they have a hot fix ready soon.

    ​

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------

    Original Message


  • 7.  RE: Master Order Balance Recalculation

    Posted 03-29-2021 08:48
    It would be nice if Sage noted on all KB articles what versions the issues are related to. This may not be an issue seen by a lot of people ( since it’s limited to master PO use ) but for those who do use it in a formalized purchasing department my guess is that it could be a big deal.

    ---------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ---------------------------------





  • 8.  RE: Master Order Balance Recalculation

    Posted 03-29-2021 09:01
      |   view attached
    @Wayne Schulz  Thankfully, in this instance, Sage did note in the title of the KB that version 2020 is affected.  The KB is attached here.​  This is a serious issue for the companies that use a lot of master POs.  Sage should immediately issue a program fix and a utility to clean up the mess.  I have a customer that has several incorrect POs that have hundreds of lines that need to be corrected.  The bug incorrectly recalculates every line item on the master PO when a standard PO that referenced the master PO is cancelled.

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------

    Original Message


Related Content