David, I'm not sure how you would do that. Customers are just a flat database, a list; there is no Customer Hierarchy.
-derek On Fri, August 6, 2021 3:34 pm, David H wrote: > Samantha, > > Like David Carlson I'm not a business features user so I'm only guessing > here but can you setup your customers or Sales in a heirarchy - i.e > Customers, Customers UK, Customers Local, Customers Non UK OR Sales, Sales > UK, Sales Local, Sales Non UK and report on them that way ? > > Cheers David H. > > On Sat, 7 Aug 2021 at 03:36, Samantha Payn > <saman...@boorertranslations.com> > wrote: > >> Sorry, I replied to Derek only and I meant to include the list. >> >> Here is my response to Derek's question. >> >> ---------- Original Message ---------- >> >> From: Samantha Payn <saman...@boorertranslations.com> >> >> To: Derek Atkins <de...@ihtfp.com> >> >> Date: 06/08/2021 16:26 >> >> Subject: Re: [GNC] Creating a customer report by location >> >> I am a freelance translator in the UK with clients all over the >> world. In applying for advice and grants from a local >> government-run >> business support agency they want to know the proportion of my >> sales >> to local (county) customers, to the wider UK and as “exports”. >> >> Location by country for me would be sufficient (I don’t yet have any >> clients in my actual locality). >> >> In fact, for my purposes, a custom text field with A, B, C, D or E >> would be sufficient. >> >> I hope this helps and would love it if someone could come up with >> something. >> >> Many thanks for any pointers >> >> Samantha >> >> On 6 Aug 2021, at 15:25, Derek Atkins <de...@ihtfp.com> wrote: >> >> Hi Samantha, >> As far as I know, there is no report like that. Indeed, I can't even >> think of a way that you could collate customers by location within >> GnuCash. Are you thinking by State? By Zip Code? By some other >> means? >> Once you figure that out, then one could write a routine that sorted >> and >> collated based on that. But to my knowledge, no such thing exists. >> I'm curious what your actual use-case is here? >> -derek >> On Fri, August 6, 2021 9:11 am, David Carlson wrote: >> >> No, not unnoticed, but I do not use business features, so I waited >> to see >> >> if a business user would step up. >> >> GnuCash has no geographical data feature to use for such a report. >> You >> >> would have to somehow manually add appropriate information in a >> text >> >> field, >> >> but reports generally only have rudimentary sorting on text >> fields, >> so >> >> maybe at best you could come up with a manually implemented zip >> code >> >> scheme. >> >> Short answer, no. >> >> On Fri, Aug 6, 2021 at 7:43 AM Samantha Payn < >> >> saman...@boorertranslations.com> wrote: >> >> Is this not possible, or has this request slipped through >> unnoticed? >> >> Cheers >> >> On 05/08/2021 14:26 Samantha Payn >> >> <[1]saman...@boorertranslations.com> >> >> wrote: >> >> Can anyone tell me how to set up a report on income by customer >> >> location, please? >> >> Many thanks >> >> Samantha Payn >> >> _______________________________________________ >> >> gnucash-user mailing list >> >> [2]gnucash-user@gnucash.org >> >> To update your subscription preferences or to unsubscribe: >> >> [3]https://lists.gnucash.org/mailman/listinfo/gnucash-user >> >> If you are using Nabble or Gmane, please see >> >> [4]https://wiki.gnucash.org/wiki/Mailing_Lists for more >> information. >> >> ----- >> >> Please remember to CC this list on all your replies. >> >> You can do this by using Reply-To-List or Reply-All. >> >> References >> >> 1. mailto:saman...@boorertranslations.com >> >> 2. mailto:gnucash-user@gnucash.org >> >> 3. https://lists.gnucash.org/mailman/listinfo/gnucash-user >> >> 4. https://wiki.gnucash.org/wiki/Mailing_Lists >> >> _______________________________________________ >> >> gnucash-user mailing list >> >> gnucash-user@gnucash.org >> >> To update your subscription preferences or to unsubscribe: >> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> >> If you are using Nabble or Gmane, please see >> >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> >> ----- >> >> Please remember to CC this list on all your replies. >> >> You can do this by using Reply-To-List or Reply-All. >> >> -- >> >> David Carlson >> >> _______________________________________________ >> >> gnucash-user mailing list >> >> gnucash-user@gnucash.org >> >> To update your subscription preferences or to unsubscribe: >> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> >> If you are using Nabble or Gmane, please see >> >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> >> ----- >> >> Please remember to CC this list on all your replies. >> >> You can do this by using Reply-To-List or Reply-All. >> >> -- >> Derek Atkins 617-623-3745 >> de...@ihtfp.com www.ihtfp.com >> Computer and Internet Security Consultant >> _______________________________________________ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> ----- >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. >> > _______________________________________________ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > ----- > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
