x Want to participate? Join the group to interact

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

  • Sage 100 Standard 2020: How do I import a bank statement to Sage 100?

    Hi all, I'm new to Sage 100 and trying to become more efficient at my job. I learned recently that it is possible to import a bank statement onto Sage 100 and automatically create invoice entries for them. After doing some preliminary research, there…

  • VI General Journal total debits and assign credit account number

    I'm trying to import a journal entry. I've calculated the Debit Account number by combining other fields to make the complete account and that works. Now I need to total all the debits to get the credit amount and then assign the credit account number…

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

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

*Community Hub is the new name for Sage City