Sage 100

Hello, We just upgraded from an older version of MAS 90 / Providex to Sage 2023 100 Premium. It appears that all of the NULL values in our company tables have been converted to empty data, with the exception maybe of the date fields. This is causing…

We are in the middle of a parallel upgrade of our Sage MAS 90 4.5 company accounting system to Sage 100 2023 Premium. This is an upgrade that goes from 4.5 SP 7 to 4.5 SP 8 to 2018 to 2023 Premium. It appears that during the migration and conversion…

Hello everyone, I'm reaching out to the community for clarification on certain aspects of the SAGE 100 Accounting solution's architecture and communication protocols, which I haven't found detailed information on. Application Server and Database…

I am trying to import payroll as I do every pay period. But for some reason I keep getting this error today. My VI import job for payroll has not changed, and has worked for years...until today. Any direction where I could get some help to fix the issue…

Hello I'm upgrading from 2018 Advance to 2022 Premium. When on the server we can run canned reports within Sage 2022 without error. When we try and run reports from a client 2022 workstation we get "The database login failed. Error in File GL_ChartofAccountxxx…

Currently on Sage 100 Premium 2021; I need to track changes to AR_RepetitiveInvoiceHeader and AR_RepetitiveInvoiceDetail, but no built-in audit log exists. I've toyed with scripting to a UDT but now that we've moved to Premium, the power of MS SQL is…

Has anyone ran two versions of Sage 100 Accounting software using RemoteApp on a remote desktop?

Hello, I'm using an SQL version of Sage, and use Sage 100 Premium. I'm having an issue with a report in Sage Intelligence. I have a copy of the Sales, Customer Sales report that I had copied into another folder. When I try to click on it, it immediately…

I changed the description and short description and hit Accept from the Main Account Maintenance window. However, the trial balance and account inquiry still shows the old description. Shouldn't I be able to update the description from the Main Account…

Hello all, I am looking in Account Inquiry at AP and MC source journal entries. Drilling down on AP entries brings up AP Invoice History information. However, drilling down on an MC entry brings up only Payment History Inquiry. Does anyone know why…

Sage 100 2021.5 running on a Hyper V Server 2019 instance, 8cores and 24gigs of RAM. The server presently serves no other funcdtions other than some very light IIS tasks. CPU and RAM usage is minimal throughout the day. Sage is connected to SQL Server…

Can you Convert from Sage 100 Premium to Advanced. Has anyone ever done this?

Sage intelligence has stopped refreshing when I change the Period or Year. I have formulas linked to a Year and Period so that changing either cell with the Year or Period changes the data to that time frame. It worked fine in a previous report version…

I set the company background color last week and now they are all the same. In Company Maintenance on the Theme tab I tried to turn it back to standard, then change back to classic and choose a new color, but it still isn't showing the background or frame…

Running Sage 100 Premium 2021: need to reduce the size of the AR Invoice History tables. The purge invoice history utility is good as far as it goes, but I need to remove invoices for only one division that creates thousands of repetitive invoices monthly…

Test conversion from 5.40.3 to 7.0.1 Sage 100 Premium with multiple integrations. 5.40 instance and 7.0 instance are on same SQL server. This is the 2nd test migration, so MAS_XXX and MAS_SYSTEM databases currently exist in the new SQL instance. During…

Hi, Hoping someone knows how to get the details sections of a crystal report to not repeat the same values as I can not have step instructions and signoff information repeat I moved things around in the PM WT Traveler report that came with the install…

I have a client using Sage 100 Premium for core accounting for 200 companies installed in the default instance. I need to upgrade for 2019 to 2021, what is the procedure to keep using the default instance on a single server? Ideas? There are multiple…

Hi, I need to upgrade Sage100 desktop application from Sage100 Advanced to Sage100 Premium. Question 1 - What are the perquisites for upgrading/migrating? Question 2 - What will happen to my data if I switched from Sage100 Advanced to Sage100 Premium…

I am upgrading a client from Sage 100 2018 Premium with a complex Sage Intelligence install to Sage 100 2021 Premium with no change in Sage Intelligence's version. According to the documentation and a support call, I need to do a clean install of the…

When launching an attachment that has a .docx extension from our customer memo screen, we receive a "Sage 100 has stopped working" message. This issue is happening on all our windows 10 machines that have office 2016 and above. We have tried uninstalling…

I am looking to add the Routing (now Template) description to my printed Work Ticket Traveler. I want it to appear in a header section of the crystal report. The routing description is now step 000000 of the route instead of its own field. How do I get…

Version: Sage 100cloud Premium 2020 (Version 6.20.0.01) Additional software: Scanco Operations Management & Multi-bin, Some custom DSD programming Hello all! First post here. Looking for some assistance when it comes to replicating data for reporting…

We have several non-financial accounts, and we use Sage 100 Premium. Our auditor was looking at our NF account (apparently for his own enjoyment) and questioned how our non-financial accounts can be off balance, but our trial balance is still in balance…

With 4k monitors and a lot more screen room we would like to move some information from the "additional" tab to the "main" tab in inventory and accounts receivable so we don't have to flip back and forth between tabs to see everything we need. I was working…