i am missing something while creating a saved search. requirement is simple enough, i need to pull up all bills with paid amount details.

the paid amount reflects only on the main line (as its not an item/line level field).
so i just want to replicate the paid amount value in main line in other lines too, this will help me on exporting the csv with paid amounts.

example :

bill a - (main line) - amount - paid amount
bill a - (line item1) - line amount - Paid amount (same as main line)
bill a - (line item2) - line amount - Paid amount (same as main line)