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.

1

Need to find product quantities in locations to create draft delivery order

By
Greg Moss
on 6/27/13, 11:48 PM 645 views

OpenERP 7

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.

Example CSV:

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

i have a need to know how to do this too...

Niklaus Hartmann
on 12/5/13, 10:37 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: 6/27/13, 11:48 PM
Seen: 645 times
Last updated: 3/16/15, 8:10 AM