Physical and financial cost is updated as 0 after posting PO invoice in ax 2012

(0) Share

Report

Posted on by Dhanshri

515

Hi All,

From PR we have created one PO and posted invoice for that PO but somehow physical & finanacial cost is not updated for the item used in PO line.Unit price is defined on Po and PO invoice.If i try to post new PO for same item then it calculates the cost correctly. It is stocked item which has FIFO inventory model.

Below are the screen shot from Item master & inventory transaction-

17646.1.png

4101.2.png

2313.3.png

I want to understand -

1.In which case cost can be 0 (any setup?)

2. How to update physical and financial cost on inventory transaction now?

In order to resolve it , i tried to post return Purchase order with non zero unit price against the same PO and system calculated inventory costs correctly. But in this case previous PO transaction were posted with zero cost whereas return order transaction are posted with non zero cost.Hence ledger will not match in this case.

If i try to post return order with 0 unit price , system won't allow me.

Or Can i simply write some X++ job to update this cost from InventTrans table?If so would be great if you can provide some reference.

Thanks ,

Shri

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (1)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Shri,

For 1:

It is difficult to say why the cost was recorded with $0. Probably a user changed the price when posting the PO invoice?!

For 2:

Can't you simply adjust this transaction in the inventory and closing form? There is an 'adjustment-transactions' button available that should allow you to do this correction for the product receipt. If you have not used this feature before, test it carefully in a demo/test environment.

Best regards,

Ludwig

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

Like (0)

Report

Hello Shri,

Just wondering whether you have been able to get this one resolved.

Would be great if you could update us.

Best regards,

Ludwig

Was this reply helpful? Yes No
Dhanshri 515 on at

Like (0)

Report

Hi Ludwig,

Due to health issue unable to update you in past few days.

I tried posting inventory adjustment as said and it updated financial cost as well :)

Physical cost is still 0, how to adjust it? Or is it ok if we just update financial cost & not the physical cost?

(I am not function so may be i might ask you very basic question, sorry for that)

Thanks,

Shri

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Shri,

Can't you use the following 'adjustement-transactions' functionality in the inventory module for adjusting/correcting your transaction?

Have you tested that in a demo/test system?

Best regards,

Ludwig

Was this reply helpful? Yes No
Dhanshri 515 on at

Like (0)

Report

Hi Ludwig ,

I used the same 'adjustment - transaction' in test instance.It updated financial cost i.e Cost amount in inventory transaction screen but physical cost is not updated, it is still showing as 0. Ideally when we post PO receipt it update physical cost and then when we invoice the PO then it update its financial cost.I want the same result as this.

Will it just update financial cost?Is there any way to updated physical cost too?As Po receipt is also posted so it should show same figure in physical cost on inventory transaction screen too..

Thanks,

Shri

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

Like (0)

Report

Good Morning Shri,

I am wondering what made the PO posting special that you cannot post adjustments.

Can you share additional details

* of the PO and the line recorded (including prices and quantities)

* how the item is setup (especially the item model group setup)

* Details about the PO receipt and invoice postings made so far.

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No
Dhanshri 515 on at

Like (0)

Report

Hi Ludwig,

PO was created for 2 items out of which for one item physical & financial cost is 0 on inventory transaction.This po was created from PR and MRF where only affected item was part of PR with price as 0.

PO details-

2.Item model group setup:-

3. Po receipt

4.PO invoice

Kindly let me know how to update physical cost using adjustment -transaction.

Thanks ,

Shri

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

H4237.Invoice.png"_blank" href="/api/data/v9.1/msdyn_richtextfiles(9AFD42AF-B5A3-47DE-BAFA-CD276233831C)/msdyn_imageblob/$value?size=full">community.dynamics.com/.../4237.Invoice.png

Having 7 decimal places available in the price field is not a standard functionality but a system modification.

Please clarify why this has been done as you will run into this issue many times in the future if this modification is not changed or your price setup is not made in a way that those roundings can be avoided.

Best regards,

Ludwig

Was this reply helpful? Yes No
Dhanshri 515 on at

Like (0)

Report

Thanks Ludwig!

Counting journal didn't help to correct the physical cost.

Can i post ledger adjustment to correct the balances instead? so that i can adjust both physical & financial cost ledgers which will lower the risk if we miss something in code o update the amount at single place.

I will check the purpose of system modification.So you mean if we keep item price upto 2 decimal places this scenario will never happen?

Thanks,

Shri

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Shri,

I think the problem is a mix of the modification that has been made and the way how prices are setup.

In the example above you have a price of 1.214953 for 30 pcs of a tool.

If you always order them in bundles of 30 pcs you could setup a price of 36.45 instead for the 30 pcs.

This creates a loss of 0.0423 compared to the exact price with 7 decimal places but at the same time saves you probably a couple of hundred dollars of internal costs that arise because you have to consult your system admins/developers, because of the delay in the processing, etc.

Best regards,

Ludwig

Was this reply helpful? Yes No