I tried searching the forum but didn’t quite the answers I’m searching for.
Most of my customers belong to a franchise and their HQ wants a monthly statement of all their branches.
I have used the customer codes to group them by franchise. example:
OVK, BKB, GWK
the individual customers is named like this.
BKB Gauteng etc etc
What I need is to create a customer statement grouped by code so that all the OVK customers statements is on it and I can send it to OVK headquaters.
Is there a way for me to do it by creating a custom report or special accounts or control accounts?
I would appreciate any help and advice