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, ...
Answered

i want to changed inventory dimension ( status ) for on hand item this status is blocked status

(0) ShareShare
ReportReport
Posted on by 48
i want to changed inventory dimension ( status ) for on hand item this status is blocked status cannot do this transaction using transfer journal
 
there is a standard job can do it Warehouse management > Periodic tasks > Inventory status change. 
but i can't make a class to simulate same behaviour : (
 
so how can i do it using X++ there are any class will help me to reach my requirements or anyone can help me to use the standard class to reach my goal ? thanks in advance
 
 
I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    300,904 Super User 2025 Season 2 on at
    Hi Omar,
     
    What is the exact business process for where you need this? Why can't you use or call the standard periodic job for the status change?
  • Verified answer
    OmarAbdlhamed Profile Picture
    48 on at
    Hi Andre,
     
    thanks for your reply, 
     
    the requirement was to use the same process but using code, but i just noticed this class has two parm methods are useful one for the query and the second for the status
    and i tired the code below and it works as standard periodic job screen
     
    WhsInventoryStatusConvert WhsInventoryStatusConvert = new WhsInventoryStatusConvert();
            query   query = new Query(queryStr(WHSInventStatusChange));
            QueryBuildRange qbr,qbr2,qb3 ;
            
            qbr = SysQuery::findOrCreateRange(query.dataSourceTable(tableNum(InventSum)), fieldNum(InventSum, ItemId));
            qbr.value(queryValue("00257646"));
            //
            qbr2 = SysQuery::findOrCreateRange(query.dataSourceTable(tableNum(InventDim)), fieldNum(InventDim, InventLocationId));
            qbr2.value(queryValue("110"));
            qb3 = SysQuery::findOrCreateRange(query.dataSourceTable(tableNum(InventDim)), fieldNum(InventDim, WMSLocationId));
            qb3.value(queryValue("01-001-20"));
            WhsInventoryStatusConvert.parmQuery(query);
            WhsInventoryStatusConvert.parmToStatus("Damaged");
          //  WhsInventoryStatusConvert.parmInBatch(false);
                WhsInventoryStatusConvert.run();

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 663 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 348 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans