Skip to Content
This question has been flagged
2 Replies
956 Views
Avatar
Bill Schultek

Odoo 14

I'm attempting to make a view to access all PO, deliver and receipt info for each line item of the POs.  I have got close but I am stuck on an issue.


If a Subcontracting PO is created with multiple items where we have to ship out product to the vendor I assume the flow goes like this:

PO==>Receipt Order==>Outgoing orders

So per PO line item I am able to get the Po number, easy.  I am able to get the receipt order, easy all items are on one receipt.  The problem is getting the outgoing delivery orders I am pulling all of them that pertain to the PO and not just the PO line item.  If I have 5 subcontracted items on the PO I get 5 ids.  


So how do I map the Subcontracted PO line Item to the outgoing delivery that is associated with it?

Avatar
Discard
Avatar
Ricardo Gross
Best Answer

Hi Bill

To resupply your "subcontrating location" in one single transfer:

1. Enable developer mode

2. Go to inventory->configuration->routes

3. Open the Route: Resupply Subcontractor on Order and Edit

4. Open the Rule: Stock → Subcontracting Location and change the Propagation of Procurement Group from Propagate to Leave Empty.

And so you will have a single "Outgoing delivery".

I hope it helps

Thanks

Ricardo Gross

Avatar
Discard
Avatar
Bill Schultek
Author Best Answer

Will that create a separate PO for each subcontracted item?  If so That would work also.

Avatar
Discard
Ricardo Gross

If you want a PO for each item you can just create them, but my answer is related to your question about having only 1 transfer to the Subcontracted with all the components needed to produce products related to different PO lines, or did I misunderstand your question?

Bill Schultek
Author

Actually I think you misunderstood. Currently they are all in one PO. However our view is by line item so we can keep track of what needs to go out for the subcontacted parts ad receipts are tied to a PO but the required deliveries arent in the PO views. Currently our new view is working but in instances where a PO has more than one item I am pulling up all deliveries per line item for the PO for instance if I have Parts A-F in a PO, the new view will list these out in each line, but when looking for the outgoing deliveries all 5 are on each line item instead of just the delivery for that line item. So what we are trying to do is create a related field to only find the outgoing delivery for that line item. So the solutions are to either figure out the mapping or create a separate PO foe each line item automatically via reordering rules.