Inventory transaction: How to change Value Open from YES to NO

(0) Share

Report

Posted on by Community Member

Dear All,

There are some transactions from old period (2014) in my system that have Value Open set to YES, so when I do Recalculation I got error message "Unit cost Price xxxx can be wrong as the transaction cannot be fully settled".

I did check and found that these transactions have the Value open set to YES as below screenshot:

Can you please let me know why the Financial has been posted but Value Open didn't set to NO?

How can I change this Value Open to NO?

Thank you

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

Hi nglehang,

the message says that the transactions have not fully been settled and might consequently been (partially) settled once again at the time you run the next inventory recalculation/close. Once it is fully settled, the value open field changes to NO.

What inventory valuation method do you use?

Best regards,

Ludwig

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

Like (1)

Report

... and do you have 'Include physical value' ticked (next to the Inventory model on the Item Model Group?

It could be that there is no financially updated receipt to settle these issues to.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ludwig & Guy,

Here is my setup:

Those transactions are from periods that already closed. Is there any way to change Value Open from YES to NO?

Thank you for your support

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

Like (0)

Report

Hi,

Have you already reviewed Terry's answer regarding the physical inventory parameter?

Best regards,

Ludwig

Was this reply helpful? Yes No
Verified answer

Guy Terry 28,924 Moderator on at

Like (1)

Report

You're using Weighted average. That model can only close issue transactions if there are enough financially updated receipt transactions.

So lets check that...

Check your 'Dimension groups' setup; which dimensions have 'Financial inventory' ticked? Make a note.

Go to the Items list and find the 441159 item. Get AX to show all Inventory transactions for that item (probably Inventory -> Transactions). Use 'Dimensions display' to show only those dimensions which have 'Financial inventory' ticked.

Find the BOM Line transactions. Considering only the dimensions which have 'Financial inventory' ticked, make a note of each dimension value on the BOM Line transactions. Turn on 'Filter by Grid' (Ctrl + G). Filter the records to show only transactions with the same dimensions as your BOM Line transactions. (e.g. If your BOM Lines are on Site '01', and Site is the only Financially tracked dimension, filter all the items transactions to show only Site '01').

Now add another filter for the field 'Receipt status'. Filter where the receipt status is 2 or 3. Does it show any transactions which are older than the BOM Line transactions?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you a lot for your support, Terry.

I will do check as your guideline.

Was this reply helpful? Yes No
JordonGe 5 on at

Like (0)

Report

Then how to solve it ?

Was this reply helpful? Yes No