SQL Suite Customization
Put your business ideals to work
Download
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.
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.
Feature
- 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.
Freight & Forwarding Account
Description
This module for company which provide shipping services.
Feature
- Unlimited fields add for invoice
- Foreign currency module for automatic gain/loss ledger posting
Photocopier – Meter Reading
Description
This module for company which provide service for the photocopier machine.
Feature
- Able to Set unlimited Machine for each customer
- Able to Set Min Quantity charge per machine
- Able to input Spoil Quantity in % or Qtyr
- Able to check the Agreement Expired on data entry
Customer Statement Report group by Company Category
Description
This report provides same company category will group the info together. Major for workshop company.
Maintain form mode for Today, Current Month, This Month vs Last Month
Description
This form mode functions will allow opening the browse screen a bit faster cause it doesn't have to load so much of old transaction
Recurring System
Description
This module is suitable for Apartment Billing (eg Water, maintenance, etc)
Feature
- Able to Set Min Amount Charge for Water
- Rounding Mechanism for Water
- Water reading can be in Decimal Point
- Able to cater Water Rebate
- Able to generate overdue interest
Bonus Voucher Point System
Description
This to calculate the point by customer
Feature
- 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
Import Batch of Document into Delivery Order
Description
This customize allow import batch of document into delivery order, will be very useful for those already have the data list at excel. The output file must save as .CSV file. The sample given is for the scrap Metal Industries.
Batch Payment & Credit Note Knock-off
Description
This allow user to do an unapplied Amount for Payment or Credit Note to Knock Off in Batch It can be either by Invoice vs Payment or Payment vs Invoice
Salesman Commission Report
Description
- System generated salesman commission report.
- This commission report is based on different company category, different commission rate.
- Kindly contact us if you have a different type of commission calculation.
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
Update Purchase Invoice Cost to Maintain Stock Item RefCost
Description
The system will update Purchase Invoice cost to Maintain Stock Item ref cost.
Ref Cost = Subtotal * Currency Rate / Qty
Payroll Summary Work Unit with OT PayRate
Description
This report generates Payroll summary Work Unit Report with OT rate and OT Payrate.
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
Customer Multi Payment Listing in Landscape
Description
This report will display customer multi payment listing in landscape view.
One Click Email to Multiple Customers
Description
This report design setting just click once can email to multiple customers.
Feel trouble need click one by one and email to customers? This is the best solution for you.
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 %.
Customer Monthly Average Item Price
Description
This report generate the Customer Monthly Average Item Price.
Price = Monthly Value / Monthly Qty
Customer Daily Sales Qty
Description
Generate the Report with Customer Daily Sales Qty, will group by customer follow by item code.
Generate New Grid on Sales Price History
Description
This new grid added FromDocNo Info.
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
Calculate Customer Point
Description
Calculate customer up to date point.
Point = IV Amount + CS Amount + DN Amount - CN Qty
System generates Carton Running No by Customer
Description
Each customer have own set of carton no, the purpose is to help customer store the last of the carton no.
Call out the batch info and auto calculation for the Qty
Description
Store the info at maintain batch, when issuing document, select batch code will auto trigger the batch info and auto calculate the QTY.
Prompt password to Override the confirmed Document
Description
For those documents that had been confirmed, does not allow user to edit this Document, only manager level allow to override Confirmed Document.
Combine Multiple Item Info to Browsing Screen
Description
The system will update the item field to browse screen, user can view the field at browsing mode rather than go in one by one and view it.
Pull out the Driver Information from Maintain Agent
Description
This customization enables to store driver's info at Maintain Agent, when issuing the document, user able to choose from the drop down list instead of manually key.
We are the Number 1 accounting software in South East Asia use by more than 210,000 companies!
