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…

I am trying to apply the Sage 2020.1 update. During the update, when it scans for corruption it says that PL_JournalPDFLog.M4T has an ambiguous "file discrepancy" in it. The instructions say to simply Rebuild Key Files for any discrepancies, but alas…

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…

Has anyone run into an issue with a general journal posting that occurred months earlier now showing a different result if you were to run the report today? In January we had one entry, and if we run the report today, it shows 3 of the same entry. For…

Hello, I was wondering if anyone else ran across this issue and if so, how it was resolved. We have identical item numbers that appear when we search for an item in item inquiry and item maintenance. Selecting one of the item numbers results in…

We have had this problem since switching to Sage 100. When we try to change an item's valuation in the Item Valuation Change Selection task in Inventory Management, and all users are logged out of Sage, we get the below dialog: When I click More…

Hi, I want to read and write data in sage100 database, so after some research I found out this course for reference. But just need to validate that is this course really guides on how to read and write back data to Sage100 database or not? This…

Hi, I am new to Sage100 and customer is using Sage100 advanced which comes with ProvideX ODBC driver which only allows to read data from Sage100. I did some research on the functionality to write back the data in Sage100 but was not able to find any…

A SAGE100 Premium VS. 2020 has occasional missing S/O order header records. The order lines are still there. The order is completely there in order history. The order has NOT been invoiced. Anyone seen this?

Hi I do have a concern with sage 100 V 6.10.2, My inventory item shows 0 item no transactions in there, but when I run the Inventory Stock status report it show a quantity on hand of 384 any idea how to clear that or if there is any program to run…

Hello, There is error message on the Sage100 as shown below. How to fix the error? Thank you in advance for your help!

This is happening after our sales associates are done creating the sales order and have already clicked the EMV button, and swiped the card, then when the go back to click the "Get EMV Pmt" button, the sales order is gone. The credit card processes fine…

After Job Cost was updated to the Business Objects Interface Sage confirms but has not corrected two major problems (for us). When Sales Order is integrated with Job Cost there is the ability to create a new job from Sales Order Entry. When entering the…

Hello, We had something strange happen once last week, and now once again today. We had an order which was not acceessible through Sales Order and Quote History, so accounting contacted me. After checking our database, I noticed that there was no…

For some reporting purposes I need to normalize the bill of materials exactly how it shows in the BM_SummarizedReportWRK report into a SQL table. How do I do this? I've been attempting to backwards engineer from the regular and accessible Bill Of Materials…

Hello, I am trying to do a SQL query to see which users have had activity on a specific company ABC by doing a SQL query on the SY_ActivityLog table. When I do a query where CompanyCode = 'ABC', I get MOST of the users that have had activity on ABC…

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…

Merged over 3,300 items to code "Z_Discontinued" after months of working with staff to make sure all items on list were approved for merging. Now they need 2 of the 3,300 items restored, historical data. I created the original item numbers and setup…

Sage 100 Version 5.20 Crystal 2011 for Sage Window server 2012 R2 Ok, here is an odd one. We had been having incorrect data running a Inventory List via Crystal. We have a total of 600 items. When I add a filter for Category 2 data I am getting…

Hello, Received a notification for a Payroll Update, so I ran the update, but when completed, gives error "File 'PR_PayrollCycle' not found". I did this both on server and client workstation and same result. There is no file permission issues, and…

Our invoice clerk report 3 times that she had back orders on invoice she had entered last week. We don't do backorders in our business so this is very unusual. The Backorder column is not on the SO Invoice Data Entry form. The system seems to grab the…

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…

Have an issue with what I believe is a corrupted date value. It resides in purchase order detail required date and PO header PO date. Running the open order report on "required expire date" for date greater than 12/30 will result in "Vendor Code 9"…

Once every 1-2 weeks I rebuild all sort files and am wondering if I should also be rebuilding the key files? Is there any risk/downside to rebuilding the key files? Also, when I am running the utility do I want Integrity Check and Optimize File checked…

I would like to have a list of all email address associated with every account, but I am not aware of a method to do this.