List of customers and supplier table details

Hello Bushair,

1 ) How to update/upload the openerp customers and suppliers list with the existing list in my pos?
And : you can create a csv for that and Using Import wizard you can add (customers and suppliers list)in partner form.

2) In Which table(Database table) in openerp the customers and suppliers datas are stored?
Ans : res_partner Table.

3) How to update the products list in openerp that is available in my existing POS?Which is DB table used in openerp for storing the product details.?
Ans: Product_product and product_template are the database table for product.You can add product also like partner using import.

Thanks.

Hi,
Thanks alot for the information
Also i would like to know which database table has the following details?

1)Customer balance

2)Supplier balance

Thanks

Hello Bushair,

They are not stored in any table/record. They are functional fields.

They are calculated based on account move line.

Thanks.

Hi,
thanks for the information.

but i was using an ERP (not open erp) ,which has the customer and supplier balance data.

Now i would like to move to openerp , so how and where i can store these balance details in openerp database?

Thanks

Hi,

OpenERP does not have any direct details of Balance.

We get them calculated dynamically from Accounting entries and these are frm account.move and account.move.line.

Thanks.