Get Customer PO ref on item level delivery and invoice

[Berik]

How can I get the PO reference of the customer, on the item level of the delivery and invoice? Sometimes I deliver multiple PO’s of the customer on one delivery, and one invoice.

How would I be able to do this?

I tried fetch from sales order.po_no to insert at customizing, but this doesn’t do the trick.

Any help is appreciated!

Thanks and regards

[Berik]

Customer's PO number on Delivery Note Item

You can solve it but this will require a small change in the Python code which may lead to update conflicts in the future. Hence I would not recommend it. Can we include items from multiple sales orders into a single delivery note ? This can be done for items from multiple sales orders. For the Customer PO field in Delivery Note Item, mention this in Options Fetch From of that field, assuming against_sales_order is the Sales Order Link in that Item row : against_sales_order.po_no You can ke…

I managed to get it on Delivery Note through above.

Anybody know how to get it from delivery note to Invoice?

[root13F]

@Berik

Anybody know how to get it from delivery note to Invoice?

I think you should be able to fetch it from the purchase order against which you are making your invoice

[Berik]

But if you make invoice from delivery note? Does it copy from field delivery to field invoice?

[root13F]

Is this field available in that delivery note ? If yes, then we can fetch it.

please share a screenshot of the delivery note, redact any sensitive details. also share if the screenshot of the area in invoice where you want to get it fetched. i need to know if it is the parent invoice doctype or do you want to get it fetched in the child doctype, i.e. the items table

[Berik]

I think I got it to work in the delivery note item, will test today and share a screenshot asap.

It indeed is about the invoice items. On item line I want to mention PO (or, if possible, create a “break” for each po number).