• VI Import to SO_InvoiceTracking with multiple packages from UPS Worldship export

    Hi Sage 100 Community, I'm trying to help our warehouse cut some manual entry time with their UPS tracking numbers. There is currently a process in place with UPS Worldship that exports a CSV at EOD to our Sage server and then a series of VI Import…
  • User is unable to print from Sage 2022

    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…
  • Zip Code Removal on US Country

    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…
  • Visual Integrator

    We recently had two customers combine and now have a new company name. I am trying to use visual integrator to update their ship-to address names (all of them - not just primary) and I cannot figure it out. Thank you in advance for any info.
  • Error 11 Can anyone shed some light on how to correct?

    We have an user that is moving parts around on several bill of materials. He is consistently receiving this message. Often after the message is received the items behave oddly, such as not being able to delete or modify. When we try to delete or modify…
  • sage mas90 odbc version 3.3.100 error can't start transaction

    Hello i wanna to connect mas90 using odbc i know mas90 odbc is only read information, but i need also write some values in some tables for example on Purchase Orders when we received a pdf invoice read information from there and put on file detail of…
  • VI Job Output via Command Line

    I'm currently running SAGE 100 version 7.10.5.0. I can run VI Import jobs no problem via a .bat file or through command line. However I'm looking to get some output back from running the job. Ranging from: Successful or unsuccessful login (right…
  • 2023 SQL Premium configuration & backups

    Hello friends, We have begun working with our awesome consultant on our Sage 2023 Premium upgrade from an older Providex version of MAS. It's very exciting! We are at the point now where we need to get backups running for our new accounting system…
  • VI Cash Receipt with only invoice number

    Sage 2019 - Looking for way to import into AR_CashReceiptHeader from a source file that contains only the invoice number and check number but not the customer number. Manual entry allows to enter an invoice number followed by the check number. This automatically…
  • VI General Ledger Journal Entry Import - JournalComment Issues

    Hello Sage 100 Community, I've been tasked with creating an Excel import sheet for Journal Entries. I've used the following layout: Account No. Debit Credit Posting Comment Journal Comment 6570-00 500.00 0.00 Test comment…
  • Attempting to use ODBC Driver returns `[S0000] [ProvideX][ODBC Driver][FILEIO]Table is not accessible (12)`

    I'm attempting to pull data from Sage across the ProvideX ODBC connection via external application (Python, C#, etc). After I establish a connection using the existing Data Source, every subsequent attempt to read any table returns the following error…
  • Server-mounted PowerBI Gateway

    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.…
  • Exporting Invoices from Customer Inquiry to Excel Produces a Date in the Amount Field

    Hello, We are attempting to export all invoices for a specific customer from the Invoices tab of A/R Customer Inquiry using the Excel button. However, the output in Excel produces a date in the Amount column for all invoices. How can we fix this issue…
  • Error message while trying to print sales order in MAS 90 V 3.22

    Got this error message when printing sales order in was 90 v 3.22. Was able to "end" and print sales order. Error 262. Program SOZREB. Line 5305. I have no idea what this means. Any help?
  • ACA Reporting Worksheet

    I have a client that wants to set up ACA in Sage. They have several hundred employees so I was hoping to use the VI jobs to import the information. The knowledge base article (Solution ID: 224924550061699) that has the path to the VI jobs, references…
  • Sage 100: Dropping in Employee Maintenance Data using a CSV or Excel file

    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!
  • exporting invoice detail lines

    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…
  • VI Job import not working with inventory warehouse transfer transaction with Scanco muti-bin Enhancement - Does not distribute the lines to the appropriate Bin Location

    I have a vi job that is suppose to transfer inventory items from one warehouse to another along with their bin location. Scanco muti-bin is installed. The job is not able to distribute the line tiers of bin location. Has anyone had this issue with VI…
  • BM_GrossReqrmntReport_rpt

    I'm not finding a way to import several Bill Numbers into this report's parameters. Can you help me? It seems like i should be able to do this, however i'm not finding the right path yet. VI doesn't offer it and i'm having trouble finding clues to help…
  • hosting platform? Backup is made to third-party solution ?

    Is user data backed up, and if so, is it backed up to a third-party solution? what about Hosting Platform, Can you provide detailed information about this ?
  • importing vendor invoices

    How can i import vendor invoices from a spreadsheet
  • VI Job for IM_ItemMemo

    Hello, Was trying to create a VI import job to add an item memo for a particular vendor items. When an user enters in the item during SO entry it would auto display letting them know they must call vendor for quote. However when attempting to create…
  • Merging Items

    I am getting this error when trying to merge items, I am assuming in is an Insynch table but I don't see it in the SQL DB. Any ideas? Also have about 24k items we want to merge, importing into IM_DeleteChange table and running the merge utility is the…
  • VI import to JC Trans Detail Cost Type invalid

    New install bringing in JC Trans Detail seems to think all entries are change orders and change orders can only be Cost Type S (subcontractor). Errors on all transactions that are not Cost Type S.
  • Are we able to import memo settings for auto-display?

    When you create a new memo, there is a preset list of records automatically populated into the module's ...memosettings.m4t table. I don't see anything in VI nor any other work-around that will let us access that table to do updates. (This is when we…