• 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…
  • Visual Integrator Chain to & Change company code

    Is it possible to change the company code during a VI Chain to event? We have a process of importing data into the SO tables in one company code and then updating a field in the PO Header of another company code. I'd like to use the VI Chain To field…
  • 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…
  • Duplicate imported payments

    We imported manual check entry payments via the Visual Integrator module. Accidentally uploaded twice, and now have duplicate payments posted. They're exactly the same, down to the same check number. Can I delete the duplicate? Or will I have to void…
  • 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 Import Job Expression Builder IF THEN ELSE Statement

    How can I use an IF THEN ELSE statement in the Expression Builder when importing a job? I keep getting a syntax error. For my current example: I'm looking to import item shipping weights. I already have my import value assigned to Temp001 . So now I…
  • 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…
  • Anyone using Time Track for Job Costing, but exporting the time track entries for outside payroll service to process payroll

    Anyone using Time Track for Job Costing, but exporting the time track entries for outside payroll service to process payroll?
  • Automatically Distributing Lot Number in S/O Invoice Data Entry through Visual Integrator

    Hello All, I've been trying for the last two months to figure out a way to automatically distribute lot numbers by FIFO in S/O invoice data entry using visual integrator. We don't create a sales order before creating the invoice. Each of our inventory…
  • Import PO using Visual Integrator

    Trying to import POs with different Units of Measure in the lines. Inventory item is set up with Purchase UOM TON and Sales UOM LB. For some reason, the imported PO has a quality error (when UOM is different from the Purchase UOM, it multiply the conversion…
  • Visual Integrator Import Sales Orders Referencing a Master Order

    I use VI to regularly import sales orders. In this case, I would like to reference an existing master order, as the only data that needs to change per order is the header comment. As I have several master orders to reference, it would be nice to populate…
  • Sage100 Visual Integrator: Where to put ship to informaton?

    OK. This has me flustered. I have figured out how to use Temp fields in Vi for Sage 100 2019 to create a single SO that has multiple items on it. The data source I'm using has a separate row for each item purchased, and my current VI job creates one…
  • Business Insights List Query

    Hello! I am trying to find a way to automatically export sales order data (specifically ship date) from business insights sales order view into a locked excel document provided by my customer. It would be nice if i could filter a whole list of orders…
  • Can I use SAGE 100 Visual Integrator to export data from Job Cost's JobHistoryTransDetail table to a SAGE 100 User Defined Table?

    I've encountered problems while trying to use SAGE 100's Visual Integrator to export data from Job Cost's JobHistoryTransDetail table to a SAGE 100 User Defined Table? I need to export all of the JobHistoryTransDetail table records for a desired date…
  • Sage100 Visual Integrator Conundrum

    All, I'll try and be concise. I am working with Sage100 2019 and Visual Integrator Jobs. We just moved up from Mas90 4.3. Whoa, I know. Here's my dilemma: In Mas90, we had a VI job that would bring in website orders in a csv formatted file and import…
  • VI Jobs missing for newly created Role.

    Hello, I am in the process of restructuring roles for our company. We just began testing, and one of the reported issues is that there are no VI jobs in the job select menu. All of the Visual Integrator permissions are selected for this role, so I am…
  • AP Invoice Entry - VI Job

    Hello Everyone, We are currently on Sage 100 Advanced v2018. I am trying to create a VI Job into table AP_InvoiceHeader to load AP Invoices into AP Invoice Entry. but i keep getting an error during load from my Excel FIle that i am using. adding…
  • How to Chain VI Export Job to Import Job

    It looks like the Chain utility only allows chaining multiple Import jobs OR multiple Export jobs. Is there a way to chain an Import job to an Export job or vice versa?
  • How to import invoice date in an AP_ ManualCheckHeader VI Job

    Hello all, I have just created a VI job to import invoices and corresponding manual checks. The invoices have a separate date from the check date. The VI job seems to only acknowledge the check date, using the same date for the invoice and the check…
  • Invoice with multiple lineitems with different dates in AP import (via VI module)

    Questions: 1) Please suggest how can we create AP invoice with different dates for details within and success import their via VI module? 2) Please suggest how can we add lines (details) to existing AP invoice via VI module? Description: Our…
  • Check status of VI Job (Sage MAS 100)

    Questions: 1. How to check status completion of VI Job? (see picture 1) 1. What Sage MAS 100 table and field should we use to determine VI Job status using ODBC? 2. Is there other way to run VI Job without using PVXWIN32.EXE? The problem description…
  • How to enter search criteria for Blank Fields

    Utilizing Visual Integrator, I am attempting to create an export query where I only export the AR Customers records with blank comment fields. Anyone know of a way to do this?