Sage 100

 View Only
  • 1.  Customer was on v2015, upgraded to v2018. Problem

    Posted 11-14-2018 08:59
    Customer was on v2015, upgraded to v2018. Problem started in v2015, still there in v2018. They do a lot of SO Repetitive Invoices. User Auto Generates Invoices from Repeating Orders. These orders only have / Items on them (Misc.). However, when she generates the invoices, inventory items with quantity and price/extension are randomly added. These inventory items are not calculated into the invoice total though. However, the user isn't catching them and so the invoice is going out with the random items and the correct items on it and getting updated. I tried purging history from years ago (2010 back to 1999) hoping it was due to duplicate invoice numbers but that hasn't resolved the problem. Any ideas on how to stop this from happening?


  • 2.  RE: Customer was on v2015, upgraded to v2018. Problem

    Posted 11-14-2018 09:23
    I'd look for bad data in SO_SalesOrderDetail.


  • 3.  RE: Customer was on v2015, upgraded to v2018. Problem

    Posted 11-14-2018 09:42
    While you track it down, you can write a crystal report to find them before they are posted....