# Routing Report

**URL:** <https://www.epiusers.help/t/routing-report/81175>\
**Category:** Epicor ERP 10\
**Tags:** e10\
**Created:** [August 3, 2021, 2:26am UTC](https://www.epiusers.help/t/routing-report/81175 "2021-08-03T02:26:38Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![jasonath2h](https://www.epiusers.help/letter_avatar_proxy/v4/letter/j/e0b2c6/32.png) [@jasonath2h](https://www.epiusers.help/u/jasonath2h)\
**Post date:** [August 3, 2021, 2:26am UTC](https://www.epiusers.help/t/routing-report/81175/1 "2021-08-03T02:26:38Z")

</div>

I have a SSRS Breaking & Routing for my PO report.

We attach JobMat drawings, Company T&C and Vendor Quote on Email. (Using DocStar & Routing).

Client wants a compliance form added to PO email for certain suppliers.

I created new Document Type linked to supplier. Attach form to Supplier.

In Routing I tried to setup a Take DocStar Attach. Set is:

- For every record in the report table PO Header
- Attachment Table: Vendor and Vendor Form Document Type
- Using Key Field
- designed value needs VenNum. Insert a field from the PO Header Table. This issue is that the PO Header in this list doesn’t contain the VenNum. It contains the VendorID.

Does anyone have a suggestion how I can get the VenNum in this list? (It is actual stored in the DB!)

---

<div class="post-metadata">

**Author:** ![bderuvo](https://www.epiusers.help/user_avatar/www.epiusers.help/bderuvo/32/55706_2.png) [@bderuvo](https://www.epiusers.help/u/bderuvo)\
**Post date:** [August 3, 2021, 1:57pm UTC](https://www.epiusers.help/t/routing-report/81175/2 "2021-08-03T13:57:46Z")

</div>

Can you add the field in the Report Data Definition?

---

<div class="post-metadata">

**Author:** ![jstephens](https://www.epiusers.help/letter_avatar_proxy/v4/letter/j/f05b48/32.png) [@jstephens](https://www.epiusers.help/u/jstephens)\
**Post date:** [August 3, 2021, 2:31pm UTC](https://www.epiusers.help/t/routing-report/81175/3 "2021-08-03T14:31:42Z")

</div>

The POHeader data source in the report data definition contains the VendorNum field by default. It’s probably just excluded. Go into the RDD to verify and clear the exclusion if present.

---

<div class="post-metadata">

**Author:** ![jasonath2h](https://www.epiusers.help/letter_avatar_proxy/v4/letter/j/e0b2c6/32.png) [@jasonath2h](https://www.epiusers.help/u/jasonath2h)\
**Post date:** [August 25, 2021, 12:16am UTC](https://www.epiusers.help/t/routing-report/81175/4 "2021-08-25T00:16:07Z")

</div>

Thanks @bderuvo and @jstephens . Both spot on - not sure why I didn’t think that one through. All the best.