Dynamics Community Forum Thread Details

fetching all records from inventsum according to inventtable.

Hi!

I am developing a customized report in which i need to add a filter of item group id.

and fetch availphysical from inventsum and minimum and maximum quantity from reqitem table.

so I built a query

while select ItemId from inventItemGroupItem

where inventItemGroupItem.ItemGroupId == parmItemGroupId.parmObject()

join sum(AvailPhysical) from Inventsum

where inventsum.ItemId == inventItemGroupItem.ItemId

join MinInventOnhand,MaxInventOnhand from reqItemTable

where reqItemTable.ItemId == inventItemGroupItem.ItemId

here the problem is there are every record in inventtable but not all added to the inventory

and the table inventsum only contains the records which are added to the inventory and reqitemtable only provides the records of which minimum and maximum quantity has been added. so when i run this query it only fetches the records present in all three tables. otherwise it doesnt bring the other all records in invent table.

iwant to fetch all the records from inventtable and of which item the min max and avail physical is not available it show them blank but must fetch the data according to inventtable.

what should i do please help.

Quick Links

Leaderboard