Report Script: Simple Calculate Commission by Item UDF Rate: Difference between revisions
Content added Content deleted
(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/>...") |
(No difference)
|
Revision as of 07:26, 14 August 2018
Under Construction
Introduction
This tutorial shows how to apply report scripting to calculate commission that is based on item rate commission rate entitlement.
Tasks in this tutorial:-
- Add User Defined Field (UDF)
- Add Calculate Field
- Calculate commission of each item
- Report - Group by Sale Agent
- Report - Add Group Total
- Report - Add Report Total
Product
AutoCount Accounting 2.0
Applicable to AutoCount Accounting 1.8 / 1.9
Tutorial
Add UDF
Category | Table | Name | Caption | Type | Size | Precision | Scale |
---|---|---|---|---|---|---|---|
Maintenance | Stock Item | COMMRATE | COMM RATE | Decimal | 18 | 0 |
Open Report Designer and Load Report Template
- On Main Menu, go to Sales > Invoice
- Click [Print Listing] button
- Select option Print Invoice Detail Listing
- On Main Menu of Sales Invoice,
- go to Report > Design Detail Listing Report
- Select Report Template of "Invoice Detail Listing"
Amend Report Layout
Go to top
|
Resources For AutoCount Software Developers
|