Microsoft Dynamics AX (Archived)

[Ax 2009] InventTrans with both StatusIssue and StatusReceipt blank..

(0) Share

Report

Posted on by vv1984

1,087

Hi everyone,

just encountered this situation on a couple of items.

The InventTrans type is "Sales".

Is this standard behaviour? What does it could mean?

Thank you in advance

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Guy Terry 28,924 Moderator on at

Like (0)

Report

Hi vv1984,

I would say there are no circumstances in standard AX where a record in InventTrans should have Issue and Receipt status both Blank (or zero, if you're looking in the database).

Was this reply helpful? Yes No
André Arnaud de Cal... 301,158 Super User 2025 Season 2 on at

Like (0)

Report

Hi vv1984,

can you also find a reference in the inventory transactions? Probably these transactions are related to sales quotations.

Was this reply helpful? Yes No
vv1984 1,087 on at

Like (0)

Report

I'm afraid that's not the case. The inventTrans records i'm observing are related to SalesLines which are still present in the ax table.. Could be that something went wrong while ax was changing their status from user interface? (nothing was done roughly by x++code or sql..)

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

Like (0)

Report

I guess anything is possible, but it shouldn't happen. In AX 2009, the Inventory transaction has a direction field ('Other' tab -> 'In/Out'). If it's a normal Sales order line (i.e. not a return or a credit), the direction will be 'Issue' and the 'Issue status' field on the 'General' tab should have a value.

If you can reproduce exactly everything that has happened to the sales order line on another order, you may find a scenario which causes this to happen.

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

Like (0)

Report

Hi,

It also occurred to me that the Consistency check tool might cover this scenario. You can find it at Sys Admin -> Periodic -> Database -> Consistency check.

Run it for Inventory transactions, in 'Check' mode:

Depending on the number of Inventory transactions you have, it may take a long time to run. Try it in a test system first!

Was this reply helpful? Yes No