Skip to Content
0
Jan 13, 2023 at 06:20 PM

Find all open documents containing an ItemCode

61 Views

Hi,

I wonder if is there a query to find all the open documents that contains a specific ItemCode.

Domething like this:

SELECT "DocEntry" FROM (all the tables) WHERE "LineStatus" ='O' AND "ItemCode" ='13'

Thank you very much in advance.

Sandra Goldwasser