Hi all, we create a bill for multiple purchase orders. We want to show the related PO number of each line in the line item of the bill. Created a workflow, but it pulls through the last PO number on each line. Do you think I need a script or something is wrong with my workflow?

Have you already tried a custom line field? I didn't actually set this up to validate, but setting up a line field like the below might work. Might take some tweaks too (maybe do it as a formula?), but I think this would be ideal vs a WF if you can get it to work.

Thanks @RJMNS I tried different ways, but not working. I have to resort to scripts.