• VI job error in VI_ImportAssignValues.pvc

    Hi there, I'm testing out the first of many imports in our parallel upgrade test environment. We are going from 4.5 to 2023 100 Premium. I'm getting an error when running an import of an order that is downloaded from TrueCommerce's EDI TransactionManager…
  • 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…
  • AR Invoice History file size limits or performance hits

    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…
  • Visual Integrator; Importing into SO_InvoiceHeader and Leaves Back Order

    I'm on Sage 100 Standard 2020 (v6.20.1.0). We create sales orders, and then after each sales order ships, invoices are imported into a SO_InvoiceHeader batch. When the batch is posted, all the sales orders are supposed to disappear from SO_SalesOrderHeader…
  • VI Job for Inventory Adjustments

    Hi there, I hope you can help me. I created a job to import data for a positive inventory adjustment, and I need to specify the unit cost. We are using Scanforce multi-bin software, so we also need to specify the bin and lot. The issue is that the job…
  • VI Job How can I import a job with forced return?

    I am importing new item descriptions and it includes a character return (alt enter). If I enter it in the file, it causes the entry to error out when imported. Is there another way I can import it or will we have to go in and manually enter the hard return…
  • VI import limits data that can be imported

    I have a VI job that imports in to a UDF associated with the IM_ProductLine table. One of the UDF's; "UDF_LIC_ROY_DUE" is a number masked to two (2) digits. It is intended to hold a number between 1 and 31, representing the day of the month payment…
  • Safe to convert Sage 100 Premium to Temporal Tables in MS SQL?

    Currently on Sage 100 Premium 2021; I need to track changes to AR_RepetitiveInvoiceHeader and AR_RepetitiveInvoiceDetail, but no built-in audit log exists. I've toyed with scripting to a UDT but now that we've moved to Premium, the power of MS SQL is…
  • VI Export Conditional Expression

    Morning, I am trying to create a conditional express for a VI export job, but don't seem to be able to figure out the formula. Can someone guide me on what it is I am doing wrong (if not all)? {SY_SalesTaxClass29.TaxClass$} = "NT" then {Temp002…
  • VI JOB Cash Receipts Import - How do you set up the job to validate INVOICE TYPE in the user's source column/field to be either IN or PP and never blank or null?

    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…
  • VI Import Job Unable to open [wdx][odb]<dsn_name>

    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…
  • VI job to import cash receipts

    I've been tasked with creating a VI job to import cash receipts and am new to using VI. Actually, fairly new to Sage, but I come with some relational database experience. I am having issues linking the AR_CashReceiptsDeposit and AR_CashReceiptsDetail…
  • How to rename a Temp Field in a VI export?

    Haven't found this posted before, although it may have been and my searching skills are diminished. I also understand that this might be something that I can pull into Access or Excel, or even write a Crystal Report, to accomplish. But for the moment…
  • Customizer Import Refuses .M4X file from the same version (both are Sage 100 2022 7.10.2.0 32 & PR 2.23.0.0 32-Bit)?

    Why would a Sage 100 2022 Customizer Utility import fail if it is used to copy from a ".M4X" file a P/R UDT, VI jobs, and event script to the same level (Both are Sage 100 Standard 7.10.2.0 and P/R 2.23.0.0) from which it was created?
  • 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…
  • How to avoid triggering pre-total events for each line of the same imported invoice?

    I've developed a script that, for some customers, discounts TX ItemCode's to absorb their AvaTax calculated sales tax and present a invoice total including sales tax (but not freight) equal to the original net invoice, but when the invoice is imported…
  • Calculate Running Total per Invoice in a VI Job

    My client imports SO Invoices, and would like to calculate the quantity of one line based on the running total of the other lines, and then assign that quantity to the item line. Here's the scenario: 1. Accumulate the quantity of all the items that…
  • Can we use VI to place/drop a standard PO that pulls balance from a master PO?

    Hi, We have a lot of master PO's that suppliers ship partials in multiple shipments. Hence we assign a letter to a standard PO for each shipments using the same master PO #. The standard PO draws balance from the master PO (Master/Repeat PO). We are…
  • VI Import Cash Receipts Deposit w/o Deposit Number

    Working on Sage 100 v2016 and trying to figure out how to import cash receipts using one file when the file does not contain a Deposit Number. I don't believe I can use the 'NEXT' operation because my Cash Receipts Header/Detail import needs to use the…
  • 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…
  • Remove line breaks in VI Export

    Hello all, SAGE 100 Could Advanced 2020 (V6.20.1.0) I have a VI (Visual Integrator) export job that pulls fields from CI_Items out of SAGE and into a .CSV file. I use Task Manager to automate this export and then another software reads the .CSV files…
  • VI Invoice Counter on export of AP_CheckDetail

    Hi Everyone, I am trying to export the AP_CheckDetail and CheckHeader information but I need to have a counter on the invoices. There is a field NumberOfDetailLines but if the Check has 5 invoices this field shows 5 but I need to have each invoice…
  • VI Job error WO with Bill Revision

    I'm trying to create a job to change dates for Work orders. Some WO through errors like this when the Revision Code has any letters. Some of our revisions are just numbers like the ### but some do have some letters which are allowed in the Bill of Materials…
  • Import AR Salesperson Commission - Err Record in Uneditable State

    Older version Sage 100 4.5 (yay, I know) Need to change the SalesSubjectToComm amount, created VI Import to AR_SalespersonCommission Test run, all records pass. Live run, all records fail with "Record is in Uneditable State". No other users…
  • VI *.SQL Files Are Not Being Migrated To 2021

    I have seen two different upgrades affected by the *.SQL files under MAS90\VI failing to be migrated to the 2021 MAS90\VI folder during upgrades. Anyone else encountering this? The manual solution is to just copy them but I don't recall having to…