• Invoice import through visual integrator not hitting ledger accounts

    I have been trying to import invoices from one vendor through the visual integrator, I can pull up the invoices in vendor maintenance in accounts payable but the transactions are not posted to the ledger accounts. I visited invoice register to post but…
  • VI Import General Journal Entry

    I'm trying to create a VI Import job to bring in some general journal entries but can't seem to figure out to grab the next Entry No automatically like I can with Batch Numbers and Invoice Numbers. I can't get them to import properly without actually…
  • VI job with File Assign IM_ItemVendor

    Trying to do a VI import into IM_ItemVendor but in my import file I don't have the vendor number only the vendor name so I file assigned the vendor number on a conditional statement if the temp field (pointing to the vendor name in import file) equals…
  • Import AR credit memo detail lines from history?

    I am hoping to streamline my VI script designed to import AR credit memos. If entered manually I only enter CM <Next Invoice>, Customer Number, Apply To Invoice. I am then asked "Do you want to copy invoice information from history?" Clicking Yes allows…
  • Pass TEMP0001 to next VI Job in chain?

    On Sage 100 Advanced 2018, 6.00.5.0. Most of my experience with VI has been rather basic, updating or adding customer accounts, but I also have written scripts to import to Repetitive Invoicing Entry and Cash Receipts. However that is using data that…
  • VI Job for Inventory Transaction with lot or serial numbers

    FormerMember
    FormerMember
    Hello All, Running: Sage 100 2017 V5.40 Here is the problem. Need to import inventory transactions however, getting this message on the import. (Already checked inventory is there and good) Please help, I have tired everything even SAGE without…
  • VI Job HS Record Failure (All lines have not been distributed)

    I'm running into a problem with an import job from Excel where the VI Job passes in Test mode but not when executed. If there is more information needed please let me know and I will try to get it. Keep in mind that I was not fully trained in this…