Question

Voucher is not balanced in accounting currency issues

  • 17 April 2024
  • 0 replies
  • 24 views

Badge +1

Hi, I’m currently trying to load some GL entries into IFS Cloud 10, and I’m having troubles with balancing the voucher, and I think it has to do with having very large numbers inside the .csv file that I’m trying to load. I’m including an image below to show that although the column does sum to zero according to excel, I am still getting the balance error when I try to load. There are four entries in this column that are extremely large, for example one of them is “206177399998227” so the .csv file does some formatting to it (scientific notation, showing as ######## if I don’t expand the column, etc.) and I believe this is what is throwing off the load. I was able to load other GL entries that didnt contain these super large numbers with no issues. I think this is more of an excel question, but I wanted to see if anyone here has had similar issues, and if so how were they resolved. Thank you!

 


0 replies

Be the first to reply!

Reply