Expenses a/c to be mapped in TDS Register ?

[Former Member]

Hi

A new requirement has come up,Client requested  to map expenses GL a/c to TDS register report.

Since we are using a customised TDS report.

With fields :

Document No.

Vendor

Name

Vendor Bill No.

Recepient Type

Selection

PAN No.

Item Text

Posting Date

TDS

TDS%

Bill Amount

Document Date

For Instance :

MIGO :

Expenses a/c ....DR

Expenses a/c ....DR

          To GR/IR clearing a/c

MIRO

GR/IR clearing .....Dr

          To Vendor a/c

          To TDS payable a/c

Is it possible to map Expenses GL a/c to TDS register report ? If yes then what needs to be done and also what are the limitations ?

Note : As this is legal requirement in all  the companies.Has anyone received such request and if yes what alternative method have been provided.

[Former Member]

Hi,

Since we have an urgent requirement and it will take around 3 to 4 months for Z report creation in our organisation.

Is there any work around solution.

For instance like we have a standard report FBL3N report, we are getting GR and IV document number in the same field.

Is it possible that we can get  IV and GR document number in a different column ( like in a reference column)  and we can eassily identify that these IV document number are in the reference with GR document number.

Since we have tried Table level BSEG and tried Vlook up also as PO document number is a common field, however PO document number is missing in some cases. while extractive IV document number.Hence not appropriate.

Please let us know in case you have any solution.

[former_member198650]

Hi Vijeta,

Check the field "Reference key 3" which has GRN no. in FBL3N report. But this field has the value in the combination of YEAR+GRN No+item No against the IV No.

Regards,

Mukthar

[ankit_agarwal8]

Hi Vijeta,

For this requirement, you need to develop a Z report.Generally, expenses book through Fi direct entry ( RFBU transaction type) , at the time of MIGO ( RMWE TT) and at the time of MIRO (RPRP TT). you need to take care all of these three cases. Because TDS can be deduct in all of theses three transactions.

First select line item of expense line item from table FAGLFLEXA with TT RFBU, RMRP and RMWE.

In case of RFBU and RMRP transactions type entries, you need to pass the document in table with_item. Because With_item table only updates with document, when documents contain TDS line.

In case of RMWE TT, you need to take BKPF-AWKEY  field as it contains your material document no.(MIGO no.) Then pass this material document no. in table MSEG and EKBE table.And take out MIRO no against this MIGO no. Then pass this MIRO in With_item table.

This is the logic to get this type of report. Detail FS you can prepare after detail study.

Regards,

Ankit K. Agarwal

[Former Member]

Thanks

[former_member198650]

Hi Vijeta,

Instead of capturing the expenses at the time of GRN you can capture it at MIRO. Then you can easily extract in the report. At our client side we are following this approach since 2013.

Regards,

Mukthar

[ankit_agarwal8]

Hi Mukthar,

Interesting...how's your accounting treatment in case of service PO i.e. at MIGO and MIRO.

Please suggest.

Regards,

Ankit K. agarwal

[former_member198650]

Hi Anit,

In service PO we have created as non-valuated GR. So there is no accounting entry get generated at MIGO.

Regards,

Mukthar

[Former Member]

Hi Mukthar,

Could you please guide us in little detail.