Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
I have a requirement in which I need to create an import routine to pull in delivery orders from a CSV file. One of the requirements is that in the CSV file, we don't have the locations that the products are located in... we will need to look them up during the import. So, as the file is getting imported, I need to go into the OpenERP inventory and pull out all the locations that match my product code in the CSV file.
To make things a bit more complex, the locations need to be processed by a priority. I'm currently using the PosX field in the location to keep that priority. 0 = primary bin, 1 = secondary, 2 = tertiary, etc. So if there is not enough in the primary to fill the order for that product, I'll need to create another line item to pull from the second location... and so on.
Part Qty Z01 20 Z02 30 Locations: Location Part Qty Loc1 Z01 4 Loc2 Z01 5 Loc3 Z01 14 Loc1 Z02 15 Loc2 Z02 10
I will then create a line item in the delivery order so that the warehouse workers can have a pick ticket that tells them which bin to pick from.
Many thanks in advance
About This Community
This platform 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.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 6/27/13, 11:48 PM|
|Seen: 875 times|
|Last updated: 3/16/15, 8:10 AM|