User:Csloo/Main Structure: Difference between revisions

From eStream Software
No edit summary
 
(33 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.
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%;"
 
| <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]]
 
| <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]]
 
| <div style="float: right"></div>
*[[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]]
 
 


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




==<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====
|- align="center" bgcolor="tan"
''Menu: GL | Maintain Account...''
! width="20%" | '''Stock (Inventory)'''
! width="20%" | '''Production'''
! width="20%" | '''Inquiry'''
! width="20%" | '''Tools'''
! width="20%" | '''View'''


Mainly to structure your Chart of Account for Balance Sheet and Profit & Loss Account. [[File:GL-Maintain Acc.jpg|240px]]
|- valign="top" align="left" style="background: antiquewhite; font-size: 92%;"


====Cash Book Entry====
| <div style="float: right"></div>
====Journal Entry====
*[[Maintain Stock Group]]
====Foreign Bank Adjustment====
*[[Maintain Stock Item]]
====Maintain Opening Balance====
*[[Maintain Stock Category]]
====Bank Reconciliation====
*[[Maintain Stock Category Template]]
====Maintain Stock Value====
*[[Maintain Stock Price Tag]]
====Maintain Budget====
*[[Maintain Item Template]]
====Reports====
*[[Maintain Stock Item Matrix Profile]]
=====Print G/L Document Listing=====
*[[Maintain Location]]
=====Print Journal of Transaction Listing=====
*[[Maintain Batch]]
=====Print Transaction Summary Listing=====
*[[Stock Received]]
=====Print Ledger Report=====
*[[Stock Issue]]
=====Print Trial Balance=====
*[[Stock Transfer]]
=====Print Receipt & Payment Report=====
*[[Stock Adjustment]]
=====Print Profit & Loss Statement=====
*[[Stock Reports]]
=====Print Balance Sheet Statement=====
**[[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]]


===Customer===
| <div style="float: right"></div>
====Maintain Customer====
*[[Job Order]]
====Customer Invoice====
*[[Stock Item Assembly]]
====Customer Payment====
*[[Stock Item Disassembly]]
====Customer Debit Note====
*[[Production Reports]]
====Customer Credit Note====
**[[Print Job Order Listing]]
====Customer Refund====
**[[Print Outstanding Production Document Listing]]
====Customer Contra====
**[[Print BOM Relation]]
====Reports====
**[[Print BOM Listing]]
=====Print Customer Document Listing=====
**[[Print BOM Material Usage]]
=====Print Customer Balance Report=====
**[[Print BOM Planner]]
=====Print Customer Due Document=====
**[[Print BOM Wastage Report]]
=====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>
*[[Account Inquiry]]
*[[Cash Flow Inquiry]]
*[[Cash Flow Forecast]]
*[[Customer Pricing Inquiry]]
*[[Supplier Pricing Inquiry]]
*[[Serial Number Inquiry]]
*[[SQL Power Search]]


===Supplier===
| <div style="float: right"></div>
====Maintain Supplier====
*[[Maintain User Group]]
====Supplier Invoice====
*[[Maintain User]]
====Supplier Payment====
*[[User Access Right Assignment]]
====Supplier Debit Note====
*[[Maintain Style]]
====Supplier Credit Note====
*[[Maintain Commission Script]]
====Supplier Refund====
*[[Maintain Acceptable Transaction Date]]
====Supplier Contra====
*[[Maintain Document Number]]
====Reports====
*[[Maintain Form Mode]]
=====Print Supplier Document Listing=====
*[[Maintain Agent]]
=====Print Supplier Balance Report=====
*[[Maintain Area]]
=====Print Supplier Due Document=====
*[[Maintain Terms]]
=====Print Supplier Aging Report=====
*[[Maintain Currency]]
=====Print Supplier Statement=====
*[[Maintain Journal]]
=====Print Supplier Post Dated Cheque Listing=====
*[[Maintain Payment Method]]
=====Print Supplier Analysis By Document=====
*[[Maintain Project]]
=====Print Supplier Purchase and Payment 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)]]


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

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