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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Inventory Transaction ...
Microsoft Dynamics AX (Archived)

Inventory Transaction saying Deducted....

(0) ShareShare
ReportReport
Posted on by Lionel07 495

Hello Everyone,

I need some helping solving an issue... In AX 2012R2 there are some 1497 units of an item are taken from stock and I cannot seem to put them back in... the issue column has DEDUCTED on it also the sales order ID  that the deduction is associated with does not exits. Can any explain what happened?

*This post is locked for comments

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,020 Super User 2025 Season 2 on at

    Hi Lionel,

    What happened is unknown for me. It can be caused by customizations or data correction/manipulation jobs. Does the Inventory On-hand also mentions these 1497 units as deducted? You used a tag "retail". Do you know if the original sales order was created from retail transactions?

  • Guy Terry Profile Picture
    Guy Terry 28,924 Moderator on at

    Try running the Consistency checker on Inventory transactions for the affected item. Here's an idea how to do it timsaxblog.wordpress.com/.../consistency-check-for-a-single-item-in-dynamics-365-for-operations-and-ax-2012-and-ax-2009

  • Lionel07 Profile Picture
    Lionel07 495 on at

    Hello Andre, no sales order was a normal sales order. It was not created from retail. There was no customization or job manipulation. Funny thing is the Inventory On-hand does not have the 1497.  

  • Lionel07 Profile Picture
    Lionel07 495 on at

    Thanks for the suggestion Guy, unfortunately this did not solve the problem. am now back at square one.

    One funny thing though.....when i went to my database and run the query select * from SALESLINE where SALESLINE.SALESID ='ACP-022396' It showed the line with the quantity. but if i try to find the invoice(Select * from CUSTINVOICETRANS where CUSTINVOICETRANS.SALESID='ACP-022396') for the sales order number i find nothing...

    From this, I figured the sales order did not actually got invoiced. Any thoughts on this?

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,020 Super User 2025 Season 2 on at

    Hi Lionel,

    It is hard to tell what happened. It seems like the sales order header got deleted without the line(s). Can you find in the history journals the sales order confirmation and/or picking lists/packing slips?

  • Guy Terry Profile Picture
    Guy Terry 28,924 Moderator on at

    The transaction is not linked to an Invoice; if it were, it would have the status Sold. It should be linked to a packing slip though.

    However, that doesn't help you much. It shouldn't be possible to delete a sales order which is only packing slip updated. Do you know how that might have happened? Did the 1,497 units get delivered to a customer, or are they still in your physical inventory?

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
Ali Zaidi Profile Picture

Ali Zaidi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans