Go Back > Forum > Baan Quick Support: Functional & Technical > Finance, Invoicing and Integration

User login

Frontpage Sponsor


How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 43

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 26th May 2006, 10:46
learn_ln6 learn_ln6 is offline
Join Date: Apr 2006
Posts: 34
learn_ln6 is on a distinguished road
Baan: LN6.1,BaaN IVc4 - DB: Oracle,SQL Server - OS: Hpunix , WS2003
Problem in Opening Balance


Version: LN6
Session tfgld6201m000 ( Close Year provisional)

The opening of retained earning account is coming as wrong.

This is the first time closing is done in this company and opening was entered in the 11 period using Opening Balance transaction type. So the P&L accounts have opening also.

Now the retained earning balance is coming as Balance of Transactions for the year but doesn't consider Opening.

As I understood , normally P&L accounts don'e have opening balance thus standard program would be considering on Balance of transactions for the year.

Eg. Opening = 100
Debit = 60
Credit = 40

Thus , Correct Balance = 100+60-40 = 120

While the system balance = 60-40 = 20.

Please advise if someone has faced this issue before...

Reply With Quote
Old 21st June 2006, 08:18
baanravi baanravi is offline
Senior Member
Join Date: May 2006
Posts: 102
baanravi is on a distinguished road
Baan: b4c4, ERP, LN - DB: Oracle, SQL - OS: Unix
P&L accounts can't have opening balance

P&L accounts can't have opening balance.

how was it entered ?
Reply With Quote
Old 26th June 2006, 14:26
h_baan_ln6 h_baan_ln6 is offline
Join Date: Jun 2006
Posts: 48
h_baan_ln6 is on a distinguished road
Baan: LN6 - DB: oracle - OS: NT

Either thru exchange scheme or by making account type as BS and then again PL

Reply With Quote
Old 19th July 2006, 06:18
finwizard finwizard is offline
Junior Member
Join Date: Jul 2006
Posts: 4
finwizard is on a distinguished road
Baan: LN - DB: SQL - OS: Unix
Reverse Op Bal

One possible solution could be - first reverse the op bal of the P&L accounts using Op Bal transaction type, re-enter the op balances in P&L accounts on first day of period 11 using normal journal. Now, standard report / process would consider these op balances as normal transactions and the closing bal would be calculated accordingly.

Reply With Quote
Sponsored Links

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
how to get the opening balance in BAAN VC ncgjiju Tools Development 3 6th October 2005 11:49
tfgld3203m000-Rebuild Opening Balance/ History from Transaction Student Finance, Invoicing and Integration 2 31st May 2005 05:55
Adjustment Orders (opening balance) faditimo Distribution, Transportation & Warehousing 8 3rd March 2004 09:10
when Can I input the transaction with category of opening balance? armiewei Finance, Invoicing and Integration 13 14th February 2003 00:51
Ledger Opening Balance incorrect kamran Finance, Invoicing and Integration 4 22nd January 2003 19:04

All times are GMT +2. The time now is 21:11.

©2001-2018 - -