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 :
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / In Critical on hand in...
Supply chain | Supply Chain Management, Commerce
Answered

In Critical on hand inventory report want to add maximum quantity same as minimum

(4) ShareShare
ReportReport
Posted on by faiz7049 2,430
Hi Experts,
 
I want to add maximum quantity in critical on hand inventory report. Difficulty is where I should put code and what in class InventSumCriticalInt and how to add my new report to user interface(subcribe new report design).
 
 
Thanks,
Faiz
 
 
Categories:
Dynamics 365 Supply Chain Management
  • faiz7049 Profile Picture
    faiz7049 2,430 on at
    Hi Experts,
     
    Could you please check my approach is correct in below X++ code.
     
    [ExtensionOf(classStr(InventSumCriticalInit))]

final public class SFA_InventSumCriticalInit_Extension
{

        public void processInventSumCriticalRecords()
        {
            next processInventSumCriticalRecords();
        
            QueryRun queryRun = new QueryRun(this.criticalOnHandQuery);
            ReqItemTable reqItemTable;
            InventDim inventDim;
            ItemId itemId;
            InventDimParm inventDimParm;
            InventDimGroupSetup inventDimGroupSetup;
            ReqSetup reqSetup;

            while (queryRun.next())
            {
                if (queryRun.changed(tableNum(ReqItemTable)))
                {
                    reqItemTable = queryRun.get(tableNum(ReqItemTable));
                    if (itemId != reqItemTable.ItemId)
                    {
                        itemId = reqItemTable.ItemId;

                        reqSetup = ReqSetup::newItemId(itemId);
                        inventDimGroupSetup = InventDimGroupSetup::newItemId(itemId);
                        inventDimParm.initCovPrDimension(inventDimGroupSetup);
                    }
                }

                inventDim = queryRun.get(tableNum(InventDim));

                // Custom logic to include maximum quantity
                this.insertPhysicalOnhandBelowMinimumQuantity_Extended(
                reqSetup,
                itemId,
                inventDim,
                inventDimParm,
                inventDimGroupSetup);
            }
        }

        private void insertPhysicalOnhandBelowMinimumQuantity_Extended(
        ReqSetup _reqSetup,
        ItemId _itemId,
        InventDim _inventDim,
        InventDimParm _inventDimParm,
        InventDimGroupSetup _inventDimGroupSetup)
        {
            InventDim inventDimCoverage = InventDim::find(_inventDim.reqCovDimId(_inventDimGroupSetup));
            InventQtyMinOnhand minimumOnHandQuantity = ReqSetupDim::newCovInventDimId(_reqSetup, inventDimCoverage.InventDimId).minInventOnHand();
            InventQtyMaxOnhand maximumOnHandQuantity = ReqSetupDim::newCovInventDimId(_reqSetup, inventDimCoverage.InventDimId).maxInventOnHand(); // Fetch max quantity

            InventSum inventSumOnHand  = InventOnHandQty::newItemDim(_itemId, inventDimCoverage, _inventDimParm).inventSum();

            if (inventSumOnHand.physicalInventCalculated() < minimumOnHandQuantity)
            {
                this.initTmpTable_Extended(inventSumOnHand, _inventDim, minimumOnHandQuantity, maximumOnHandQuantity);
                this.insertTmpTable();
            }
        }

        protected void initTmpTable_Extended(
        InventSum _inventSumOnHand,
        InventDim _inventDim,
        InventQtyMinOnhand _minimumOnHandQuantity,
        InventQtyMaxOnhand _maximumOnHandQuantity) // Add max quantity parameter
        {
            InventIAvailability inventAvailability = InventAvailabilityProvider::findBySumDim(_inventSumOnHand, _inventDim).parmInventAvailability();
            inventSumCriticalTmp.QtyMinOnhand = _minimumOnHandQuantity;
            inventSumCriticalTmp.QtyMaxOnhand = _maximumOnHandQuantity; // Store max quantity
            inventSumCriticalTmp.ItemId = _inventSumOnHand.ItemId;
            inventSumCriticalTmp.InventDimFieldsMap::initAllDimensionsFrom(_inventDim);
            inventSumCriticalTmp.Ordered = inventAvailability.ordered();
            inventSumCriticalTmp.ItemName = _inventSumOnHand.itemName();
            inventSumCriticalTmp.PhysicalInvent = _inventSumOnHand.physicalInventCalculated();
        }
    }
     
  • faiz7049 Profile Picture
    faiz7049 2,430 on at
    Hi Experts,

    Maximum quantity is not showing in Critical on hand inventory report. Could you please help my extension code.
     


    ​​​​​​​
  • faiz7049 Profile Picture
    faiz7049 2,430 on at
    Hi Experts,
     
    Please could you check my below extension code. What is missing in it.
     
    [ExtensionOf(classStr(InventSumCriticalInit))]

final public class SFA_InventSumCriticalInit_Extension
{

            public void processInventSumCriticalRecords()
        {
            next processInventSumCriticalRecords();
        
            QueryRun queryRun = new QueryRun(this.criticalOnHandQuery);
            ReqItemTable reqItemTable;
            InventDim inventDim;
            ItemId itemId;
            InventDimParm inventDimParm;
            InventDimGroupSetup inventDimGroupSetup;
            ReqSetup reqSetup;

            while (queryRun.next())
            {
                if (queryRun.changed(tableNum(ReqItemTable)))
                {
                    reqItemTable = queryRun.get(tableNum(ReqItemTable));
                    if (itemId != reqItemTable.ItemId)
                    {
                        itemId = reqItemTable.ItemId;

                        reqSetup = ReqSetup::newItemId(itemId);
                        inventDimGroupSetup = InventDimGroupSetup::newItemId(itemId);
                        inventDimParm.initCovPrDimension(inventDimGroupSetup);
                    }
                }

                inventDim = queryRun.get(tableNum(InventDim));

                // Custom logic to include maximum quantity
                this.insertPhysicalOnhandBelowMinimumQuantity_Extended(
                reqSetup,
                itemId,
                inventDim,
                inventDimParm,
                inventDimGroupSetup);
            }
        }

        private void insertPhysicalOnhandBelowMinimumQuantity_Extended(
        ReqSetup _reqSetup,
        ItemId _itemId,
        InventDim _inventDim,
        InventDimParm _inventDimParm,
        InventDimGroupSetup _inventDimGroupSetup)
        {
           InventDim inventDimCoverage = InventDim::find(_inventDim.reqCovDimId(_inventDimGroupSetup));
           
            InventQtyMaxOnhand maximumOnHandQuantity = ReqSetupDim::newCovInventDimId(_reqSetup, inventDimCoverage.InventDimId).maxInventOnHand(); // Fetch max quantity
              
                this.initTmpTable_Extended(maximumOnHandQuantity);
                this.insertTmpTable();
         }

        protected void initTmpTable_Extended(InventQtyMaxOnhand _maximumOnHandQuantity) // Add max quantity parameter
        {
          
          
            inventSumCriticalTmp.QtyMaxOnhand = _maximumOnHandQuantity; // Store max quantity
          
        }

}
     
  • Verified answer
    faiz7049 Profile Picture
    faiz7049 2,430 on at
    This thread is closed. I created separate report based on min max from reqItemTable.
     
    Thank you.
    Faiz 

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

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
André Arnaud de Calavon Profile Picture

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

#2
Paolo Cecchelli Profile Picture

Paolo Cecchelli 79 Super User 2026 Season 2

#3
Aayush Tiwari Profile Picture

Aayush Tiwari 71

Last 30 days Overall leaderboard

Featured topics

Quality order uses default receipt location instead of actual physical receipt location

Product updates

Dynamics 365 release plans