Is it possible in a saved search or dataset (tried but unsuccessful) to allocate the bill payment amounts which are linked to the header of the bill to the Bill LINES (pro-rata)? Bill line amount / bill amount x bill payment amount.
As you can see below, they are in separate
rows, so I am not sure how to reference the bill payment amount in the bill line rows.