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 / Finance | Project Operations, Human Resources, ... / Inventory - reserve/ u...
Finance | Project Operations, Human Resources, ...
Unanswered

Inventory - reserve/ unreserve

(0) ShareShare
ReportReport
Posted on by Community member 7
I facing challenge on unreserving the inventory for SO which already has a work created. When tried to unreserved via code getting the following error, /Reservation cannot be removed because there is a work created which relies on the reservation/.
I have used the below blog to implement the unreservation / reservation.
REF: https://omar-iqbal.com/index.php/2022/07/07/reserve-and-unreserve-salesline-inventory-in-x/
 
Hoping the community members to provide a work around to unreserve the item without canceling  the work
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 294,349 Super User 2025 Season 1 on at
    Inventory - reserve/ unreserve
    Hi,
     
    I don't have technical information about how to extend or develop mobile processes. With my previous employer, we had to extend one process. At that time, I did some reverse engineering to check how all should be developed as it is hard or impossible to find public information.
     
  • Community member Profile Picture
    Community member 7 on at
    Inventory - reserve/ unreserve
    As there is a deviation from Initial post, created a separate detailed post on the same.
    Kindly follow up the discussion here - Work Split
     
  • Community member Profile Picture
    Community member 7 on at
    Inventory - reserve/ unreserve
    Hi Andre,
    The 3PL is using the mobile app and I have to stick with work process. I have did some digging and found the following ways
    1. in mobile app there full button which split work based on quantities and batches which is updating the reservation as well,
    2. Split work functionality within FO, facing challenges on splitting the work with single pick line and no option to update quantities/ batches.
    The mobile app scenario suits my requirement and tried to implement the same but couldn't  find any technical reference. can you help me with any code reference to implement the same
     
     
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 294,349 Super User 2025 Season 1 on at
    Inventory - reserve/ unreserve
    Hi,
     
    When I understand it correctly, you are using an external warehouse provider (3PL). Also when work is created, it looks like there is a setup for advanced warehouse management in your environment. I would not enable advanced warehouse management in this scenario unless the 3PL is using mobile devices linked to your Dynamics environment. As you receive a message, in case warehouse management is not enabled, you can update the 3PL information in the picklist registration with the batch numbers and quantities. When work is created, you indeed can't change reservation details. 
  • Community member Profile Picture
    Community member 7 on at
    Inventory - reserve/ unreserve
    As part of EDI Customization, The SO in released status is shared to Network(third party) Warehouse via EDI where the picking /shipping happens. Once shipped Network(third party) Warehouse sends back the information of Quantities and Batch against which the order is shipped via EDI, once received will be updating the same in the SO reservation, Load Line and Work. I'm trying to achieve the same but facing difficulties in updating the reservations
    I have used the below code to unreserve the item
     
     /// This method unreserves SalesLine record.
    /// The SalesLine record to unreserve.
    public void unReserveInventory(SalesLine _salesLine)
    {
        InventTrans           inventTrans;
        InventTransOrigin     inventTransOrigin;
        InventMovement        inventMovement;
        InventUpd_Reservation inventUpd_Reservation;
        SalesLine             salesLine;

        // Remove reservations and markings on a reserved salesorder
        while select inventTrans
            where inventTrans.StatusReceipt     == StatusReceipt::None
                    && (inventTrans.StatusIssue == StatusIssue::ReservPhysical
                    ||  inventTrans.StatusIssue == StatusIssue::ReservOrdered)
        exists join inventTransOrigin
            where   inventTransOrigin.RecId == inventTrans.InventTransOrigin
        exists join salesLine
            where   salesLine.InventTransId == inventTransOrigin.InventTransId
                    &&  SalesLine.RecId     == _salesLine.RecId
        {
            if (inventTrans.MarkingRefInventTransOrigin)
            {
                InventTransOrigin::deleteMarking(inventTrans.MarkingRefInventTransOrigin,   
                                 inventTrans.InventTransOrigin,
                                 -inventTrans.Qty,
                                 true);

InventTransOrigin::deleteMarking(inventTrans.InventTransOrigin,    
                                 inventTrans.MarkingRefInventTransOrigin,  
                                 inventTrans.Qty,
                                 true);
            }

            if (inventTrans.StatusIssue == StatusIssue::ReservPhysical || 
                inventTrans.StatusIssue == StatusIssue::ReservOrdered)
            {
                inventMovement = inventTrans.inventmovement(true);
                inventUpd_Reservation =   
                InventUpd_Reservation::newInventDim(inventmovement,
                                                    inventTrans.inventDim(),
                                                    -1 * inventTrans.Qty, 
                                                    false);
                inventUpd_Reservation.updatenow();
            }

        }
    }
    When tried to unreserved via code getting the following error
    Reservation cannot be removed because there is a work created which relies on the reservation
     
       /// This method reserves SalesLine record with specific InventBatchId. 
    ///The SalesLine record to reserve.
    ///Quantity to reserve.
    ///InventBatchId to reserve against
    public void reservesalesLineByBatchId(SalesLine _salesLine, 
                                          InventQty _reserveQuantity,             
                                          InventBatchId _inventBatchId)
    {
        InventUpd_Reservation reservation;
        InventMovement        movement;
        InventDim             inventDimSalesLine, inventDim;
        InventSum             inventsum;
      
        movement = InventMovement::construct(_salesLine);
        
        if (_reserveQuantity > 0)
        {

            select inventdim
            where inventdim.inventSiteId == _salesLine.inventDim().InventLocationId &&
            inventdim.inventBatchId == _inventBatchId
            exists join inventsum
            where inventdim.inventdimId == inventsum.inventdimId &&
            inventsum.itemId  == _salesLine.itemId &&
            inventsum.availPhysical >= _reservedQuantity;

            reservation = InventUpd_Reservation::newInventDim(movement,
                                                             inventDim,
                                                           -_reserveQuantity, 
                                                             false);
            reservation.updateNow();
        }
    }
     
    I also tried the above code to reserve the item against the batch, it's not working but there are also no errors.
    I'm looking for a way to update the reservation without canceling the work.
     
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 294,349 Super User 2025 Season 1 on at
    Inventory - reserve/ unreserve
    Hi,
     
    Can you describe the required business process and where you currently have the gap for which you need to remove the inventory reservation? Why do you need to remove the reservation by coding? 

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March 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... 294,349 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,029 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans