Hi,
I'm using SAP Business One 9.2
I know nothing about query but I would like to be able to benefit from its powerful possibilities to create some particular searches and alerts.
I found this query in a book but I was not able to run it. If you can help. Thanks
SELECT T1.DocNum
FROM dbo.INV1 T0
INNER JOIN dbo.OINV T1 ON T1.DocEntry = T0.DocENtry
WHERE T1.DocNum = $[$8.0.0] AND
T0.ItemCode = $[$38.1.0] AND
T0.BaseType = -1