VI Import to AR_InvoiceHeader fails with HS Record Invalid

I exported the AR_OpenInvoice file to Crystal to extract very old invoices and save to a .csv file.

I built a simple VI_Import to create CMs to write off the invoices.  The import job validates on test but then fails when run with HS Record Invalid or Write Failed column is not in the IOList.

Has anyone experienced this error?

Parents Reply
  • 0 in reply to Sailor

    I know, which is why I said what I did.  The order things are done does matter.

    If you get Next before setting invoice type, Sage may have already assumed it was IN (open the Entry screen and try it)... making it impossible to change to CM after that.  Type and ApplyToInvoiceNo would become unavailable for input. 

    The help files indicate type comes before the Next invoice number is selected.

Children