Skip to main content
Solved

Posting Proposal unbalanced due currency rate mismatch

  • May 10, 2023
  • 4 replies
  • 493 views

Dilrukshi
Sidekick (Employee)
Forum|alt.badge.img+7

One of the customers is facing challenge with balancing the posting proposal of manual supplier invoice, due to header currency rate is not the same with posting information line currency rate.

Error message ID: Accounting Currency not Balanced

Error Details: Net amount in accounting currency ####.## does not match with posted amount ####.## in accounting currency SEK.

 

This line currency rate cannot be manually edited and only relevance of this currency rate is that it is the rate on original created date of the attached invoice. But the customer has not ticked the “Use File Transaction Date as Voucher Date checkbox” in external supplier invoice parameters window at the time of voucher creation.

 

Please help to share your ideas and any known reason/solution for this issue. Thanks.

Best answer by Shehan Almeida

Hi Dilrukshi,

 

Is there a Purchase order receipt matched to this posting line? And if that PO is connected to a Project which is connected to a currency rate type, then it could cause this kind of imbalance. 

 

Application would always take the currency rate from the currency type connected to the project instead the rate defined in the invoice header. Please see the solution ID 257503 for similar scenarios reported. 

 

Shehan Almeida.

4 replies

Shehan Almeida
Superhero (Partner)
Forum|alt.badge.img+18
  • Superhero (Partner)
  • Answer
  • May 10, 2023

Hi Dilrukshi,

 

Is there a Purchase order receipt matched to this posting line? And if that PO is connected to a Project which is connected to a currency rate type, then it could cause this kind of imbalance. 

 

Application would always take the currency rate from the currency type connected to the project instead the rate defined in the invoice header. Please see the solution ID 257503 for similar scenarios reported. 

 

Shehan Almeida.


Dilrukshi
Sidekick (Employee)
Forum|alt.badge.img+7
  • Author
  • Sidekick (Employee)
  • May 11, 2023

Hi Shehan,

Thanks for your feedback.

Yes, there is a purchase order with milestone/stage payment. 

Let me check on the information shared and get back.


Dilrukshi
Sidekick (Employee)
Forum|alt.badge.img+7
  • Author
  • Sidekick (Employee)
  • May 11, 2023

Hi Shehan,

After checking, PO is connected to a project and this is the reason for the issue.

Thanks for the support.


Forum|alt.badge.img+16
  • Hero (Customer)
  • January 25, 2024

@Shehan Almeida 

@Dilrukshi 

 

I have the same error as reported. a PO is connected to a project. see the error screenshot below.

May I know what is the solution? in project, we are also using currency rate type 1, the same as invoice header currency rate type.