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_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