Skip to Content

Expense GL wise TDS information - Logic to build Z report

Hi All,
One of our client is looking Expense GL wise TDS information. This is legal requirement as auditor is asking the TDS details as expense wise.

Scenario 1

Printing & Stationery GL, during the month & year there will be lot of entries in this GL,now auditor wants to know against which line item tds got deducted or against which line item TDS is not there.
Likewise for other GL also. I tried to look any option in FBL3N line item display but not got any solution.

Scenario 2

Since auditor is asking Expense GL wise TDS information in below scenario it very difficult to track expense account.
MIGO:

Inventory Dr.

GR/IR Cr.

MIRO

GR/IR Dr.

Vendor Cr.

In above scenario expense is in MIGO whereas TDS will come in to picture during MIGO. What logic I have to write here to identify the expense GL?


More over TDS related to vendor. Now I need to develop Z program can anybody help me to get the solution or to build the logic for this?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jun 02, 2017 at 05:26 AM

    Hi Mukesh,

    It is a very complex development as is includes various scenarios.We have developed the same report for tax assessment purpose in our company and its logic is quite tedious.

    So you need to assess and study all the relevant scenarios in your system and then define the logic accordingly.

    Regards,

    Ramnik Singh

    Add comment
    10|10000 characters needed characters exceeded