Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SAP Business One Query

Hi Experts,

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

2. Length

3. Width

4. Height

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...


Former Member

Try this:

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

0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question