Skip to Content
0
Mar 20, 2021 at 06:18 PM

Alert for invoice without base document

56 Views

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