Unable to populate the G/L account text ( description ) in drill down repor

[Former Member]

Hi

We have developed the trial balance drill down report from FAGLFLEXT table under 0FL library for company code wise.

The charecters are period,fiscal year & Version and the key figures are HSL ( GLT0 table ).

We are getting only the GL account number in the row ( actual requirement is we need to get the g/l account number and text beside of number ) . Please suggest.

Regards

Venkat

[Former Member]

Please refer to my suggestion in the thread below.

Regards,

Elias

[Former Member]

Hi

Thanks for the reply, this we have already tried. We are preparing the report for the trial balance which consists of the Balance sheet accounts & Profit and loss accounts. The total number of G/L accounts is more than 500. Here under the Charecteristic values we are giving the account number range . We dont want to manually enter the description for all the G/L accounts. The report should automatically populate the G/L account description ( text ) from the range of the G/L accounts such as 10000000-30000000 etc.

Regards

Venkat

[Former Member]

Unfortunately, it does not happen that way. Either group those accounts as sets or you got to enter them manually.

Let me know if you find another means of doing that besides my suggestions.

Regards,

Elias

[Former Member]

Hi

Thanks for your reply again. For example i want to display the G/L account text for the account number 16000001 as Accounts payable how i need to include in the Set Also Can we save the output and make the reports undisplayed that we really donot require Number of reports are shown on the left hand side of the output out of which only one is correct and we wanted to display only one. Please suggest on the above.

Regards

Kiran