Hi all, I am trying to show supplier balance on PO before the PO is saved. I used custom field, but it only pulls through the balance of the main Subsidiary. If I change Subsidiary, the value does not change to reflect the supplier balance on the selected subsidiary. I used a workflow, but the results are the same. Any ideas on how to achieve this?

Try custom field with saved search and check out store value

Yup, I've done it, but the balance defaults to the Subsidiary (Main)