We have added search box. Key in SAP issue keyword to search
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

Re: [sap-acct] Balance of Trial Balance is Not Zero

Posted by Admin at
Share this post:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

Reply from Roy B on Jun 4 at 7:03 AM
Running program RFSEPA01 is not so easy as it sounds. Firstly it depends on which version you are using. If you set up a G/L account without line item display and subsequently want to change this, you have to change the master record and then rebuild the line items using RFSEPA01. The G/L account has to be blocked for posting (TCode FS05) during the operation and unblocked afterwards. Note that the program will fall over if there are too many line items, so proceed by document number intervals to be safe.

If you are in a version higher than 4.6B you can not run this program unless you do modifications as per note 0175960 or 210999. Many SAP customers have made a mess of this process. Read also note 67456. What SAP tells you is to make a copy of the original report into ZFSEPA01 and execute that report instead.

The program will run for a very long time if you have lots of items (see above). The first time I ran it (about 10 years ago) for a single account it ran all night (there were 45,000 line items in this one account). OK, that was an older version but on powerful hardware. I was running the program for a French company but our SAP servers were in the USA so there may have been some delays due to the time lag in transmission, but even today the program will not be much faster because of all the checks it has to make. So you need to plan when you are going to run it and break down the GL into bite-sized lumps so you are not tying up the accounts for days on end. After each run you will get a log telling you what has been done.

Then you have to go through the ledger looking for the difference. I would still recommend using the document journal as an additional tool because this shows each document with its debits and credits, and you can trace from there to the GL to make sure the postings are correct, ticking them off as you go. It will take time but you should be able to find the difference this way. Then we can go about fixing it.

Rgds, Roy

mark as helpful.

Roy Brookes FFA, FInstBA,
SAP? Financials Expert
Senior SAP? Financials Consultant
Published Author
Tel: +49 171 268 9635 (mobile)
Tel: +49 40 793 19642 (landline)
email@removed
email@removed
email@removed
Skype ID: roystonbrookes
www.RoyBrookes.com
www.Software-Partner-Solutions.com
www.linkedin.com/in/roybrookes
SAP? Expert Index Registration: CRF **42819*
SAP? Referral Partner for Business One

---------------Original Message---------------
From: Tiger100
Sent: Monday, June 04, 2012 6:19 AM
Subject: Balance of Trial Balance is Not Zero

Mr. Roy Brookes...

Please throw some light on the second point a well:

2) What will be the effects if I run the Program "RFSEPA01" to re-generate line items for the accounts and how and where can I check the effects. Also, what prerequisites we should have.

Thanks in advance...

Regards
Nitin

 
Reply to this email to post your response.
 
__.____._
Manage Settings | Unsubscribe | Create FAQ | Send Feedback
  
Copyright © 2012 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
 
Roy B  
SAP Financials Expert
achievements
 
Mark as helpful
View this online
Ask a new question
 
In the Spotlight
Have an SAP Question? Ask Your Peers at Toolbox for IT

_.____.__

0 comments:

Post a Comment

T r a n s l a t e to your language