Report Script: Simple Calculate Commission by Item UDF Rate: Difference between revisions
Content added Content deleted
No edit summary |
No edit summary |
||
Line 1: | Line 1: | ||
==Introduction== |
==Introduction== |
||
This tutorial |
This tutorial uses a simple example to demonstrate how to apply report scripting to calculate commission that is based on sub total and item rate.<br/> |
||
{{Note|This example can also be done with '''Expression''' in Calculated Field without scripting.}} |
|||
Tasks in this tutorial |
==Tasks in this tutorial== |
||
*Add User Defined Field (UDF) |
*Add User Defined Field (UDF) |
||
*Add Calculate Field in Report |
*Add Calculate Field in Report |
||
*Calculate commission of each item |
*Calculate commission of each item |
||
*Report - Add Group Total |
*Report Design - Add Group Total |
||
*Report - Add Report Total |
*Report Design - Add Report Total |
||
==Product== |
==Product== |
||
Line 16: | Line 16: | ||
{{SourceDownload|link=https://drive.google.com/open?id=1Hm4v8je7pQrG2lqeylRTmA_q04ricj46|remark=(AutoCount Accounting 2.0)|Download Report Template|Simple Calculation.}} |
{{SourceDownload|link=https://drive.google.com/open?id=1Hm4v8je7pQrG2lqeylRTmA_q04ricj46|remark=(AutoCount Accounting 2.0)|Download Report Template|Simple Calculation.}} |
||
[[File:Prog ivlistcomm.png|link=]]<br /> |
[[File:Prog ivlistcomm.png|link=]]<br /> |
||
==Tutorial== |
==Tutorial== |
||
Line 30: | Line 29: | ||
===Open Report Designer and Load Report Template=== |
===Open Report Designer and Load Report Template=== |
||
#On '''Main Menu''', go to Sales > Invoice |
#On '''Main Menu''', go to Sales > Invoice |
||
#Click [Print Listing] |
#Click [Print Listing] Link Button |
||
#Select option '''Print Invoice Detail Listing''' |
#Select option '''Print Invoice Detail Listing''' |
||
#:Click [OK] |
#:Click [OK] |