SAP Business One Query
Hopefully someone can help...
I require a report with selection criteria.
I wish to run a report that looks at the Item Master Data Length, Width and Height Fields.
Basically when I run the report I would like to have 4 selection criteria boxes:
1. Item Group
When I enter the relevant data in one or more then a list of items in that length or greater will appear. I only want to show items that are in stock.
Example: Item Group = Timber
Length = 2 metres
Results show anything 2m or longer.
Is this possible?
I appreciate your help...
Nagarajan K replied
SELECT T0.[ItemCode], T0.[ItemName], T0.[OnHand], T1.[ItmsGrpNam] FROM OITM T0 INNER JOIN OITB T1 ON T0.ItmsGrpCod = T1.ItmsGrpCod WHERE T1.[ItmsGrpNam] = [%0] and T0.[BHeight1] >= [%1] and T0.[BWidth1] >=[%2] and T0.[BLength1] >= [%3] and T0.[OnHand] > 0