Skip to main content

Notifications

Microsoft Dynamics AX forum
Suggested answer

[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

Categories:
  • Guy Terry Profile Picture
    Guy Terry 28,452 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,452 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... 290,142 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,452 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).

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Dynamics 365 Community Newsletter - August 2024

Catch up on the latest D365 Community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,142 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 227,979 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans