• SO_SalesOrderHistoryDetail has records with a null SalesOrderNo

    I've noticed that we have just over 14,000 records in the SO_SalesOrderHistoryDetail table where the SalesOrderNo field is null. This is causing some issues with trying to do a copy into a MySQL database due to the Primary Key not accepting null values…
  • Customer Last Purchase History on Sales Order not working

    Hi Guys So we recently upgraded to Sage 2023. Since the upgrade some users have being reporting that the Customer Last purchase history (Red Binoculars) is not populating for them on sales order. I first thought it might have been a permissions issue…
  • SO Invoice Doubling total on line items

    Not sure how this has happened, but we have an invoice that has doubled a line item. Sage Advanced 2018 6.00.3.0 The problem also is, it does not show up in the Lines tab, only the Totals tab, or when the invoice is printed. Our system seems to…
  • Sage 100 BoI corrupt records with extended ascii

    We're currently on Sage 100 2014 (Non SQL) and we're currently running into the issues where we are being sent names containing certain ranges of extended ascii characters. For now, we are going to limit ourselves to the first 127 in the ascii table…