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

Initial Stock for POS OpenERP 7.0

By
Johan
on 3/25/13, 10:39 PM 3,341 views

Hi,

I just try migrate from local POS program to OpenERP 7.0. The product is successfully imported from CSV file. How can I put initial stock qty for my product? In which Warehouse location it should be put on?

Thanks + regards, Johan

1
Antoine Huvelle
On 3/26/13, 9:19 AM

You could go in Warehouse > Inventory Control > Physical Inventories and create a new inventory. You'll have to add one line per product and specify the stock location.

Of course, once your inventory is created, you can chose to import it.

A v7 Runbot with all DB will give you an example of Starting Inventory at that place.

Thanks Antonie. Since I am newbie, please explain in detail how I can import the initial inventory data from CVS? BTW what is A v7 Runbot? Where is it? Thanks

Johan
on 3/27/13, 2:47 AM
0
Hans
On 3/25/13, 11:39 PM

I think you must make purchase to increase the qty of the product

I think you are right if I just begin the business with OpenERP. Actually I am migrate from other local made simple POS program, and the retail business is already running with about 800 active items with some stock of them. Any Idea?

Johan
on 3/26/13, 12:10 AM
0

Omal Bastin

--Omal Bastin--
1146
| 6 6 8
Kochi, Kerala, India
--Omal Bastin--

Swiming deep into openERP/ODOO

Omal Bastin
On 3/26/13, 4:34 AM

From the product menu, select your product. There is a tab called 'Inventory' n the form view of product. There you can see a button link called 'Update' which is use to update the quantity available with you. If you have multiple locations then you need to add the group 'manage multiple locations' to the user.

0

patrick

--patrick--
1958
| 5 4 7
Baarn, Netherlands
--patrick--
patrick
On 3/26/13, 7:36 AM

It can be scripted as well, depending on the amount of work it is for someone to manually add the numbers (and they might change after they have been added....). If you want to scipt it, you need:

a csv-file with the following things:

  • article (name/code/ what ever to uniquely identify it in the DB)
  • amount available
  • location (name/code what ever to uniquely identify location in the DB)

a script which does:

  • read file per line
  • look up the article, store the ID within the DB
  • look up the location, store the ID within the DB
  • in the table 'stock.change.product.qty', add the values: location ID, quantity
  • use the method change_product_qty to get the needed things changed

Code below is using the additional module openerp-client-lib. It is NOT a complete snippet, just something to get you started. If needed, I can give a more detailed answer later.

connection = openerplib.get_connection(hostname=h, database=db, login=u, password=p)

m = 'stock.change.product.qty'

model = connection.get_model(m)

v = {'prodlot_id': False, 'location_id': locID, 'new_quantity': from csv-file}

stockID = model.create(v)

context = {'active_id': id} # id of product!

res = model.change_product_qty([stockID], context)

Please give more detail.

Johan
on 4/18/13, 5:00 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: 3/25/13, 10:39 PM
Seen: 3341 times
Last updated: 3/16/15, 8:10 AM