Sage 100

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…

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

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…

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…

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…

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…

Hello, I'm working on a project and I need to be able to pull the same information the "Invoice History Printing" report pulls for a date. For my selected date, in our database we have about 3,000 invoices. The report, however, only pulls about 140…

Good evening. I have tried to create new companies and activate them in Sage 100 Premium. Currently creating a new company does not add a new database. Attempting to activate the company also fails Attempting to copy a company to a new company…

Hello, We have been trying to troubleshoot our slow performance with SAGE 100 PREMIUM 2018 and are running out of options. I have read all the articles here and on the knowledge-base, and nothing seems to be improving our performance. My last inquiry…

Hello, We are having stomething strange going on where 11 lines from an order are showing up in both the "Detail" and "History Detail" tables, but 3 are missing from the "Detail" table and are in the "History Detail" table. Any ideas? Apart from straight…

Hello, I'm looking to re-create a Crystal report so that it can be run by Knowledge Sync. I initially wanted to just use the report provided by SAGE, but it looks like I can't use this report as the information the SAGE report pulls is only generated…

Hello, We are looking to remove some data from the "Customer Maintenance" screen as some customers take roughly 30 seconds to load all of their history. I am specifically talking about records under tab 6 "Invoices", and tab 7 "Transactions". I am…

Hello, We had a strange event occur a few days ago. For one of our batches, the Cash Receipts Journal processed all of our checks except for the last 4 in the batch. However, the full batch was posted to the General Ledger, and the full amount shows…

Hello, Our accounting team inquired about the possibility of making the "Comment" field on Sales Orders editable even after they are put into the history table.I do not believe this is possible, but was hoping that it IS possible to add a NEW "Comments…

Hello, We are looking to automate statement printing for our customers. I looked through the "Task Scheduler" provided by MAS and noticed that this was not an option. I have no experience with this sort of thing, but it seems that this should be possible…

Hello, I am creating a report for our accounting department which shows all A/P batches that either remain open, or were created today. I have the first part, where I can pull up all active batches through GL_CompanyActiveBatch. However, I am having…

Hello, Our company MAS system has been running very slowly and I would like to delete some records form our database. There does not seem to be information on certain tables inside of SAGE under File Layouts and Program Information. Specifically, I…

Hello, I am scripting a button that, when clicked, opens up the sales order history lookup from the Invoice History Inquiry panel. I am trying to get this lookup to already have the sales order number entered that is shown on the current panel. For…

Hello, We are having an issue with the AR trial balance report. If we run this report without specifying a customer, and leave the Customer Number field set to All, the report runs fine. However, we have a specific customer we want to run this report…

Hello, Our accounting department was trying to limit who has access to Vendor Maintenance, and instructed me to remove permissions for all users except for a select few. Unfortunately, when one user was trying to use "Receipt of Invoice Entry," and…

I am currently doing Period End processing for my company, and have successfully completed it for our active company. However, we have an old company we still do maintenance on in SAGE, and while I was trying to change the Fiscal Period in GL I receive…