x Want to participate? Join the group to interact

  • VI Cross Reference Customer Email to Customer Number

    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…

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

  • 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.

  • Visual Integrator not importing all rows to SO_Invoice

    I'll probably rebuild this process as a BOI but.... this is just so perplexing I'd kind of at least like tug the thread and see where it leads. Environment: Sage 100c 2021 v7.05 I have an ETL process that brings the invoices in from our mobile invoicing…

  • Invoice import through visual integrator not hitting ledger accounts

    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…

  • VI job does not import Serial Numbers

    I'm going through a process of converting several Standard Cost Parts to Serialized in our system for each of our warehouses. I've adjusted the items out manually using a transaction entry. I've changed the valuation from Standard to Serialized using…

  • VI Import Not Recognizing All GL Account Numbers

    Trying to upload a budget file. However, when I test the upload I am getting errors where the 3rd segment of a GL account number is being left off and causing the error XXXXX-XX- is not on file. However, other GL accounts are loading just fine. Our…

  • VI Import General Journal Entry

    I'm trying to create a VI Import job to bring in some general journal entries but can't seem to figure out to grab the next Entry No automatically like I can with Batch Numbers and Invoice Numbers. I can't get them to import properly without actually…

  • VI import Job for AR Invoicing without an Invoice Nbr on input file

    I've been tasked with creating an AR Invoice import job with the input file not having an invoice number. Looking for a way to have a "Run Assign" field that would prompt for the next invoice number to use and then increment that number upon change…

  • VI Export Job: Issue Linking Tables

    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…

  • VI Import AP Credit Memos

    Have the following source file (CSV) 2 questions: 1 - I want to import the Invoice No and append "-CM". Is this possible? 2 - Importing the lines Distribution Amount from the Credit Column. How do I reverse the sign so it comes in as a negative…

  • Purge specific records from AR Invoice History-VI or SQL?

    Running Sage 100 Premium 2021: need to reduce the size of the AR Invoice History tables. The purge invoice history utility is good as far as it goes, but I need to remove invoices for only one division that creates thousands of repetitive invoices monthly…

  • VI Cash Receipt with only Invoice #

    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…

  • Import AR credit memo detail lines from history?

    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…

  • Sage 100 Premium 2020 SQL Server Transactional Replication for Reporting

    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…

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

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

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

  • Intermittent "[ProvideX][ODBC Driver]Internal error"

    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…

  • 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

  • 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.

  • Unable print _Manual check and payment register_databace connector error

    Hello, There is error message on the Sage100 as shown below. How to fix the error? Thank you in advance for your help!

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

*Community Hub is the new name for Sage City