x Want to participate? Join the group to interact

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

  • Upload Work Ticket Template with Visual Integrator

    I am uploading several work ticket templates at one time using visual integrator. I can find the tables/variables where all the field data exists, but am not able to find the extended text. Can you please help and advise the table name where the extended…

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

  • Sage 100 2020 VI for JT Tables

    Hi, I am attempting to export the JT_Template table to turn around and import the file in another company. The only field not coming through the export is the Text field from tab 6 of WT Template Maintenance. The field in the Data tab of the export says…

  • Table for "Promoted to Order On", VI and Making Excel Reports

    I am trying to make an excel sheet (ideally a custom report), which shows the amount we invoiced every day, and the amount that was promoted from quote to sales order every day. Grouped bar graphs is what I'm trying to achieve. I figure the easiest…

  • Can you add new products using Visual Integrator?

    I need to add several hundred product from our website into sage. I can export product codes from our website, and I'd prefer to format descriptions on one master excel sheet. Can you "mass add" products using VI? I'm a bit new to VI, so I wanted to ask…

  • Work Ticket Entry – Import using Visual Integrator

    I am working on importing into Work Ticket Header in Sage 100 version 2020 Premium working with Production Management. I am trying to create the same action that occurs in the user interface of Work Ticket Entry in Production Management. In the UI of…

  • Importing Sales Order with Credit Card Pre-Auth getting error

    I am trying to import our Web Sales orders with Credit Card Pre-Auth and getting this error. Anyone know what this error means?

  • Table not listed in in VI import job maintenance table list (but is listed in VI export job)

    I'm attempting to create a job in visual integrator to update info in a table column from a CSV file, but am running into the issue that the table does not appear in the table list when creating the new import job (the export job works without issue)…

  • Update records with combine keys(records)

    When we import by Visual Integrator to update certain records it adding on another line instead of updating. Needed to update price_columns on AR_PriceLevelByCustomerPriceCode, where expected it will update the 'pricelevel' by looking the combination…

  • Next Work Order Number

    I am trying to create a VI job to import work orders. The job works fine, but there does not appear to be the option to use the next available work order number., the "Next Assign" feature is not available. Does anyone know how I can auto assign the next…

*Community Hub is the new name for Sage City