Difference between accounting currency and reporting currency in a posting

(0) Share

Report

Posted on by Eric_Santos

Hi all.

I'm having a problem in the postings of purchase orders on D365OP related with accounting currency and reporting currency. When I post a purchase order the system records transactions without error but when I see the voucher recorded I note an error there. The values of credit and debit are not balanced only to the reporting currency. And the difference between credit and debit are being posting in another ledger account.

Anyone can help me to fix it ??

I have the same question (0)

All responses (8)

Answers (0)

Sort by

André Arnaud de Cal... 306,430 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Eric,

What type of posting is this? A purchase receipt or invoice? Does the purchase order have one or multiple lines?

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Eric_Santos,

I cannot see that the voucher is not balanced. The total DR and total CR transactions are identical in accounting and reporting currency.

In the reporting currency you have an additional amount posted on a separate account but in general DR and CR match.

Can you let us know the English language posting type that is used for the transaction in the last line?

Best regards,

Ludwig

Was this reply helpful? Yes No
Eric_Santos 46 on at

Like (0)

Report
Copy link

Link copied!

Hi Ludwig.

Thanks for your reply.

Ludwig, if you pay attention in the screenshot you will see that have diferences. Look that on the reporting currency the debit value is 11.300,10 and the credti value is 11.304,80. Because of this the system created a new line on the voucher of 4,70 wich is the difference between debit and credit values.

Was this reply helpful? Yes No
Eric_Santos 46 on at

Like (0)

Report
Copy link

Link copied!

Hi André.

That's a purchase order invoiced. The invoice have only one line, account and off set account. In the last screenshot appears more lines because my collegue did the reverse posting of the invoice but as you see, it doesn't worked. In the purchase order reversing process the system made the same thing.

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Eric_Santos,

Thank you for the feedback.

Is this a foreign currency purchase order?

Do you know if the exchange rate that is used for recording either the foreign currency purchase order or the exchange rate that is used for the reporting currency changed after the packing slip was posted?

If this is not the case, can you find any charge, service item or something else alike in the purchase order that might be responsible for the $4.70 posting?

Best regards,

Ludwig

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Eric_Santos,

I tried replicating this issue and wanted to ask if you are aware whether somebody has possibly changed the currency in the PO header after the packing slip was posted?

Can you check that?

Best regards,

Ludwig

Was this reply helpful? Yes No
ZvikaR 190 on at

Like (0)

Report
Copy link

Link copied!

Can I ask to the reason you are using the same currency for accounting currency and reporting currency?

what purpose does reporting currency serves for you?

Was this reply helpful? Yes No
Suggested answer

Ahmadbarghouthi 85 on at

Like (0)

Report
Copy link

Link copied!

Hi Ludwig,

I am facing the same issue result but in different way.

The SO transaction imported from external system and should be inclusive the VAT, whats happened that the VAT checkbox wasn't ticked and then the VAT has been added an extra line to the voucher, thus, the total was to be 585 and now it's 700, which is the transaction and reporting currency are equal but the accounting currency is differ with the amount that equal the VAT which 115.

What do you think about this one?

Was this reply helpful? Yes No