Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
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…
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…
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 All,
We are using SAGE 100. Somehow On PO qty coming in Stock status report is not Open PO Qty.
SAGE is pulling a open PO qty from somewhere - SAGE ppl kindly share your thoughts
In the below example, in main I m seeing a open PO qty but in…
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…
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…
I recently found a discrepancy in values between the quantities tab and the cost detail tab within Item inquiry on a few items.
After researching in the Knowledge Base, I came across the following steps to clear out the issue:
Update all transactions…
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…
Our Sage 100 version 4.40 server had a few files fail the integrity test with either read or write errors. I selected OK to rebuild them but now all the records are gone. The log file shows all the records were recovered.
Is this normal?
I can import…
Once every 1-2 weeks or so I have to get in after hours to rebuild sort files, in our old business system a similar process was scheduled to run each night. Does anyone out there have a script or other method that would allow for scheduling a rebuild…