Alert: Check for BP Tax Codes

If a state tax code was not entered on the Customer's Ship-To address then when the Sales Order is invoiced you will receive a message stating that the tax code was not provided for the order. This Alert will notify someone when the tax code was not entered. Create a Query with the following SQL and associate it with an alert:

SELECT
T1.CardCode AS 'BP Code'
,T1.CardName AS 'BP Name'
,T0.TaxCode AS 'Tax Code'

FROM [dbo].[CRD1] T0
INNER JOIN [dbo].[OCRD] T1 ON T1.CardCode = T0.CardCode

WHERE T0.TaxCode = ' ' AND T0.AdresType = N'S' AND T1.CardType = N'C'
FOR BROWSE