User:Csloo/Main Structure: Difference between revisions

From eStream Software
No edit summary
 
(15 intermediate revisions by the same user not shown)
Line 1: Line 1:
<big>SQL Financial Accounting</big>
[[File:SQLAcc Logo.jpg|thumb|right|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.  
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.
<br />
<br />
 
-eStream Software Updated 22 July 2010
<br>
<br>
<br>
'''System Requirements'''<br>
 
*for Standalone or Client (Workstation) PC
  - Microsoft Windows XP, Windows 7 and above.
  - SVGA - minimum of 16 bis colors recommended.
  - Intel Pentium IV, Quad Core, i3, i5 and above computer.
  - 1 GB of RAM (recommended 2GB).
  - 1 GB of available hard disk space.
  - Microsoft Windows Compatible Printer.


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.
*for Server PC
  - Microsoft Windows XP, Windows 7 and above.
  - SVGA - minimum of 16 bis colors recommended.
  - Intel Quad Core, i3, i5, i7 and above computer.
  - 2 GB of RAM (recommended 4 GB).
  - 2 GB of available hard disk space.
  - Microsoft Windows Compatible Printer.
  - 100 Base-T NIC.
<br />
 
{| width="100%" bgcolor="#fff" border="0" cellpadding="3px" cellspacing="2px" style="margin:auto;"
|- align="center" bgcolor="tan"
! width="20%" | '''GL'''
! width="20%" | '''Customer'''
! width="20%" | '''Supplier'''
! width="20%" | '''Sales'''
! width="20%" | '''Purchase'''
 
|- valign="top" align="left" style="background: antiquewhite; font-size: 92%;"
 
| <div style="float: right"></div>
*[[Maintain Account]]
*[[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]]
 
| <div style="float: right"></div>
*[[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]]
 
| <div style="float: right"></div>
*[[Maintain Supplier]]
*[[Supplier Invoice]]
*[[Supplier Payment]]
*[[Supplier Debit Note]]
*[[Supplier Credit Note]]
*[[Supplier Refund]]
*[[Supplier Contra]]
*[[Supplier 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]]


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.
| <div style="float: right"></div>
*[[Quotation]]
*[[Sales Order]]
*[[Delivery Order]]
*[[Invoice]]
*[[Cash Sales]]
*[[Extra Delivery Order]]
*[[Debit Note]]
*[[Credit Note]]
*[[Sales Cancelled Note]]
*[[Sales 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]]


-eStream Software
| <div style="float: right"></div>
Updated 22 July 2010
*[[Purchase Request]]
*[[Purchase Order]]
*[[Goods Received]]
*[[Purchase Invoice]]
*[[Cash Purchase]]
*[[Extra Goods Received]]
*[[Purchase Debit Note]]
*[[Purchase Returned]]
*[[Purchase Cancelled Note]]
*[[Purchase Reports]]
**[[Print Purchase Document Listing]]
**[[Print Outstanding Purchase Document Listing]]
**[[Print Purchase Price History]]
**[[Print Purchase Analysis by Document]]
**[[Print Yearly Purchase Analysis]]




==<big>Overview</big>==
===Features===
===Standard Function & Button===


==<big>Main Modules</big>==
===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...''


[[File:GL-Maintain Acc.jpg|440px]]


* 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=====
[[File:GL-New_GL_Acc.jpg|340px]]
1. GL Code
* Field type : Alphanumerical
* Length : 10
* Not spacing is allowed in any coding.


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


3. 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====
|- align="center" bgcolor="tan"
====Journal Entry====
! width="20%" | '''Stock (Inventory)'''
====Foreign Bank Adjustment====
! width="20%" | '''Production'''
====Maintain Opening Balance====
! width="20%" | '''Inquiry'''
====Bank Reconciliation====
! width="20%" | '''Tools'''
====Maintain Stock Value====
! width="20%" | '''View'''
====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===
|- valign="top" align="left" style="background: antiquewhite; font-size: 92%;"
====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=====


| <div style="float: right"></div>
*[[Maintain Stock Group]]
*[[Maintain Stock Item]]
*[[Maintain Stock Category]]
*[[Maintain Stock Category Template]]
*[[Maintain Stock Price Tag]]
*[[Maintain Item Template]]
*[[Maintain Stock Item Matrix Profile]]
*[[Maintain Location]]
*[[Maintain Batch]]
*[[Stock Received]]
*[[Stock Issue]]
*[[Stock Transfer]]
*[[Stock Adjustment]]
*[[Stock Reports]]
**[[Print Stock Document Listing]]
**[[Print Stock Reorder Advice]]
**[[Print Stock Physical Worksheet]]
**[[Print Stock Card]]
**[[Print Stock Card Qty]]
**[[Print Stock Month End Balance]]
**[[Print Stock Aging]]
**[[Print Stock Analysis By Document]]
**[[Print Stock Batch Expiry]]
**[[Print Stock Serial Number Conflict]]
**[[Print Stock Serial Number Outstanding]]


===Supplier===
| <div style="float: right"></div>
====Maintain Supplier====
*[[Job Order]]
====Supplier Invoice====
*[[Stock Item Assembly]]
====Supplier Payment====
*[[Stock Item Disassembly]]
====Supplier Debit Note====
*[[Production Reports]]
====Supplier Credit Note====
**[[Print Job Order Listing]]
====Supplier Refund====
**[[Print Outstanding Production Document Listing]]
====Supplier Contra====
**[[Print BOM Relation]]
====Reports====
**[[Print BOM Listing]]
=====Print Supplier Document Listing=====
**[[Print BOM Material Usage]]
=====Print Supplier Balance Report=====
**[[Print BOM Planner]]
=====Print Supplier Due Document=====
**[[Print BOM Wastage Report]]
=====Print Supplier Aging Report=====
=====Print Supplier Statement=====
=====Print Supplier Post Dated Cheque Listing=====
=====Print Supplier Analysis By Document=====
=====Print Supplier Purchase and Payment Analysis=====


| <div style="float: right"></div>
*[[Account Inquiry]]
*[[Cash Flow Inquiry]]
*[[Cash Flow Forecast]]
*[[Customer Pricing Inquiry]]
*[[Supplier Pricing Inquiry]]
*[[Serial Number Inquiry]]
*[[SQL Power Search]]


===Sales===
| <div style="float: right"></div>
====Quotation====
*[[Maintain User Group]]
====Sales Order====
*[[Maintain User]]
====Delivery Order====
*[[User Access Right Assignment]]
====Invoice====
*[[Maintain Style]]
====Cash Sales====
*[[Maintain Commission Script]]
====Debit Note====
*[[Maintain Acceptable Transaction Date]]
====Credit Note====
*[[Maintain Document Number]]
====Sales Cancelled Note====
*[[Maintain Form Mode]]
====Reports====
*[[Maintain Agent]]
=====Print Sales Document Listing=====
*[[Maintain Area]]
=====Print Outstanding Sales Document Listing=====
*[[Maintain Terms]]
=====Print Sales Picking Listing=====
*[[Maintain Currency]]
=====Print Sales Price History=====
*[[Maintain Journal]]
=====Print Profit & Loss by Document======
*[[Maintain Payment Method]]
=====Print Sales Analysis by Document=====
*[[Maintain Project]]
=====Print Yearly Sales Analysis=====
*[[Maintain Tax]]
*[[Maintain Company Category]]
*[[Maintain Shipper]]
*[[Print Audit Trail]]
*[[Analyse Data Integrity]]
*[[Report Designer]]
*[[Print Bar Code (Direct Printer)]]
*[[Print Bar Code (Windows Printer)]]
*[[Options]]
*[[Maintain DIY]]
*[[SQL Control Center]]


| <div style="float: right"></div>
*[[Show Chart]]
*[[Sales Price History (Shift+Ctrl+S)]]
*[[Purchase Price History (Shift+Ctrl+P)]]
*[[Available Stock Balance (F11)]]
*[[Price Tag (Ctrl+T)]]
*[[Stock Item Picture]]
*[[Stock Item Search (F9)]]


===Purchase===




===Inventory===
|}
===Production===

Latest revision as of 03:42, 9 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


System Requirements

  • for Standalone or Client (Workstation) PC
  - Microsoft Windows XP, Windows 7 and above.
  - SVGA - minimum of 16 bis colors recommended.
  - Intel Pentium IV, Quad Core, i3, i5 and above computer.
  - 1 GB of RAM (recommended 2GB).
  - 1 GB of available hard disk space.
  - Microsoft Windows Compatible Printer.
  • for Server PC
  - Microsoft Windows XP, Windows 7 and above.
  - SVGA - minimum of 16 bis colors recommended.
  - Intel Quad Core, i3, i5, i7 and above computer.
  - 2 GB of RAM (recommended 4 GB).
  - 2 GB of available hard disk space.
  - Microsoft Windows Compatible Printer.
  - 100 Base-T NIC.


GL Customer Supplier Sales Purchase






Stock (Inventory) Production Inquiry Tools View