Sage 100

I'm new to sage, and have a customer that wants to upgrade from 4.5 to 2017. I'm doing some reading of the documentation, and it mentions pre-migration and parallel migration utilities, converting the data to 2017, and migrating it to 2017 version. My…

Greetings, We're in the process of upgrading our ancient Sage 4.50 to Sage 2018. Ran into a strange issue with regards to rebuilding the key files prior to migration. All the files were able to be rebuilt and optimized without any issue except for…

For some reporting purposes I need to normalize the bill of materials exactly how it shows in the BM_SummarizedReportWRK report into a SQL table. How do I do this? I've been attempting to backwards engineer from the regular and accessible Bill Of Materials…

We have Sage 100 installed on a remote desktop server. It's been working for a couple of months, now every 2 or 3 days, the Sage 100 client stops working and I get one of two errors. It says either "No valid servers found" or "Sage 100 ERP is not set…

Greetings, We are running an older release of Sage 100 (4.50.40) and we have a third party extended solution called M9-SO-1099 'On Demand' Sales Order Fill Report which was provided by Blytheco. The manual for the add-on is here. https://wiki.blythecodev…

Hi, does anybody have any idea how to speed up Sage MAs 200 version 4.5 printing. when i print or preview a document, such as an invoice, every invoice take 1 minute to print out/preview. We checked our internet provider and was advised that our internet…

I want to add some info to General Ledger - > Daily Transaction Register Form. How to do with it?

We have a new crystal report that references the largest tables in the database, the sales order header and detail tables, and we had to a UDF field to one of these large tables. The crystal report references this UDF field to make a calculation, and…

User says that reports were printing normally on this workstation until today when this error occurred and now cannot print or preview any reports. Has uninstalled and reinstalled MAS client (Autorun - run as administrator) but still gets the error message…

Is there a utility or tool that will allow us to identify a master developer enhancement affecting (read / write) a particular M4T file? The file in question is CU_Users.m4t. For some reason teh sales order program wants to look at the CU_Users.m4t located…

Hi, I'm writing a query of my Version 4.5, I need a listing of TransactionType used in AR_TransactionPaymentHistory and what mathematical sign should be used with each in creating a report in Excel. I know about the following Transaction Types: I, P…

I am a veteran MAS 200/Sage 100 ERP user and have done many types of imports over many years. I am working on a 4.5 Sage 100 Advanced version of Sage (we are upgrading in early September) and need to import some temporary vendors and their invoices…

We are running MAS 200 Version 4.5 - non SQL version. We are planning to upgrade to Sage 100 2014 before the end of the year. I am trying to find out the maximum number of orders that MAS 200 / Sage 100 can handle per day, before I will see the performance…

Hi All, Because of some peculiarities with the PR_EmployeeDocuments.M4T file in version 4.5, I am needing to edit a large number of records manually. What I am looking for is a hot-key or hot-key combination to go to the next record. While in DFDM…

I want to import a table's date field with a RUN ASSIGN field that has the current date (or a formula would be better) as the default instead of a static date. So that the user can either accept the default current date or enter their own date. Does anyone…

I built an application that pulls data from BusinessWorks, which now needs to be converted to Sage 100 4.5. With BusinessWorks, I ran simple queries like the following against the ODBC connection with no issues. With Sage 100, I'm receiving an error:…

Hi, I was wondering if anyone had any thoughts on the SQL version of MAS200. We are considering either getting the DSD SQL mirroring software or switching to the SQL version in our next upgrade. We publish reports on a Sharepoint site, and the Providex…

Hello, I am preparing myself for the eventual migration to MAS 4.5. I have created 2 test servers to facilitate this process in understanding how it works, what will break and what we will need to do for a smooth production migration. The first test…

Looking at any views in Explorer for our main company works fine. However, in our test company (which should be a recent copy of our main company), when you click on any view, the screen shows no details and when you close the window, you receive Providex…

I'm having problems using VI to update Sales Order and Invoice files that contain the following fields: CorporateTaxOverrd and DepositCorporateTaxOverrd. These fields appear blank in older records and all set to "N" in newer records, but I can't find…