Refunds

[Former Member]

Hi,

I am trying to get a list of all the refunds due on a given date. Can you please advise which table I need to use to get to this.

Regards,

Imran

[Former Member · Accepted solution]

Hi ,

          Run FPY1 with the concerned due date , payment method in simulation mode .you can find the list in Environment -Payment list . the same can be found out from table DPAYH by giving date id and identification.

[Former Member]

Thanks for the help. I am using table DPAYH. What identification do I need to use?

[Former Member]

Hi ,

        You need to use the date id and identification of the "simulation run " of FPY1.

[AmlanBanerjee]

Hi Imran,

Giving the date ID and the identification, will list all the documents including the exceptions as well.

So if you want only the documents which have been picked up for refund , then apart from the date ID and Identifcation give the group number as 101.

Hope it helps..

Thanks,

Amlan 

[Former Member]

Thanks Amlan. Following your advice I managed to get the correct data.