# TopLevel Customer BAQ **URL:** \ **Category:** Epicor ERP 10\ **Tags:** baq-reports, epicor10\_0\ **Created:** [January 18, 2021, 2:13pm UTC](https://www.epiusers.help/t/toplevel-customer-baq/74595 "2021-01-18T14:13:17Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![Dek\_Reddy](https://www.epiusers.help/user_avatar/www.epiusers.help/dek_reddy/32/32652_2.png) [@Dek\_Reddy](https://www.epiusers.help/u/Dek_Reddy)\ **Post date:** [January 18, 2021, 2:13pm UTC](https://www.epiusers.help/t/toplevel-customer-baq/74595/1 "2021-01-18T14:13:17Z")
Hey Everyone, I am a new to this forum and also learning BAQ’s. Hope someone can help with below query 🙂 I am building a BAQ to show all Customers with AR info. We have a UD Field to identify Parent CustomerID or Child Entity Name in the same field, this makes me difficult to build a AR Rollup to show TopLevel Customers(Parent). Any suggestions please? Thank you. ---
**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\ **Post date:** [January 18, 2021, 2:34pm UTC](https://www.epiusers.help/t/toplevel-customer-baq/74595/2 "2021-01-18T14:34:41Z")
Welcome! First off, using that one field to identify either the Child or the Parent, was a mistake. But that’s what you’ve got to work with. Is there any other logic behind the value of that UD field? Any other way to tell who the parent is? What if Cust A’s UD value is `B`, and Cust B’s UD value is `A`? How to which is which. And any BAQ that would try to determine the parent/child relationship might get stuck on that circular reference. If the UD field was well defined (say it always holds the CustID of the Parent), then you BAQ would have the Customer table in it twice (the second instance would be automatically named `Customer1`), with the relationships: - Customer.Company = Customer1.Company - Customer.CustID = Customer1.UDfield - Make the relationship join type: “All rows from Customer” That would give all the customers, and when no Child exists for a customer, the Customer1 fields would be blank. You would also get several rows for the parent customer, one for each Child customer. Like: ```nohighlight Cust_CustID Cust1_CustID Cust1_UDfield ABCDEF QWERTY QWERTY ABCDEF QWERTY ZYXWVUT STOPQRT ZYXWVUT QWERTY ``` Cust’s ABC… and ZYX… have QWERTY in their UD field. ---
**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\ **Post date:** [January 18, 2021, 2:50pm UTC](https://www.epiusers.help/t/toplevel-customer-baq/74595/3 "2021-01-18T14:50:56Z")
BTW - You know there is a built system for specifying the parent of a customer? ---
**Author:** ![Dek\_Reddy](https://www.epiusers.help/user_avatar/www.epiusers.help/dek_reddy/32/32652_2.png) [@Dek\_Reddy](https://www.epiusers.help/u/Dek_Reddy)\ **Post date:** [January 18, 2021, 3:01pm UTC](https://www.epiusers.help/t/toplevel-customer-baq/74595/4 "2021-01-18T15:01:44Z")
Thanks Calvin. There is no other logic for that UD field except holding Parent Customer ID or Child Entity name. For example: If Customer ‘A’ has Multiple child entities: Parent UD Field contains CustID always starting with ABC01, Child UD filed contains Customer Name XYZ and they have a relationship P-C defined in National Account. If Customer ‘B’ has no Entities: Customer is created with CustID ABC02. ---
**Author:** ![Dek\_Reddy](https://www.epiusers.help/user_avatar/www.epiusers.help/dek_reddy/32/32652_2.png) [@Dek\_Reddy](https://www.epiusers.help/u/Dek_Reddy)\ **Post date:** [January 18, 2021, 3:04pm UTC](https://www.epiusers.help/t/toplevel-customer-baq/74595/5 "2021-01-18T15:04:14Z")
No, I am completely new to Epicor. I believe there should be toggle within the Epicor to identify parent same as other systems. Would you have more information on this? Thank you ---
**Author:** ![jkane](https://www.epiusers.help/user_avatar/www.epiusers.help/jkane/32/57624_2.png) [@jkane](https://www.epiusers.help/u/jkane)\ **Post date:** [January 18, 2021, 3:23pm UTC](https://www.epiusers.help/t/toplevel-customer-baq/74595/6 "2021-01-18T15:23:45Z")
@Dek_Reddy the functionality @ckrusen is referencing is called National Account. I would search for that in Epicor’s documentation to learn more. ---
**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\ **Post date:** [January 18, 2021, 3:29pm UTC](https://www.epiusers.help/t/toplevel-customer-baq/74595/7 "2021-01-18T15:29:11Z")
I’ve not used the National Account functionality. It appears to be primarily for billing (since it is under the Billing tab in Customer Maintenance). So using that might cause you more problems, as I assume your using the UD field just for reporting. ---
**Author:** ![Dek\_Reddy](https://www.epiusers.help/user_avatar/www.epiusers.help/dek_reddy/32/32652_2.png) [@Dek\_Reddy](https://www.epiusers.help/u/Dek_Reddy)\ **Post date:** [January 18, 2021, 3:55pm UTC](https://www.epiusers.help/t/toplevel-customer-baq/74595/8 "2021-01-18T15:55:40Z")
Thanks @jkane, We use National Account primarily for billing. I will read more about it if there is an option. @ckrusen, Reporting and UD field ID is the same CustID used in other systems to identify customer. May I know which system built you were talking about to previously? Thank you ---
**Author:** ![jkane](https://www.epiusers.help/user_avatar/www.epiusers.help/jkane/32/57624_2.png) [@jkane](https://www.epiusers.help/u/jkane)\ **Post date:** [January 18, 2021, 4:08pm UTC](https://www.epiusers.help/t/toplevel-customer-baq/74595/9 "2021-01-18T16:08:46Z")
@Dek_Reddy yes, you can use National Account for Billing but it can also be used for reporting. I have used it in an old position for reporting only and it worked well. ---
**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\ **Post date:** [January 18, 2021, 4:11pm UTC](https://www.epiusers.help/t/toplevel-customer-baq/74595/10 "2021-01-18T16:11:35Z")
When I mentioned “Parent/Child” it was from seeing it mentioned in the online help: ![image](https://www.epiusers.help/uploads/default/original/3X/b/e/be86d14113c46cf0a675eab15128f09365d0b91a.png) I’m guessing that’s actually the National Accounts functionality. ---
**Author:** ![Vinaykamboj](https://www.epiusers.help/user_avatar/www.epiusers.help/vinaykamboj/32/14848_2.png) [@Vinaykamboj](https://www.epiusers.help/u/Vinaykamboj)\ **Post date:** [January 18, 2021, 4:10pm UTC](https://www.epiusers.help/t/toplevel-customer-baq/74595/11 "2021-01-18T16:10:08Z")
We have been using National Account functionality. This is a good way to identify parent and child customers. You can have tiered or non tiered relationships. This allows for credit sharing, reporting and payer billto relationships. You should read the help. It is a standard functionality in Epicor and is very useful. Using it does not have any other effect on using Epicor. Once you have these defined you can use the various Rls\* tables to look for the information you want. Vinay Kamboj ---
**Author:** ![Dek\_Reddy](https://www.epiusers.help/user_avatar/www.epiusers.help/dek_reddy/32/32652_2.png) [@Dek\_Reddy](https://www.epiusers.help/u/Dek_Reddy)\ **Post date:** [January 18, 2021, 4:45pm UTC](https://www.epiusers.help/t/toplevel-customer-baq/74595/12 "2021-01-18T16:45:14Z")
Thank you, it does make sense to report from National Account as I am looking for AR info rolledup to Parent customer. We have defined Relationship for top level customer (P-C/P-C GC) I think this link will help to build report. I am going to start heavy reading on this topic, please share if you have report examples of these kind. Unfortunately the Help function has been disabled in our Epicor 😕 I have started looking into Rls tables to get some info.