Sage 100

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…

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…

When I try to open a sales order I get the following error dialog "the lock information was not found" This is from Sales Order Entry on Sage 100 2019 Premium.

With Sales Order history enabled, lines that are deleted by an event script (Pre-Totals) are not reflected as CancelledLine="Y" in SO History. Thus, there is no way to differentiate deleted lines from lines that remain in the order. This results in overstated…

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…

Hi, I'm currently learning how to use this software. Using demo company ABC, I can see on the Vendor Maintenance screen that the Vendor '02-SCR' has an invoice '043090' with a transaction of 5000 $. How can I see the details of that invoice and on which…

Hello, I'm having an issue with a warehouse to warehouse transfer that is racking my brain, no pun intended. A user made a transfer and when i went to update it, it showed 0 entries. When i asked if he added an entry he said yes. Also the quantity in…