• Export Notes

    Hello Together We try to export all the notes out of Sage CRM. I did try run it by Microsoft Query but no idea how the table is really called as they are so many. Or is there an other and easy way to do it. Like all of them at once? Cheers and Thank…
  • VI Automation behaving oddly

    I have a Batch file that has been running VI jobs for years. But recently some of it hasn't been working. The batch file calls 2 separate VI Import jobs, with a timed pause between. The first VI job runs fine, and loads the data without issue. The…
  • Unable to retrive purchase order and lines using the dispatch object mentioned on the description

    using (DispatchObject poObject = new DispatchObject(pvx.InvokeMethod("NewObject", "PO_PurchaseOrder_bus", oSS.GetObject()))) Could any one of you suggest, which dll or nuget to be used for this dispatch object. We are using the below object management…
  • 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…
  • 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.
  • 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…
  • 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…
  • 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…
  • 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…
  • 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…
  • Where to see Task Schedule completion?

    This is all done on a test company. I am running a task through Task Scheduler, but am not seeing anywhere that is has completed running. I've looked through the logs with no indication of completion. Anyway to see completion?
  • Import Error

    I am receiving an error message when clicking on any template in the task scheduler. Here is what happened. How it happened: Library Master > Task Scheduler > I ran IMPORTITEMS (worked great until I put all the imports into script). It has been…
  • Opening Balances of GL

    Hi Team Please help to locate the Opening Balance column/field in the GL table list. Or how can we get the Opening Balance/Closing Balance data from Sage 100 ERP. Thanks Thulasi.
  • VI import

    Hello... I'm trying to create VI jobs that will update the Customer Price Levels. I have two tables with fields I need, CI_Item (itemcode & Vendor) and the IM_PriceCode (Price Method, CustomerPriceLevel and DiscountMarkup). So I created one VI job to…
  • Visual Integrator - Update value in CI_Item

    Can Visual Integrator update all the PriceCode values to a specific value (like an SQL Update works)? Example; I want to apply the letter "A" as the PriceCode for all records in the ci_item table. Using visual Integrator, I can export, modify the…