Sage 100

Hopefully someone here can assist as Sage Tech Support could not answer the question. Is the SData connector compatible with Sage 100c Premium (SQL) on Windows 2016 Server? If yes, what version of the adapter? (Extra love for a link to it!) …

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…

Is anyone else having any issues with this? It appears to be a conflict between Avatax and Starship. System is Sage 100c Premium 2018 (Version 6.00.3.0); , Avatax Config shows "Sage 100, 6.00.3.0 || 2.0 DSD", StarShip Client is 18.0.3. Some funny…

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…

We are using Sage Premium 100, and have crystal reports for sage installed. We have the SQL version of sage. My user role is an 'admin' in sage. I know how to get to the place to make a new database connection, however, I am lost after that. I would appreciate…

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…

Good morning. During the refresh of an upgrade from 2017 Standard to 2018 Premium, the system activity log shows the following messages for each company that was converted. XXX Company data conversion to version 06.00.00.00 started XXX Company data…

I have a client that's interested in using 100 Premium in a SQLaaS (SQL as a service) environment. I can't find ANY documentation on this, so am assuming it's not supported by Sage. Has anyone had any experience with SQLaaS at all, or with Sage 100 Premium…

We are purchasing Sage 100 Premium 100 SQL version. We will be purchasing a new server (Server 2012). I know little about SQL. My question is, does Sage provide the SQL version we need, or do we purchase it. Would it be Microsoft SQL server? Also…