Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

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

Posted on by 1,085

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

  • Guy Terry Profile Picture
    Guy Terry 28,621 Super User 2024 Season 2 on at
    RE: [Ax 2009] InventTrans with both StatusIssue and StatusReceipt blank..

    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:

    ConsistencyCheck.jpg

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

  • Guy Terry Profile Picture
    Guy Terry 28,621 Super User 2024 Season 2 on at
    RE: [Ax 2009] InventTrans with both StatusIssue and StatusReceipt blank..

    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.

  • vv1984 Profile Picture
    vv1984 1,085 on at
    RE: [Ax 2009] InventTrans with both StatusIssue and StatusReceipt blank..

    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..)

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,269 Super User 2024 Season 2 on at
    RE: [Ax 2009] InventTrans with both StatusIssue and StatusReceipt blank..

    Hi vv1984,

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

  • Suggested answer
    Guy Terry Profile Picture
    Guy Terry 28,621 Super User 2024 Season 2 on at
    RE: [Ax 2009] InventTrans with both StatusIssue and StatusReceipt blank..

    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).

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans