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, ... / InventSum does not upd...
Finance | Project Operations, Human Resources, ...
Suggested answer

InventSum does not update when using reservation lot.

(0) ShareShare
ReportReport
Posted on by pam86 45

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();
}

  • Suggested answer
    pam86 Profile Picture
    pam86 45 on at
    RE: InventSum does not update when using reservation lot.

    The result is still the same after removing conditions.

    Actually, I created this view to use for factbox query for my salestable form.  But as this did not work so I used the factbox logic implemented in inventory on-hand form factbox. That worked for me as it takes care of reservations etc.

    Thank you for your feedback.

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: InventSum does not update when using reservation lot.

    Hi Pam,

    Can you get rid of the where condition in the query and try? Maybe the reservation is getting done in a location other than "MAIN DC".

  • pam86 Profile Picture
    pam86 45 on at
    RE: InventSum does not update when using reservation lot.

    same result, the reservation lot does not show.

  • Suggested answer
    Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: InventSum does not update when using reservation lot.

    Can you change the query to something like this -

    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
OUTER JOIN WMSLOCATION WM ON D.INVENTLOCATIONID = WM.INVENTLOCATIONID AND D.WMSLOCATIONID = WM.WMSLOCATIONID
WHERE WM.INVENTLOCATIONID = 'MAIN DC'
GROUP BY I.ITEMID

  • pam86 Profile Picture
    pam86 45 on at
    RE: InventSum does not update when using reservation lot.

    Yes, the inventory on hand does show the reservation on the sales order.

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: InventSum does not update when using reservation lot.

    Hi Pam,

    Can you check the inventory transactions for the sales order and provide screenshots of the inventory transactions post reservation?

    Are you able to see any changes in the inventory on hand values after doing a reservation on the sales order?

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February 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... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans