Sage 100

I am trying to use VI to import Sales Orders from a e-Commerce platform but the only customer-unique field that the source file has is the customer's email address. I would like to use those emails as a cross-reference to assign the customer number to…

Hello, We have a custom-defined script that triggers Post-Write on the table CI_Item. This script then reads the field 'ItemCode' of that table. We also want to extend this by triggering this script with other tables. I am seeking a way to retrieve…

This is happening with a single table MS Query in Excel 64-Bit when accessing large individual I/M and P/R files and continues after rebuilding them (Ex. IM_ItemTransactionHistory) . I reviewed the other thread on this error, but nothing applies other…

We are on Sage 100 Advanced v2022.1 and I don't see anywhere a Sales Forecasting report or option to enter numbers or imported via VI. We have a new Sales Executive and he wants me to import sales forecast numbers, by Customer and Item to produce a…

I just upgraded from Sage 2020 to Sage 2023 and can't get any of my existing (or new) VI Import Jobs to work. When I try to actually run the job and test them, I get the message: "VI JOB_NAME Unable to open [wdx][odb]<dsn_name>" I don't get this message…

I have been trying to import invoices from one vendor through the visual integrator, I can pull up the invoices in vendor maintenance in accounts payable but the transactions are not posted to the ledger accounts. I visited invoice register to post but…

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…

Client is running Sage 100 v2018 and have asked for a VI import of cash receipts. They scan in information and save it as a csv. However, the information does not include Customer Number...only Invoice Number. Within the Sage 100 Company where the data…

I am hoping to streamline my VI script designed to import AR credit memos. If entered manually I only enter CM <Next Invoice>, Customer Number, Apply To Invoice. I am then asked "Do you want to copy invoice information from history?" Clicking Yes allows…

Version: Sage 100cloud Premium 2020 (Version 6.20.0.01) Additional software: Scanco Operations Management & Multi-bin, Some custom DSD programming Hello all! First post here. Looking for some assistance when it comes to replicating data for reporting…

PR header and detail are chained. Same problem with each.

Any help is greatly appreciated. Using Sage 100cloud Standard. My company uses Access to query Sage data. This works well, but I'd like to run more advanced and rapid queries. My system administrator has allowed me to install Postgresql on my computer…

We are transitioning from Century Business Solutions to Paya Connect Merchant services Objective: to see if there's a way to move the credit card tokens from CBS to Paya so we can continue to have access to the credit cards. I understand that I need…

I am encountering an intermittent "[ProvideX][ODBC Driver]Internal error" within an Excel workbook containing several worksheets, each of which contains a Microsoft Query (MSQuery) to various Sage 100 Advanced v. 2019 PU 2 files/tables. The query results…

Is there a way that I can use to import my Main Account, MA Description, Account Category, Main Account Group, MAG Description, Account Type & cash Flow Type? I'm not copying this from another company. It's a brand new chart of accounts with over 1000…

On Sage 100 Advanced 2018, 6.00.5.0. Most of my experience with VI has been rather basic, updating or adding customer accounts, but I also have written scripts to import to Repetitive Invoicing Entry and Cash Receipts. However that is using data that…

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…

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…

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

Hi; Please someone can help me ; i need a manuell of structure database SAGE 100 ; thnks!

Hello! I am trying to create an order completely with SData and Paya. I have no problems with it when I am trying to create an order with PaymentType = Check. Here is the XML for such example: <entry xmlns:atom=" ">http://www.w3.org/2005/Atom…

The name limit for the local computer network adapter card was exceeded. We have to manually start the backup every night. Then it will complete successfully.

Hello, Received a notification for a Payroll Update, so I ran the update, but when completed, gives error "File 'PR_PayrollCycle' not found". I did this both on server and client workstation and same result. There is no file permission issues, and…

Hi all! Just curious what your experiences are because Sage doesn't officially validate individual SQL Server builds with Sage 100 Premium. If you can supply the version of Sage 100 Premium (e.g., 2017 ) and the SQL Server build # (e.g., 12.00.5546…

We've recently moved from Sage 100 providex to SQL. Upon looking at our tables in SQL it appears that every field of type datetime now has been set to not allow null values. As a result all of those fields now automatically populate with 1753-01-01 (SQL…