Special Lookup

Hi!
I have a report that I need to show the date the bill was paid on the same line. (QB wont spit out the report like this of course!)
Currently, the report shows the bill payment on one line, and underneath the various invoices that were paid.  
My report has about 10,000 lines so manual processing is not an option. Also each payment can have from 1 to 100 bill lines.

I have attached a snippet of the report, basically I am trying to get the payment date highlighted in yellow in column D of the ‘Bill Pmt -Cheque’ line.  to appear in column L against all ‘Bill’ lines.

 

How do I send a snippet of my spreadsheet?

 
Is the possible??? =)
Bec
 

By: Rebecca Sciberras

Leave a Reply

Your email address will not be published. Required fields are marked *