Hi everyone, Is it possible to run a report that shows which customers have been invoiced using a particular nominal code. I don't want to see all the invoices relating to the code just the customer names.
Hi everyone, Is it possible to run a report that shows which customers have been invoiced using a particular nominal code. I don't want to see all the invoices relating to the code just the customer names.
Hi Nichola,
I don't think there are any reports that won't give you the full list of invoices for nominal transactions, however you could export a nominal's activity as a CSV and then use the following formula in a blank column of the report to see a list of the customers listed only once;
=UNIQUE(D6:D62,,FALSE)
Replace D6:D62 with the column/rows that your list of customer names appears in
Hope this makes sense.
Kind regards,
Tim
Hi Nichola,
I don't think there are any reports that won't give you the full list of invoices for nominal transactions, however you could export a nominal's activity as a CSV and then use the following formula in a blank column of the report to see a list of the customers listed only once;
=UNIQUE(D6:D62,,FALSE)
Replace D6:D62 with the column/rows that your list of customer names appears in
Hope this makes sense.
Kind regards,
Tim
*Community Hub is the new name for Sage City