User:Csloo/Main Structure: Difference between revisions

From eStream Software
No edit summary
 
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.
 
*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%;"


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


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>
*[[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]]


-eStream Software
| <div style="float: right"></div>
Updated 22 July 2010
*[[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]]


| <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]]


==<big>Overview</big>==
| <div style="float: right"></div>
===Features===
*[[Purchase Request]]
===Standard Function & Button===
*[[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>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)


<br />


=====Create New GL Account=====
[[File:GL-New_GL_Acc.jpg|340px]]


{| class="wikitable"
|-
! 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
|}


<br />


=====Special Account Type=====
At different standard Account Type (level 1), there is a separate set of special type : -
<br />
{| class="wikitable"
|-
! Account Type !! Special Type !! Purpose
|-
| Fixed Asset || Accumulated Deprn Account || To differentiate the fixed asset cost and accumulated depreciation in Balance Sheet report , especially select Balance Sheet format as ‘This Year – 3 column’.
|-
| Current Asset || Bank Account || Enable to create Bank Reconciliation and input single entry in Cash Book Entry, Customer Payment and Supplier Payment.
|-
| Current Asset || Cash Account || Enable to create Bank Reconciliation (if you need to reconcile the cash balance) and input single entry in Cash Book Entry, Customer Payment and Supplier Payment.
|-
| Current Asset || Customer Control Account || To set this account to Maintain Customer and input single entry by selecting the customer in Sales invoice, Cash Sales, DN, CN, Customer Payment, etc, but not allowed in journal entry.
|-
| Current Asset || Balance Stock Account || To capture the Balance Sheet stock account in Maintain Stock Value.
|-
| Current Liabilities || Bank Account || Enable to do Bank Reconciliation and input single entry in Cash Book Entry, Customer Payment and Supplier Payment.
|-
| Current Liabilities || Supplier Control Account || Enable to set this account to Maintain Supplier and input single entry by selecting the supplier in Purchase invoice, Cash Purchase, DN, CN, Supplier Payment, etc, but not allowed in journal entry.
|-
| Cost of Goods Sold || Opening Stock || To capture the P&L opening stock account in Maintain Stock Value.
|-
| Cost of Goods Sold || Closing Stock || To capture the P&L closing stock account in Maintain Stock Value.
|-
| Cost of Goods Sold || Manufacturing Control Account || To differentiate part of the COGS account categorized into the manufacturing accounts.
|}


====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