x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 1 reply
  • Subscribers 29 subscribers
  • Views 360 views
  • Users 0 members are here
Browse Forums
Announcements
71
topics
0
replies
Making Tax Digital
37
topics
47
replies
Sage Accounting General Discussion
1k
topics
1k
replies
Sage Accounting Start General Discussion
165
topics
274
replies
Sage Individual General Discussion
18
topics
33
replies
Nichola Brown

Identifying customers by nominal code

Posted By

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.

Parents
  • 0

    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

Reply
  • 0

    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

Children
No Data

*Community Hub is the new name for Sage City