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.

Freight & Forwarding Account

Description

This module for company which provide shipping services.

Features

  • 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.

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

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

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)

Features

  • 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

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

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

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.

Follow us on Social Media

  • Facebook
  • YouTube
  • instagram-marketing

Copyright © E Soft Business Solution Sdn Bhd (1275024-H)

All rights reserved.