Microsoft Dynamics AX (Archived)

Price difference account posting issue

(0) Share

Report

Posted on by Harisgillani

291

hi experts,

hope all are fine.

actually i am facing issue while using moving average inventory value method when i post invoice with different unit price the price difference for moving avg. account is not posted that time below is my whole process information.

new item created associated with moving average method.
create purchase order with quantity of 5 and unit price 10 then confirm and post product receipt.
create sale order with qty 2 and price 15 confirm so and then post packing slip and invoice.
again open purchase order with status of product receipt and post invoice with price 12. the voucher show the price difference for moving average with amount 4. there is no doubt in this whole process but the next posting with this item is giving problem in posting the account of price difference.
create po of same product, confirm and post product receipt with quantity of 1 and amount of 20.
create sale order with qty 1 and price 15, confirm, packing slip and invoice.
after that open po with product receipt status and create invoice with amount 25 and post but invoice voucher does not show price difference account posting as it will be proportionally expense in price difference account with amount of 5.

your answers will be appreciate. thank you

regards

haris gillani

*This post is locked for comments

I have the same question (0)

All responses (16)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

In step 4, you posted a quantity of 2. Is that right?

Can it be the case that a typing error occured with one of your posting dates?

I would suggest that you run the inventory value report for your item with the 'Transaction level' parameter selected in the row section. This report will chronologically list your item transactions and hopefully help explaining the posted amounts. For details, please see the end of the following website: technet.microsoft.com/.../hh597235.aspx

Best regards,

Ludwig

Was this reply helpful? Yes No
Harisgillani 291 on at

Like (0)

Report

Hi Ludwig,

In step 4 invoice whole quantity of PO which is 5 has been posted. Sale order invoice is posted with quantity of 2 which is step 3. After step 4 when i post Product receipt and then Invoice SO system calculate C.P.U= physical cost+financial cost/quantity after that when i invoice Purchase order with different unit price e.g from 20 to 25 see above steps from 5 to 7, system does not post price difference account according to my understanding after posting PO invoice C.P.U is change when PO invoice and the difference in C.P.Unit before posting Invoice and After posting PO invoice should be charge to price difference. what i am right?

Regards

Haris Gillani

Was this reply helpful? Yes No
Suggested answer

Muthusamy 4 on at

Like (0)

Report

Hi Haris,

I have tried the same scenario,

When i posted the first purchase order with the price of 12, it posted the amount $10 to the price difference for moving average account.( I have invoiced for 5 quantity, so amount $10 posted as difference).

When i posted the second purchase order with the price of $25 , it posted the amount $5 to the Price difference for moving average account.

Below chart is for your reference with sequence of entry.

Thanks,

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

Like (0)

Report

Hi Haris Gillani,

Can you prepare a Excel sheet similar to what Muthusamy V created.

To me things are still not cristal clear especially when you posted the packing slips, invoices, whether something has been backdated, etc.

Can you possibly export your item transactions to Excel in a chronological order and share that file or a screenprint of that?

Many thanks,

Ludwig

Was this reply helpful? Yes No

Harisgillani

291 on at

Like (0)

Report

Hi Muthusamy and Ludwig,

Below table is the chronological sequence of entries with description where required.Hope this detail will help to understand.

Doc no.	qty	Price	Amount		Price difference for moving average	Physical cost	Financial cost	Average cost P.U
P-01	5	10	50	received		50		10
S-01	2	10	20	invoiced			-20	10
P-01	5	12	60	invoiced	4		36	12
P-02	1	20	20	received		20	36	14
S-02	1	15	15	invoiced		20	22	14
P-02	1	25	25	invoiced	No price difference account is posted		47	15.6

Muthusamy thanks for working to help me but in your table the difference of 10 is not correct i think you enter wrong figure by mistake it should be 4 and yes next difference of 5 is accurate which i want my system should post.

Thank you,

Haris Gillani

Was this reply helpful? Yes No

André Arnaud de Cal... 300,904 Super User 2025 Season 2 on at

Like (0)

Report

Hi Haris,

Can you please change your post and use normal characters instead of capitals? Capitals are considered as screaming which is NOT allowed on this forum. Usually I change a title or small texts, but will remove this post if you don't change it yourself. If you are not able to edit your post, send the text in a private message on this forum. Then I will replace it for you.

In addition, don't use names of persons in your tags. It has no use.

Was this reply helpful? Yes No
Suggested answer

Muthusamy 4 on at

Like (1)

Report

Hi Haris,

For the Purchase order (P-01) whether you have posted the invoice for 5 Qty or 2 Qty?

Because, price difference for the PO receipt and invoice is $2 and total quantity is 5.

I have invoiced total 5 Qty. So, system posted the difference amount $10 (5 Qty * 2$ difference price) to price difference for moving average account.

Also,when i posted the product receipt for PO-002, Amount $10 is posted to price difference for moving average account.

Note: Cost price per quantity is $10 for all transactions. Current on hand quantity is 3 and Cost price is $10.

See my inventory transaction screen.

Can you post the inventory transactions screen here? like above

Thanks,

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Harisgillani,

How did you calculate your average costs?

Did you calculate them in Excel or did AX show you those values

To clarify this issue, can you run an inventory value report with the transaction details for your item?

By doing that you should get a chronological order of your transactions and average cost price details that hopefully clarifies things.

Best regards,

Ludwig

Was this reply helpful? Yes No
Harisgillani 291 on at

Like (0)

Report

Hi Muthusamy V,

Thank you for focusing, resolving and understanding my issue please review transactions of item in chronological order.

Hi Ludwig Reinhard,

Sorry for not giving proper understanding above table might give you proper understanding regarding my issue. Thank you

Regards

Haris Gillani

Was this reply helpful? Yes No
Harisgillani 291 on at

Like (0)

Report

Hi Andre Arnaud,

i edited my post as you adviced. Now, hope my post is according to forum standard. thank you.

Regards

Haris Gillani

Was this reply helpful? Yes No