Browse By Tags

  • 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 for Transaction Entry

    Hello, I setup a VI import Job for Transaction Journal Entry and it was working fine until recently. It is taking the offset account number and using it for the line account number as well. I am telling it to get the number from column, but it ignores…
  • VI Bat File Error

    Attempting to create my first bat file to run a VI job outside of Sage 2018 Advanced 6.00.5.0, getting a Connection Time Out error. Can anyone tell me where I went wrong? I followed the steps carefully to create the new app in the Sage Application Server…
  • Visual Integrator - how do I renumber a vendor and delete the old vendor number?

    I used visual integrator on a test company to try to renumber an AP vendor. I used AP Vendor Master table, downloaded a copy, changed one vendor to test, and uploaded. This worked to create another vendor with the new number, however, the original vendor…
  • How to use VI to adjust an invoice and recode it or use VI to enter one invoice coded to many GL accounts

    I currently have a VI job that we use to import commissions invoices. We obtain those commissions from a separate software. Here is a screen shot. I am looking to modify this in order to adjust an invoice. For example, we pay our corporate credit…