You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Steve <st...@neobits.com> on 2009/04/01 20:15:24 UTC
Load California Sales Tax Rates
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
Re: Load California Sales Tax Rates
Posted by BJ Freeman <bj...@free-man.net>.
-----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-----
Re: Load California Sales Tax Rates
Posted by BJ Freeman <bj...@free-man.net>.
-----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-----
Re: Load California Sales Tax Rates
Posted by neobits <st...@neobits.com>.
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.
--
View this message in context: http://www.nabble.com/Load-California-Sales-Tax-Rates-tp22832546p22834561.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Load California Sales Tax Rates
Posted by BJ Freeman <bj...@free-man.net>.
-----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-----