Sage 100

A user of ours has recently been set up on a newly refurbished device. Device is on Windows 11 While logged into Sage 2022 they can drill down to specific location but when trying to print or preview the get the following alert "The database login…

Hi, I'm having an EDI PO import error that says zip code "33966" for Fort Myers FL is used in more than one country. I exported the SY_ZipCode table and found it listed for both US and USA. Would someone be willing to suggest a method for removal…

Having trouble with a server-mounted, On-Premises Gateway communicating with my silent ODBC for Sage 100 access. On-Premises Gateway successfully installed on my server (also the Sage server), and my published Power BI semantic model recognizes it.…

Anyone have any experience with using an excel or csv data base spreadsheet to import employee maintenance info into Sage 100? Looking to save some time for a large client. Name, Address, SSN.. Thanks!

is there a way to export the line details on current open AR invoices. When I use Business insights the current open AR invoices just give the balance of the invoice not the line detail for those invoices. If I use invoice history I get more then open…

First time in 12 years that the report I maintain is getting an error. Failed to retrieve data from the database. Details: s0000:[ProvideX][ODBC Driver][PVKIO]Data page header contains invalid record offset information. [Database Vendor Code: 109…

Looking to see how big AR Invoice History Header and Detail files can get before there is a performance hit or a file size limit. We are looking at importing AR invoice details going forward in 2024, instead of a 1 line summary per invoice (actually…

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…

Is it possible to change the company code during a VI Chain to event? We have a process of importing data into the SO tables in one company code and then updating a field in the PO Header of another company code. I'd like to use the VI Chain To field…

Please help!!! Very simple VI job has been in use since 2015, maybe earlier. But within the last year, we have had at least 3 incidents, and want to make sure that if user forgets to populate this column of the AR cash receipts excel template, the record…

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…

Where can I get a cross reference table from the files/tables in V2019 to map to V2022 fields Thanks

How can I use an IF THEN ELSE statement in the Expression Builder when importing a job? I keep getting a syntax error. For my current example: I'm looking to import item shipping weights. I already have my import value assigned to Temp001 . So now I…

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, I want to read and write data in sage100 database, so after some research I found out this course for reference. But just need to validate that is this course really guides on how to read and write back data to Sage100 database or not? This…

Hi, I am new to Sage100 and customer is using Sage100 advanced which comes with ProvideX ODBC driver which only allows to read data from Sage100. I did some research on the functionality to write back the data in Sage100 but was not able to find any…

I have seen some similar threads but none of them seem to work. Here is my situation, and bear with me I am very green with ODBC connections: I am wanting to connect to SOTAMAS90 through PowerBI gateway to get my data on a constant refresh. This would…

I have built an order importer that automatically creates sales orders based off of an EDI file from our customers. It works great. We are currently upgrading Sage 100 to include Production Management Plus and I want to be able to add in the ability to…

Hello All, I've been trying for the last two months to figure out a way to automatically distribute lot numbers by FIFO in S/O invoice data entry using visual integrator. We don't create a sales order before creating the invoice. Each of our inventory…

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…

There are several orders in our system, of which both the Sales Order Entry UI and table field of PickingSheetPrinted indicates that the picking sheet has not been printed. However, I do find the paper version of picking sheets of those orders in the…

Trying to import POs with different Units of Measure in the lines. Inventory item is set up with Purchase UOM TON and Sales UOM LB. For some reason, the imported PO has a quality error (when UOM is different from the Purchase UOM, it multiply the conversion…

we are attempting to delete a SO. we have successfully done so to other SO but this one item gives us an error #47 Substring reference out of string and we are unable to do anything.

I've encountered problems while trying to use SAGE 100's Visual Integrator to export data from Job Cost's JobHistoryTransDetail table to a SAGE 100 User Defined Table? I need to export all of the JobHistoryTransDetail table records for a desired date…

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…