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
© 2009, Mark Chinsky. All rights reserved. Formed in 2005. the 90 Minds Consulting Group is a collaboration of 100 Sage partners who independently join together online in a 24 x 7 private communication network to solve difficult issues for their customers. The group is not affiliated with Sage and our collaboration provides for unparalleled member access to early warnings of bugs and other issues which members in turn are encouraged to use to provide an exceptional customer experience.
Mark is a partner at Clients First Business Solutions, LLC. He is based out of the NY/NJ office.
Mark has been in ERP sales and service for more than 20 years and at least 15 with Sage
Mark Chinsky
« 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) »
February 7, 2012
by: Wayne Schulz • 90minds
January 30, 2012
by: Wayne Schulz • Uncategorized
January 23, 2012
by: Wayne Schulz • Sage MAS 200, Sage MAS 90
January 21, 2012
by: Wayne Schulz • Giving Tree Consulting, Sage MAS 200, Sage MAS 90
January 21, 2012
by: Wayne Schulz • Sage, Sage MAS 200, Sage MAS 90
January 5, 2012
by: Wayne Schulz • Sage MAS 200, Sage MAS 90
January 23, 2012
by: Wayne Schulz • Sage MAS 200, Sage MAS 90
January 21, 2012
by: Wayne Schulz • Giving Tree Consulting, Sage MAS 200, Sage MAS 90
January 21, 2012
by: Wayne Schulz • Sage, Sage MAS 200, Sage MAS 90
January 5, 2012
by: Wayne Schulz • Sage MAS 200, Sage MAS 90
December 30, 2011
by: Wayne Schulz • 90minds, Bottom Line Software, Sage MAS 200, Sage MAS 90, Schulz Consulting
December 27, 2011
by: Wayne Schulz • Quantera Systems, Sage, Sage MAS 200, Sage MAS 90
January 23, 2012
by: Wayne Schulz • Sage MAS 200, Sage MAS 90
January 21, 2012
by: Wayne Schulz • Giving Tree Consulting, Sage MAS 200, Sage MAS 90
January 21, 2012
by: Wayne Schulz • Sage, Sage MAS 200, Sage MAS 90
January 5, 2012
by: Wayne Schulz • Sage MAS 200, Sage MAS 90
December 30, 2011
by: Wayne Schulz • 90minds, Bottom Line Software, Sage MAS 200, Sage MAS 90, Schulz Consulting
December 27, 2011
by: Wayne Schulz • Quantera Systems, Sage, Sage MAS 200, Sage MAS 90
Leave a Comment
You must be logged in to post a comment.