User:Csloo/Main Structure: Difference between revisions

Revision as of 04:53, 1 June 2012

SQL Financial Accounting

SQL Business Suite is designed to support applications that deliver business-critical functionality to large deployment of network environment. It is build and optimized for mission-specific application.

At the core SQL Business Suite lies a robust Client-Server architecture that allows it to deliver significant advantages in flexibility, reliability, performance and stability. Self-tuning features include cost-based query optimization and dynamic re-balancing of reports structures enhance performance and provides a wide range of business reports.

More important, SQL Business Suite is an open period solution that enables you to collect more data over a wider time frame for better decision-base analysis.

-eStream Software Updated 22 July 2010

Overview

Features

Standard Function & Button

Main Modules

GL

Recording all the General Ledger double entry and bank transactions.
Maintain your detailed budget data in order to compare with your actual results.
Review / print the financial year end reports, e.g. Profit and Loss Statement, Balance Sheet, etc.

Maintain Account

Menu: GL | Maintain Account...

Mainly to structure your Chart of Account for Balance Sheet and Profit & Loss Account.
You able to set multiple levels to your Chart of Accounts tree, eg. level 1, 2, 3,...... See the above screenshot (Vertical lines represent levels)

Create New GL Account

Field Name	Properties
GL Code	* Field type : Alphanumerical Length : 10 Not spacing is allowed in any coding.
Description	* Field type : Alphanumerical Length : Unlimited (Not recommended to store too long because you may have difficulties to view the full description in the report.) Spacing is allowed.
2nd Description	* Field type : Alphanumerical Length : Unlimited (Not recommended to store too long because you may have difficulties to view the full description in the report.) Spacing is allowed

Cash Book Entry

Journal Entry

Foreign Bank Adjustment

Maintain Opening Balance

Bank Reconciliation

Maintain Stock Value

Maintain Budget

Reports

Print G/L Document Listing

Print Journal of Transaction Listing

Print Transaction Summary Listing

Print Ledger Report

Print Trial Balance

Print Receipt & Payment Report

Print Profit & Loss Statement

Print Balance Sheet Statement

Customer

Maintain Customer

Customer Invoice

Customer Payment

Customer Debit Note

Customer Credit Note

Customer Refund

Customer Contra

Reports

Print Customer Document Listing

Print Customer Balance Report

Print Customer Due Document

Print Customer Aging Report

Print Customer Statement

Print Customer Post Dated Cheque Listing

Print Customer Analysis By Document

Print Customer Sales and Collection Analysis

Supplier

Maintain Supplier

Supplier Invoice

Supplier Payment

Supplier Debit Note

Supplier Credit Note

Supplier Refund

Supplier Contra

Reports

Print Supplier Document Listing

Print Supplier Balance Report

Print Supplier Due Document

Print Supplier Aging Report

Print Supplier Statement

Print Supplier Post Dated Cheque Listing

Print Supplier Analysis By Document

Print Supplier Purchase and Payment Analysis

Sales

Quotation

Sales Order

Delivery Order

Invoice

Cash Sales

Debit Note

Credit Note

Sales Cancelled Note

Reports

Print Sales Document Listing

Print Outstanding Sales Document Listing

Print Sales Picking Listing

Print Sales Price History

Print Profit & Loss by Document=

Print Sales Analysis by Document

Print Yearly Sales Analysis

Purchase

Inventory

Production

@@ Line 32: / Line 32: @@
 =====Create New GL Account=====
 [[File:GL-New_GL_Acc.jpg|340px]]
-. GL Code
-* Field type : Alphanumerical
+{| class="wikitable"
+|-
+! Field Name !! Properties
+|-
+| GL Code || * Field type : Alphanumerical
 * Length : 10
 * Not spacing is allowed in any coding.
+|-
-. Description
+| Description || * Field type : Alphanumerical
-* Field type : Alphanumerical
 * Length : Unlimited (Not recommended to store too long because you may have difficulties to view the full description in the report.)
 * Spacing is allowed.
+|-
-. 2nd Description
+| 2nd Description || * Field type : Alphanumerical
-* Field type : Alphanumerical
 * Length : Unlimited (Not recommended to store too long because you may have difficulties to view the full description in the report.)
 * Spacing is allowed
+|}
 ====Cash Book Entry====