Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

How do I see what the balance was for an item when it was supposed to be reserved in a SO?

(0) ShareShare
ReportReport
Posted on by 18

Hello

I have an "old" sales order where an item got canceled when it probably was at least 10 pcs in quantity that time. Probably ... But it could have been zero too..

But I don´t know how to see if there was some in quantity when the item was supposed to be reserved.

And instead, it got canceled.


Where in the SO ( or on any other place in AX2012 , maby in "Inventory transactions") can I see in retrospect if there was a balance just when the item was supposed to be reserved?


Where can I see the reservation jobs for this?

/ BCC

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: How do I see what the balance was for an item when it was supposed to be reserved in a SO?

    Hi BCC,

    In this case I think there is nothing that you can really do to find out except possibly reverting to older backups of your system. Yet, I am not sure if this is worth the effort.

    Best regards,

    Ludwig

  • BCC Profile Picture
    18 on at
    RE: How do I see what the balance was for an item when it was supposed to be reserved in a SO?

    Hello André

    Unfortunately, the item is not included in the reservation journal in the sales order. So from what I can see, you can not see why an item is canceled when AX2012 reserving the articles.

  • BCC Profile Picture
    18 on at
    RE: How do I see what the balance was for an item when it was supposed to be reserved in a SO?

    Hello Ludwig

    One of our customers wondered why the item was canceled even though there was a balance on it (according to the customer). 

    But the order is old and it´s difficult today to see if there was really a balance when the item was to be reserved. We mostly want to troubleshoot this so there is no problem in AX2012 that has with reservation of items.

    I had hoped to be able to see that in "Inventory Transaction" and what the balance was that time when an item was purchased or sold.

    pastedimage1602657696035v2.png

    //BCC

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    293,311 Super User 2025 Season 1 on at
    RE: How do I see what the balance was for an item when it was supposed to be reserved in a SO?

    Hi BCC,

    If you have sent a confirmation(s) of this sales order, the confirmation journals might have the original quantity stored.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: How do I see what the balance was for an item when it was supposed to be reserved in a SO?

    Hi BCC,

    I don't know a specific place where you could track that data. Usually the history of transactional data is not recorded and tracked e.g. via the database log. Do you probably have an old copy / backup of your database where you could check that? Also, can you let us know why you would need this information?

    Best regards,

    Ludwig

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,311 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,183 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Product updates

Dynamics 365 release plans