Sage 100

 View Only
  • 1.  Does anyone have a sample VI Import job for import

    Posted 10-17-2014 11:07
    Does anyone have a sample VI Import job for importing into AP Check Header? Version 4.5 - the project is to import Invoice Payment Selections. TIA!


  • 2.  RE: Does anyone have a sample VI Import job for import

    Posted 10-21-2014 16:26
      |   view attached
    Well, ok, so I have something that works. The plan is to design an Aging report to export to Excel. The decision-maker will put a mark in a column that represents ""Pay this invoice"". The file becomes the data source for the import. But here's the thing - if there are invoices on hold or with discounts, it imports them - if they have discounts, the job log shows them as having imported with invalid fields (message - invoice amount exceeded). In the case of invoices on hold, it just brings them in. If you open the record in the job log, you see the message ""Warning - the invoice is on hold - do you want to continue?"" If you make your selections using data entry, you get prompted. Since the records will get imported if marked to pay (regardless of the discount date), is there anything I need to (or can) do about this other than train users to look for them in Check Maintenance?

    Attachment(s)

    pdf
    vi_importjobdefinition.pdf   56 KB 1 version