• Override Unit of Measure in Visual Integrator

    I'm doing an import job maintenance. Our PO has the field L.QuantityOrdered as 12 and L.UnitOfMeasure as "EA". In Sage, the Item has a Sales UOM of "CS6", which translates to 6. So when we import the order, the PO means 12 total, but the system…
  • Import Employees to New Company

    I have a client that has been sold. We are going to create a new company and copy accounts, vendors, customers, etc. but not the history. I also need to copy all of the active employees. Has anyone done in the new payroll with PII? Thanks, Suzanne…
  • VI Import of A/P Invoices using AP Expense Distribution Table

    Our client has a system in place that kicks out a dept code. This department code has been directly linked to a G/L account by utilizing the AP Expense Distribution Table (Code 5 on the Distribution Table is equivalent to the G/L account we want to import…
  • Exporting data through a VI job where a numeric field may be zero (0) but need it to show as 0.00.

    Client is running Sage 100 v2018. Tried PRC(AP_InvoiceHeader04.DiscountAmt,2) in the numeric field - Calculation but that doesn't seem to change anything. The numeric mask is ###,###,###.00- but if the DiscountAmt being exported is 0, it's not showing…
  • Importing daily file with a variable name

    Running SAGE 100 v2018 and trying to import a file on a daily basis that will contain a data stamp on it. What I'm trying to do is automate the process by creating a scheduled task in Windows that opens a batch file that runs the VI program. The only…
  • AR Invoice Import

    I feel like I should know this, but for some reason I'm struggling with this VI job. I am importing into AR Invoice Data Entry. My file has over 400 lines in it. What I want to happen is have the import assign the Next new invoice number, once. However…
  • VI import into payroll doesn't stop, have to click "cancel". All records are imported, though.

    PR header and detail are chained. Same problem with each.
  • Importing employee data

    I'm attempting to create an import job that will either create a new employee record if it does not already exist or update an existing employee if it's already present. I'm running into an issue where existing employees are not updating and am not sure…
  • Importing sales orders Premium version

    Have a request to schedule VI jobs automatically to run multiple times during the day but then they want the .csv file deleted out of the location since the next import file will be named the same. This is for importing sales orders. It's v2020.2 and…
  • VI import for PO Receipt of Invoice

    Hello, I have created a VI job to import into PO Receipt of Invoice and encountered a problem with assigning the OrderLineKey from the original purchase order. I have it working if I manually provide the order line key in the import file but need to…
  • Import $0 A/P invoice

    Is it possible to import a $0 A/P invoice? The current V/I import job fails when a $0 invoice is imported. The message reads, "You must have at least one line." I can manually enter a $0 invoice, so I'm hoping a $0 invoice can be imported. If there…
  • Quantity on sales order does not match order tab quantity

    Sage 100c Advanced SQL 2018 6.00.5.0 So I think this is happening because of me... Before last year, when we pulled orders on paper, we would take the sales order and move it to invoicing, then key punch all of the backorders on the Sales Order Invoice…
  • VI Export Job - Conditional export of two data fields into one column

    I want to export SO_InvoiceDetail data. In one of the columns, I need the value to be the ItemCode, unless there is an AliasItem, in which case I want the AliasItem to be exported in the column. My export currently looks like: InvoiceNo - Col 1 ItemCode…
  • Visual Integrator - Export Job - Error 12

    Running Sage 100c 2018 I had a job get stuck and attempted to unlock. In doing so, it now gives me the error that a file could not be found and an error #12 File VIWDEF.LIB Is this an easy fix? Thanks, Ryan
  • Desktop Customization Import v2020

    Has anyone used the new v2020 feature under File, Desktop Utilities, Customization Import? I have an upgrade from 2017 to 2020 and have classic users on the 2017 version with shortcuts and the boxes to check for importing are blank. There doesn't seem…
  • Visual Integrator INV History (by Item by Date)

    I'm trying to export a list of items sold by date and product line. It seems that no matter what formatting I try, VI just ignore my date and processes all records that match the product line criteria.
  • Export All Sales Orders for Move to QB

    Hello, I've been tasked with moving us from Sage 100 to Quickbooks Enterprise. I don't know much about the backend and support of Sage 100, so looking for someone to baby step me through A)Is it possible to export all current Sales Orders? B)How do…
  • Need help creating a VI Job

    I am new in this company and I found out that previous people were not knowledgeable of the Bank Reconciliation Module. I am now facing a the situation that though we only have 1 bank account, 2 different Bank Code have been assigned to it, making it…
  • Visual Integrator Export - Error #17: Invalid file type or contents

    Hello, I am trying to create a VI Export job to extract AR_InvoiceHistoryDetail & AR_InvoiceHistoryHeader Information. I've setup the fields very much like I would a VI Import job, but when I click accept to test run the job I am receiving an error that…
  • Tax Exemption Exports

    Hello. We're moving from Sage 100 (2013) to another software, and I need to export actual tax exemption certificate numbers out of Sage, but having a hard time finding it. Let me start by saying I got thrown into supporting Sage without any training or…
  • Visual Integrator Link Table Wildcard idea?

    Hello All. I am somewhat familiar with VI and have used it for imports and exports. However, I have something I can not figure out. Perhaps not possible. I have a need to dump the entire contents of the IM_AliasItem file to CSV. Not a big deal. However…
  • Importing Main Account, etc

    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…
  • Export and import default delimiter

    I apologize if this is the wrong place and/or if this has been asked before. I have searched and having found it. I'm looking to change the default delimiter for Visual Integrator from comma to semicolon as we have lots of uses for commas in descriptions…
  • ODBC for VI using Access Split Database

    Hi all, would like a better understanding of best practice in setting up an ODBC link for Sage 100 VI jobs. We are currently still on Sage 100C Advanced 2018, and I am working to beef up what began as a home-grown Access solution to meet a specific accounting…
  • Pass TEMP0001 to next VI Job in chain?

    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…