2,743
edits
Report Script: Simple Calculate Commission by Item UDF Rate: Difference between revisions
Report Script: Simple Calculate Commission by Item UDF Rate (view source)
Revision as of 07:45, 15 August 2018
, 5 years ago→Add Calculated Field
(Created page with "==Under Construction== ==Introduction== This tutorial shows how to apply report scripting to calculate commission that is based on item rate commission rate entitlement.<br/>...") |
|||
| (4 intermediate revisions by the same user not shown) | |||
Line 1:
==Introduction==
This tutorial
{{Note|This example can also be done with '''Expression''' in Calculated Field without scripting.}}
==Tasks in this tutorial
*Add User Defined Field (UDF)
*Add Calculate Field in Report
*Calculate commission of each item
*Report Design -
*Report Design - Add
==Product==
AutoCount Accounting 2.0<br/>
Applicable to AutoCount Accounting 1.8 / 1.9 (require to manual modify some code)
{{SourceDownload|link=https://drive.google.com/open?id=
▲{{SourceDownload|link=https://drive.google.com/open?id=11uJzctlWBNC6YQ1Z8rdWgNPgAxZ4N_ZO|remark=(AutoCount Accounting 2.0)|Download Report Template|Packing in Delivery Detail Listing.}}
▲[[File:Prog PickList.PackUOM.png|link=]]<br />
==Tutorial==
===Add UDF===
Create below udf in the table
{| class="wikitable"
|-
Line 32 ⟶ 29:
===Open Report Designer and Load Report Template===
#On '''Main Menu''', go to Sales > Invoice
#Click [Print Listing]
#Select option '''Print Invoice Detail Listing'''
#:Click [OK]
#Select a range of '''Document Date:''' in '''Basic Filter'''
#On '''Main Menu''' of Sales Invoice,▼
#Change '''Group By:''' to "Agent" in '''Report Options'''.
#Click [Inquiry]
#:go to Report > Design Detail Listing Report
#Select
===
#While the report design is at '''Designer''' layout form
#*Right click '''1 Main Data: Invoice Master''' in '''Field List'''
#*Click '''Add Calculated Field'''
#Rename newly added Calculated Field, and set property
#*Select the newly added Calculated Field in '''Field List'''
#*In '''Property Grid''', change the '''(Name)''' to "calcTotalComm"
#*In '''Property Grid''', change the '''Field Type''' to '''Decimal'''
===Add Script Event===
#While "calcTotalComm" is selected
#*Click [+] beside Scripts in '''Property Grid'''
#*:Under Scripts, find '''"Get a Value"''' event name
#Click the empty box next to "Get a Value"
#*Click the down arrow button, and select "'''(New)'''"
#*:The window will now focus at '''Scripts''' editor
#*:An event of '''calcTotalComm_GetValue''' is created.
===Insert script into the event of calcTotalComm_GetValue===
====for version 2.0====
<syntaxhighlight lang="csharp">
private void calcTotalComm_GetValue(object sender, DevExpress.XtraReports.UI.GetValueEventArgs e)
{
//Get the subtotal of item that exclude Tax Amount
decimal subTotal = AutoCount.Converter.ToDecimal(GetCurrentColumnValue("SubTotalExTax"));
//Get the UDF_COMMRATE that is maintained in Item Maintenance
decimal rate = AutoCount.Converter.ToDecimal(GetCurrentColumnValue("ItemUDF_COMMRATE"));
//Calculate commission
e.Value = subTotal * rate / 100;
}
</syntaxhighlight>
====for version 1.8 / 1.9====
<syntaxhighlight lang="csharp">
private void calcTotalComm_GetValue(object sender, DevExpress.XtraReports.UI.GetValueEventArgs e)
{
//Get the subtotal of item that exclude Tax Amount
decimal subTotal = BCE.Data.Convert.ToDecimal(GetCurrentColumnValue("SubTotalExTax"));
//Get the UDF_COMMRATE that is maintained in Item Maintenance
decimal rate = BCE.Data.Convert.ToDecimal(GetCurrentColumnValue("ItemUDF_COMMRATE"));
//Calculate commission
e.Value = subTotal * rate / 100;
}
</syntaxhighlight>
===DataBinding of '''calcTotalComm''' to a label===
#Rename label at header
#*Rename "Debtor" to "Comm"
#*Rename "Code" to "Rate"
#*Rename "Description" to "Commission"
#Data Binding from '''Field List''' to label in '''DetailBand1'''
#*Drag "'''_UDF:COMMRATE (Item)'''" to label which original show "Debtor Account"
#*Drag "'''calcTotalComm'''" to label which original show "Debtor Company Name"
===Add Group Total of calcTotalComm===
#Right click the label of '''calcTotalComm''' in '''DetailBand1''' and Copy
#Right click on "'''GroupFooter2'''" band and Paste
#*Align the position of label in "GroupFooter2",<br/>so that it is aligned to "calcTotalComm" in '''DetailBand1'''
#While this new label in "GroupFooter2" is selected
#In '''Property Grid''', find '''Summary''', and click [+] to expand
#*Change '''Running''' to "Group"
#*Update '''Function''' to "Sum"
#*Change '''Ignore Null Value''' to "Yes"
===Add Grand Total of calcTotalComm===
#Right click the label of '''calcTotalComm''' group total in '''GroupFooter2''' and Copy
#Right click on "'''SummaryBand1'''" band and Paste
#*Align the position of label in "SummaryBand1",<br/>so that it is aligned to "calcTotalComm" in '''DetailBand1''' and '''GroupFooter2'''
#While this new label in "SummaryBand1" is selected
#In '''Property Grid''', find '''Summary''', and click [+] to expand
#*Change '''Running''' to "Report"
#*Update '''Function''' to "Sum"
#*Update '''Ignore Null Value''' to "Yes"
<br/>
*'''Click Preview'''
<br/>
| |||