# Label Report and Flowfields

**URL:** <https://www.dynamicsuser.net/t/label-report-and-flowfields/9817>\
**Category:** Developers Forum\
**Created:** [March 22, 2005, 3:17pm UTC](https://www.dynamicsuser.net/t/label-report-and-flowfields/9817 "2005-03-22T15:17:09Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sandy](https://avatars.discourse-cdn.com/v4/letter/s/2bfe46/32.png) [@Sandy](https://www.dynamicsuser.net/u/Sandy)\
**Post date:** [March 22, 2005, 3:17pm UTC](https://www.dynamicsuser.net/t/label-report-and-flowfields/9817/1 "2005-03-22T15:17:09Z")

</div>

I am trying to modify the standard Navision Item Label report to give the details from the Stockkeeping units table instead of the Item Table. I have everything work perfect except for the description. As it seems the Description fields on the Stockkeeping unit table are flowfields. I need to pull the details from the Item table relating to each Item No. as it process the through the Stockkeeping unit table. I have set Item as Global variable relating to the Item table and changed up this code in the OnAfterGetRecord part of the Stockkeeping Unit. ItemDescription[ColumnNo] := Item.Description + Item.“Description 2”; I know that I need to use the GET function somewhere but I am not exactly sure what and where. I know it’s going to be something simple… help!?! Thanks.

---

<div class="post-metadata">

**Author:** ![FormerMember](https://avatars.discourse-cdn.com/v4/letter/f/74df32/32.png) [@FormerMember](https://www.dynamicsuser.net/u/FormerMember)\
**Post date:** [March 22, 2005, 3:26pm UTC](https://www.dynamicsuser.net/t/label-report-and-flowfields/9817/2 "2005-03-22T15:26:13Z")

</div>

You either put the Item.GET(“Item No.”) in the OnAfterGetRecord Trigger for the SKU Table. Another Option is to put CALCFIELDS(Description,“Description 2”) in the OnAfterGetRecord Trigger and use ItemDescription[ColumnNo] := Description + “Description 2”;

---

<div class="post-metadata">

**Author:** ![MikeB2168](https://avatars.discourse-cdn.com/v4/letter/m/aca169/32.png) [@MikeB2168](https://www.dynamicsuser.net/u/MikeB2168)\
**Post date:** [March 22, 2005, 3:48pm UTC](https://www.dynamicsuser.net/t/label-report-and-flowfields/9817/3 "2005-03-22T15:48:10Z")

</div>

Hi Sandy, As mentioned by CrisK, using the Calcfields function on after get record is probably the best & simplest solution.

---

<div class="post-metadata">

**Author:** ![Sandy](https://avatars.discourse-cdn.com/v4/letter/s/2bfe46/32.png) [@Sandy](https://www.dynamicsuser.net/u/Sandy)\
**Post date:** [March 22, 2005, 4:53pm UTC](https://www.dynamicsuser.net/t/label-report-and-flowfields/9817/4 "2005-03-22T16:53:49Z")

</div>

Works like a charm!