Sage 100

We need an MRP report that is just a small subset of the entire 154 p. report and in a format more readily readable by our purchasing buyers. Using a silent connection string, I created a MSQuery table in Excel that brings in the filtered results of MRP…

Has anyone used Sage Alerts & Workflow v10 w/Sage 100 providex yet? When I try to add a calculated column, the top where it says calculations to perform is blank and I can't choose a calculation. If try to do it manually whatever calculation I receive…

Hello, There is error message on the Sage100 as shown below. How to fix the error? Thank you in advance for your help!

I added a tab to my Invoice Data Entry panel with UDFs I want to be able to select an option in "SCAC Code" which will then display the proper name of the carrier outside of the SCAC Code dropdown. I want the SCAC Code and CARRIER NAME to be separate…

Hello. We're moving from Sage 100 (2013) to another software, and I need to export actual tax exemption certificate numbers out of Sage, but having a hard time finding it. Let me start by saying I got thrown into supporting Sage without any training or…

Does Sage 100 Vendor Maintenance have the ability to tie into the IRS TIN data base to verify a vendor's SSN or FED ID when setting up the vendor code in A/P?

We're using the SODAMAS90 4.0 ODBC driver from sage. Our excel is part of office 365, so it is the latest version. We were able at one point in time (a few weeks ago) to run queries in excel via Data > Get Data > From Other Sources > From Microsoft Query…

Hello All, We are using SAGE 100. Somehow On PO qty coming in Stock status report is not Open PO Qty. SAGE is pulling a open PO qty from somewhere - SAGE ppl kindly share your thoughts In the below example, in main I m seeing a open PO qty but in…

v2019 Adv. Customer would like a Crystal report showing what email address is set up in Employee Maintenance/Paperless for Electronic Delivery. It may/may not be the same as the Email that is on the Employee Header. The PR_EmployeeDocuments.m4t is an…

Hi, I've been wondering if there's a way to get the latest revision number from A Bill of Materials. I've tried to get the value by uising oProduction.nGetValue("Revision$", strRevisionNo) but im still getting the "000" revision number. Thanks…

why is the container importing my excel file with blank (NULL) values for items with alpha numeric labels? additionally the columns have switched order? Excel Output Connector Module Sample Run Original Excel FIle Import

I have set up a linked server in SQL 2017 set up from Sage 100 using the v4.40.0004 ProvideX ODBC Driver. We are looking to create a data warehouse to mirror Sage 100 ProvideX tables in full and refresh deltas throughout the day. Pulling FULL tables…

It appears that the process that is used to synchronize the workstation synchronization is no longer an app that can be run to update components after product updates are installed. Instead a vb script is run from a temporary folder. The problem is…

Sage 100c 2018 SQL server I want to add a database to my production Sage 100 Server instance. Will this cause any issues with Sage 100? I may also be able to use a linked server, but I'm not familiar with the limitations there, either.

We are in the beginnings of trying to get positive pay setup. I have our bank specifications for the positive pay file. I am learning that this file can be setup to be produced by Sage under the Bank Reconciliation module. We do not use the bank reconciliation…

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…

Asking for friend who just moved to Sage 100 Premium from Advanced and he has a question. "I need to figure out how to get all of my SQL data (logs and data) to reside on the D: drive instead of the C: drive. If I make a backup company the C drive starts…

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…

Recently updated Sage 2017 from v5.40.3 to v5.40.4 along with Jobops to resolve an issue that caused us to have to run sort files daily to fix inventory. Does anyone have any inkling as to how to resolve this issue?

I have a client his mas90 program crashed. He has a backup. Can i get the name of a company that can help me import the data into sage 100

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

User 1 created an excel file that pulls in data from Sage 100 Standard via ODBC. Created same dsn connection (same dsn name) on User 2's computer. "Test Connection" successful with saved username/pw. User 2 opens the same excel file and tried to refresh…