Skip to Content
0

On hand Stock with Specific Item Properties

Jul 03, 2017 at 07:53 AM

45

avatar image
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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Agustin Marcos Cividanes Jul 03, 2017 at 09:37 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded