Sage 100

I have a csv file I am importing into an associated item table from a DSD enhancement. The original file, the csv file, and the data in a text file all have just the item code, ex “2000-Black-S” in the files shows “2000-Black-S The” as trying to import…

We bought Sage 100 STANDARD and need to import Customer data so that we can create jobs and record time. There is no obvious way to import a CSV of Customer data. The online help says to GO TO CONTACTS. There is no CONTACTS option. Specifically I went…

We are trying to setup a VI export job to bring out 10 fields from the AP_PaymentHistoryWrk table. We do see data in the AP Payment History report which uses this table so I'm not sure why the VI export is blank. The job is setup as follows: …

Hi, I know SequenceNo counts up if a duplicate record is generated on the same day but I am not sure what fields exactly need to be used. Is it just SalesOrderNo, WTNumber, WTStep, RecordType, and TransactionDate? Or is it the rest of the fields as…

Hi, I am looking at our backend tables and I am trying to determine what user did what. In our worktickets I see UserCreatedKey and UserUpdatedKey but I cannot find a table that links those to the employees table. I read that they might be stored…

Hi All. We're in the process of upgrading to Sage 2022 and I'm trying to recreate some SSIS packages (SQL Server 2019 and Visual Studio 2022) that connect to Sage 2022 via the ODBC 64-bit driver and copies to one of our SQL Server 2019 tables. I'm…

Trying to upload a budget file. However, when I test the upload I am getting errors where the 3rd segment of a GL account number is being left off and causing the error XXXXX-XX- is not on file. However, other GL accounts are loading just fine. Our…

This is a Go-Live upgrade, so obviously the test upgrade, and a subsequent "refresh migration" were able to go through. However, now that we are trying the final migration, with just the MAS_XXX company data (no system files) we are getting this - over…

I'm trying to create a VI Import job to bring in some general journal entries but can't seem to figure out to grab the next Entry No automatically like I can with Batch Numbers and Invoice Numbers. I can't get them to import properly without actually…

I have a need to import new inventory parts that have the inch symbol as part of the description. The file was given to me as an Excel file so when I save it as a csv it puts double quotes in the description. Example: Mating Deck 12" X 1 1/2"" I remember…

I need to export invoices that are from yesterday's date and the related Sales Order begins with a J. I am a novice at using Sage Intelligence, but I have some SQL experience. I understand that it's not actually SQL. I'm able to get the below SQL…

In our SQL Agent Data Warehouse load job, we are running into intermittent issues with connecting to our ODBC driver. We had run into this issue previously, but it essentially disappeared on its own; however, once I upgraded the SQL server's OS to Windows…

We are using Sage 100 Standard ERP 2013 (Version 5.00.4.0) / SAGE 100 ERP Issue detail: when I click on Work Order -> Work Order Transaction Entry (Snapshot 1) -> it asks for the date and once I enter the date and click OK -> I get an Update Interrupted…

I'm pulling data from across several Sage companies into a postgreq db to do some reporting on sales trends. What is the difference between ar_invoice_header (psuedo) and ar_invoice_header_history? ..and if you can tell me, at what point do they move…

Hello I Have MAS90 version 4.05, I tried to connect using ODBC driver but i don't get connect send a error could bot connected Driver keyword syntax error, I created new odbc and when i tested sad is ok don't error but i called from app send error my…

Client just upgraded from 2019 Premium to 2022.2. This Cash Receipt import was working on the prior version. It is basically line for line what I have with another client on 2019 Adv which IS working and same as what I just tested on my Std 2022. I have…

I've been tasked with creating an AR Invoice import job with the input file not having an invoice number. Looking for a way to have a "Run Assign" field that would prompt for the next invoice number to use and then increment that number upon change…

when I try to rebuild the GL Summary Detail Drill Down file I get the following error, Error 107 Keyed file error (Wrong key Block addr) Program is SY_Rebuildfile_BUS PVC Statement is 2324 We are trying to rebuild this file because we cannot add a new…

I was originally trying to do a linked table in MS Access to JC_Job, but I got an ODBC call failed. I have no problem pulling other tables, so I tried import instead of link and I get "The decimal field's precision is too small to accept the numeric you…

I am having difficulty exporting PO's from Sage 100 2021 Advanced to MS Access via the ODBC connection. I can export headers just fine but I can't seem to export lines. I know I can get the data via linked tables, but it doesn't allow me to do what I…

I'm trying to connect via ODBC to Sage from PHP and I keep getting this error: Uncaught PDOException: SQLSTATE[S0000] SQLDriverConnect: 145 [ProvideX][ODBC Driver][PVKIO]Logon failed in X I made a 64 bit DSN, configured it, went to Debug tab, Test…

During the migration process, the following error appears. Parallel Migration Wizard - InstallShield Wizard Error execute: Select ServerProperty('ProductVersion') As Product Version. After clicking on the OK button. This error appears: SQL Server…

Sage 100 2021 PU4 This did not happen in PU2. There is a knowledgebase article ( Solution ID: 112555); however, TimeCard is not installed and no records have a blank ModuleNumber$ field.

Greetings, I'm running into a roadblock attempting to add an ODBC data source via Power BI Service via +New / Data sources page from the following URL. https://app.powerbi.com/groups/me/gateways Here are a few facts: The ODBC driver (for Sage…

I am needing to run an Open Balance Export job that contains specific headers that are located on different tables. The primary table I'm using is the `AR_OpenInvoice`, to which I am attempting to link to the `AR_InvoiceHistoryHeader` table. The problem…