Load California Sales Tax Rates

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

Load California Sales Tax Rates

Steve Fatula
There are around 2,000 entities, what is the best way to load/update  
these? Is there a good process to update them from a file of some  
sort? Anyone know where such a file is?

Have not had any luck looking for the data.

Steve
Reply | Threaded
Open this post in threaded view
|

Re: Load California Sales Tax Rates

BJ Freeman
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

here is a good place to check
http://docs.ofbiz.org/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo
you can also search for articles.
this is one I am working on
http://docs.ofbiz.org/display/OFBIZ/Handling+of+External+data
you should be familar with the
http://docs.ofbiz.org/display/OFBTECH/OFBiz%27s+Tax+Authority+Data+Model

Steve sent the following on 4/1/2009 11:15 AM:
> There are around 2,000 entities, what is the best way to load/update
> these? Is there a good process to update them from a file of some sort?
> Anyone know where such a file is?
>
> Have not had any luck looking for the data.
>
> Steve
>
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJ076JrP3NbaWWqE4RAm6NAJ9NKHcjsoq8sESyWXEO4h1555zfAgCgoqcX
onnzlZ1Sbdve67xz6AyUOus=
=p5U0
-----END PGP SIGNATURE-----
Reply | Threaded
Open this post in threaded view
|

Re: Load California Sales Tax Rates

Steve Fatula
What I would most like to understand is how an order even gets sales tax on it. A customer places an order, what associates the customer with a sales tax region, authority, whatever?

In California, that is by zip code or city. So, when a customer is placing an order, what tells ofBiz to look something up, and, where does it look it up? I do not see that doc anywhere.

Sure, I can see that there are some tables for taxes, and, I can see there are tax authority geo codes (ids). So, what associates a customer to a given tax_authority_geo_id, i.e., how does ofbiz determine that customer has that geo id? It has to look something up somewhere, based on something. And where is that something defined? Or, is it just build in, still, if so, I'd like to understand how that association happens.
Reply | Threaded
Open this post in threaded view
|

Re: Load California Sales Tax Rates

BJ Freeman
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

you best reference is to start with the Data modeling book reference on
the ofbiz site
next would recommend working you way  thru
http://docs.ofbiz.org/display/OFBADMIN/Apache+OFBiz+Getting+Started


neobits sent the following on 4/1/2009 1:04 PM:

> What I would most like to understand is how an order even gets sales tax on
> it. A customer places an order, what associates the customer with a sales
> tax region, authority, whatever?
>
> In California, that is by zip code or city. So, when a customer is placing
> an order, what tells ofBiz to look something up, and, where does it look it
> up? I do not see that doc anywhere.
>
> Sure, I can see that there are some tables for taxes, and, I can see there
> are tax authority geo codes (ids). So, what associates a customer to a given
> tax_authority_geo_id, i.e., how does ofbiz determine that customer has that
> geo id? It has to look something up somewhere, based on something. And where
> is that something defined? Or, is it just build in, still, if so, I'd like
> to understand how that association happens.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJ08sVrP3NbaWWqE4RAia3AJ9m+XB9tfDfnGdkFrfMqoMZFR3GsgCgl1OX
hXRHNOcc75Uu2JH7JWPeVGI=
=rJZh
-----END PGP SIGNATURE-----
Reply | Threaded
Open this post in threaded view
|

Re: Load California Sales Tax Rates

BJ Freeman
In reply to this post by Steve Fatula
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

another source is to use the artifacts in the webtools
https://demo.ofbiz.org/webtools/control/ArtifactInfo
type in Tax


neobits sent the following on 4/1/2009 1:04 PM:

> What I would most like to understand is how an order even gets sales tax on
> it. A customer places an order, what associates the customer with a sales
> tax region, authority, whatever?
>
> In California, that is by zip code or city. So, when a customer is placing
> an order, what tells ofBiz to look something up, and, where does it look it
> up? I do not see that doc anywhere.
>
> Sure, I can see that there are some tables for taxes, and, I can see there
> are tax authority geo codes (ids). So, what associates a customer to a given
> tax_authority_geo_id, i.e., how does ofbiz determine that customer has that
> geo id? It has to look something up somewhere, based on something. And where
> is that something defined? Or, is it just build in, still, if so, I'd like
> to understand how that association happens.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJ08ySrP3NbaWWqE4RAtEEAJ9szsiODlg9OLOfVBlx2jR4KESbMQCdHGgP
45rWSfkSH8UWYlMRXTt18Bc=
=bi9i
-----END PGP SIGNATURE-----