x Want to participate? Join the group to interact

  • How to change VI job export column heading

    I'm exporting column names in my Visual Integrator export. I need to rename one of the column headings, but I can't seem to find a way to do that. Anyone have any suggestions? Thanks!

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

  • How to obtain Quantity of Items Sold and Issued with Custom Date Range

    I am trying to export a report, by vendor (or product line), of the quantity of items sold AND issued for the last 12 months. We would like to be able to export it using any custom date range that we want. What is the best way of getting this data? I…

  • VI Import chain via batch file launched by windows task scheduler.

    We have a long time customer that has been running a batch file that launches a VI job. The first job chains to another and so on for several jobs. They are and have been Sage 100 premium, we just upgraded them to 2020. The batch file works and all the…

  • VI Perform logic Error Log

    Hello everyone, I received existing import job with defined perform logic The import job contains Command "CREATE_ERRORLOG" on Failure. Сan anyone tell me where I can find this error log? Also, Is there a link where listed all available commands…

  • VI PO Receipt of Goods both Lot and Avg items in the same receipt

    I'm trying to recreate PO Receipt of Goods from history. I can't seem to import to a PO where 10 lines are lot distributed and 1 line is not. What field can i add to distinguish between them?

  • Visual Integrator

    We have an export for item quantities. At the moment we're exporting 3 columns of data which include "Item Code", "Temp001" (which is a calculated field), and "Suggested Retail Price". We're having negative numbers that are exporting in the "Temp001…

  • VI job addDays to add business days

    Hello, I've used VI jobs for various import and export jobs to import things from sales order info to bill structure. I dont use a lot of conditional based columns. What im trying to do is have the ShipExpireDate be 5 business days added to the order…

  • VI Import for SO Invoice - Misc and Charge items from SO not importing

    I need to know if there is a script or perform logic that can help my situation. - I have a VI Import Job importing Invoices from Sales Orders - The source file does NOT contain the Misc or Charge items from the SO Can this be done without the…

  • Next doesn't work for EntryNo on VI import to BR_Transaction

    The only option I have on the VI import to BR_Transaction EntryNo field is Incr Assign. It tells me Next is invalid for this column name. I'm attaching a pic of my VI import. I'm in Sage 100c 2018 Premium. What's happening is our imports are copying over…

  • Paperless Office Log Files / Visual Integrator Import - PLEASE VOTE!

    This idea for the Paperless Office/Visual Integrator module was posted over a year ago and could use some votes. You don’t really realize you need this, until you really need it. Currently, the Paperless Office log files cannot be accessed through…

*Community Hub is the new name for Sage City