Finance forum

Charge adjustment in vendor invoice

(0) Share

Report

Posted on by Galio

145

Dear All

I am facing with issue about Adjustment on vendor invoice.

For more detail, after posting invoice for PO, I received a freight bill which has to be loaded on inventory. So I use Adjustment function in invoice line to record this charge. My charge code debit Item and credit to ledger a/c and having amount 200,000 VND.

->My expect result after adjust charge is :

Debit item : 200,000 VND

Credit ledger a/c : 200,000 VND

->But after adjust charge, my voucher transaction for this addition charge include debit to Vendor invoice rounding-off account as below capture and the charge amount does not allocate fully in inventory:

And additional info is my accounting currency is USD. Could you please tell me whether vendor invoice rounding off is always included in charge adjustment voucher or not? If possible, how does my charge voucher meet my expectation (only include Debit item and credit ledger a/c)

Categories:

Financial Management

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Galio,

It might indeed be related to currency issues.

Can you share details on the PO, the item prices and values recorded?

Have you tried replicating this in a different demo/test environment? If so, did you get the same result?

Best regards,

Ludwig

Was this reply helpful? Yes No
Galio 145 on at

Like (0)

Report

Thanks for your reply,

I create a PO to buy 10 item A with unit price 50,000 VND/1 ea as below:

After posting invoice, I use adjustment function to add 02 charge code in invoice line, one having transaction currency USD, another is VND:

The voucher transaction of charge code having currency USD does meet my expectation (Debit inventory/ credit ledger a/c):

However, The voucher transaction of charge code having currency VND does not, it happened vendor invoice rounding-off account:

One more additional info about currency rounding rule of VND in my enviroment as below:

I have tried to test in different environment but all of result for this case is similar. Does it standard of D365 or I miss some configuration?

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

What is the exchange rate VND-USD that is setup in your system?

To me it seems to be a rounding issue.

If we have the exact FX rate then we can calculate.

Ludwig

Was this reply helpful? Yes No
Galio 145 on at

Like (0)

Report

Hi,

I set up 1USD= 22,740 VND for this transaction day as below :

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Galio,

If I look at your charge of 200000VND then it is converted into 9.5238 USD.

That is, an exchange rate of 21000.021 is used for this conversion.

This is different from the exchange rate 22740 that you shared.

Do you know why?

Best regards,

Ludwig

Was this reply helpful? Yes No
Galio 145 on at

Like (0)

Report

Hi,

Sorry for my mistake. that is my exchange rate for this charge : 1USD=21000 VND

Was this reply helpful? Yes No
Galio 145 on at

Like (0)

Report

Hi Ludwig,

As your consider about rounding rule, when I adjust rounding rule for general and purchase from 0.0000 to 0.4000, the vendor rounding-off is not include in my charge voucher as below:

But I have yet to clear about the meaning of this field. How does the system calculation and rounding all number? Can you give me more details on this and suggest to me which amount should be entered in this field?

Was this reply helpful? Yes No