Skip to main content
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

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.

View original
Did this topic help you find an answer to your question?

Forum|alt.badge.img+4
  • Sidekick (Customer)
  • 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

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+10
  • Hero (Customer)
  • 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.


  • 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
 

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings