Microsoft Dynamics AX (Archived)

Financial cost amount value come incorrect.

(0) Share

Report

Posted on by Shivendra singh kus...

Hello All Expert,

I created one new item and Created 2 PO for it

1. 20 Qty 250 Unit Price = 5000 Net amount

2. 30 Qty 300 Unit Price = 9000 Net amount

Now I partially invoice both the PO,

Posted Transaction

1. 10 Qty 250 Unit Price = 2500 Net amount

2. 15 Qty 300 Unit Price = 4500 Net amount

System is considering ordered status amount of PO also in Financial Cost amount. Please provide me the solution.

See the screenshot below

7510.Cost-Price.JPG

*This post is locked for comments

I have the same question (0)

All responses (14)

Answers (0)

Guy Terry 28,924 Moderator on at

Like (0)

Report

Hmm, that does look odd. Can we get a screenshot of the Storage Dimension Group settings for the Item? And what is the Inventory model on the Item's item model group?

Was this reply helpful? Yes No
Shivendra singh kus... 70 on at

Like (0)

Report

Hello Terry,

LIFO model we are using on item model group. Below is the screenshot of storage dimension group but from starting we are using same dimension group and we didn't make any changes in that.

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

Like (0)

Report

Hi,

The values seem to have doubled.

How do your voucher look like for the partial invoices that have been posted?

Best regards,

Ludwig

Was this reply helpful? Yes No
Shivendra singh kus... 70 on at

Like (0)

Report

Hello Ludwig,

You can see in financial cost amount, it is considering both purchase order total amount i.e.

1. 20 Qty 250 Unit Price = 5000 Net amount

2. 30 Qty 300 Unit Price = 9000 Net amount

Total = 14000

Total Posted Qty = 25

Cost Price = 14000/25 = 560

Below is the voucher screenshot, You can see the posting it is coming correctly.

Was this reply helpful? Yes No
Shivendra singh kus... 70 on at

Like (0)

Report

You are right Ludwig.

Value has doubled for financial cost amount.

I created one more PO for 10 Qty 150 unit price and posted invoice of 3 qty.

Now Financial cost amount is coming 14900. Double of 450 is added to previous 14000 value.

Was this reply helpful? Yes No
Guy Terry 28,924 Moderator on at

Like (0)

Report

Does the currency of the PO match the Accounting Currency of the Ledger (General Ledger -> Setup).

Was this reply helpful? Yes No
Shivendra singh kus... 70 on at

Like (0)

Report

Yes Terry

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

Like (0)

Report

Hi,

Is this a general problem in your system or do you see this only for a single vendor/PO?

Best regards,

Ludwig

Was this reply helpful? Yes No
Shivendra singh kus... 70 on at

Like (0)

Report

Cost Price of lots of item is coming inappropriate so I checked with creating one new demo item and problem is coming same in all cases.

Was this reply helpful? Yes No
Guy Terry 28,924 Moderator on at

Like (0)

Report

Are there any Charges attached to the PO Header or Line?

Was this reply helpful? Yes No