We have a third part proof of delivery system which records the proof of delivery information in the Item Fulfilment record.
From this I can include these custom fields in the 'Packing Slip' template so that if this is printed after delivery it becomes a 'proof of delivery' document showing the items along with the signature and names etc.
I'm looking to try and include this POD information with the Invoice document. We are moving to automated invoicing (daily) so in 99.9% of cases there should only be 1 fulfilment per invoice - but there can be multiple invoice/fulfilments for a sales order.
There doesn't appear to be a direct link from the Invoice to the Fulfilment, so I'm not sure how to retrieve that data. Even if I copied the data from the Fulfilment up to the Sales Order record, I can't see how this would work with multiple invoice/fulfilments on a single order....
Does anyone have any ideas on how this could be achieved? Or has anyone done anything similar?