web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Supply chain | Supply Chain Management, Commerce
Unanswered

Minimum and maximum from ReqItemTable

(2) ShareShare
ReportReport
Posted on by 2,430
Hi Experts,
 
Customer requirement to get item minimum and maximum from ReqItemTable with Availablephysical and Ordered quantities
 
The AvilablePhysical and Ordered quantity not respecting inventDimId. It is giving me all AvailablePhysical and Ordered quantities for an itemid.
 
SELECT 
    R.ITEMID,
    INVENTDIM.CONFIGID,
    INVENTDIM.INVENTSTYLEID,
    INVENTDIM.INVENTSIZEID,
    INVENTDIM.INVENTCOLORID,
    INVENTDIM.INVENTSITEID,
	INVENTDIM.INVENTLOCATIONID,
    R.COVINVENTDIMID,
    R.MININVENTONHAND,
    R.MAXINVENTONHAND,
    SUM(ISUM.AvailPhysical) AS TotalAvailPhysical,
	SUM(ISUM.ORDERED) AS TotalAvailORDER
FROM 
    REQITEMTABLE R
JOIN 
    INVENTDIM ON R.COVINVENTDIMID = INVENTDIM.INVENTDIMID
JOIN 
    INVENTSUM ISUM ON R.ITEMID = ISUM.ITEMID 
WHERE 
    R.COVRULE = 2
   
GROUP BY
    R.ITEMID,
    INVENTDIM.CONFIGID,
    INVENTDIM.INVENTSTYLEID,
    INVENTDIM.INVENTSIZEID,
    INVENTDIM.INVENTCOLORID,
    INVENTDIM.INVENTSITEID,
	INVENTDIM.INVENTLOCATIONID,
    R.COVINVENTDIMID,
    R.MININVENTONHAND,
    R.MAXINVENTONHAND
 
 
  • jac_rod Profile Picture
    39 Moderator on at
    Check the settings on the dimension groups (especially the storage dimension group) and confirm that the "Coverage plan by dimension" checkbox is checked for the dimensions that you're interested in.
  • Laurens vd Tang Profile Picture
    5,286 Super User 2026 Season 2 on at
    Good day,
     
    Which dimensions are you missing?
     
    Best regards,
    Laurens van der Tang
  • faiz7049 Profile Picture
    2,430 on at
    Thank you Jac rod.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Laurens vd Tang Profile Picture

Laurens vd Tang 129 Super User 2026 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 115 Super User 2026 Season 2

#3
Aayush Tiwari Profile Picture

Aayush Tiwari 46

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans