Hi,
I have created AX View based on the below SQL query. It calculates all the qty fields fine until you reserve a lot in a sales order. Then this view does not provide the correct available qty after reservation. I tried to use AX job to update the inventSum table but no help.
Thank you in advance for your insight/help.
SELECT ITEMID, SUM(I.RESERVPHYSICAL) RESERVEPHY, SUM(I.PHYSICALINVENT) PHYINVENT, SUM(I.AVAILPHYSICAL) AVAILPHY
FROM INVENTSUM I
JOIN INVENTDIM D ON I.INVENTDIMID = D.INVENTDIMID
JOIN WMSLOCATION WM ON D.INVENTLOCATIONID = WM.INVENTLOCATIONID AND D.WMSLOCATIONID = WM.WMSLOCATIONID
WHERE WM.INVENTLOCATIONID = 'MAIN DC'
GROUP BY I.ITEMID
static void Job2(Args _args)
{
InventSumRecalcItem InventSumRecalcItem;
;
InventSumRecalcItem = new InventSumRecalcItem("M2300N95", true, checkfix::fix);
InventSumRecalcItem.updatenow();
}
