Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

I want to default a standard tax for supplier and customer for existing 2000 products Which table can I update?

By
JC
on 1/1/15, 10:48 PM 471 views

I have setup all the products in odoo8 and now wish to set the standard tax for each product via SQL. Please help?

 

1
Anand
On 1/2/15, 1:03 AM

Hi,.. it seems like a simple question but it has some confusions

this is sample query.. you should insert rows in product_taxes_rel

INSERT INTO product_taxes_rel VALUES
    (10,2);

10- product.template table id

2- account.tax table id

it works for me...

Anand, Thanks for the answer, I just voted for you. Are you able to help me with this too -> https://www.odoo.com/forum/help-1/question/how-to-initialize-product-quantity-available-equal-to-quantity-on-hand-72098

JC
on 1/2/15, 4:15 AM

k will check it...

Anand
on 1/2/15, 4:23 AM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 1/1/15, 10:48 PM
Seen: 471 times
Last updated: 3/16/15, 8:10 AM