Trail balance Posting date wise .

Hello all,

My Cleint want trail balance Date wise reporting.

We had done go live on 27.11.2011

They want a reporting of that date .

I am trying in F.01 ,

In special evaluation there is option of

Alternative period selection here I am giving date : 27.11.2011

but there are giving whole month reporting.

As include posting of 28-30 th nov.

PLs reply is too Immediatte

SAP Managed Tags:
SAP ERP,
FIN (Finance)

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (5)

Did anyone face performance issue on these reports? Please advise if there is any way out to handle it.

regds,

Egor

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hello,

The document has been removed from the link. Can anybody please upload the document again?

I have similar requirement of creating financial statemtns by posting dates.

Regards,

Rahul Kulkarni

Hi,

Please check this link

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

Thanks,

Sharif

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Sharif,

This is a very good doc on trial balance report. However, I have got some error while configuring.

In t.code: GRR1...........

click on Column 2.......Select the Document local currency – actual (BHSL-I)

Not sure on this (BHSL-I). I would be obliged if you could explan me of how to go through this.

Even, col 3 & 4, have the same.

I have tried considered, the same, UMSAV and also, Doc. Local curr (Actual), however, while selecting the posting date, RFDATE1 & RFDATE2, are not picking up.

I guess I have to configure in GRCT > BASIC KEY FIG.

Correct me in my understanding. If this is the correct way, pls, lemme know what would be the table and value fields to be updated in this, thanks.

Thanking in Advance,

Raghav.

bluishrags@gmail.com

Hi Raghav,

Please dont skip any of the steps described in the document. They are in sequence.

The first step is to add the posting date (BUDAT) under special characteristics and Balance Carryforward (UMSAV) under Basic key figures in t.code GRCT.

You need to create variables RFDATE1 & RFDATE2 in t.code GS11.

However request you to please follow the document as-is. DO NOT SKIP any of the step.

Thanks,

Sharif

Hi Sharif,

Thanks a ton for your timely rply with a doc. I have configured & report is getting generated.

Thanks,

Raghav.

Hi Sharif,

Greetings for the Day,

The report is perfect, however, I would like to add few more in selection criteria.

Say like, I need to have a report from Jan`2012 till Dec`2012.

In my selection criteria, I need to run this report twice to get the data.

Need to run for CURR FI YR: 2011 >> CURR DTS: 01.01.2012 to 31.03.2012 & the other report with CURR FI YR: 2012 >>> CURR DTS: 01042012 to 31.12.2012.

I would be highly obliged if you could suggest me on this. I need a single report from Jan`2012 till Dec`2012.

Thanking in Advance,

Raghav.

Hello Raghav,

Remember only single entry option is made for Fiscal year in Selection Screen to avoid inconsistent data output. therefore the report can be executed only for any given single Fiscal year.

However, the option you need can be done by adding additional columns and additional variable for Fiscal year.

Thank you,

Sharif

Hello Sharif,

Pls help me, in GRR1,when i double click on the column, I am unable to find the Bal Carryf Fwd or UMSAV in the basic key figure list. I have checked all the GRCT configurations etc, but cannot find the error.

Pls let me know any possible area I might have missed out.

best regds
Subha

Hi Subha,

Ensure UMSAV is selected in Basic Key Figures against the library created in GR22.

Thanks

Sharif

Hi,

have checked the UMSAV in GR22, however its still not appearing in GRR1.

best regds

Subha

There is no way that field UMSAV is not appearing. Ensure you are creating the report under the library which you have selected this key figure.

You are correct!! checked all the initial set up and found to have taken a wrong table. rectified now.

Many thanks!

Hi,

tried so many times. the report runs but then it hangs. any suggestion on the possible cause ?

best regds

subha

Hi Sharif,

I have got one more query.... this is for customer due dt analysis....

S_ALR_87012078: Due dt analysis for vendor open items.

the same being FDI1: Line item....

I got the report, which is perfect, however, when I click on the 0-30.. bucket, I need to have the line items been displayed. How to modify this report. Any ABAP support, pls help me in this.

Also, does this S_ALR_87012078, include both normal and spl (A), items ?

Thanking in Advance,

Raghav.

Hi,

on the below screen shot,kindly help me know what are the values I'll have to key in for the items in red.

best regds

Subha

Hi Subha,

Please fill in the following:

Ledger: 0L

Record Type: 0 & 2 (at the corner you will find right arrow button, click on that to add one more value)

Version: 0 (it depends on your settings at client level).

Request you to make it your email id visible in your profile.

Thanks,

Hi,

thanks. Last time i executed the report, it hanged, this time i got the foll error.

"No selections for program GP0H1UTUBC8RCQ7V2VO47ESG5K9800

Message no. DB259".

Pls advice.

best regds

Subha

I got the same error .while i did try to create same report . I just copied the FAGLTEXT table instead of using standard as SAP always Advise " DO NOT DELETE OR CHANGE SATANDARD SAP "

Interested to know the solution of this error

Many Thanks

Hi Preeti,

so r u suggesting I should change FAGLFLEXT to FAGLTEXT ?. If so, where and how ? . pls help me.

best regds

Subha

No I am not suggesting any thing . I am saying that I am facing same problem and What i did when I created the report .

Many Thanks

Hi Raghav,

By default these reports executes in graphical report-output which is confusing for the end users

Therefore execute the report in Classic drilldown, to have that options

In change mode (FKI2 or FDI2), select the report 0SAPDUEAN-01 for open items, you better copy these reports.

go to output type tab, Select "Available on Selection screen"

Execute the report in Classic drilldown report

Place the cursor on required aging bucket and press Ctrl+Shift+F3, you will have options for balances and line item report

You can select Special GL indicators from dynamic selections on the selection screen or include this field in characteristics tab.

Raghav: Create new thread for new queries, to avoid confusion.

Thanks,

Sharif

Hi,

This error says you have to enter correct input parameters.

For e.g.

FY: 2012

CoCd: 1000

Previous dates: 01.04.2012 to 31.05.2012

Current dates: 01.06.2012 to 26.11.2012

Thanks,

Sharif

Dear All,

my report is up, but now i am getting the following error .

"Company code XXXX is not assigned to an FM area"

pls help me on this last bit.

best regds

Subha

Sharif,

pls let me know on the logic of dates we are using. if i have to generate TB for sept any date (period 6th), then how should i place the date on the report parameters.

Subha

It will be:

FY: 2012

Previous dates: 01.04.2012 to 31.08.2012

Current dates: 01.09.2012 to 26.09.2012

Thanks,

Sharif

Hi Sharif,

Thanks for your timely rply, this is working.

Thanks a ton. Yes, would use different threads for different queries, apologies, thanks.

Thanking in Advance,

Raghav.

Date Wise Financial Statements

Hi Sharif,

Greetings for the Day,

I have a very small doubt in this.

While creating the BASIC SET in GS01: say CALLED.... here we are giving FROM VALUE as 50000 - CALLED UP CAPITAL NOT PAID.

Can you explain me on this.

Is this 50000, which we give here or the one we have to pick from GL (FS00) ??

Since, this calledup capital I cannot find in my GL (FS00).

Similarly all, the other BASIC SET`s aswell ?

Also, can we take all the GL`s available in my comp code instead ?? if so where ??

Please suggest, thanks.

Thanking in Advance,

Raghav.

My friend,

Those are all examples. You need to create sets according to your financial statement version.

Hi Sharif,

I need the document for "trial balance posting date wise". The link that you mentioned is deleted.

So kindly provide the doc as i need it urgently. You can mail me the same.

erp.varun@gmail.com

Thanks & regards,

Varun

Thanx for ur reply

I am trying the same .

But i am getting the balance of 30.11.2011

I am giving the date 27.11.11 there...

Plss reply ...............

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

You enter FROM date and TO date as 27.11.2011 in the date specifications under special evaluations

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Expert,

You have an option to Select Calendar reporting period and Comparison calendar period in T-Code: F.01 by Selecting in Special Evaluations Tab(Mention the Date From and To Intervals)

Regards,

SAP

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Ask a Question

Top Q&A Solution Author

User

Count

108