Maintain Opening Balance: Difference between revisions

From eStream Software
(Created page with "''Menu: GL | Maintain Opening Balance...'' =='''Introduction'''== * Before you start this, please check the setting '''Financial Start Period''' and '''System Conversion Date...")
 
No edit summary
Line 1: Line 1:
''Menu: GL | Maintain Opening Balance...''
==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. <br>
2. Click on New Database button.
::[[File:Installation.Standalone01.jpg]]
3. Select the Location where you wanted to save for the DCF File.
  Default is at ''C:\estream\SQLAccounting\Share''
::[[File:Installation.Standalone02.jpg]]
4. Select the Database Folder & click Ok.
::[[File:Installation.Standalone03.jpg]]
5. 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]]
6. 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.
|}
:::----------------------------------------------------------------------------------------------------------------------------------------------------
7. 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'''.
|}
8. Select the Firebird Version & Click OK.
::[[File:Installation.Standalone07.jpg]]
:::----------------------------------------------------------------------------------------------------------------------------------------------------
::::{|
|-
|-
| || Local DR  || Input the '''local currency DEBIT''' opening balance
| [[File:Template.Tips-01.jpg|60px]]|| [[Firebird]] Version we recommended is '''Firebird 2.1'''.
|}
:::----------------------------------------------------------------------------------------------------------------------------------------------------
9. Double Click the Company Name.
::[[File:Installation.Standalone08.jpg]]
10. 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
|-
|-
| || DR || Input the '''foreign currency DEBIT''' opening balance, especially for foreign bank accounts
| 3 Dot Button || To Go back to DCF Database list.
|-
|-
| || 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 />

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.

Installation.Standalone01.jpg

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

  Default is at C:\estream\SQLAccounting\Share
Installation.Standalone02.jpg

4. Select the Database Folder & click Ok.

Installation.Standalone03.jpg

5. Double Click the Firebird Icon.

Installation.Standalone04.jpg
Field Name Properties
Create Group Create New DCF file. Normally use at Server.
Add Group Add Existing DCF file. Normally use at workstation.
----------------------------------------------------------------------------------------------------------------------------------------------------
Template.Tips-01.jpg 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.

Installation.Standalone05.jpg
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
----------------------------------------------------------------------------------------------------------------------------------------------------
Template.Tips-01.jpg You can use Drag & Drop from windows explorer to restore the database.
----------------------------------------------------------------------------------------------------------------------------------------------------

7. Enter the Company Name & Click OK.

Installation.Standalone06.jpg
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.

Installation.Standalone07.jpg
----------------------------------------------------------------------------------------------------------------------------------------------------
Template.Tips-01.jpg Firebird Version we recommended is Firebird 2.1.
----------------------------------------------------------------------------------------------------------------------------------------------------

9. Double Click the Company Name.

Installation.Standalone08.jpg

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.