Solved

Incorrect Domestic Amount in Expense Sheet and Voucher

  • 2 November 2022
  • 2 replies
  • 126 views

Badge +2

Hi All,

 

I am experiencing a strange problem in Expense sheet and in the E voucher created in relation to that.

 

The company’s Accounting currency is EUR and it doesn't have a parallel currency. The expense is entered in SEK which has a currency rate of 10.84. Therefore when an expense is entered for 100 SEK and paid in EUR the equivalent amount in Pay currency is 9.22 (EUR) which is correct. 

 

However the domestic amount which should also be in EUR has a different amount (1,084.21)

 

 

As you can see the value entered in SEK has reverse calculated the amount for EUR. 

 

Had anyone experienced this?

 

Kind Regards,

Antony

icon

Best answer by MadushaDissanayake 4 November 2022, 04:23

View original

2 replies

Userlevel 7
Badge +17

Hi @NovAntonF ,

 

As per the correct functionality, the domestic amount should be equal to the gross amount in pay currency. I have checked this in the latest UPD version of our internal Core environment and it is correct.

 

There’s a bug fix [Bug ID 164116] which belongs to next UPD to be released [UPD18] that might resolve this reported issue

 

Here’s the description of the fix, please check if it’s the same issue you are having.

 

Companies with Inverted Quotation Currency erroneous amounts are recorded in the domestic amounts.

*Test Plan:*

# Accounting Currency is EUR

#Note that the currency rate is with inverted quotation - Currency Rate of USD for an example is 1.36

# Add an expense sheet with currency code USD > Authorize >  Gross Currency amount is 1,000 and Gross amount in pay currency is 735.29

# On the postings tab, the same amount 1,000 can be seen in Gross Currency Amount, but the Domestic Amount shows a different amount as 1,360.

 

Thanks and Best Regards

Madusha

Badge +2

Hi Madusha,

 

This is the exact issue that we are facing and thank you for letting us know there is a fix.

 

Appreciate it.

 

Kind Regards,

Antony

Reply