I'm hoping there is a soul out there who has some experience with 4D SAS. We use it for our inventory/sales management. What I am struggling with now is how to set up some sort of system to automatically calculate sales tax within our own state etc.
Edited: Currently we sell products in CA and we are required to adjust sales tax based on the locations of certain orders. We take orders online and that part is easy, currently WooCommerce can integrate with TaxJar or solutions like that to address our needs.
Any phone/fax/mail order however we input directly into 4D. This is where I am struggling. Currently when we have any of these orders, we have to then declare taxes at a later date etc.
What I am trying to do is set up either my own database (I think?) or what I would prefer to do, is have some external service integrate directly with 4d that would automatically calculate the necessary sales tax and include that in our totals.
So to TLDR my questions: 1) Is there an automatic 3rd party solution that I can integrate with 4d that will automatically calculate sales tax? If so does anybody have any experience in doing so? 2) If not, is there the ability to build a manual database of tax rates (based on zip codes for example) that can be implemented into 4D. If so does anybody have any experience in doing so?
If there is some sort of database entry that anybody is aware of or that someone can guide me to that would be much appreciated, and/or if anybody has experience with this specific issue and knows what to do that also would be great! Hope that helps clarify!
TaxJar or ZipTax both offer APIs that 4D can use to do lookups. IMO, REST is the way to go. I've integrated 4D with WooCommerce as well.