Follow us on Social Media
Enhance SQL Business Software functionality with a selection of best-selling DIY customizations and report templates. If you have any feedback or suggestion, please help by emailing us your taughts or report any problems you experienced.
Download
Multiple Payment Method in Cash Sales * NEW
Description
User allow to received multiple payments in Cash Sales.
-
Max 3 Payment Methods, additional payment method are allow to add.
-
OR Document Number will be same as Cash Sales Number, added -1 if have more than 1. Example : CS-00013, 1st OR Docno = CS-00013, 2nd OR Docno = CS-00013-1, 3rd OR Doc No = CS-00013-2.
-
Allow to calculate balance change when balance does not more than Cash Received.
-
Allow to edit Cash Sales and repost NEW OR.
-
DIY Field & DIY Script Module are required
Note : The list price does not include the module price, additional fees required for the DIY Field and DIY Script Module.
User can view and select certain Item Code by Stock Group
Description
This is for some company business nature which have 2 or more different type of business nature, the salesperson can view the respective Itemcode. Those reduce the unnessary of item from the pull down.
Feature
-
Can view selected ItemCode by Stock Group
-
User can self define the User Stock Group
-
User can view more than 1 Stock Group
-
Module Required : DIY Field & DIY Script
Note : The list price does not include the module price, additional fees required for the DIY Field and DIY Script Module.
Override with Password when Print Count more than 1
Description
This is the special control for the user who needs to control the user only can print for 1 time, in order to reprint have to request for the permission user to override with the User Name & Password.
-
Module Required : DIY Field & DIY Script
Note : The list price does not including the module price, additional fees required for the DIY Field and DIY Script Module.
Photocopier – Meter Reading
Description
This module for company which provide service for the photocopier machine.
Features
-
Able to Set unlimited Machine for each customer
-
Able to Set Min Quantity charge per machine
-
Able to input Spoil Quantity in % or Qty
-
Able to check the Agreement Expired on data entry
Bonus Voucher Point System
Description
This to calculate the point by customer
Features
-
Able to set Claim Rate (i.e. 1 Point = How many RM eg 1 Point = RM0.01 so enter as 0.01)
-
Able to set Point Rate by item code (i.e. RM1 = How many point eg RM1 = 1 so enter as 1)
-
Point Rate can be calculate by Amount and/or Qty
-
Able to Claim like Voucher as Discount
-
Able to Claim Item
-
Claim Point Rate can be change runtime
Get Excel Data Import into Document Detail
Description
Enable data import from EXCEL into document detail. It is very useful for company wish to import the long list of data prepared in EXCEL format.
Advantages:
============
1. End-user able to import the data from the EXCEL format.
2. All the details columns able to import via EXCEL.
3. Save time to input the document detail data.
Disadvantages:
==============
1. The end-user has to make sure the items code, project, location & GL Account are valid
Formula to Calculate Stock Qty for Timber Industry
Description
This customization is specifically made for the timber industry to calculate stock Qty.
There are 3 formulas to calculate the Qty. When the selected formula is:-
i) N1
- Gross Ton = ((Thick * Width / Exchange Unit) / Exchange Tonnage) * ((1pcs * 1mft) + (2pcs * 2mft) + (3pcs * 3mft) + ... + (19pcs * 19mft) + (20pcs * 20mft))
- Qty = Gross Ton - Deduct 3 - Deduct 6
- Total Pcs = 1pcs + 2pcs + 3pcs + 4pcs + ... + 19pcs + 20pcs
ii) N2
- Gross Ton = (Thick * Width / Exchange Tonnage) * ((1pcs * 1mft) + (2pcs * 2mft) + (3pcs * 3mft) + ... + (19pcs * 19mft) + (20pcs * 20mft))
- Qty = Gross Ton - Deduct 3 - Deduct 6
- Total Pcs = 1pcs + 2pcs + 3pcs + 4pcs + ... + 19pcs + 20pcs
iii) N3
- Gross Ton = (Thick * Width * Exchange Unit) / Exchange Tonnage
- Deduct2 = Gross Ton * (Deduct1 / 100)
- Deduct3 = Deduct2 * Unit Price
- Deduct5 = Thick * Deduct4 * Deduct4 / Exchange Tonnage
- Deduct6 = Deduct5 * Unit Price
- Qty = Gross Ton - Deduct2 - Deduct5
Formula to Calculate Stock Qty for Timber Industry
Description
This customization is specifically made for the timber industry to calculate stock Qty.
There are 3 formulas to calculate the Qty. When the selected formula is:-
i) N1
- Gross Ton = ((Thick * Width / Exchange Unit) / Exchange Tonnage) * ((1pcs * 1mft) + (2pcs * 2mft) + (3pcs * 3mft) + ... + (19pcs * 19mft) + (20pcs * 20mft))
- Qty = Gross Ton - Deduct 3 - Deduct 6
- Total Pcs = 1pcs + 2pcs + 3pcs + 4pcs + ... + 19pcs + 20pcs
ii) N2
- Gross Ton = (Thick * Width / Exchange Tonnage) * ((1pcs * 1mft) + (2pcs * 2mft) + (3pcs * 3mft) + ... + (19pcs * 19mft) + (20pcs * 20mft))
- Qty = Gross Ton - Deduct 3 - Deduct 6
- Total Pcs = 1pcs + 2pcs + 3pcs + 4pcs + ... + 19pcs + 20pcs
iii) N3
- Gross Ton = (Thick * Width * Exchange Unit) / Exchange Tonnage
- Deduct2 = Gross Ton * (Deduct1 / 100)
- Deduct3 = Deduct2 * Unit Price
- Deduct5 = Thick * Deduct4 * Deduct4 / Exchange Tonnage
- Deduct6 = Deduct5 * Unit Price
- Qty = Gross Ton - Deduct2 - Deduct5
Stock Items Special Measurement Appearance in Documents
Description
You can input the variable's value (e.g. Height, Width & Thickness) to compute a new factor result (e.g. Weight) in Maintain Stock Item. The factor result and other variable's value of each item will be appear in documents such as sales order, invoice, purchase order, goods received, etc.
Formula can be set to any form you like to meet the customer business requirement.
For example,
A X B X C = ABC
A X B + C = AB + C
A X B + (C + C) = AB + 2C
Advantages:
==========
1. You can input variable to calculate the new factor result.
2. One time setup in Maintain Stock Item.
3. Flexible because the fields provided are variable input.
Disadvantages:
=============
1. User has to input all variable value for each items in Maintain Stock Item.
Function Lock Agent Code to Application Report
Description
Enable lock agent code function to the application reports. It will restrict the agent (sales person) to view his own reports by login his ID.
Advantages:
=========
1. He/she cannot access other Agent's (or Sales Person) customer sales data
2. Agent (or Sales Person) can print and view their Customer Aging, Customer Statement, Sales report by themselves.
3. Cut-down the Accounts Department workload.
4. May cut-down paper cost. Because the report can be viewed on the screen by Agent themselves.
Disadvantages:
============
1. User ID (from Maintain User) and agent code (from Maintain Agent) must be SAME.
2. You have to tick "LOCK" in Maintain User.
Lock Agent function workable to the following application reports:
1. Print Customer Document Listing
2. Print Customer Balance Report
3. Print Customer Due Report
4. Print Customer Aging Report
5. Print Customer Statement
6. Print Customer Post Dated Cheque Listing
7. Print Customer Analysis By Document
8. Print Customer Sales and Collection Analysis
9. Print Sales Document Listing
10. Print Outstanding Sales Document Listing
11. Print Sales Price History
12. Print Profit & Loss by Document
13. Print Sales Analysis by Document
14. Print Yearly Sales Analysis
NOTE: Lock by Agent code to Supplier & Purchase application reports are workable too.
Stock Received / Issue Listing – Monthly Qty
Description
This report generates Stock Received / Issue Monthly Qty, will group by Item Code.
This report enables to show Stock Received/Listing on column view.
Also available for the Report as below :
1. Stock Received - Monthly Stock Value
2. Stock Issue - Monthly Stock Value
Debtor/Customer 6 months aging report
Description
Debtor/Customer 6 months aging report specially designed to extract the following info:
1. MTD Sales
2. YTD Sales
3. MTD Pay
4. Last Pay
5. Telephone
6. Credit Limits
7. Terms
8. Contact Person
9. Area
10. Agent
11. Address Report footer ending with summary results %.
System will Trigger the Info stored at Maintain Batch hence Calculate the Qty Needed.
Description
Store the info at Maintain Batch, when issuing the document, select batch code will auto trigger the batch info hence calculate the Qty needed.
Based on the sample screen below, system will help to calculate Qty needed based on the formula below :
Qty = Sheet/Roll * Length * Width
