I'm needing to create a script/program that works on a Quick-books report exported to an excel document. i need the customer names for one of the functions, which wouldn't be a problem if they were all in the first field. the person keeping record put cash transactions in as "CASH CUSTOMER" on the first line in the "bill to" field, with the client's name in the second or sometimes the third line of that field. when creating the report excel sheet, Quick-books only grabs the first line...
...Is there any way to have lines other than the first thrown into the report as well?
...If Quick-books just does not support that feature, where can i find the raw data in my file-system so i can just grab it from there without doing repetitive actions in the UI?
Any help is appreciated. if i can just get those extra lines containing the customer names, i will be saved from going through thousands of invoices by hand.
Think of that as a Mailing Label. You want Names, which you stated are in line 2 or 3. You would select for display Name Street 1 (line 2) and Name Street 2 (line 3). Export this report to Excel, to use it to manipulate in Excel and for linking in Excel.