Baanboard.com

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

User login

Frontpage Sponsor

Main

Google search


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

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 17th August 2006, 13:39
baan_slmf baan_slmf is offline
Junior Member
 
Join Date: Nov 2005
Posts: 15
baan_slmf is on a distinguished road
Baan: IVC4 - DB: ORACLE - OS: WIN2K
Opening Balance
Baan: Other/Unknown

Hi All,
Being a novice person in Baan IV Finance I need some help regarding entering of opening balance,Due to some problem we could not complete data enteries of fiscal year 2005-06 and now we 've decided to enter new opening for fiscal year 2006-07,Can somebody tell me should we start entering opening balance by leaving the previous year data as junk as we can not put efforts in deleting the previous year data we just want to leve it as it is.Kindly advice me at the earliest ,Is there any technical difficulties in re-entering opening balances even if previous year data is there and closing is not done?


Waiting for a reply desperately.

Reply With Quote
  #2  
Old 17th August 2006, 13:55
h_baan_ln6 h_baan_ln6 is offline
Member
 
Join Date: Jun 2006
Posts: 48
h_baan_ln6 is on a distinguished road
Baan: LN6 - DB: oracle - OS: NT
Hi

NOT ADVISABLE...

This will lead to inconsistency in the system.....

Further it is not possible to set current year as 2006-07 without closing previous year..

What I advise.. get the balance for last year... pass correction entry in worrection period to ensure required closing balance...

Do the junk work in last year so that opening comes correct...

Regards,

H
Reply With Quote
  #3  
Old 18th August 2006, 09:24
baan_slmf baan_slmf is offline
Junior Member
 
Join Date: Nov 2005
Posts: 15
baan_slmf is on a distinguished road
Baan: IVC4 - DB: ORACLE - OS: WIN2K
Instead of entering the opening balance....

Thanks for the prompt response...

Instead of entering the opening can we enter difference at the end of the year and close year 2006-07 even if 2004-05 and 2005-06 are still pending for final closure.

Kindly revert back at the earliest...


Regards.
Reply With Quote
Sponsored Links
  #4  
Old 18th August 2006, 12:28
h_baan_ln6 h_baan_ln6 is offline
Member
 
Join Date: Jun 2006
Posts: 48
h_baan_ln6 is on a distinguished road
Baan: LN6 - DB: oracle - OS: NT
Hi

Even 04-05 is pending !!!

well you will have to close all years....

then in 05-06 get the closing balnce as per system entries. Then enter correction JVs in the correction period to get the required closing..


But frankly .. the situation there is really bad... get an expert to look into ur system and then advise...

but as a bottomline avoid any GTM activity...

Regards
Reply With Quote
  #5  
Old 19th August 2006, 08:21
reghuks reghuks is offline
Junior Member
 
Join Date: Sep 2003
Location: Bombay
Posts: 19
reghuks is on a distinguished road
Baan: BaaN IV - DB: sql - OS: NT
If you have a correction period you can do like below
close all transaction and period till 12 th period and get a trail balance of the same do correction entries in correction period .In the case of debtors and creditors use debit note + or _ entries and match the same.

Reagrading open orders short close all orders
regarding inventory use cyclecount or inv adjustments to tally with correct inventory in hand
Then close the year using standardard functionality of baan
the correct opening balance will be carried in next year

reghu
Reply With Quote
  #6  
Old 21st August 2006, 09:22
baan_slmf baan_slmf is offline
Junior Member
 
Join Date: Nov 2005
Posts: 15
baan_slmf is on a distinguished road
Baan: IVC4 - DB: ORACLE - OS: WIN2K
Can i keep my purchase orders/sales orders/RPL untouched?

Thanks for u'r valuable inputs.

I need some more clearity regarding distribution also,As we are having single logistics multi finance setup and ILC contol implemented do i 've to clear my pending purchase orders and sales orders too.

I am following the below mentioned steps for doing the same for closing:
1. Clearing all integration related errors
2. Re-build dimension/Ledger /Opening Balance history
3. Closing of all the periods and JV's in the correction period
4. Reconcilation of trial balance with manual records.
5. provisional closing of fiscal year
6. closing of correction period followed by final closing
7. Inventory adjustments on need basis.
8. Trial balance as on 01/04/2006 for checking the opening balance.

Pls review the above mentioned steps,Kindly advice if I'm missing anything.


Do you have any documented procedure with you for closing in finance and distribution as well? Pls. do share if possible.

We are using Distribution and Finance module in Baan IV .

Waiting for a response.
Reply With Quote
  #7  
Old 21st August 2006, 14:22
reghuks reghuks is offline
Junior Member
 
Join Date: Sep 2003
Location: Bombay
Posts: 19
reghuks is on a distinguished road
Baan: BaaN IV - DB: sql - OS: NT
Smile opening balance

Yes all of your steps are right.
after doing provisional closing do one more exercise that
In baan finance there is a session to c/f the opening balance even with out final closing the difference will go in some control account only.That session is under finance provionsal close from that also you can find all the op balance for the next financial for talling.If it tally then you can have the final closing as you said.Please take the back up before final closing (data).You have mentioned wrongly that your company is single logistic multi finance it may be other way round single finance multilogistic.

Please check the pening work of logistic company.I hope the table related to item, inventory, finance integration etc may be shared if not then check any pending also.

I hope your problem will be solved by doing this

reghu
Reply With Quote
  #8  
Old 21st August 2006, 14:30
h_baan_ln6 h_baan_ln6 is offline
Member
 
Join Date: Jun 2006
Posts: 48
h_baan_ln6 is on a distinguished road
Baan: LN6 - DB: oracle - OS: NT
check out this link

http://www.baanboard.com/baanboard/s...ad.php?t=14009
Reply With Quote
  #9  
Old 24th August 2006, 11:16
baan_slmf baan_slmf is offline
Junior Member
 
Join Date: Nov 2005
Posts: 15
baan_slmf is on a distinguished road
Baan: IVC4 - DB: ORACLE - OS: WIN2K
MIne is Single Logistics and Multi Finance

Hi Rahhuks,
Mine is Single Logistics and Multi Finance..any problem with the same ,Pls. brief me again if any changes are required in the steps mentioned by me.

Pls. revert back soon.

Reply With Quote
  #10  
Old 24th August 2006, 12:09
reghuks reghuks is offline
Junior Member
 
Join Date: Sep 2003
Location: Bombay
Posts: 19
reghuks is on a distinguished road
Baan: BaaN IV - DB: sql - OS: NT
op balance

The steps is correct even for single logistic multifinance.

please take up full data back up and system back up after closing ok

There is no other solution for this type of problem .

The second solution is there (SOS)

If you do not have to refer the old transaction you can do re implementation from start
cleaning all data and creating new set up.
If you have time and resourse you can do.Masters you can dump from old set up that will avoid creation of master.

But do the same with good tool and function experts.other wise while transfering the master some tables you have to run correction.

I hope it is clear to you

regards
best of luck carry on.. other wise how many day you spend in confusion????

reghu
Reply With Quote
  #11  
Old 24th August 2006, 12:23
baan_slmf baan_slmf is offline
Junior Member
 
Join Date: Nov 2005
Posts: 15
baan_slmf is on a distinguished road
Baan: IVC4 - DB: ORACLE - OS: WIN2K
I think first solution is better in my case!

I'm following up with the first solution,Thanks for u'r prompt response.I'll update you once i receive the correct balances for 2006-07.

We 've started working on clearing the integration log as we are having several companies and lot of purchase/sales data.It will take sufficient time.


Thanks again.

Reply With Quote
  #12  
Old 25th August 2006, 11:07
baan_slmf baan_slmf is offline
Junior Member
 
Join Date: Nov 2005
Posts: 15
baan_slmf is on a distinguished road
Baan: IVC4 - DB: ORACLE - OS: WIN2K
Need u'r inputs!

Dear Reghuks,
I need one more suggestion from u'r side ,Can we do one thing as nullyfying the ledger accounts/Dimension by passing contra enteries and making closing balance as zero and than we will enter opening balance for the current year as we've previous year's Trial Balance and Balance sheet already prepared in manual system and we don't want Baan IV Finance data for previous years.

One more suggestion i would like to have from u in this regards ,which all reports other than Trial Balance I should check for zero or new opening balance for the new fiscal year,Kindly give details .

Any special treatment for Bank,Supplier and Customer Balance?

Thanks in advance.

Reply With Quote
Reply


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
Problem in Opening Balance learn_ln6 Finance, Invoicing and Integration 3 19th July 2006 05:18
how to get the opening balance in BAAN VC ncgjiju Tools Development 3 6th October 2005 10:49
tfgld3203m000-Rebuild Opening Balance/ History from Transaction Student Finance, Invoicing and Integration 2 31st May 2005 04:55
Adjustment Orders (opening balance) faditimo Distribution, Transportation & Warehousing 8 3rd March 2004 08:10
when Can I input the transaction with category of opening balance? armiewei Finance, Invoicing and Integration 13 13th February 2003 23:51


All times are GMT +2. The time now is 05:32.


©2001-2018 - Baanboard.com - Baanforums.com