THIS SITE HAS MOVED TO accountingdes.com

accountingdes.com

Double Entry System Accounting Solution

[Product Features and Specifications]

Client/Server Architecture

DES is developed based on a client/server technology in Windows environment.This architectural design allows user to perform data input, data analysis and report printing in the most efficient and effective way.DES is a three-tier architecture, with a presentation layer (GUI) connecting to a database (DBMS) via interfacing with an application layer (middleware). Client/server technology is an ideal solution for both local and remote clients.

Database Platform

DES currently runs on Microsoft SQL Server DBMS (2000 and above). The Microsoft SQL Server database was developed on RDBMS approach, ensuring scalability and data integrity. SQL Server also facilitates data analysis through data warehousing, data mining and OLAP Third-party programs.

Microsoft Office Integration

DES interface with most of Microsoft productivity tools, including Microsoft Word,Microsoft Excel and Microsoft Access. These tools facilitate data access through Open Data Base Connectivity (ODBC) or direct SQL statements. DES allows user to export report into HTML or Text format and allow user to open HTML format within Microsoft Excel and saved as XLS format on-the-fly for data analysis.

Built in Triggers

DES is a fat-server/thin-client system. A big chunk of the stored procedures and triggers was created and reside as data object in the DBMS. Data validation, and business logic control is performed mostly at database layer, reducing the number of trip to the server.Through the use of triggers, information can be filtered, monitored in realtime and key data can be pushed to other functional area of the enterprise and its supply chain.

General Ledger Module

General Ledger Features :

To provide companies with latest financial status, performance and reports from various aspects of the business, allowing management to better monitor and control corporate performance.

The value of DES General Ledger :

• Print reports for actual performance by month, current and prior years

• Retains unlimited detail of transaction ledger

• Creation of unlimited number of accounts code

• Drills down into accounts code transaction to find source of ledger

• Preview reports on screen and export into .txt, .htm format

• Integrates with AR/AP/Cash/Inventory modules

Accounts Payable Module

Accounts Payable Features :

To provide timely, accurate and efficient control of vendors’ invoices processing, payment control and detail expenses analysis.

The value of DES Accounts Payable :

• Allow easy processing of vendor invoice on screen for non-stock and stock items

• Enforce business process control with mandatory input field (e.g. PO/GRN number)

• Apply Goods Received Notes to track Accounts Payable accruals

• Accept partial matching of purchase invoice with GRN

• Accept matching of purchase invoice with multiple GRN

• Direct Interface with Inventory/GL module

• Automatic update of inventory balance upon completion of GRN process

• Automatic posting in GL upon completion of GRN/purchase Invoice process

• Support credit note issue for processed purchase invoice

• Automatic update of inventory balance after processing purchase credit note

• Allow printing of vendors’ ageing report

• Preview of ageing report on screen and export into .htm, .txt format

• Linking of vendor code with default ledger codes

• Automatic computation of purchase invoice due date

• Allow direct charging of non-stock expenses to GL (ADJ module)

Accounts Receivable Module

Accounts Receivable Features :

To accumulate and manage customer transaction to ensure timely collection of revenue and to monitor credit control for better cash flow management.

The value of DES Accounts Receivable

• Improves customer service via instant access to customer profile and account information,including outstanding invoices, delivered orders, etc.

• Allow easy processing of sales invoice on screen for non-stock and stock items

• Enforce business process control with mandatory input field (e.g. PO/DO number)

• Apply Delivery Order to track Goods-In-Transit clearing account

• Accept partial billing of Delivery Order to customer

• Accept billing to customer with multiples Delivery Orders

• Direct Interface with Inventory/GL module

• Automatic update of inventory balance upon issuance of Delivery Order

• Automatic posting in GL upon completion of DO/sales Invoice process

• Support credit note issue for processed sales invoice

• Automatic reversal of original journals upon issuance of credit note

• Support printing of delivery order, sales invoice and credit note form

• Allow printing of statement of account and customers’ ageing report

• Preview of reports on screen and export into .htm, .txt format

• Direct interface of customer code (Customer Setup) with ledger code (COA Setup)

• Automatic computation of sales invoice due date

• Create individual credit terms and credit limit for each customer

• Restrict billing to customer with outstanding invoices exceeding credit limit

Cash Module

Cash Features :

To provide latest update on company’s cash movement and cash position for an efficient cash management.

The value of DES Cash Book :

• Allow partial matching of purchase invoice with payment issued to vendor

• Allow partial matching of sales invoice with collection from customer

• Direct interface with AR/AP/GL modules

• Automatic update of outstanding balance in AP module

• Automatic update of outstanding balance in AR module

• Automatic posting of journal in GL upon completion of payment/collection process

• Enforce business process control by mandatory input field (Cheque No.)

• Allow printing of cash forecast report for due collection/payment

• Allow printing of actual cash collection/payment for current and prior year

• Allow instant access to bankers’ profile, address, account number

• Allow direct posting of collection and payment journal in GL (Adjustment module)

• Maintains unlimited number of bank account code

• Direct interface of banker code (Cash Setup) with ledger code (COA Setup)

• Create unique GL account code for each banker for better control

Inventory Module

Inventory Features

To provide latest information on stock item quantity balance, stock movement history, individual stock pricing, for efficient management of inventory control and profit maximization.

The value of DES Inventory :

• Plans stock purchases and allocates deliveries accordingly

• Check latest stock item pricing and quantity balance at hand

• Direct interface with AP/AR/GL module

• Automatic update on stock item balance upon completion of GRN/DO process

• Automatic computation of AVEG/FIFO costing for each stock item

• Automatic posting of journal in GL upon completion of GRN/DO process

• Allow adjustment of stock quantity/pricing for each stock item (increase/decrease)

• Allow printing of Stock Balance, Stock movement and Ageing report

• Preview report on screen and export into .txt, .htm format

• Allocate costing method (AVEG/FIFO) to individual stock item

• Allow grouping of stock item by category

Copyright © 2010 DES. All rights reserved.

All brand and product names are trademarks or registered trademarks of their respective holders.

No part of this documentation or content may be reproduced or transmitted in any form or by any means, electronic or mechanical,

including photocopying, recording,or by any information storage or retrievel system, without prior

written permission from the publisher.

Notice of Liability

Every effort has been made to ensure that this documentation or content contains accurate and current information. However, DES and

the author shall not be liable for any loss or damage suffered by readers as a result of any information contained herein.