Sage 100

Sage 100 2021 PU2 This happens even if no changes are made.

I see this on two new upgrades to v2021.1 Standard (both on SPC, but that may just be a co-incidence). Edit a Role and I get this prompt when saving: (SY_RoleApply.Y2) But this is what I "should" see: Similarly, with the Document Date warning…

I want to delete a report - get an error 'The function GetDataValue can only service SQL calls that result in a single return value' how can I fix this? We are on Sage 2020, not on a SQL server backend

We've gathered a collection of a few dozen salesperson records that essentially "dead" - meaning there are no open orders/invoices, there are no assigned customers or shipto records, no sales activity at all for years..... and they are starting to get…

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…

Hey all. We are moving from Mas90 4.3 to Sage100 Cloud. Finally! Over the weekend, we made a backup of our entire Mas90 directory and uninstalled some shipping link software before moving data from all companies. Long story made short, we did not get…

we are attempting to delete a SO. we have successfully done so to other SO but this one item gives us an error #47 Substring reference out of string and we are unable to do anything.

With different frequency, but frequent enough to be a nuisance, especially when involving millions of dollars, the Original and Revised contract amounts get out of balance. Since it cannot be tracked easily, I'm wondering whether anyone has run into this…

We have recently upgraded to Sage 100 2020 and one of our companies is noticing a weird issue in Work Order Inquiry. When attempting to open certain work orders, the Work Order Inquiry window closes. However, if we open a different work order and go to…

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.

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…

Hi guys We seem to be having an issue with auto reorder. We have ran a rebuild on the modules PO, SO and IM and it didn't seem to solve the issue. See picture below. Any ideas on what my have caused this? Thanks Guys

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…

I went to process an ACH payment for a vendor invoice & it had a line that showed double the amount of the invoice. The total line was ok but when I got further in the process it said the daily transaction register was out of balance. The vendor inquiry…

I am assuming I have a client experiencing this, since they have large negative numbers showing up on certain items which should have On PO qtys of 2,3, etc. The client did have a PO blow up during entry and the items appear to be related, but I can…

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…

I have a client that has to rename these files several times each week. Aside from anti-virus or anti-malware programs corrupting these files, what else could cause this problem. The problem is Sage opens for about 1 second and then immediately closes…

Client is on 2018.8 and upgraded from prior version in Feb 2019. One employee shows on the Data Entry Audit Report for being paid in May 2019. That employee no longer shows anywhere in the PR_Employee.M4T file - at least as far as I can tell. The only…

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…

Hello, running into a strange issue here and a bit stumped. Running Sage 100 218 Premium (SQL) We have a customer who has no sales / invoice history, however in the AR Customer Maintenance / Inquiry module under Summary is shows values for Sales/Cogs…

So about a week ago I had a client go live in Sage 100 2018.6 with Scanco add ins after a couple of months of testing. A few days in there was a request to add some user-defined fields to the pr_employee file. When I went to add the fields, the list…

I need help with this error message. This particular file worked fine on Friday. Now, on Monday, it won't open. My other files seem to work just fine. I get this error: Excel cannot open the file "file name" because the file format or file extension…

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…

Hello, We have an issue where an order is currently marked as an "Active Order" under Sales Order and Quote History, but this file is not accessible inside of Sales Order Entry. We get the message: "The Sales Order number already exists in the History…