Vendor number in FBL3N report

[former_member210666]

Hello Freinds,

There is a filed in line item report FLB3N "VENDOR".

In one of the requirement we need to populate the vendor number in a GL account. In vendor recon account the vendor number is populated but for the other GLs involved in the transaction we require the vendor account in in the filed "VENDOR".

Ex: Vendor A/C Credit ........................... 850

Expense A/C Debit .......................... 1000

Withholding Tax Payable Credit ........ 150

In the line item report (FBL3N for Withholding tax payable account) we want to view the vendor number in filed vendor.

Any body please share your experience in this regard.

Thanks & Regards,

[Former Member · Accepted solution]

Hello,

The request functionality you asked is not covered by the standard

system.The reason is Notes 112312 and 217189 helps you to add the

field "GKONT-Offsetting account" to the line item display.

To get this functionality, you need to implement Open FI 1650 where

the offsetting account is read. Within this Open FI, you run function

module GET_GKONT to select the offsetting account. However, this

function module only search for the information in BSEG table.

You can use a new BADI too. Please check the notes 1034354 and 1504612.

Best regards, Hana

[former_member210666 · Accepted solution]

Hi Hana,

Thanks for your reply and the information you have provided, its very useful.

What i understood from your post is that we can get off setting account in FBL3N. But field GKONT is not availabe in BSEG, so is it possible to get vendor number in field LIFNR in FBL3N report by implementing BTE 1650.

Regards

[Former Member · Accepted solution]

Hi,

Unfortunately it is not possible to output the gl & vendor number

(RFPOSXEXT-U_LIFNR) in FBL3N since this information is not available in

the general ledger item which is displayed to FBL3N.

The two fields GKONT and GKART will get filled from the Document table.

In the transaction FBL3N you can see the field GKONT only, not vendor/customer.

I hope this helps.

Best regards. Hana

[former_member210666 · Accepted solution]

Hi Hana,

But field GKONT is not available in BSEG, how can it be displayed in FBL3N.

Could you please elobrate this.

Thanks & Regards

[former_member188028 · Accepted solution]

This is possible Offsetting account addition.

Please go to FIBF-Settings-Products---Of a customer

New entries

Create a product with proper text and activate it.

Again Settings-P/S Module--of a customer

New entries

Event : 1650

Product : Select/Enter which you have created in the above step

Function Module : LINE_ITEMS_GET_GKONT

Now you can find Offsetting account in the layout in any FBL* reports

It will give you the desired ouptput.

Rgds

Murali. N

[former_member210666 · Accepted solution]

Hi Murli,

Thanks for the info, i used BTE1650 its fetching offsetting account, this BTE holds good only for documents which has only 2 line items. When there are more then 2 line items in a document its not fetching correct offsetting account.

With this BTE implementation the offsetting account is getting pupulated in GKONT in the following sequence.

Test Case : Document entered with below line items

Expense1 A/C Debit .......................... 500

Expense2 A/C Debit .......................... 500

Vendor A/C Credit ............................. 850

Withholding Tax Payable Credit ......... 150

For the above entry the FBL3N report for these accounts displayes offsetting account as follows

for Expense 1 -

---

offsetting account is Vendor account

for Expense 2 -

---

offsetting account is Vendor account

for Withholding tax payable account -

---

offsetting account is Expense 1

for Vendor recon account -

---

offsetting account is Expense 1

In other words, in FBL3N is it possible to get the VENDOR (LIFNR field ) populated with value of vendor account number if a transaction involves any vendor account.

For example: From the test case transaction mentioned above

In FBL3N report of

for Expense 1 -

---

the field LIFNR to should have Vendor number

for Expense 2 -

---

the field LIFNR to should have Vendor number

for Withholding tax payable account -

---

the field LIFNR to should have Vendor number

Regards,

Edited by: SAP_FICO on May 25, 2011 10:39 AM

[former_member210666 · Accepted solution]

Hi Friends,

BTE-1650 is not getting the desired info. We came across BTE-1120-"DOCUMENT POSTING: Field substitution header/items", i think this can do the work.

But one thing we are not sure about, on which your comments are rquried.

This BTE-1120 is already implemented in our system for getting the Assignement field filled in the vendor line item with value of assignment field from the GR/IR account during transaction MIRO.

Now our concern that, can we include our requirement code wiith the existing code in functional module.

Regards,

[sanilbhandari · Accepted solution]

Hi

There is a Table, I guess T021S. You can get the table from the config of Adding Special Field for Line Item Display under Financial Accounting>general Ledger Accounting>Master data>Line Items.

You need to make sure that in that table, the details for BSEG-LIFNR are updated with value as 0 if you are on classical ledger and 2 if you are on New GL.

Regards

Sanil Bhandari

[former_member213733 · Accepted solution]

For offsetting entry - BTE 1650 comes in to picture .

Through FIBF you can view the same .

Cheers ,

Dewang

[former_member210666 · Accepted solution]

Hi Sanil,

Special field BSEG-LIFNR is already selected and is available in the FBL3N layout, but its not fetching any value, its blank.

Regards

[former_member210666 · Accepted solution]

Hi Dewang,

Yes agreed with you, when talking about offsetting account BTE 1650 is talked about.

As you have viewed the above replies, its not working out.

We need to have the BSEG-LIFNR field filled with offsetting vendor, BTE 1650 not getting desired information.

Regards

[Former Member · Accepted solution]

To the best of knowledge it wont be posibble as from accounting documents point of view, you are entering Vendor only once

if we go over your example

Expense1 A/C Debit .......................... 500

Expense2 A/C Debit .......................... 500

Vendor A/C Credit ............................. 850

Withholding Tax Payable Credit ......... 150

Since vendor a/c is only entered once , it wont show up on all other line items.

FBL3N is nothing but a std report built on join of BSEG,BKPF and few other tables.

Try querying BSEG for this particular document number in SE16 and you will realise that vendor is populated only on one line item .

I would suggest that you use other standard report or better build out a query on Logical Database SDF with join of LFA1/LFB1

.

Hope it helps

Edited by: Sameer Singh on Aug 3, 2011 3:04 AM

[Former Member]

Hi,

Appling the Note 1504612 will solve the issue. The offset account informtion will be populated.

Please check the prerequisites and the related notes as well.

Regards

Chaitanya

[Former Member]

You may need to apply note 1034354

[former_member210666]

Hi,

We using classic GL, the note you refered is all about new GL.

Thanks

[Former Member]

Hi,

You can use the new report i.e FAGLL03 - GL Line Item Display.

after executing the report just change the layout and use the vendor field for display.

If still the values are not appearing you have to add the vendor fields in the report. For that go to SPRO--> Financial Accounting (new) --> GL --> Master Data --> GL Master --> Line Items --> define special fields for line item display.

Give the table name & field name.

Thanks & Regards,

shashi kanth.

[former_member210666]

Hi Shashi,

Thanks for the reply, but we are using classic GL.

Regards,

[Former Member]

Hi,

Can you check this link [ Vendor code in FBL3N Report |;

your problem will solved

[atif_farooq]

Dear,

Having executed FBL3N please go to menu Settings .. Special fields.

Copy any existing field and in field name write LIFNR and in Table write BSEG.

Now re run fbl3n and fetch this new field in your layout.

Regards

[former_member210666]

Hi Atif,

Thanks for the reply. I already have the field in my layout, but my question was how to fetch data in it.

Regards