Solved
Report for Supplier Bank Account Details
I need a report that shows my supplier bank accounts details. How do I do this? Thanks
Hi Mike_James
Thanks for that.
Regards
Lisa_H
Forum Discussion
Hi Lisa_H , the card export is the very simplest set of data. There is no other easy report,
Open the text file in Notepad, then copy all the text and paste it into an Excel file. (You get that option after the export has finished).
In addition to the selected fields you want to see, include in your export the Card Status field, which will read Y for inactive cards. Those can be filtered/deleted in Excel, leaving your active suppliers. Presumably you need to know which of those do not have bank accounts.
Also include the Record ID field, which will make it easier to import the cards back again, matching on record ID instead of company name is more accurate.
When I paste card records into Excel, I make a copy of that worksheet right away and work on the copy. If anything goes wrong I've got the original.
PS because the record ID is allocated sequentially, the largest record ID numbers are the most recent suppliers.
