Maintain Opening Balance: Difference between revisions

From eStream Software
No edit summary
No edit summary
 
Line 1: Line 1:
==Introduction==
''Menu: GL | Maintain Opening Balance...''
Standalone is the License for Single User.
 
==Setup==
=='''Introduction'''==
1. Double click the '''SQL Product''' icon at the desktop and the below dialog will appear. <br>
* Before you start this, please check the setting '''Financial Start Period''' and '''System Conversion Date''' in '''Tools | Option...(General Ledger)'''.
2. Click on New Database button.
* To maintain the opening balance migrated from others system.
::[[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.
|}


:::----------------------------------------------------------------------------------------------------------------------------------------------------
::[[File: GL-Maintain Opening Balance.jpg | 640px]]
::::{|
|-
| [[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.
|}
:::----------------------------------------------------------------------------------------------------------------------------------------------------


6. Click New Database On left Panel.
{| class="wikitable"
::[[File:Installation.Standalone05.jpg]]
::{| class="wikitable"
|-
|-
! Field Name !! Properties
! !! Columns !! Explanation
|-
|-
| Backup || To Backup Selected Database
| A  || Local DR  || Input the '''local currency DEBIT''' opening balance
|-
|-
| Restore || To Restore from the Backup
| A  || Local CR || Input the '''local currency CREDIT''' opening balance
|-
|-
| Create New Database || To Create New Database with empty transaction
| B  || DR || Input the '''foreign currency DEBIT''' opening balance, especially for foreign bank accounts
|-
|-
| Create Sample Database || Create a Database with sample transactions
| B  || CR || Input the '''foreign currency CREDIT''' opening balance, especially for foreign bank accounts
|-
| Find Database || Auto Find & add back the database which already drop link
|-
| Add Database || Manually add back the database which already drop link
|}
|}


:::----------------------------------------------------------------------------------------------------------------------------------------------------
<br />
::::{|
 
|-
=='''Customer Opening Balance'''==
| [[File:Template.Tips-01.jpg|60px]]|| You can use '''Drag & Drop''' from windows explorer to restore the database.
 
|}
::[[File: GL-Maintain Opening Customer.jpg | 640px]]
:::----------------------------------------------------------------------------------------------------------------------------------------------------
 
7. Enter the Company Name & Click OK.
<br />
::[[File:Installation.Standalone06.jpg]]
 
::{| class="wikitable"
* 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.
! Field Name !! Properties
* Input the outstanding amount into '''Total'''.
|-
 
| Database|| Database Name. May leave it as Default.
::[[File: GL-Maintain Opening Customer-Pass Invoice.jpg | 640px]]
|-
 
| Company Name || A Full Company Name you wanted to use for.
<br />
|-
 
| Remark || This useful if you wanted to create 2 or more Same Company Name but for Different Year or Location.
=='''Supplier Opening Balance'''==
|-
 
| Change Password || This to Change the Default '''ADMIN''' password.<br> Default '''ADMIN''' password is '''ADMIN'''.
::[[File: GL-Maintain Opening Supplier.jpg | 640px]]
|}
 
8. Select the Firebird Version & Click OK.
<br />
::[[File:Installation.Standalone07.jpg]]
 
:::----------------------------------------------------------------------------------------------------------------------------------------------------
* 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:Template.Tips-01.jpg|60px]]|| [[Firebird]] Version we recommended is '''Firebird 2.1'''.  
 
|}
::[[File: GL-Maintain Opening Supplier-Pass Invoice.jpg | 640px]]
:::----------------------------------------------------------------------------------------------------------------------------------------------------
 
9. Double Click the Company Name.
<br />
::[[File:Installation.Standalone08.jpg]]
 
10. Enter the User Name & Password As '''ADMIN''' & Click Log on (assuming the password is not change on step 7).
=='''Stock Opening Balance'''==
::[[File:Installation.Standalone09.jpg]]
 
::{| class="wikitable"
::[[File: GL-Maintain Opening Stock.jpg | 640px]]
|-
 
! Field Name !! Properties
<br />
|-
 
| 3 Dot Button || To Go back to DCF Database list.
* 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]]...
| Remember password || Tick this option (Not Recommended) for who don't want to type password every time open the database.
::[[File: GL-Maintain Opening Stock Value.jpg | 640px]]
|}
 
<br />

Latest revision as of 03:55, 25 July 2012

Menu: GL | Maintain Opening Balance...

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.
GL-Maintain Opening Balance.jpg
Columns Explanation
A Local DR Input the local currency DEBIT opening balance
A Local CR Input the local currency CREDIT opening balance
B DR Input the foreign currency DEBIT opening balance, especially for foreign bank accounts
B CR Input the foreign currency CREDIT opening balance, especially for foreign bank accounts


Customer Opening Balance

GL-Maintain Opening Customer.jpg


  • 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.
GL-Maintain Opening Customer-Pass Invoice.jpg


Supplier Opening Balance

GL-Maintain Opening Supplier.jpg


  • 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.
GL-Maintain Opening Supplier-Pass Invoice.jpg


Stock Opening Balance

GL-Maintain Opening Stock.jpg


  • 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...
GL-Maintain Opening Stock Value.jpg


Retrieved from "https://wiki.sql.com.my/index.php?title=Maintain_Opening_Balance&oldid=398"
Last modified
This page was last edited on 25 July 2012, at 03:55.