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

Notifications

Announcements

No record found.

Community site session details

Community site session details

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

Pallet is Physically reserved on the On-hand screen.

(0) ShareShare
ReportReport
Posted on by 10

Hello Everyone, 

Having limited knowledge of inventory, I must ask the Gurus here about this problem. 

I have two different pallets both with qty 1 and are shown as Physical reserved. These are return orders and the order is already executed, the payment is also returned to the customer but the amount is still not showing under Available Physical. Can I forcefully change the available quantity here?

pastedimage1574415841151v1.png

I have the same question (0)
  • Pedro Tornich Profile Picture
    955 on at

    It seems like a very particular case where something didn't went well.

    Have you tried to reproduce this?

    If you create the exactly same scenario and the problem doesn't happen, then I think you should ask a developer to investigate with you.

    If the very same thing happens when you recreate the scenario, then you may have some kind of configuration issue or some missing step in the process.

    Sorry, but you can't force quantity changes on this form. You would need to make an update directly in the database, which is highly dangerous and not advisable specially in cases involving inventory.

    Let's wait to hear from other experts.

  • Suggested answer
    Zain Hamza Profile Picture
    10 on at

    Hi Pedro,

    It's not a normal case and I can't reproduce it. I want to change it by code and do something like the following:

    static void UpdateInventSum(int availPhy, int reservePhy, int recId)

       {

           InventSum inventSum;

           ttsBegin;

           while select forUpdate inventSum

                   where inventSum.RecID == recId

           {

               inventSum.availphysical = availPhy;

               inventSum.reservphysical = reservePhy;

               inventSum.update();

           }

           ttsCommit;

       }

    Problem: I am unable to get the recid because it's a sum(SQL) value.

    Please help.

    Regards,

  • Suggested answer
    Pedro Tornich Profile Picture
    955 on at

    That's the problem when you try to update inventory records, they are strongly linked.

    For example, the amounts in the InventSum table must ALWAYS reflect the records on the InventTrans table and the InventTrans table quantities must ALWAYS reflect the quantities on the source record (Purchase Order, Production Order and etc.).

    To force a change on the InventSum you first need to understand which InventTrans records were used to compose that quantity and if you decide to update the InventSum anyway, then you will have to update the InventTrans as well, to keep the quantities balanced. But if you update the InventTrans, they may stop reflecting their source record. Do you see where I'm going?

    Forget about hard updates for a minute and think about a movement journal or a count journal where you could change inventory quantities without messing with the system integrity.

    NOTE: If you still need to update InventSum records, you will have to look into those display methods to understand what is behind them and what fields (and tables) you really need to update.

  • Guy Terry Profile Picture
    28,924 Moderator on at

    Before you do anything drastic, check the Inventory transactions of the Item(s) to determine what it is that has made the reservation. It is likely you will be able to release the reservation when you determine what has made it.

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…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 503 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 434 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 278 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans