cancel
Showing results for 
Search instead for 
Did you mean: 

Is possible date wise trial balance in sap

former_member481693
Participant
0 Kudos

Hello,

Is it possible date wise trial balance in sap, for example trail balance as on 20.06.2010.

Please provide your inputs

Thanks,

Ratnam

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Date wise trial balance can be created using report writer tools. Have done this for my clients.

Following activities have to be done:

Install table FAGLFLEXA using t.code: GRCT

You can do this by copying FAGLFLEXT, after copying, add additional fields like posting date, value fields like balance carryforward etc.

Create a report library using t.code GRR1 and reference the table FAGLFLEXA or FAGLFLEXT

Create a report under the library created above

Using report writer or report painter you design the report same as F.08

Let me know your email id, will provide the detail screenshots.

Thanks,

Sharif

Former Member
0 Kudos

Hi Syed,

can you please explain in more detail  or attached document here . I do not think we can give mails ID here which is not permitted on SCN forum .

many Thanks

Former Member
0 Kudos

Hi,

Please see the link, just created the document

http://scn.sap.com/docs/DOC-33486

Thanks,

Sharif

ravichandran_iyer
Active Contributor
0 Kudos

If you are using standard report for Financial Statements, you can try the 'Calendar reporting period' field in the 'Special Evaluation' tab.

Ravi.

former_member481693
Participant
0 Kudos

Hello Ravi,

Thanks for your reply!

Client wants date wise trial balance not periodic basis.

Thanks

Ratnam

Former Member
0 Kudos

Hi

It is as Ravi said. Use S_ALR_87012284, click on the special evaluations tab in the middle of the screen. Tick the option 'Alternative period selection and put in the date range for the current time period and the comparitive as you want it.

Kind regards

Dawn

former_member481693
Participant
0 Kudos

Hello Dawn,

Thanks for suggestion!

user is comparing trail balance report with FBL3N report but it is not matching with trail balance S_ALR_87012284. Is there any alter native way to get trail balance with date wise in the mid of the month.

Thanks,

Ratnam

ravichandran_iyer
Active Contributor
0 Kudos

FBL3N is not a Trial balance report. Its only a transaction listing report. FBL3N does not include opening and closing balances for the period. Your TB and FBL3N will not tally unless your opening balance is zero for all the accounts for the reporting period.

former_member481693
Participant
0 Kudos

Hello Ravichandran,

Thanks for your reply! I have given you points.

I will discuss with my user regarding this.

Thanks,

Ratnam