Using Query generator - Showing Bin location, item code, description, barcode etc

Former Member — Wed, 17 Jun 2020 13:33:03 GMT

Hi All,

Using Query generator, I would like a report that shows everything in the main and bulk warehouse including the items that have NO STOCK (the no stock items are always removed when running the standard reports but they are very useful for a lot of the work that I am doing)

Currently I can run 2 standard reports and capture most of the information but it doesn't include the zero stock items. I would like to combine this data and include the zero stock items.

I have tried to use query generator and for the most part I have got the information I need however I can't seem to get the bin location added to my report using JOIN table... I'm pretty new to SAP and SQL so apologies if I'm doing it all wrong!!!

I want the Query to include the following including the zero stock items (I can't stress about these zero items enough lol):

Bin location

item code

description

barcode

mfr

stock

min

max

unit price

I am using SAP Business one 9.3 if that helps

Thanks in advance

Anthony

Re: Using Query generator - Showing Bin location, item code, description, barcode etc

former_member932476 — Tue, 26 Jan 2021 09:04:59 GMT

Hi Anthony,

SELECT T0.[DfltWH], T0.[ItemCode], T0.[ItemName], T0.[CodeBars], T0.[SuppCatNum], T0.[OnHand], T0.[MinLevel], T0.[MaxLevel], T1.[Price]

FROM OITM T0 INNER JOIN ITM1 T1 ON T0.[ItemCode] = T1.[ItemCode]

hopefully it can help you

topic Using Query generator - Showing Bin location, item code, description, barcode etc in Application Development and Automation Discussions

Using Query generator - Showing Bin location, item code, description, barcode etc

Re: Using Query generator - Showing Bin location, item code, description, barcode etc