Hi,
For multiple reasons I want to check if a invoice is sent or not in quickbooks. Since I can’t seem to check all the active invoices, I decided to paste the invoice numbers into a excel sheet. Now everytime the automation starts I want to loop that excel and get the last row of the sheet and see if that invoice is sent in quickbooks or not. If sent create a new invoice number with an increment of 1. If not sent add this item to the invoice. Anyone can help me out on here. I can’t get the hang to loop the excel sheet.