Penny difference on SO invoice vs PO invoice

(0) Share

Report

Posted on by Community Member

Hello all,

I'd like to know about penny difference on AX2012. I found that if I enter the SO and PO in the same amount, same currency, and same exchange rate, system generate penny difference account only after posting SO invoice. Why?

Example:

Sales order

Qty	@	Net	Exch.Rate
140	14.43	2,020.20	33.705902
140	14.43	2,020.20	33.705902
140	15.66	2,192.40	33.705902
140	15.66	2,192.40	33.705902

The accounting transaction from SO invoice is:

		USD		THB
		Debit	Credit	Debit	Credit
DR. A/R		8,245.20		283,978.97
	Cr. Revenue		8245.2		283,978.96
	Cr. Penny difference		-		0.01

But the accounting transaction for PO invoice is:

		USD		THB
		Debit	Credit	Debit	Credit
Dr. Expense		8,245.20		283,978.97
	Cr. Account Payable		8,245.20		283,978.97

Please help me.

Thank you very much.

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (0)

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

Hi,

Can you share details of your sales price setup?

Do you make use of sales prices that are valid for more than a single item?

How are your rounding rules defined for SO and PO?

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ludwig,

I didn't setup any sales price or purchase price for the item.

The rounding rule on SO and PO are 0.00.

Best regards,

Noon

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Noon,

To understand why the PO posting is done without rounding difference but the SO posting is, it is important to know how the prices are setup.

As an example, if you purchase items with a price of $1.33 / item but sell it for $12.93/ 5 items a rounding might occur.

In addition, there can be surcharges and discounts that result in an overall cent difference.

Quite difficult to give you a detailed hint with that limited information.

Suggestion:

Can you replicate those postings in a demo/test environment? If this is the case try modifying the price setup, discounts, etc. and see what difference those changes make.

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ludwig,

I got your point.

I input the data on SO and PO by the same item code, quantity, unit price, amount, and without discount.

Also, I use the same exchange rate of USD = 33.705902

Home currency = THB

Transaction currency = USD

Thank you.

Best regards,

Noon.

Was this reply helpful? Yes No
Suggested answer

zubairalam 151 on at

Like (1)

Report

NoonA1,

Please check the penny difference amount in Accounts payable and Accounts Receivable parameters, and make both the same.

Thanks.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi

I input the SO and PO as the picture below:

SO in USD currency, Exchange rate = 33.705902

PO in USD currency, Exchange rate = 33.705902

Home currency = THB

AR Parameter

AP Parameter

GL Parameter

Then after post SO transaction, the accounting transaction is

System automatically generate the penny difference 0.01

The accounting transaction after post PO invoice is

I wonder why system didn't generate the penny difference for PO invoice transaction same as SO invoice transaction?

Regards,

Noon.

Was this reply helpful? Yes No
Khaled Alloud 3,658 on at

Like (0)

Report

Dear,

Can you check the Currency form > Rounding option ? and share a screen shot about it pls.

Thank you,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Khaled,

The currency as below:

Was this reply helpful? Yes No
lally 8 on at

Like (0)

Report

Hi All ,

Even we have the similar issue ..Any help would be greatly appreciated ?

Was this reply helpful? Yes No
Suggested answer

ZvikaR 168 on at

Like (0)

Report

Are you able to create the issue, by entering the same numbers, in a demo data environment? that would help ruling out difference of configuration as the root cause of the issue and will also allow you to open a ticket with Microsoft, if necessary.

Was this reply helpful? Yes No