Financial quantity is zero whereas financial cost amount exists for Standard cost items?

Finance and Operations/AX User Forum
1

Dear Experts,

I am trying to cancel a PO receipt for some Standard cost items but cannot due to an update conflict error message.

After having debugged, I find that the function cannot pass because financial cost amount (PostedValue) of the items in that receipt have values, whereas their financial quantity (PostedQty) is zero.

I tested to manually update correct PostedValue field under table InventSum, then I could cancel the receipt. However, this way is quite risky as it raises inconsistency in data among tables.

Could you please help me if there is another way to correct the Financial cost amount or to bypass this error message?

2

What is the status of the purchase order?
What function are you using to cancel the order?
Can you post a screen shot of the actual error message?

3

Hi AdamRoue!

Thank you for your reply.

The PO is not yet invoice updated, its status is “Received”.

I go to Product receipt journal, click button “Cancel” to cancel the posted receipt and get this ambiguous error message:

Cannot edit a record in Purchase order - update table (PurchParmTable).

An update conflict occurred due to another user process deleting the record or changing one or more fields in the record.

After debug, I find more detailed error message:

Item number XXX. Update conflict. The standard cost does not match with the financial inventory value after the update. Value = 0.01. Quantity = 0.00. Standard cost = ZZZ.

The message explains that the financial cost amount of item XXX is 0.01 whereas its financial quantity is zero.

I tried to manually update table data of field Financial cost amount to 0.00 and the error disappears. However, I prefer a less risky solution if any.

~ I am sorry I don’t know how to post a screenshot. Please teach me ~

4

You click “Use rich formatting” and attach it that way.

You would need to understand how the PO got into that position.

My advice would be NOT to ever update the table directly, it only makes matters worse.

5

Thanks for your advice.

Updating the table is not a solution, but helps me to know that only when fixing Financial cost amount, the error is solved.

The PO is no problem, but the items.

I had thousands of items and transactions with correct financial cost amount. But after converting company currency (just run the function “Ledger accounting currency conversion”), many of these items display incorrect financial cost amount in decimals.

It seems hopeless to track.

So I focus on how to adjust the Financial cost amount, because this is real-time value based on financial quantity and cost price.

Just now I find some possible ways to fix this field and they worked (maybe not for all items): Activate new STD cost or Update invoice to revalue inventory; run Consistency fix to adjust the field directly.

If you have another idea, please comment!

Thank you.