Report Script: Simple Calculate Commission by Item UDF Rate: Difference between revisions

← Older edit

Report Script: Simple Calculate Commission by Item UDF Rate (view source)

Revision as of 07:45, 15 August 2018

28 bytes added , 5 years ago

→‎Add Calculated Field

DanielY

authors, Bureaucrats, Confirmed users, Rollbackers, Administrators

2,743

edits

Revision as of 10:35, 14 August 2018 (view source) DanielY (talk \| contribs) No edit summary ← Older edit		Latest revision as of 07:45, 15 August 2018 (view source) DanielY (talk \| contribs) (→‎Add Calculated Field)
(2 intermediate revisions by the same user not shown)
Line 1: ==Introduction== This tutorial ~~is to use~~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''' ofin 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 - Add Group Total Report Design - Add Report Total ==Product== AutoCount Accounting 2.0<br/> Applicable to AutoCount Accounting 1.8 / 1.9 (require to manual modify some ~~coding~~code) {{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 /> ==Tutorial== Line 30 ⟶ 29: ===Open Report Designer and Load Report Template=== #On '''Main Menu''', go to Sales > Invoice #Click [Print Listing] ~~button~~Link Button #Select option '''Print Invoice Detail Listing''' #:Click [OK] Line 41 ⟶ 40: ===Add Calculated Field=== #While the report design is at '''Designer''' ~~mode~~layout form #Right click '''1 Main Data: Invoice Master''' in '''Field List''' #*Click '''Add Calculated Field'''