Store the tax rate as the attribute of product in product dimension table?

View previous topic View next topic Go down

Store the tax rate as the attribute of product in product dimension table?

Post  phoenixbai on Wed Sep 28, 2011 1:59 am

Hi All,

This is my first post, so hi and nice to meet you all.

My Business Requirement: client wants the amounts of sale tax. And client offers the list the tax rate for certain product categories, for the rest, no tax rate.

My question would be: can I store the the tax rate as an attribute of the product dimension?
if no, why? and how you guys deal with this kind of situation in which, the tax rateh is based on the product?

Thanks

phoenixbai

Posts : 2
Join date : 2011-09-28

View user profile

Back to top Go down

Re: Store the tax rate as the attribute of product in product dimension table?

Post  ngalemmo on Wed Sep 28, 2011 3:07 am

Absolutely not! Sales tax should be its own dimension. It has no direct relationship to product. It is a function of product, usage, and location.

Also, if you are collecting sales tax, it is more than likely your company is on the hook to sending a number of checks every quarter to various municipalities, counties, parishes, and states. Having a tax dimension and an associated bridge to distribute tax by taxing authority would allow users to easily produce information for their quarterly tax returns.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

You are right, I should create a new tax rate dimension. Thank you very much for the instanct response

Post  phoenixbai on Wed Sep 28, 2011 4:32 am

ngalemmo wrote:Absolutely not! Sales tax should be its own dimension. It has no direct relationship to product. It is a function of product, usage, and location.

Also, if you are collecting sales tax, it is more than likely your company is on the hook to sending a number of checks every quarter to various municipalities, counties, parishes, and states. Having a tax dimension and an associated bridge to distribute tax by taxing authority would allow users to easily produce information for their quarterly tax returns.

phoenixbai

Posts : 2
Join date : 2011-09-28

View user profile

Back to top Go down

Re: Store the tax rate as the attribute of product in product dimension table?

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum