Dynamics Community Forum Thread Details

Inventory Status Change with Specific Quantity

Hello Guys,

I have a requirement related to Inventory status changes, where I need to update the status of a specific item using a batch job.
I am attempting to change the status (e.g., from Available to Damaged) for a particular quantity, but it is not working as expected.

For eg: If an item has 200 units available in the On-hand inventory, I want to change the status of 50 units to Damaged. After the update, the system should reflect 50 units as Damaged and the remaining 150 units as Available.

I’ve shared the code below—could you please help me resolve this?

Query query;

WhsInventoryStatusConvert whsInventoryStatusConvert = WhsInventoryStatusConvert::construct();

query = whsInventoryStatusConvert.buildQuery();

SysQuery::findOrCreateRange(query.dataSourceTable(tableNum(InventSum)), fieldNum(InventSum, InventLocationId)).value(stagingCaller.GLNInventWarehouse);

SysQuery::findOrCreateRange(_query.dataSourceTable(tableNum(InventSum)), fieldNum(InventSum, ItemId)).value(_line.ItemNumber);
SysQuery::findOrCreateRange(_query.dataSourceTable(tableNum(InventSum)), fieldNum(InventSum, InventVersionId)).value(_line.InventVersionId);
SysQuery::findOrCreateRange(_query.dataSourceTable(tableNum(InventSum)), fieldNum(InventSum, InventStatusId)).value(_line.FromInventoryStatus);
SysQuery::findOrCreateRange(_query.dataSourceTable(tableNum(InventSum)), fieldNum(InventSum, InventBatchId)).value(_line.inventBatchId);
SysQuery::findOrCreateRange(_query.dataSourceTable(tableNum(InventSum)), fieldNum(InventSum, PhysicalInvent)).value(SysQuery::value(_line.InventQty));

_whsInventoryStatusConvert.parmQuery(_query);
_whsInventoryStatusConvert.parmToStatus(_line.ToInventoryStatus);

_whsInventoryStatusConvert.run();

Categories:

Microsoft Dynamics AX

Quick Links