line item display

[Former Member]

Using T code FBL3N i can't see the balance and posting of general ledger xxxxxx payables from group companies . This account has been assigned to vendors code YYYY and Xyz during 2014 in April. I need to see balance and posting done as per balance sheet (S_ALR_87012284 - General -> Actual/Actual Comparisons -> Financial Statement ).

Thanks

[João_FI_FIN-CS · Accepted solution]

Hi Majo,

Try to use the S_ALR_87012332 report. This tcode will display the GL, AP and AR. But if you selected this account for GL option the report won't display because for these items from vendors you've to check in the subledgers as Eli already said.

In case if this account don't has the flag 'display line items' in data master, the items will display in the output report like a FBL1N.

The flag use the program RFSEPA01 to post the items just in the BSIS and BSAS tables e.g GL view. And not for the AP and AR views.

JPA

[iklovski]

Hi,

I don't get your point. If you say that the account is assigned to vendors, do you mean it is reconciliation account? And if 'yes', why would you expect line items in FBL3N?

Regards,

Eli

[Former Member]

Hi

The user need to know document and it is used in exchange rate differnce oba1

Thanks

[iklovski]

How is it linked to vendors? Please, specify for which account are you running report providing screenshot from FS00.

[Former Member]

Its an Recon account for foreign vendors

[iklovski]

If it's reconciliation account, it is obvious that you don't see items via FBL3N.

[Former Member]

But i can see line item display for other recon accounts?

Thanks

[iklovski]

Reconciliation accounts should not be even defined as line item managed: this does not make any sense. You can see the items via sub-ledgers.

[former_member198650]

Hi Majo,

Check the GL in FBL3N, by selecting all items options as shown in the below screen shot.

Regards,

Mukthar

[Former Member]

hi

i did that but didnt got line item

[Former Member]

Dear Majo,

I have gone through your communication on this topic. Just wanted to understand one thing whether the Line Item Display tick edited recently for this account? or its from the begining when you create the GL Master ? Can you please check the Master Data Changes for this GL account from Tcode FS04?

Regards,

Sachin

[Former Member]

Hi

I checked in fs04 line item display is changed on 21/1/15.so what we do for getting those documents previously posted?

Thanks

[Former Member]

Dear Majo,

Its not possible to view the Line Item details from FBL3N for this account which was posted prior to the changes. I can suggest one workaround for you.

As per your requirement (if I correctly understood) you need to see the details for the GL account which was appearing in the report S_ALR_87012284 - General -> Actual/Actual Comparisons -> Financial Statement which is nothing but the Trail Balance as on balance sheet date. If you want to see the details then go to FBL1N T Code and enter the Company code and balance sheet date ( without Vendor Number) as shown in the below screen shot

The above selection gives you the whole list of Vendor Open Item then select the G/L account field in from Change Report layout as per below screen

After that do the SubTotal on the G/L Account Column and you will find this Total will match with your GL Balance as on Balance Sheet Date.

Hope this will help you.

Regards,

Sachin

[former_member198650]

Hi Majo,

Have you checked the GL account whether line item display check box selected or not? If not, then it won't display any line items in FBL3N and also not update the details in BS* tables.

Regards,

Mukthar

[Former Member]

Hi all

I checked in fs00 line item display is ok, and this account which is maintained in oba1

Thanks

[Former Member]

Send the FS10N and FBL3N screen shots for that GL account...

Regards

Message was edited by: svamsi amarambedu

[Former Member]

[Former Member]

please check the fbl3n attachments

[Former Member]

Hi

check the FS10N and FK10N

or check the table

BSIS,BSAS and BSIK and BSAK

Regards

[Former Member]

Hi

I checked in fs10n value is there but in bsis table no value and also in fbl3n no line item is displayed

Thanks

[Former Member]

if it is showing the FL10N transaction...it show at table level..BSIS and BSAS....

And also check your authorization level for transaction FBL3N...plzs check parked  check mark....