Is there a way to show the total vendor bill amount (net of tax) in transaction currency per PO in the Vendor Bill itself? Note: A Vendor Bill is always linked to one PO only. I've tried the applying, applied to, etc. but none of them seem to show. It's easy to show it in the PO but not on the Vendor Bill itself.

there's an amount foreign currency no tax field

Sorry, I wasn't so clear. I need to show the total amount of ALL vendor bills associated with the same PO. Ex. PO1 for 1,000 VB1 linked to PO1 for 300 VB2 linked to PO1 for 600 I need total billed amount of 900 on each vendor bill.

I would have expected what you did to work, assuming you're filtering to the PO only?

I need to start from the vendor bill back to the PO then to all linked vendor bills because I need to show it on the vendor bills. I'm stuck because of join limitations