# OrderComments on FulFillment Workbench

**URL:** <https://www.epiusers.help/t/ordercomments-on-fulfillment-workbench/113179>\
**Category:** Epicor ERP 10\
**Tags:** customization, e10, epicor\
**Created:** [March 27, 2024, 6:11pm UTC](https://www.epiusers.help/t/ordercomments-on-fulfillment-workbench/113179 "2024-03-27T18:11:23Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![jrhodesMVP](https://www.epiusers.help/user_avatar/www.epiusers.help/jrhodesmvp/32/57965_2.png) [@jrhodesMVP](https://www.epiusers.help/u/jrhodesMVP)\
**Post date:** [March 27, 2024, 6:11pm UTC](https://www.epiusers.help/t/ordercomments-on-fulfillment-workbench/113179/1 "2024-03-27T18:11:24Z")

</div>

I am trying to add OrderComments to the Fulfillment workbench Order Fulfillment tab. We are running 10.2.500.40. I found this article [Add UD fields from other BO in grid - #15 by A.Baeisa](https://www.epiusers.help/t/add-ud-fields-from-other-bo-in-grid/53140/15) It gave me a few ideas but they do not seem to be working.

 ![image](https://www.epiusers.help/uploads/default/original/3X/1/6/1611711ae523c5f0bfbe2cbc67d649f598bf9e4c.png)  
‘’’ foreach (var ttOrderAllocList in (from row in OrderAllocRelease select row))  
{

```
  var dbOrderHeadOrderComment = (from row in Db.OrderHed
                        where row.Company == Session.CompanyID &&
                              row.OrderNum == ttOrderAllocList.OrderNum &&
                              row.OrderComment
                              select row.)FirstOrDefault();
                              
                              
  if(dbOrderHeadOrderComment != null)
  {
      ttOrderAllocList.Warehousecode = dbOrderHeadOrderComment.OrderComment;
  }
  else
  {
      ttOrderAllocList.Warehousecode = " ";
  }

```

}‘’’

Has anyone done this before that could lend some help?

---

<div class="post-metadata">

**Author:** ![dr\_dan](https://www.epiusers.help/user_avatar/www.epiusers.help/dr_dan/32/48005_2.png) [@dr\_dan](https://www.epiusers.help/u/dr_dan)\
**Post date:** [March 27, 2024, 6:27pm UTC](https://www.epiusers.help/t/ordercomments-on-fulfillment-workbench/113179/2 "2024-03-27T18:27:02Z")

</div>

> [@jrhodesMVP](#):
>
> ```auto
> var dbOrderHeadOrderComment = (from row in Db.OrderHed
> where row.Company == Session.CompanyID &&
> row.OrderNum == ttOrderAllocList.OrderNum &&
> row.OrderComment
> select row.)FirstOrDefault();
> 
> ```

I think you want…

```auto
var dbOrderHeadOrderComment = (from row in Db.OrderHed
                        where row.Company == Session.CompanyID &&
                              row.OrderNum == ttOrderAllocList.OrderNum
                              select row.OrderComment).FirstOrDefault();
```

---

<div class="post-metadata">

**Author:** ![jrhodesMVP](https://www.epiusers.help/user_avatar/www.epiusers.help/jrhodesmvp/32/57965_2.png) [@jrhodesMVP](https://www.epiusers.help/u/jrhodesMVP)\
**Post date:** [March 27, 2024, 6:33pm UTC](https://www.epiusers.help/t/ordercomments-on-fulfillment-workbench/113179/3 "2024-03-27T18:33:22Z")

</div>

![image](https://www.epiusers.help/uploads/default/original/3X/7/c/7c2545914081a57021e4d0f1ee67d69f89a00930.png)  
then i get an additional error at the bottom. I probably should have posted my errors to start with.

---

<div class="post-metadata">

**Author:** ![dr\_dan](https://www.epiusers.help/user_avatar/www.epiusers.help/dr_dan/32/48005_2.png) [@dr\_dan](https://www.epiusers.help/u/dr_dan)\
**Post date:** [March 27, 2024, 6:41pm UTC](https://www.epiusers.help/t/ordercomments-on-fulfillment-workbench/113179/4 "2024-03-27T18:41:53Z")

</div>

I think you want to swap ttOrderAllocList and OrderAllocRelease in your foreach statement. Then where you reference ttOrderAllocList inside of the foreach, swap that with OrderAllocRelease.

Then remove the .OrderComment from the end of dbOrderHeadOrderComment. Like this:

```auto
foreach (var OrderAllocRelease in (from row in ttOrderAllocList select row))
{
  var dbOrderHeadOrderComment = (from row in Db.OrderHed
                        where row.Company == Session.CompanyID &&
                              row.OrderNum == OrderAllocRelease.OrderNum
                              select row.OrderComment).FirstOrDefault();

if (dbOrderHeadOrderComment != null)
{
  OrderAllocRelease.WarehouseCode = dbOrderHeadOrderComment;
}
else
{
  OrderAllocRelease.WarehouseCode = "";
}
}
```

---

<div class="post-metadata">

**Author:** ![jrhodesMVP](https://www.epiusers.help/user_avatar/www.epiusers.help/jrhodesmvp/32/57965_2.png) [@jrhodesMVP](https://www.epiusers.help/u/jrhodesMVP)\
**Post date:** [March 27, 2024, 6:56pm UTC](https://www.epiusers.help/t/ordercomments-on-fulfillment-workbench/113179/5 "2024-03-27T18:56:51Z")

</div>

I made the changes, but i am getting this error even though i have added the assembly.

 ![image](https://www.epiusers.help/uploads/default/original/3X/c/e/cefac921655fcca76b5faec948232c2b7f3518d2.png)

---

<div class="post-metadata">

**Author:** ![dr\_dan](https://www.epiusers.help/user_avatar/www.epiusers.help/dr_dan/32/48005_2.png) [@dr\_dan](https://www.epiusers.help/u/dr_dan)\
**Post date:** [March 27, 2024, 7:04pm UTC](https://www.epiusers.help/t/ordercomments-on-fulfillment-workbench/113179/6 "2024-03-27T19:04:05Z")

</div>

I see the issue. You need to change ttOrderAllocList to OrderAllocRelease in the LINQ statement. That was my bad. I’ll correct it on that post.

---

<div class="post-metadata">

**Author:** ![jrhodesMVP](https://www.epiusers.help/user_avatar/www.epiusers.help/jrhodesmvp/32/57965_2.png) [@jrhodesMVP](https://www.epiusers.help/u/jrhodesMVP)\
**Post date:** [March 27, 2024, 7:10pm UTC](https://www.epiusers.help/t/ordercomments-on-fulfillment-workbench/113179/7 "2024-03-27T19:10:05Z")

</div>

Do i then have to create tatableset variable here?  
 ![image](https://www.epiusers.help/uploads/default/original/3X/b/5/b5a26685fd628116b4ab889e9dc9b123e593a2ef.png)

---

<div class="post-metadata">

**Author:** ![dr\_dan](https://www.epiusers.help/user_avatar/www.epiusers.help/dr_dan/32/48005_2.png) [@dr\_dan](https://www.epiusers.help/u/dr_dan)\
**Post date:** [March 27, 2024, 7:13pm UTC](https://www.epiusers.help/t/ordercomments-on-fulfillment-workbench/113179/8 "2024-03-27T19:13:54Z")

</div>

Only if you have to use that in another widget within that BPM. Otherwise, you have already instantiated the OrderAllocRelease variable within the custom code which should be an OrderAllocListTable or whatever type it is.

---

<div class="post-metadata">

**Author:** ![jrhodesMVP](https://www.epiusers.help/user_avatar/www.epiusers.help/jrhodesmvp/32/57965_2.png) [@jrhodesMVP](https://www.epiusers.help/u/jrhodesMVP)\
**Post date:** [March 27, 2024, 7:23pm UTC](https://www.epiusers.help/t/ordercomments-on-fulfillment-workbench/113179/9 "2024-03-27T19:23:56Z")

</div>

I asked that because i am still getting an error.  
 ![image](https://www.epiusers.help/uploads/default/original/3X/4/b/4b7f30ba1e94a1fe7215c6993672499ddce5a48b.png)

---

<div class="post-metadata">

**Author:** ![dr\_dan](https://www.epiusers.help/user_avatar/www.epiusers.help/dr_dan/32/48005_2.png) [@dr\_dan](https://www.epiusers.help/u/dr_dan)\
**Post date:** [March 27, 2024, 7:36pm UTC](https://www.epiusers.help/t/ordercomments-on-fulfillment-workbench/113179/10 "2024-03-27T19:36:15Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![jrhodesMVP](https://www.epiusers.help/user_avatar/www.epiusers.help/jrhodesmvp/32/57965_2.png) [@jrhodesMVP](https://www.epiusers.help/u/jrhodesMVP)\
**Post date:** [March 27, 2024, 7:48pm UTC](https://www.epiusers.help/t/ordercomments-on-fulfillment-workbench/113179/11 "2024-03-27T19:48:31Z")

</div>

I totally misread that sorry. I am testing it now and ill let you know if it works.
