Discount Rate/Amount on Back orders - Defect/Workaround?

SOLVED

I noticed a strange thing this morning that I wondered if anyone can confirm/has a work around.  I was reviewing orders that have a discount rate/amount and noticed in Sales Order and Quote History Inquiry a disagreement between Amount Subject to Discount, Discount Rate and Discount Amount in some cases.  I dug a little further and discovered that the disagreement happened on Sales Orders that had back orders (both open and completed).

Sales Order Quote History Inquiry and SO_SalesOrderHistoryHeader & Detail reflect the original product order quantities, not the backorder, so there's a disagreement between Order Totals and Discount Amount. Resulting in something like this:

Furthermore, the disagreement is permanent.  It would be one thing if the Discount Amount would update back to normal once the Order is completed, but once the back order happens, the Discount Amount in both Sales Order Quote History Inquiry and SO_SalesOrderHistoryHeader will be wrong. 

I can manually update the discount amount on completed orders, but I wondered if anyone else had noticed the problem and if there was a better workaround.

I'm on Sage 100 ERP 2013 (v. 5.00.4.0) if that helps.

Thanks!

  • 0

    I've determined that this is happening when an order has been back ordered and someone goes into Sales Order Entry and makes any line item change( such as remove the backordered item to fulfill with an alternate).  Does anyone have a suggested workflow or enhancement to resolve this situation?

    I'm still annoyed that the discount amount updates while the rest of the header stays intact.  That feels like a defect.

  • 0 in reply to Will F
    verified answer

    It is a defect. I've been complaining about problems with sales order totals and discrepancies between history and open orders for at least 5 years, to no avail.  If you have the option to retain deleted sales order lines enabled, I would highly recommend disabling it.  That solved some of my order total issues, especially on orders with backorders.