• VI Export - how to export the Company Code

    Can't find this having been discussed anywhere, although I thought I had. I am assuming I can use a Temp field and either assign "<CompanyCode>" or Calculate it somehow. So far, nothing that I have tried has worked.
  • 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…
  • Looking to Export AP Payment Transaction History-System Limiting Export

    When exporting payment history for AP I am only getting a few years information. If I run a report I can see the system has 20 years worth of data but its only giving me 2+ years which is more like just the time frame for viewing in the system. I tried…
  • 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 Export Job - Conditional export of two data fields into one column

    I want to export SO_InvoiceDetail data. In one of the columns, I need the value to be the ItemCode, unless there is an AliasItem, in which case I want the AliasItem to be exported in the column. My export currently looks like: InvoiceNo - Col 1 ItemCode…
  • Visual Integrator - Export Job - Error 12

    Running Sage 100c 2018 I had a job get stuck and attempted to unlock. In doing so, it now gives me the error that a file could not be found and an error #12 File VIWDEF.LIB Is this an easy fix? Thanks, Ryan
  • Visual Integrator adding an extra delimeter

    I'm working on some VI export jobs in Sage 100 v2019. I'm noticing that when I run the jobs, v2019 is adding an extra delimiter to the end of each row. v2017 doesn't do this. Is there a way to prevent this?
  • Using Visual integrator to export invoices, the tax amount field is always empty.

    I am not sure why when I run the VI export job, the tax amount from SO_InvoiceDetail appears to be 0 in the exported result file. All other values are being exported correctly. I have also check ed manually in the sales orders and invoices that the tax…
  • Visual Integrator Export by Date

    Is it possible to subtract days from the current date? I'm trying to do an export from the AR_InvoiceHistoryHeader table, and I want this to be automated, and I don't want to export the entire table every time. I've tried things against the TransactionDate…
  • VI export - All Vendors not just one company per job

    Hello- I have created some VI export jobs for exporting text files to export Vendors but I notice it only returns vendors for the company the job is being ran under? Is there a way to run one job and get all vendors for all companies? The best thing…
  • How to change file type in EXPORT JOB MAINTENANCE,

    How to change file type in EXPORT JOB MAINTENANCE, For me it is showing FILE TYPE: Delimited, and that drop down box is disable (grayed) so I can not change file type. Tried checking / unchecking ASCII
  • VI Import - CI_Item Table

    We were looking to clean up and standardize our misc item codes across our MAS companies. Our support group said you can't delete them if they had been used in the past, but we could switch "UseInPO" to N to hide them. I've built a VI job that seems…
  • UDF field Missing Leading zeroes in Crystal

    we are on MAS100 5.1 using crystal reports 2011 for Sage. I have created a UDF field in Sales Order Detail called UDF_Customer_Item_No , i made this 15 char long as a String, control type multi line. we are using visual integrator to import orders…
  • VI Import Question

    I am currently new to VI and looking to see if there is a lookup function that would determine a value to be passed during the import based on a value found in the import file. As an example, the import file that has been provided includes an account…