FBL5N Report Profit Center, material & Qty not updated

[pranav_gupata]

Hi Expert,

We are facing problem while view the Customer Line item details T.Code FBL5N, in this report Profit Center, Material and Qty Field not updated.

see the below screen shot.

[Marssel700 · Accepted solution]

Pranav,

you have 2 requirements:

1 - Profit Center

2 - Material / Quantity

1 -

According you scenario the Profit Center is assigned in P&L line item. How could you have it in FBL1N since it only concerns vendor line items? You can do that by User Exit or BTE.

2 - Material/Quantity was disabled in FBL1N since funcionality activation of multiple P.O per single Invoice. In this case you can have one Vendor Invoice related several materials master. What you can do is a development in order to check P.O and Invoice to fill Material field in anothe FBL1N field regarding defined criteria.

Best Regards

[pranav_gupata · Accepted solution]

Honable Sir,

Thanks for reply

i need in FBL5N not in FBL1N...

in FBL5N customer line item report... here if we select Profit Center, Material and Qty... from selection Layout... Field is Blank.. no values update in All three Fields... we are facing last 10 days for Fetch the Value...in Profit CEnter , Material as well Qty. we  Believe that. in NEW-GL activation we can see. But our Customer Not Using NEW-GL.. ECC6 is there but still not Activated..

for SD point of View.. Product is only one not multiple Products... as you said.in one Bill Number of Product... but my Customer at the Billing only Product...

Kindly help me sir... its very urgent.. to prepare Balance Sheet..

Kind regards

Pranav Kr. Gupta

SAP FICO Consultant.

[Marssel700 · Accepted solution]

Pranav,

Please Check Below Note:

There is no possibility to enter profit center on vendor/ customer lines, this is standard design.

In standard system profit center field is not available in screen for vendor/ customer lines. It is independent from the field status setting. You can only input profit center for GL accounts (mostly cost and/ or revenue).

In classic G/L, profit center is for accumulating cost and calculate profit, so only P/L account is allowed to enter PRCTR. This is not an error in the program, but the standard system behavior. This function is available if new general ledger accounting is active.

1856013 - Profit Center field for vendor and customer transactions

You have to develop a substitution user exit or BTE to fetch this values into another Document fields. This is your only way using classic GL

Regards

[pranav_gupata · Accepted solution]

Thanks A lot Marssel,

Problem Resolved , now we can see the FBL5N report with Profit Center, Material and Qty  all three field value fetching...

Thanks a lott...

Kind regards

Pranav Kr. Gupta

SAP FICO Consultant

[shinas_rh]

Hi,

Try FK10N and see the line items..

As per my Understanding , you can see the same in FAGLL03 and Select Customer recon Account.

FBL1N and FBL5N not possible, I don't think so Sir

Regards

Shinas

[Former Member]

Dear Pranav,

all Fields you can get from FAGLL03, if any fields are not there you need to add fields by defaulf you will get profit center and qty fields and for material you need to add field.

Thanks

Sada Bandla

[pranav_gupata]

Hi Sada,

Very Good morning,

thanks for reply, how to do this  get from FAGLL03.. i have typed FAGLL03 ... this t.code for GL... i want to see the Customer Line item FBL5N... in FBL5N Profit center, Material and Qty is there after select Layout... after selecting these field not updated showing Profit Center, Material Name and Qty as well.

Kindly help me.

Kind regards

Pranav kr Gupta

SAP FICO Consultant

[pranav_gupata]

FYI.

We are not Using New GL...

Thanks

Pranav

[shinas_rh]

FAGLL03 is for New GL...

[pranav_gupata]

Thats wht...

i have post the same .

we are not using NEW GL. Only ECC6.

kindly tell me, wht should i do for display Profit Center Material No. and Qty.. in FBL5N customer line item..

Kind regards

Pranav Kr.Gupta

SAP FICO Consultant.

[shinas_rh]

Dear Pranav,

In FBL1N or FBL5N, you can bring Profit  Center only by activating BTE.

BTE 1650.

In FAGLL03, You can mention ur Reconciliation account and then in the additional filed selection, select Material or Vendor.

If you are not getting this filed in Layout, then you need to add the same in SPRO.

Its Cross Client settings.

Regards

Shinas

[pranav_gupata]

Dear Shinas,

Sir, as i told you we are not using NEW GL.

and how can i activate BTE.... kindly tell me the stap by step so that. immediately resolve the issues...its urgent Sir.

Yr Quick action will be highly appreciated.

Kind regards

Pranav

[shinas_rh]

Dear Brother ,

Somewhere u have mentioned EHP 6, so i thought u are using new GL. Its My muistake.

Regarding BTE, U need ABAPER.

Go to transaction FIBF.  I did it one time with the help of ABAPER.

And this BTE use table FAGLFLEXA, that mean if you are not using New GL its difficult toget Profit center Column and Value.

for Other fields,

SPRO --> Financial Accounting (New) --> Accounts Receivable and Accounts Payable -->Customer Accounts --> Line Items -->Display Line Items -->Define Additional Fields for Line Item Display

Regards

Shinas

[Former Member]

Dear Pranan

Do lilke what shina has told

for Customer-

SPRO --> Financial Accounting (New) --> Accounts Receivable and Accounts Payable -->Customer Accounts --> Line Items -->Display Line Items -->Define Additional Fields for Line Item Display

Like same you can activate for vendor and gl also..

Thanks

Sada Bandla

[pranav_gupata]

Dear Sada ,

As i post above  regarding T.Code FBL5N when i see the line item balance of Customer, after select the layout Field like.. Profit Center, Material and Qty... in filed Profit Center, material and qty not showing.it shows blank  not .. updated while in transaction showing Profit Center. ..while data flow from SD profit center is there along with Accounting Entry... kindly tell me what should i do for the same... so that Profit Center, Material and Qty also will shown.. in .in FBL5N..

Kind reagards

Pranav

SAP FICO Consultant

.