I don’t think there’s anything wrong with the file. As you can see in the previous screenshot, the import correctly brings in as Invoice Referece 1077087098, which is a company 77 invoice series and number. I gave up on using invoice number and just added the actual invoice ID (versus number) to the input file, as recommended by another contributor. Works like a dream.
10 is the invoice series, 77087098 is the invoice number. (The input file is generated as SUPPLIER payments from a different company number to be imported into this company as customer payments.)
It even looks good on External File Transactions. (see the bottom of the image)
@gumabs , I’m missing something, apparently. No matter what I do, the value I say is Invoice Number ends up in Payment Reference on the External Payment and nothing goes to Series ID or Inv/Prepaym No. Do you see anything wrong with this? I can add currency and other columns, but Invoice Number just won’t go. (In the sample, the 1st and 4th lines aren’t good data, but the 2nd and 3rd lines should go. I’ve tried with just the two good lines, doesn’t make any difference.)
@gumabs ...Good information! I’ll adjust my template and see what happens. Thanks so much!
Thanks @gumabs . On your External Payment Parameters, Definition of Identifiers tab...how do you have that set up, if you don’t mind sharing? And what about the Message Codes tab?
@DarshiG , were you able to resolve this? I have the exact same problem.
Thanks @Jens !
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.