hi every one,
how i can get all products by each location in postgreSQL?
i can´t find the table where odoo save the quantity of all products for each location
thanks in advance
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Kế toán
- Tồn kho
- PoS
- Dự án
- MRP
Câu hỏi này đã bị gắn cờ
3
Trả lời
6641
Lượt xem
To insert product no need to create stock moves. Stock Moves needs to created only if products quantity needs to be updated.
That is because OpenERP does not store that information directly into Postgres. It is based on a calculated field that gets updated everytime it is triggered within OpenERP. For example, when a stock move is set to the specified location.
If you want an overview outside of Postgres, just go the specified location and print out the stock report.
If you must do this within postgres then you should loop over the stock_move table and calculate based on the product_id, destination_location_id and source_location_id (or something like that).
thank Ludo, and is the same for inserting a products? i have to insert data into much tables?
Inserting products should be done using an XML-RPC connection preferably, because you will loose all sort of information when only inserting records into OpenERP. If you want to insert stock for existing products than you should be fine using the stock moves.
Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!
Tạo tài khoản ngay hôm nay để tận hưởng các tính năng độc đáo và tham gia cộng đồng tuyệt vời của chúng tôi!
Đăng ký| Bài viết liên quan | Trả lời | Lượt xem | Hoạt động | |
|---|---|---|---|---|
|
Locations
Đã xử lý
|
|
1
thg 3 15
|
11210 | |
|
8
thg 12 23
|
38673 | ||
|
2
thg 8 21
|
5136 | ||
|
1
thg 4 19
|
3364 | ||
|
6
thg 10 17
|
13699 |
