# EORI numbers on forms

**URL:** <https://www.epiusers.help/t/eori-numbers-on-forms/74632>\
**Category:** Epicor ERP 10\
**Tags:** customization, e10\
**Created:** [January 19, 2021, 10:15am UTC](https://www.epiusers.help/t/eori-numbers-on-forms/74632 "2021-01-19T10:15:35Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Adrian\_Mepham](https://www.epiusers.help/user_avatar/www.epiusers.help/adrian_mepham/32/6960_2.png) [@Adrian\_Mepham](https://www.epiusers.help/u/Adrian_Mepham)\
**Post date:** [January 19, 2021, 10:15am UTC](https://www.epiusers.help/t/eori-numbers-on-forms/74632/1 "2021-01-19T10:15:35Z")

</div>

Hi everyone,  
I want to put ours and our customer’s EORI numbers on the QuoteHead. What is the best practice for doing this? I have added the respective text boxes but there is not binding to the Company Config or Customer table available. Should I create a BPM to do it or is it a Customization. I feel it is a customization and the code is probably simple, but I don’t know it.  
Thanks for your help

---

<div class="post-metadata">

**Author:** ![aarong](https://www.epiusers.help/user_avatar/www.epiusers.help/aarong/32/101218_2.png) [@aarong](https://www.epiusers.help/u/aarong)\
**Post date:** [January 19, 2021, 11:28am UTC](https://www.epiusers.help/t/eori-numbers-on-forms/74632/2 "2021-01-19T11:28:43Z")

</div>

I would use a BAQ dataView to preform this.

---

<div class="post-metadata">

**Author:** ![aarong](https://www.epiusers.help/user_avatar/www.epiusers.help/aarong/32/101218_2.png) [@aarong](https://www.epiusers.help/u/aarong)\
**Post date:** [January 19, 2021, 11:31am UTC](https://www.epiusers.help/t/eori-numbers-on-forms/74632/3 "2021-01-19T11:31:49Z")

</div>

```plaintext
	{
        supplierSourceBAQDV = new BAQDataView("TEAGLE-CustomerSupplier");
        oTrans.Add("SupplierSourceBAQDV", supplierSourceBAQDV);
        string pub1Binding = "OrderHed.CustNum";
        IPublisher pub1 = oTrans.GetPublisher(pub1Binding);
        if (pub1 == null)
        {
            string pubName = Guid.NewGuid().ToString();
            oTrans.PublishColumnChange(pub1Binding, pubName);
            pub1 = oTrans.GetPublisher(pub1Binding);
        }
        if (pub1 != null)
            supplierSourceBAQDV.SubscribeToPublisher(pub1.PublishName, "Customer_CustNum");
	}

```

The fields may not match your needs you may need to change that, create a BAQ with the two columns you want to display and go from there. Very simple.

Also check out @Carson his videos explains it. [Epicor BAQ DataView - YouTube](https://www.youtube.com/watch?v=7xBrqwpg4_k)

---

<div class="post-metadata">

**Author:** ![Adrian\_Mepham](https://www.epiusers.help/user_avatar/www.epiusers.help/adrian_mepham/32/6960_2.png) [@Adrian\_Mepham](https://www.epiusers.help/u/Adrian_Mepham)\
**Post date:** [January 19, 2021, 12:08pm UTC](https://www.epiusers.help/t/eori-numbers-on-forms/74632/4 "2021-01-19T12:08:41Z")

</div>

Thanks for this Aaron, I had a feeling it would be something along these lines. If I use a BAQ dataView, will I still need to add a UD column to the table? I’m just thinking about the printing side of things as we will want to print these numbers on our customer docs.  
Thankyou

---

<div class="post-metadata">

**Author:** ![aarong](https://www.epiusers.help/user_avatar/www.epiusers.help/aarong/32/101218_2.png) [@aarong](https://www.epiusers.help/u/aarong)\
**Post date:** [January 19, 2021, 12:14pm UTC](https://www.epiusers.help/t/eori-numbers-on-forms/74632/5 "2021-01-19T12:14:42Z")

</div>

As long as the UD column is present in the table you want to query? i.e Customer\_UD with Dealership\_c you would need to include Customer in your BAQ with that field displayed.

My BAQ is

- Customer\_CustNum- Subscribing Field (BAQ Field)
- Order.CustNum (OrderHed Field)

CustNum in Customer will bind to the OrderHed.CustNum pulling the information across.

You can then see your BAQdataView in the Binding section of customisation.

I hope this helps.

Kind regards,  
Aaron.

---

<div class="post-metadata">

**Author:** ![aarong](https://www.epiusers.help/user_avatar/www.epiusers.help/aarong/32/101218_2.png) [@aarong](https://www.epiusers.help/u/aarong)\
**Post date:** [January 19, 2021, 12:17pm UTC](https://www.epiusers.help/t/eori-numbers-on-forms/74632/6 "2021-01-19T12:17:43Z")

</div>

In SSRS can use linked and description tables to join tables together.

Once you’ve got this just add the fields to your RDD and update the SSRS with the query fields matching the RDD i.e

RDD  
OrderHed \> Linked Column (OrderNum) with Description fields (OrderHed.FOB) add it to your RDD Query with T2.OrderNum.FOB might be T3,T1 you will need to check.

Once you’ve done this, just add the field in the fields section of the report (make sure it’s a Query Field) with matching RDD (OrderNum.FOB) and the information will display.