News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX forum X++ to update sales li...

Microsoft Dynamics AX forum

Suggested answer

X++ to update sales line reserve physical qty

(0) Share

Report

Report

Posted on by Snifer

75

Hi

I have create a button and when user click on the button in sales order i want to update the reserve physical qty == deliver now qty

by default reserve physical qty == sales qty but i want to update the reserve physical qty == deliver now qty

does any on have x++ code on how to update the reserve physical qty base on sales order

Thank you

Categories:

Development / Customization / SDK

Sales and Marketing

All responses Img

All responses (3)

Answers Img

Answers (0)

Mea_ 60,274 on at

Like (0)

Report

RE: X++ to update sales line reserve physical qty

This code is meaningless without your data, we don't know if there is inventTrans, so it would go inside of the if statement or you have enough in stock to reserve. Did you try to debug ?
Snifer 75 on at

Like (0)

Report

RE: X++ to update sales line reserve physical qty

thanks ievgen Miroshnikov but the code does not work in AX 2012 R3

i am testing with below code but its not working;

static void Job16(Args _args)
{
    InventTrans             inventTrans;
    InventTransOrigin       inventTransOrigin;
    InventMovement          inventMovement;
    InventUpd_Reservation   inventUpd_Reservation ;

    // Reserve an item
    SalesLine SalesLine = SalesLine::findRecId(5640934326);
    select inventTrans
    where inventTrans.ItemId                      == SalesLine.ItemId
    && inventTrans.StatusReceipt               == StatusReceipt::None
    && inventTrans.StatusIssue                 == StatusIssue::OnOrder
    exists join inventTransOrigin
    where   inventTransOrigin.RecId            == inventTrans.InventTransOrigin;

    if(inventTrans.RecId)

    {
        Inventmovement = inventTrans.inventmovement(true);
        inventUpd_Reservation = InventUpd_Reservation::newInventDim(inventmovement,SalesLine.inventDim(),-120, false);
        inventUpd_Reservation.updatenow();
    }

    info(strFmt("%1",salesLine.reservedPhysicalSalesUnit()));

}
Suggested answer

Mea_ 60,274 on at

Like (0)

Report

RE: X++ to update sales line reserve physical qty

Hi rdewan,

Please check this blog post community.dynamics.com/.../reserving-inventory-by-code it has a code snippet how to reserve qty for sales order line, in this blog post Qty reserved is 5 but you can put deliver now qty instead.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,246 Super User 2024 Season 2

#2

Martin Dráb 228,041 Super User 2024 Season 2

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans