Microsoft Dynamics AX (Archived)

Wrong Physical Inventory Transaction

(0) Share

Report

Posted on by Community Member

Dear All,

Kindly take a look at the below transaction,

If the Inventory Movement date is before Inventory Receipt Date How this transaction is valid.

3527.Capture1.PNG

Here is the Item Model Group

5684.Capture2.PNG

Regards

Haider Qutbuddin

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Mahmoud Hakim 17,887 on at

Like (0)

Report
Copy link

Link copied!

hi Haider Qutbuddin

this is the moving average until make recalculation

after recalculation , all transaction will affect by inventory model in item model group .

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hello Mehmoud,

My concern is not on the cost.

If you can observe the below transaction with dates, you can see that inventory is being received on 8/1/2017 so how it is being moved out on 7/29/2017

Was this reply helpful? Yes No
André Arnaud de Cal... 304,138 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Haider,

It is possible if the PO receipt was posted and later a journal transaction was created with a posting date in July. AX is not checking if the inventory was zero with a certain date; only if there is stock available.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hello Andre,

So it means, AX won't be checking dates of transactions and it won't restrict the transaction to occur unless we don't have stock available.

Don't we have any setup check through which we can restrict such transactions

Was this reply helpful? Yes No
André Arnaud de Cal... 304,138 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Haider,

Unfortunately there is no such setup.

Was this reply helpful? Yes No
Suggested answer

Ahmed Elroghay 330 on at

Like (0)

Report
Copy link

Link copied!

Hi Haider ,

Check if you marked for physical inventory option in Storage dimension form or no.

Because if u didn't mark that is mean the warehouse dimension is not considered when u create an issue transaction and the quantities in all warehouses that belong to the same site are available based on site not warehouse on-hand

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

Like (0)

Report
Copy link

Link copied!

In terms of a Purchase order, the Physical date is the date of the Product receipt. Aside from André's answer, it is also possible that the PO Line was Registered into inventory on or before the 29th July.

Was this reply helpful? Yes No