GL Line item display with dynamic selection profit center

[Former Member]

Hi all,

We are trying fetch a line items for a particular GL (which is Petty cash GL) for a profit center by using dynamic selection.

When we ar doing in FBL3n its giving error as "No item selected "

Note:-

1) There is line item diplay checked in FS00  2) Not an authoization issue, Since we are able to fetch for other company code  3) Values are there for that profit center, when we see FS10n

Only with one company code and that profit center we are not able to fetch line item with profit center as dynnamic selection, What could be the reason.

Please help.

[MuhammadArsalan]

Hi Daya,

If new GL & document splitting is active then use FAGLL03 for line item reports & FAGLB03 for balance report.

If New GL & document splitting is active then in FBL3N report (which is "line item" report) there may be line items without profit center so are not selected as this report is extracted from line item tables. However, FS10n is balance report and is extracted from total table.

I hope this information will be helpful for you.

Regards

Muhammad Arsalan

[Former Member]

Hi Muhammad,

Thanks a lot...been a great help..That was the problem.

[Former Member]

Please suggest on this how can it is possible

[Former Member]

Hi Daya,

Are you able to execute that GL without putting profit center in dynamic selection through FBL3N?

Regards,

Kalim

[Former Member]

Hi Daya,

Why are you putting profit center in dynamic selection?

You can find profit center field in report layout itself once you execute FBL3N.

Regards,

Kalim

[former_member270407]

Hi Daya,

do you use any validation as mentioned at below snote

1904268 - No authorization check for Profit Center in posting transactions

Symptom

There is no authorization check on the field Profit Center in posting transactions.

Environment

• Financial Accounting

Cause

Due to design, FI transactions make no authority check on the field Profit Center in the standard. Reason for this is that there are many account assignment objects in controlling and FI does not know which controlling objects are used by the customer. Due to this and due to performance issue no CO-authority object is checked in FI transactions. Profit Center is only checked if you run a PCA-transaction.

Resolution

This is the intended system behavior.
In SAP standard there is no general solution available but you can use the validation in FI (transaction OB28). Here you can program a user-exit. In this user-exit you can call the function module for the PCA-authority object K_PCA. The function module is K_PCA_RESP_AUTHORITY_CHECK.
The parameters are:
I_KOKRS        controlling area
I_PRCTR        profit center
I_VORGN        'PRC5'
I_ACTVT        '76'

Then the user needs the same authority like in transaction 9KE0 for creating PCA-documents. Please use transaction code SU24 to check the relevant authorization objects for each transaction and the F1 help of the fields available in the list. Please also refer to transaction code SU03 to check the documentation for each object to review how authorizations can be configured.

Keywords

authority, posting document, FB01, FB03, FBL3N, PRCTR, BSEG-PRCTR, Berechtigungsprüfung, Berechtigung

Best Regards,

[Former Member]

No Such authorization, since we are able to fetch for other company codes.

[former_member270407]

hi daya,

also , try following snote

1649564 - FAGLL03: Authorization for K_PCA not for company code

it may be a program error.

first check your sytem patch level,

Support Packages & Patches

Support Packages
Software Component Release Support Package SAP_APPL 602 SAPKH60211 603 SAPKH60310 604 SAPKH60411 605 SAPKH60508 500 SAPKH50027 606 SAPKH60603 600 SAPKH60022

if it is below from those levels,so implement the snote,

Symptom

General Ledger Accounting (new) is active and you execute the line item display FAGLL03. The authorization check at company code level for the profit center returns an incorrect result or no result at all.

Other Terms

FAGL_ACCOUNT_ITEMS_INC, FORM ITEM_CHECK_AUTH, K_PCA

Reason and Prerequisites

There is a program error.
The company code information is not transferred to the check module.

Solution

Implement the attached correction instructions in your system.

best regards,