Report Script: Create a Packing List in report script: Difference between revisions
Report Script: Create a Packing List in report script (view source)
Revision as of 07:43, 14 April 2020
, 4 years ago→Introduction
| (2 intermediate revisions by one other user not shown) | |||
Line 1:
==Introduction==
This tutorial shows how to add a text which displays packing that is based on largest UOM to smallest UOM with report scripting.<br/>
Does not take into consideration of multi-location, area and customer.
==Tasks in this tutorial==
Line 50:
#*'''using System.Data;'''
#*'''using System.Linq;'''
===Insert scripts into '''calcPacking_GetValue'''===
<syntaxhighlight lang="csharp">
Line 60 ⟶ 61:
return;
//Calculate the quantity of smallest UOM that has the same "ItemCode" and "UOMRate"
//It is based on the design of this report that uses "Group Header" to group "ItemCode" and "UOMRate"
decimal smallestQty = GetSmallestQty(GetCurrentColumnValue("ItemCode"), GetCurrentColumnValue("UOMRate"));
Line 88 ⟶ 90:
}
</syntaxhighlight>
#Add function of '''GetSmallestQty'''
#Add function of '''GetUOMFromItem'''
Line 130 ⟶ 133:
</syntaxhighlight>
<br/>
===Add label to display "Packing"===
#Add a new Label into existing Group Header
| |||