# Calculated Field (Shipping Instructions) on PO Form

**URL:** <https://www.epiusers.help/t/calculated-field-shipping-instructions-on-po-form/72739>\
**Category:** Epicor ERP 10\
**Tags:** e10, ssrs\
**Created:** [November 12, 2020, 5:28pm UTC](https://www.epiusers.help/t/calculated-field-shipping-instructions-on-po-form/72739 "2020-11-12T17:28:56Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![BKen](https://www.epiusers.help/letter_avatar_proxy/v4/letter/b/76d3ee/32.png) [@BKen](https://www.epiusers.help/u/BKen)\
**Post date:** [November 12, 2020, 5:28pm UTC](https://www.epiusers.help/t/calculated-field-shipping-instructions-on-po-form/72739/1 "2020-11-12T17:28:56Z")

</div>

On the standard SSRS PO Form, the ship to box shows a {see below} if either of the following calculated fields is true: Calc\_MultiShiptoAddress or Calc\_ExistingDropShipReleases.

Then a subreport prints Calc\_ShipToConName and PORel\_Cal\_ShipToAddrList.

How do I get the phone number (or cell phone number if phone number is null) for the Calc\_ShipToConName to also print? It seems like all shipments now require a phone number, so it would be beneficial to pull that number in along with the contact name.

---

<div class="post-metadata">

**Author:** ![Jason\_Woods](https://www.epiusers.help/user_avatar/www.epiusers.help/jason_woods/32/80101_2.png) [@Jason\_Woods](https://www.epiusers.help/u/Jason_Woods)\
**Post date:** [November 12, 2020, 5:40pm UTC](https://www.epiusers.help/t/calculated-field-shipping-instructions-on-po-form/72739/2 "2020-11-12T17:40:33Z")

</div>

You will have to manually link the tables. The Calculated fields will not help.

---

<div class="post-metadata">

**Author:** ![BKen](https://www.epiusers.help/letter_avatar_proxy/v4/letter/b/76d3ee/32.png) [@BKen](https://www.epiusers.help/u/BKen)\
**Post date:** [November 12, 2020, 6:01pm UTC](https://www.epiusers.help/t/calculated-field-shipping-instructions-on-po-form/72739/3 "2020-11-12T18:01:11Z")

</div>

I assume the calculated fields are using formals to find similar fields in multiple tables. So which table do you bring in?

---

<div class="post-metadata">

**Author:** ![Jason\_Woods](https://www.epiusers.help/user_avatar/www.epiusers.help/jason_woods/32/80101_2.png) [@Jason\_Woods](https://www.epiusers.help/u/Jason_Woods)\
**Post date:** [November 12, 2020, 6:26pm UTC](https://www.epiusers.help/t/calculated-field-shipping-instructions-on-po-form/72739/4 "2020-11-12T18:26:22Z")

</div>

Take a look at field help for the fields you wish to show on a BAQ/Report. In this case it is VendCnt.PhoneNum. The link is done by POHeader.PrcConNum.

---

<div class="post-metadata">

**Author:** ![BKen](https://www.epiusers.help/letter_avatar_proxy/v4/letter/b/76d3ee/32.png) [@BKen](https://www.epiusers.help/u/BKen)\
**Post date:** [November 12, 2020, 6:43pm UTC](https://www.epiusers.help/t/calculated-field-shipping-instructions-on-po-form/72739/5 "2020-11-12T18:43:42Z")

</div>

I am not looking for the Vendor Contact, I am looking for our customer contact phone (and/or cell phone) for Drop Ship POs (or Contacts for the Multiple Shipments for POs).

---

<div class="post-metadata">

**Author:** ![Jason\_Woods](https://www.epiusers.help/user_avatar/www.epiusers.help/jason_woods/32/80101_2.png) [@Jason\_Woods](https://www.epiusers.help/u/Jason_Woods)\
**Post date:** [November 12, 2020, 6:46pm UTC](https://www.epiusers.help/t/calculated-field-shipping-instructions-on-po-form/72739/6 "2020-11-12T18:46:46Z")

</div>

So link PODetail.OrderNum to OrderHed.OrderNum & OrderHed.CustNum to Customer.CustNum (with the Company field also).

---

<div class="post-metadata">

**Author:** ![BKen](https://www.epiusers.help/letter_avatar_proxy/v4/letter/b/76d3ee/32.png) [@BKen](https://www.epiusers.help/u/BKen)\
**Post date:** [November 12, 2020, 7:26pm UTC](https://www.epiusers.help/t/calculated-field-shipping-instructions-on-po-form/72739/7 "2020-11-12T19:26:02Z")

</div>

I actually already linked those tables.

 ![image](https://www.epiusers.help/uploads/default/original/3X/9/4/942a7cf4e6b39bd7548a1e8bbbe12923c4b7ddf2.png)

So how do I know if the information is on the Release Destination, Release One Time Ship To, the Header One Time Ship To, or the header Ship To?

---

<div class="post-metadata">

**Author:** ![Jason\_Woods](https://www.epiusers.help/user_avatar/www.epiusers.help/jason_woods/32/80101_2.png) [@Jason\_Woods](https://www.epiusers.help/u/Jason_Woods)\
**Post date:** [November 12, 2020, 10:37pm UTC](https://www.epiusers.help/t/calculated-field-shipping-instructions-on-po-form/72739/8 "2020-11-12T22:37:48Z")

</div>

That may prove more complicated.  
I would offer that a BPM looks this information up and stores it at the PO Release level on a UD field. Having a Report do this work can be a huge headache.