Opening balance cookbook

eSquat · **Posted:** Wed Jan 09, 2008 4:25 pm

This thread (and the other one on the opening balance) is over my head. Maybe someone can write a simple cookbook for the most basic opening operations.

Cash Account #570000 : Opening balance +100 Euro
Bank Account #512100 : Opening balance -250 Euro
Unpaid client invoices (waiting to get paid) : 350 Euro
Unpaid supplier invoices (are to be paid) : 450 Euro

It trust this is not really difficult, so maybe someone "in the know" can scribble together some cookbook operation for Tiny 4.2.1 ?

I volunteer to write up the instructions as detailed as I can into the wiki.

Thanks in advance !

knerz · **Joined:** Tue Oct 24, 2006 10:43 am **Posts:** 591

v4.2.1, manufacturing profile, belgium account chart, no demo data

1. Financial Management -> Configuration -> Periods -> Fiscal Year: Create a fiscal Year with monthly periods

2. Financial Management -> Configuration -> General Accounts -> Accounts Definition: Create an account 'Opening Balance Account' (Account Type: 'Equity' (not sure about that, but it's working), Sign: 'Positive', Deferral Method: 'None', Reconcile: 'No')

3. Financial Management -> Configuration -> Journal -> Journal Definition: Create a new Journal 'Opening Bal Journal' (Type: 'Situation', View: 'Journal View', Entry Sequence: 'Account Journal', Default Debit Account: 'Opening Balance Account', Default Credit Account: 'Opening Balance Account', Centralized Counterpart: 'Yes')

4. Best to create a csv-file with the first line:
"Account","Effective date","Journal","Name","Period","Debit","Credit"
and the data-lines like this:
"1000","2008-01-16","Opening Bal Journal","Opening Balance Entry","01/01 - 31/01",0,53828

notice that the column 'Account' expects the account code and the entries for Debit and Credit are not in ".

5. Financial Management -> Entries -> Entries by Journal: Choose 'Opening Bal Journal' (but I think it doesn't really matter for the import

6. Menu 'Form -> Import data': Choose the file to import, 'Auto Detect', 'Ok'

Done.

Hope this helps some people. If you have any critics or improvement suggestions please leave a comment.

knerz

badralkh · **Joined:** Wed Apr 09, 2008 3:46 am **Posts:** 4

To:Knerz

Hello,
I have tried to import opening balance using above instruction, but TinyERP 4.2.2 replied with following error:

ERROR: operator does not exist: integer = boolean at character 52
HINT: No operator matches the given name and argument type(s). You may need to add explicit type casts.

select "active",id from "ac;

After trying this, I have tried to enter content of cvs file on new entry form of
Opening Balance Journal. When I press SAVE button above error is displayed. After changing Acitve field, the record has been saved successfully. But I can not view the saved record.

What is my mistake?
Best regards Badral

Marsup · **Joined:** Thu Aug 21, 2008 1:21 pm **Posts:** 3

hello

I got the same problem with the french accunting

Quote:

Code de l'erreur:

ERROR: operator does not exist: integer = boolean at character 52
HINT: No operator matches the given name and argument type(s). You may need to add explicit type casts.

select "active",id from "ac2

Détail
Traceback (most recent call last):
File "netsvc.pyo", line 200, in _dispatch
File "service\web_services.pyo", line 366, in execute
File "osv\osv.pyo", line 111, in execute
File "osv\osv.pyo", line 92, in execute_cr
File "C:\Program Files\TinyERP Server\addons\account\account_move_line.py", line 500, in write
File "C:\Program Files\TinyERP Server\addons\account\account.py", line 819, in validate
File "C:\Program Files\TinyERP Server\addons\account\account.py", line 705, in _centralise
File "C:\Program Files\TinyERP Server\addons\account\account_move_line.py", line 537, in create
File "osv\orm.pyo", line 821, in read
File "osv\orm.pyo", line 852, in _read_flat
File "sql_db.pyo", line 75, in execute
ProgrammingError: ERROR: operator does not exist: integer = boolean at character 52
HINT: No operator matches the given name and argument type(s). You may need to add explicit type casts.

select "active",id from "ac2

to fullfil the "

Marsup · **Joined:** Thu Aug 21, 2008 1:21 pm **Posts:** 3

hello, I got the answer

it is partialy explained here
http://tinyforge.org/tracker/index.php?func=detail&aid=571&group_id=13&atid=129

configuration -> journaux -> definition des journaux
ouverture
set the default account for debit and credit