Vendor Code Showing in TDS GL - FBL3N

[former_member214904]

Dear Exparts

We are facing one problem regarding the identification of TDS/VAT amount (deducted from vendor invoice).

We already activate the offset account option in the FBL3N report. But this is not serve our purpose.

Vendor invoice

GL 4000080 Advertisement         BDT 90,000/- (Dr.)

GL 1000020 TDS                          BDT   8,000/- (Cr.)

GL 1000030 VAT                          BDT   7,000/- (Cr.)

GL 1000300 Domestic Creditor BDT 75,000/- (Cr.)

In offset account system is showing the GL 4000080

Requirement is from user How can they identify the Specific vendor's TDS/VAT amount from the TDS/VAT GL.

Pls. give advice regarding process modification if required.

Regards

Tarek

[former_member196096 · Accepted solution]

Use BTE concept.

Append the RFPOS & RFPOSX structures for the vendor code. Create a new function module ZXXXX and assign it to BTE 00001650.

In the FM select the vendor code from BSIK or BSAK by Document no. Hope your problem will be sloved

Thanks

Rizvi

[Former Member]

Go for a separate report, consult your abaper for this. It will not show in fbl3n report or else you need to go for BTE concept , so that it will show in your fbl3n report. BTE concept is difficult.

my suggestion, you should go for developing a new report, abaper can copy the fbl3n report and modify accordingly,

Thanks

Sudhir Krishna Kumar Singh

[suma_mani]

Hi Tarek,

In addition to Mr. Sanil,you may use BTE concept to add new field as Vendor & fetch the data from WITH_ITEM table

Mentioned link will guide you how to adopt BTE functionality in SAP. It can be apply for all existing entries also.

http://scn.sap.com/community/abap/application-development/blog/2012/08/30/enhancing-sap-standard-tra...

Secondly you can use J1INEMIS report where you can get vendor number.

For VAT GL :-

You can use same concept which i mentioned above ,but use table BSET table to fetch the data.

Regards

Mani

[former_member218253]

Ideally this report must come from the vendor sub ledger. If this is a must have functionlity a less painless way may be to extract into excel the GL report and FBL1N report and vlookup the vendor

value.

[sanilbhandari]

Hi

FBL1N does contain the field for With Holding Tax Amount and With Holding Tax Base Amount. However, if there is more than one with holding tax code in the vendor invoice, than probably you would have to enhance the same as well.

Regards

Sanil Bhandari

[sanilbhandari]

Hi

The vendor may not show in all the reports. Refer the link below:

http://scn.sap.com/thread/3356832

You should implement the enhancement and fetch the vendor no from BSIK or BSAK by passing the document no. You would have to append the structure to add a ZZ or YY field.

Regards

Sanil Bhandari