Announcements
No record found.
Hi All,
I just want to get all the items present in an warehouse with the on hand quantity of an item through X++.
Thanking you in advance.
Thanks & Regards,
Kedar
*This post is locked for comments
Depending on what you call on-hand, this type of approach is quite easy.
In this code, the filter is on PhysicalInvent, which is PostedQty + Received - Deducted + Registered - Picked. If you're interested in a more "accounting" type of on-hand, that would be PostedQty + Received - Deducted and would require some tweaks.
InventSum inventSum; InventDim inventDimCriteria; InventDimParm inventDimParmCriteria; InventDimParm inventDimParmGroupBy; Query q; QueryBuildDataSource qbds; QueryRun qr; ; inventDimCriteria.InventLocationId = 'W'; // warehouse inventDimParmCriteria.InventLocationIdFlag = true; // filter on warehouse inventDimParmGroupBy.ItemIdFlag = true; // group by item q = InventSum::newQuery(q, '', inventDimCriteria, inventDimParmCriteria, inventDimParmGroupBy); qbds = q.dataSourceTable(tableNum(InventSum)); qbds.addRange(fieldNum(InventSum, PhysicalInvent)).value(SysQuery::valueNot(0)); qr = new QueryRun(q); while (qr.next()) { inventSum = qr.get(tableNum(InventSum)); info(strFmt("Item number: %1", inventSum.ItemId)); }
Thank you brandon.
Hi Brandon,
If I want items present in specific irrespective of on hand then the below code is enough right?
InventSum inventSum;
InventDim inventDimCriteria;
InventDimParm inventDimParmCriteria;
InventDimParm inventDimParmGroupBy;
Query q;
QueryBuildDataSource qbds;
QueryRun qr;
;
inventDimCriteria.InventLocationId = 'W'; // warehouse
inventDimParmCriteria.InventLocationIdFlag = true; // filter on warehouse
inventDimParmGroupBy.ItemIdFlag = true; // group by item
q = InventSum::newQuery(q, '', inventDimCriteria, inventDimParmCriteria, inventDimParmGroupBy);
qr = new QueryRun(q);
while (qr.next())
{
inventSum = qr.get(tableNum(InventSum));
info(strFmt("Item number: %1", inventSum.ItemId));
}
What does "in" mean without on-hand? You want to know items with open sales orders or open purchase orders in a specific warehouse?
Hey to further open this question, how do I list the warehouses containing x-item? for example I searched for an item, it will return all the warehouses that contains said item.
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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CP04-islander 39
Michel ROY 14
imran ul haq 8
