SAP Business One Formatted Search: Default the State Tax Code

If you would like to default the Customer Ship-To Tax Code to a specific value, create a query and paste in the SQL at the bottom of the post. Change the the insert your default value where noted and create a formatted search, triggered off of the address name, on the State Tax Code field. The query will retain any values that already exist in the field.
SELECT
Case When $[$-178.12.0] = ”
Then ’0′ /* Insert your default code within the single quotes */
Else $[$-178.12.0]
End As Code

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

View all posts by Mark Chinsky
Mark's website

« XL Reporter | Home | SAP Business One: Commonly Used Tables for Queries »

• 
  
  
  
  
  
  
• Ask a Question on Ask The 90 Minds Group