Hi All, just want to know if its possible to link standalone bills/invoices to the exiting PO.

I don't believe there's a way to do it unless you bill directly from the PO itself, otherwise it doesn't know there's a relationship between the two transactions.

ok thanks

yeah i've tried this a bunch of ways before and don't believe you can link to the PO unless you generate the bill from the PO

I can confirm. Also Note you can break the existing link if you modify the item or expense category in the bill. At my current company AP did that to reclass some bills and they broke the link, and no way of getting it back. One option is if the bill is not paid and open, then delete it and create the bill from PO.

yep and that's a really key thing to make users aware of if they're not - esp also between PO and SO line

another thing I am doing is added a custom field for transaction and manually select the corresponding PO a the value. This is not a proper reference ie as related records (applying and applied to transaction)

Nice, I've added something like that recently for quotes, and a script then sets the sales order on each quote line as they are generated

Currently our users deleting the bill and creating new one from PO. we also have a custom field on the Bill to update PO number for reference. but we want to find way to actually link it to PO and avoid deleting bills. So i am just trying to find a way. I know there is a also chance that users can select incorrect PO too. Lets see. Thanks!

Good luck!

use the filter for the custom field to minimize the mistake

ok