Good day Nandi

Please note that you should view statement/ age analysis for foreign customer only in foreign currency. When viewing statement for foreign customer in home currency and the customer is open item it does not display the foreign currency revaluation transactions, as they have zero value on foreign amount. You will notice the differences on Detailed Ledger and Statement are coming from the foreign currency revaluation transactions.

The differences come because of the exchange rates between currencies that fluctuate all the time. The amount on the age analysis in home currency will show because of this.

Please see the knowledgebase article below:

https://za-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=200129183137411&page=1&position=2&q=revaluation 

If you are asked to login, please use your email address and Pastel customer number as the password.

Please could you kindly verify or reply and let us know that this solution worked. 

Kind Regards. 

Good day Nandi

Please note that you should view statement/ age analysis for foreign customer only in foreign currency. When viewing statement for foreign customer in home currency and the customer is open item it does not display the foreign currency revaluation transactions, as they have zero value on foreign amount. You will notice the differences on Detailed Ledger and Statement are coming from the foreign currency revaluation transactions.

The differences come because of the exchange rates between currencies that fluctuate all the time. The amount on the age analysis in home currency will show because of this.

Please see the knowledgebase article below:

https://za-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=200129183137411&page=1&position=2&q=revaluation 

If you are asked to login, please use your email address and Pastel customer number as the password.

Please could you kindly verify or reply and let us know that this solution worked. 

Kind Regards. 

Hi

Thank you, I understand the difference between rand & Currency.

What I do not understand, is that on:

Koi002 in foreign currency I have 2 Credits.

On the rand value, I have a debit and a credit?

I can’t send this statement in currency to the customer? He is going to say we owe him money? How do I correct this?

Good day Nandi

This will need to be investigated further. Please email [email protected] with full details of the query so that they can investigate the problem for you.

Please verify or reply and let us know if the advice / suggestion provided was helpful

Kind Regards.

Good Morning,

Please could you advise if you received a resolution to your query and what the resolution was.

Kind Regards

Joanne

This was a very specific issue whereby the exchange rate was not read by the system correctly. 

On testing we opened the sales order, tabbed through the lines and deleted and re-entered the line value.

The report is now showing correctly in both foreign and home currency.

Kind Regards

Joanne