Maintain Opening Balance: Difference between revisions

Revision as of 03:54, 25 July 2012

Introduction

Standalone is the License for Single User.

Setup

1. Double click the SQL Product icon at the desktop and the below dialog will appear.
2. Click on New Database button.

3. Select the Location where you wanted to save for the DCF File.

  Default is at C:\estream\SQLAccounting\Share

4. Select the Database Folder & click Ok.

5. Double Click the Firebird Icon.

Field Name	Properties
Create Group	Create New DCF file. Normally use at Server.
Add Group	Add Existing DCF file. Normally use at workstation.

----------------------------------------------------------------------------------------------------------------------------------------------------

Right Click the Firebird Icon & select

Properties to back to Firebird Setting.
Create Desktop Shortcut to create a shortcut icon for each DCF file.

----------------------------------------------------------------------------------------------------------------------------------------------------

6. Click New Database On left Panel.

Field Name	Properties
Backup	To Backup Selected Database
Restore	To Restore from the Backup
Create New Database	To Create New Database with empty transaction
Create Sample Database	Create a Database with sample transactions
Find Database	Auto Find & add back the database which already drop link
Add Database	Manually add back the database which already drop link

----------------------------------------------------------------------------------------------------------------------------------------------------

You can use Drag & Drop from windows explorer to restore the database.

----------------------------------------------------------------------------------------------------------------------------------------------------

7. Enter the Company Name & Click OK.

Field Name	Properties
Database	Database Name. May leave it as Default.
Company Name	A Full Company Name you wanted to use for.
Remark	This useful if you wanted to create 2 or more Same Company Name but for Different Year or Location.
Change Password	This to Change the Default ADMIN password. Default ADMIN password is ADMIN.

8. Select the Firebird Version & Click OK.

----------------------------------------------------------------------------------------------------------------------------------------------------

Firebird Version we recommended is Firebird 2.1.

----------------------------------------------------------------------------------------------------------------------------------------------------

9. Double Click the Company Name.

10. Enter the User Name & Password As ADMIN & Click Log on (assuming the password is not change on step 7).

File:Installation.Standalone09.jpg

Field Name	Properties
3 Dot Button	To Go back to DCF Database list.
Remember password	Tick this option (Not Recommended) for who don't want to type password every time open the database.

@@ Line 1: / Line 1: @@
-''Menu: GL | Maintain Opening Balance...''
+==Introduction==
+Standalone is the License for Single User.
+==Setup==
+. Double click the '''SQL Product''' icon at the desktop and the below dialog will appear. <br>
+. Click on New Database button.
+::[[File:Installation.Standalone01.jpg]]
+. Select the Location where you wanted to save for the DCF File.
+   Default is at ''C:\estream\SQLAccounting\Share''
+::[[File:Installation.Standalone02.jpg]]
+. Select the Database Folder & click Ok.
+::[[File:Installation.Standalone03.jpg]]
+. Double Click the Firebird Icon.
+::[[File:Installation.Standalone04.jpg]]
+::{| class="wikitable"
+|-
+! Field Name !! Properties
+|-
+| Create Group || Create New DCF file. Normally use at Server.
+|-
+| Add Group || Add Existing DCF file. Normally use at workstation.
+|}
-=='''Introduction'''==
+:::----------------------------------------------------------------------------------------------------------------------------------------------------
-* Before you start this, please check the setting '''Financial Start Period''' and '''System Conversion Date''' in '''Tools | Option...(General Ledger)'''.
+::::{|
-* To maintain the opening balance migrated from others system.
+|-
+| [[File:Template.Tips-01.jpg|60px]]|| Right Click the Firebird Icon & select
+* '''Properties''' to back to Firebird Setting.
+* '''Create Desktop Shortcut''' to create a shortcut icon for each DCF file.
+|}
+:::----------------------------------------------------------------------------------------------------------------------------------------------------
-::[[File: GL-Maintain Opening Balance.jpg | 640px]]
+. Click New Database On left Panel.
+::[[File:Installation.Standalone05.jpg]]
+::{| class="wikitable"
+|-
+! Field Name !! Properties
+|-
+| Backup || To Backup Selected Database
+|-
+| Restore || To Restore from the Backup
+|-
+| Create New Database || To Create New Database with empty transaction
+|-
+| Create Sample Database || Create a Database with sample transactions
+|-
+| Find Database || Auto Find & add back the database which already drop link
+|-
+| Add Database || Manually add back the database which already drop link
+|}
-{| class="wikitable"
+:::----------------------------------------------------------------------------------------------------------------------------------------------------
+::::{|
+|-
+| [[File:Template.Tips-01.jpg|60px]]|| You can use '''Drag & Drop''' from windows explorer to restore the database.
+|}
+:::----------------------------------------------------------------------------------------------------------------------------------------------------
+. Enter the Company Name & Click OK.
+::[[File:Installation.Standalone06.jpg]]
+::{| class="wikitable"
+|-
+! Field Name !! Properties
+|-
+| Database|| Database Name. May leave it as Default.
+|-
+| Company Name || A Full Company Name you wanted to use for.
+|-
+| Remark || This useful if you wanted to create 2 or more Same Company Name but for Different Year or Location.
 |-
-! !! Columns !! Explanation
+| Change Password || This to Change the Default '''ADMIN''' password.<br> Default '''ADMIN''' password is '''ADMIN'''.
+|}
+. Select the Firebird Version & Click OK.
+::[[File:Installation.Standalone07.jpg]]
+:::----------------------------------------------------------------------------------------------------------------------------------------------------
+::::{|
 |-
-|  A  || Local DR  || Input the '''local currency DEBIT''' opening balance
+| [[File:Template.Tips-01.jpg|60px]]|| [[Firebird]] Version we recommended is '''Firebird 2.1'''.
+|}
+:::----------------------------------------------------------------------------------------------------------------------------------------------------
+. Double Click the Company Name.
+::[[File:Installation.Standalone08.jpg]]
+. Enter the User Name & Password As '''ADMIN''' & Click Log on (assuming the password is not change on step 7).
+::[[File:Installation.Standalone09.jpg]]
+::{| class="wikitable"
 |-
-|  A  || Local CR || Input the '''local currency CREDIT''' opening balance
+! Field Name !! Properties
 |-
-|  B  || DR || Input the '''foreign currency DEBIT''' opening balance, especially for foreign bank accounts
+| 3 Dot Button || To Go back to DCF Database list.
 |-
-|  B  || CR || Input the '''foreign currency CREDIT''' opening balance, especially for foreign bank accounts
+| Remember password || Tick this option (Not Recommended) for who don't want to type password every time open the database.
 |}
-<br />
-=='''Customer Opening Balance'''==
-::[[File: GL-Maintain Opening Customer.jpg | 640px]]
-<br />
-* You can direct create customer PASS invoice from Customer | Customer Invoice...
-* Key-in the date before the System Conversion Date (01/01/2004), you will get Customer Pass Invoice screen.
-* Input the outstanding amount into '''Total'''.
-::[[File: GL-Maintain Opening Customer-Pass Invoice.jpg | 640px]]
-<br />
-=='''Supplier Opening Balance'''==
-::[[File: GL-Maintain Opening Supplier.jpg | 640px]]
-<br />
-* You can direct create supplier PASS invoice from Supplier | Supplier Invoice...
-* Key-in the date before the System Conversion Date (01/01/2004), you will get Supplier PASS Invoice entry screen.
-* Input the outstanding amount into '''Total'''.
-::[[File: GL-Maintain Opening Supplier-Pass Invoice.jpg | 640px]]
-<br />
-=='''Stock Opening Balance'''==
-::[[File: GL-Maintain Opening Stock.jpg | 640px]]
-<br />
-* Lets assume the System Conversion Date is 01/01/2004.
-* To capture the opening stock balance as at 01/01/2004, you need to key-in the stock value in '''31/12/2003''' in GL | Maintain Stock Value...
-::[[File: GL-Maintain Opening Stock Value.jpg | 640px]]
-<br />