SAP Business One Alerts 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

Thanks to Ed Monk of SBONotes.com

« SAP Business One Retrieving the Ship-To State for a Sales Order | Home | SAP Business One Query to Show Open Balances by Customer (or Vendor) »

• 
  
  Need help? Click Here.