Skip to main content
Solved

External Voucher: Load Error

  • July 4, 2022
  • 4 replies
  • 283 views

Hi, 

When trying to load an external voucher, the system packs all the information into the account field. 

 

I don’t see where the error is in the setup: 

 

 

or in the file: 

 

 

Does anyone see something? Any help is highly appreciated :)

Kind regards, 

Anny

Best answer by Rcoubrou

I have a text qualifier of “   (quotes)  and it’s in the IFS default voucher template as well.

We also use voucher_no, (default as 1 and it gets overridden with set up) , accounting_year and currency code. You may need those defaults as well.   I wouldn’t worry about entering debit amount and credit amount, the template should work fine with just column M for amount as a debit or credit.  I’ve only used them for foreign currency entry.

4 replies

Forum|alt.badge.img+4
  • Sidekick (Customer)
  • 5 replies
  • July 4, 2022

Hi Anny, 

 

It looks like your file is separated by semicolon (;) - but your External file template has Comma as the file separator. 

Rgds

Trine

 


Forum|alt.badge.img+13
  • Superhero (Employee)
  • 111 replies
  • July 4, 2022

Hi @Anny 

it seems that you are using wrong separator in your external file template (second screenshot). Please try to use semicolon as separator.

Best regards,

Adam


Forum|alt.badge.img+11
  • Hero (Customer)
  • 133 replies
  • Answer
  • July 4, 2022

I have a text qualifier of “   (quotes)  and it’s in the IFS default voucher template as well.

We also use voucher_no, (default as 1 and it gets overridden with set up) , accounting_year and currency code. You may need those defaults as well.   I wouldn’t worry about entering debit amount and credit amount, the template should work fine with just column M for amount as a debit or credit.  I’ve only used them for foreign currency entry.


  • Author
  • 30 replies
  • July 7, 2022

@Rcoubrou @Trine  @Adam Mazurczak 

Hi all, 

Thanks for your input! It worked now and I’m very happy 😁!

Have a wonderful day 

Anny