Skip to Content
avatar image
Former Member

On hand Stock with Specific Item Properties

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 03, 2017 at 09:37 AM

    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

    Add comment
    10|10000 characters needed characters exceeded