• Is it possible to do a "test run" migration from version 4.5 to 2017?

    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…

  • Rebuild Key Files - Strange Issue?

    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…

  • querying summarized bill of materials

    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…

  • Sage 100 works, and then it stops working. No valid servers found or Sage 100 ERP is not set up properly

    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…

  • M9-SO-1099 'On Demand' Sales Order Fill Report

    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…

  • Printing is very slow.

    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…

  • How to edit General Ledger - Daily Transaction Register form

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

  • Will adding a non clustered index to a UDF field in the sales order history table cause any problems within MAS 200 client modules ?

    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…

  • MAS 200 v4.50.3 installed on Widows 10 - "Wrong version of Crystal Reports installed"

    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…

  • Error trapping enhancement related errors

    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…

  • AR TRANSACTION TYPES

    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,…

  • Vendor Number does not import when importing new vendors

    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 into…

  • Maximum Number of Orders that Sage 100 Can Handle

    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…

  • Data File Display & Maintenance Navigation

    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, using…

  • V/I Import Date field Default - Can it be done?

    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…

  • Custom Queries From My Application

    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:…

  • MAS200 SQL Version

    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…

  • MAS 3.7X SQL to MAS 4.5 SQL Upgrade Question

    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 server…

  • Explorer Views not showing data; giving error

    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…

  • CorporateTaxOverrd and DepositCorporateTaxOverrd

    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…