Solved

External Voucher: Load Error


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

icon

Best answer by Rcoubrou 4 July 2022, 15:27

View original

4 replies

Userlevel 2
Badge +4

Hi Anny, 

 

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

Rgds

Trine

 

Userlevel 5
Badge +10

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

Userlevel 4
Badge +9

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.

@Rcoubrou @Trine  @Adam Mazurczak 

Hi all, 

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

Have a wonderful day 

Anny
 

 

Reply