Report Script: Simple Calculate Commission by Item UDF Rate
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
|