On hand Stock with Specific Item Properties

[Former Member]

Good Day Experts,

My Client want me to create a report that can generate inventory per Item Properties how can I make a query that can do if there no connection between OITM and OITG. Can you help me with this.

Item Code| Item Name | On Stock | Item Property

Thank you in advance guys

[agustin_marcoscividanes]

Hi

try this SQL query:

select itemcode, itemname, onhand,

case qrygroup1 WHEN'Y'then (select itmsgrpnam from oitg where itmstypcod = 1) end as property

from oitm

You have to check each property in one line.

Kind regards.

Agustín Marcos Cividanes