Zero balance G/L where to check report

[aamna]

Hi Guys,

For new G/L accounting, i have created zero balance account

I want to check the balances of that G/L in the report format , is their any standard report please let me know

Please even explain about the segment reporting

[sanilbhandari · Accepted solution]

Hi aamna

You should be able to check the balance and line items in FAGLL03/FAGLB03. Ideally the balance in zero balance account will be zero at company code level but profit center or segment level, you will have balances. A simple example:

GL Account 1 PC 1 Segment 1 Dr $100

To GL Account 2 PC 2 Segment 2 Cr $100

This is a journal posted in entry view. However, when you check in new gl view, the same entry would look as below:

GL Account 1 PC 1 Segment 1 Dr $ 100

Zero Balance A/c PC 1 Segment Cr $ 100

GL Account 2 PC 2 Segment 2 Cr $ 100

Zero Balance A/c PC 2 Segment 2 Dr $ 100

Now if you run FAGLB03 at company code level, the balance would be zero, since the contra entries will balance out.

However, when you start looking at PC & Segment level, you will see balances, which at that level would be balanced out by a contra entry in some other GL.

Now to your second question on what is segment reporting, from a pure accounting perspective the definition would be:

Segment reporting breaks down the operations of a company into manageable pieces, or segments

In SAP, profit center and segments are organizational elements represent various dimension on which financial statements are required: It could be represented as line of business, product line or country, market etc, depending on how the organizational structure is defined.

Eg, You have various plants designated as profit center. Now these plants manufacture Product 1 and Product 2. You would than assign the segment in PC Master and you can than have Financial statements based on plants, but also at product level. This would be the simplest example.

Hope this helps

Thanks & Regards

Sanil Bhandari

[aamna · Accepted solution]

Hi Sir,

While executing FAGLL03 i am getting this error message

Account 19999, company code 1300 is clearing account

Message no. MSITEM111

Diagnosis

You have stored account 19999 in company code 1300 as a clearing account. At the same time, you use line item management with this account.

System Response

Error message issued because line item display cannot read data for an account in a ledger if line items exist partially in the entry view together with clearing items for which there are no line items. In such cases, only the data with line items would be selected.

Procedure

Check the Customizing settings or account control. Change the settings so that only automatic postings without line items can be made to the account, or select a different account as the clearing account.

n my settings i have already marked as post automatically only, but still cannot view the line item display

While executing FAGBL03 i am getting this error

if we double click on any month we are getting this message

I actually want to see the line item display of this account

[sanilbhandari · Accepted solution]

Hi aamna

You will not have line items details in this GL in entry view. That is why line item display is not valid for this GL. You should remove the line item display in the GL Master. Than you should be able to get the display in New GL View. Also if you will try to deactivate line item view in GL master, the below OSS note would need to be considered on how you can actually do that.

https://launchpad.support.sap.com/#/notes/2243831

Thanks & Regards

Sanil Bhandari

[aamna · Accepted solution]

Hi,

Our client is using ,HANA system where line item dispaly indicator is mandatory

Please suggest any report in HANA system where we can see line item display of zero balance

[sanilbhandari · Accepted solution]

Hi aamna

I do not understand what do you mean by HANA System. Are you on S/4HANA or Suite on HANA? Both of them are different since the underlying architecture is also different. A suite on HANA is an ECC system with underlying data base as HANA and S/4HANA is a different ERP.

Did you try to execute FAGLL03 with a GL view, rather than Entry view? If you are running FAGLL03 in entry view, you will get an error. The selection parameters for entry view look as below:

The selection parameters for New GL View look as below:

You should run FAGLL03 as shown in the second screen shot above. The reason is, because you will not have postings to zero balance clearing account in entry view and entries specific ledger will exists only in FAGLFLEXA/FAGLFLEXT if you are on ECC (Suite on HANA or ECC with any DB with New GL) and in ACDOCA if you are on S/4HANA.

If you still have issues in running FAGLL03, please also insert screen shot of each tab of GL Account for zero balance clearing account as well as entries from SKB1 table for the company code with specific focus on line item display indicator. Also confirm if you data source for running the report is only existing transactional data and not from Archieve.

Thanks & Regards

Sanil Bhandari.

[aamna · Accepted solution]

Hi Sir,

Client is using S4HANA

While executing FAGLB03 this screen is been displayed

we are getting this error

If we press on question mark we get this error

[aamna · Accepted solution]

If we press on question mark we get this screen

SKB1 screen has Line item display activated

[aamna · Accepted solution]

ACDOCA has values for the G/L account of zero balance

[sanilbhandari · Accepted solution]

Hi aamna

Can you run the report FAGLL03 for GL View using the radio button of all items, rather than open items and than check?.

Thanks & Regards

Sanil Bhandari

[aamna · Accepted solution]

Hi ,

If we keep radio button on all items also no values are displaying

same error as above image is been displayed

[sanilbhandari · Accepted solution]

Hi aamna

Can you share the initial selection screen of FAGLL03, that you used as well as screen shot of GL master for zero balance account under the control tab? Also share the SKB1 screen shot, which shows the line item display as active for the GL Account? Please also share the initial selection screen of FAGLB03.

If you use FAGLL03 with entry view, it will not show any line item. You have to run the report using GL View.

Thanks & Regards

Sanil Bhandari

[aamna · Accepted solution]

Hi,

Initial screen of FAGLL03 which i used is after which i got error

GL master screen of same G/L account

[aamna · Accepted solution]

SKB1 screen of G/L master activated line item display

[sanilbhandari · Accepted solution]

Hi aamna

The error is happening since you have made zero balance clearing account as open item managed. It should not be the case. You can have zero balance clearing account as line item managed, but not as open item managed. From an accounting perspective as well, there is no clearing involved, where you are paying off a liability or getting a payment against a receivable that you need clearing to happen on line item in this account. Technically, this account will not create any entries in BSEG, but only in ACDOCA. I have referenced the GL from one of our internal systems and you see the set up

Now if I run FAGLL03 in entry view for this GL, i get the same error as yourself

[sanilbhandari · Accepted solution]

In New GL View

[sanilbhandari · Accepted solution]

So if you set up zero clearing account with line item display and without open item managed, it should work with line item display. I was also able to run line item display through FAGLB03 as well.

Hope this helps

Thanks & Regards

Sanil Bhandari

[aamna · Accepted solution]

Hi

Thank u for ur answer will check with our client and let u know about zero balance account

[aamna · Accepted solution]

Hi,

I have checked other client in which clearing account was not open item managed

But still while executing FAGLL03 for the same account for all items radiobutton i am getting the same error as previous

[sanilbhandari · Accepted solution]

Hi aamna

Please also include the initial selection screen of FAGLL03 for the new client? Also is it on New GL under S/4HANA or is it an ECC System (Suite on HANA or ECC with other DB). You should include as much details as possible in one go !

Thanks & Regards

Sanil Bhandari

[aamna · Accepted solution]

Hi Sir,

Other client is ECC with sybase as the database

intial screen of FAGLB03 Screenshot

i am getting the Same error as previously shared in screenshots

[sanilbhandari · Accepted solution]

Hi aamna

Do you have document splitting active in this system on ECC ? Also what is the version of SAP_APPL application component?

Thanks & regards

Sanil

[aamna · Accepted solution]

yes document splitting is active in ecc system

[aamna · Accepted solution]

SAP versions

SAP versions 740, 750, 751, 752, 769

SAP_APPL 618

[sanilbhandari · Accepted solution]

Hi aamna

I would suggest to raise an incident with Product Support for the issue in ECC system. The below OSS Note clearly mentions the set up of master data for zero balance clearing account both for ECC and S/4HANA.

https://launchpad.support.sap.com/#/notes/961937

The set up of zero balance clearing account in your S/4HANA System is incorrect and it needs to be changed. Once you change that you should be able to display the line items in FAGLL03 or FAGLB03 as I already showed with screen shots earlier.

Thanks & Regards

Sanil Bhandari

[aamna · Accepted solution]

Hi Sir,

Thank u for your suggestion.

[former_member698447]

Hi Aamna,

Transaction Code: S_PL0_86000028 which is SAP standard report. If that doesn't show any value then there no balances in Zero Balance account.

Best Regards,

Repakula Manoj

[aamna]

Hi Sir,

My client the are not using this report for financial statement versions