web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Sales Order line - ite...
Microsoft Dynamics AX (Archived)

Sales Order line - item transaction missing

(0) ShareShare
ReportReport
Posted on by zqr 850

I created a sales order with 13 lines. All the lines are fine except two of them. Those two lines have qty of 1 per each on sales order line but there is no inventory transaction. The customer was charged with the sales amount but inventory was not reduces for those two items and I see no inventory transaction related to that sales order. When I go to invoice journal those two lines have contribution ratio of 100.

Thank you.

*This post is locked for comments

I have the same question (0)
  • Mariano Gracia Profile Picture
    Mariano Gracia on at
    RE: Sales Order line - item transaction missing

    verify that QtyOrdered field in sales order line is informed (as it is the inventory quantity that uses dynamics ax to create Inventory transactions)

  • Eddie Josling Profile Picture
    Eddie Josling 1,185 on at
    RE: Sales Order line - item transaction missing

    Hi. Although we have never confirmed this in testing, we suspected that this issues were caused by random client crashes. We could not replicate this issue in normal processing, but speaking to the users, it does suggest that the crashing of Ax maybe was the cause. 

  • Community Member Profile Picture
    Community Member on at
    RE: Sales Order line - item transaction missing

    Hello. Did you ever find the cause of this? We experience this same situation every so often. Thank you.

  • zqr Profile Picture
    zqr 850 on at
    RE: Sales Order line - item transaction missing

    I still cannot realize why that happened. When I do I will post it here.

    Thank you everybody for trying to solve this issue.

  • Weaveriski Profile Picture
    Weaveriski 23,616 Moderator on at
    RE: Sales Order line - item transaction missing

    I have seen inventory transaction lines not be created before, but it is always related to either a customization or an import of data. My suggestion would be to validate the customization and then check the differences of the two items that made the standard AX inherent logic to create the inventory transaction fail. If they are stocked and are like any other item that works there must be a customization at work here. 

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Sales Order line - item transaction missing

    please check the status of these two sales line

    may be these two lines are cancelled and hence inventory Transaction line is not there

    please verify and updated us with your findings

  • zqr Profile Picture
    zqr 850 on at
    RE: Sales Order line - item transaction missing

    It is strange because as you see items in my previous response, those items share the same characteristics. Even the UOM in sales line is same as in product details.

    Eddi Josting did you check the contribution ratio of that sales order line?

  • Eddie Josling Profile Picture
    Eddie Josling 1,185 on at
    RE: Sales Order line - item transaction missing

    Hi, we also had this issue today!  I know we have some customisations on the sales lines, especially regarding unit conversions, thus I cannot rule this out.  In our case an alternative unit was used, but stranger was that although the item does have a sales category, the line was creates without one.  It almost seems that the system regarded the line as a non-stocked item even though it is clear not.

    In what scenario did your transaction take place?

    Eddie

  • zqr Profile Picture
    zqr 850 on at
    RE: Sales Order line - item transaction missing

    The Items are stocked. All the items have same item model group, item group, cost group etc. The following are the details of the posted items. They have all the same characteristics in product details except for prices.

    The items 40090 and 40070 with contribution ration of 100 have no inventory transaction. All others are fine.

    SO Item Description        Qty Unit price Amount Margin Contribution ratio
    62 40030 Azzurra 1 850 850 480             56.47
    62 40090 Bettina 1 1000 1000 1000 100
    62 40110 Carla 1 750 750 0 0
    62 40100 Bruna 1 850 850 318.73 37.5
    62 40140 Eva 204 1 680 680 245.51 36.1
    62 40150 Eva 205 1 680 680 208.74 30.7
    62 40130 Debora 2 850 1700 383.9 22.58
    62 40120 Claudia 1 550 550 187.75 34.14
    62 40070 Berta Ek. 1 395 395 395 100
    62 41030 Marela 1 1100 1100 662.46 60.22
    62 40160 Gloria 1 700 700 296.29 42.33
    62 41080 Valdera 1 980 980 457.61 46.69
  • Suggested answer
    Ivan (Vanya) Kashperuk Profile Picture
    Ivan (Vanya) Kashperuk on at
    RE: Sales Order line - item transaction missing

    Are these items stocked items? Are they maybe of type Service?

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Syed Haris Shah Profile Picture

Syed Haris Shah 9

#2
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

#2
Community Member Profile Picture

Community Member 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans