AP Final payment register

[luckykiriti]

Hi Gurus,

I need output of AP Final payment register report in Excel. Where can I change it. I tried looking at this program, but i could not trace the report. This is a burning issue.

wht is the procedure to change the output format.

Appreciate ur early reply.

Thanks,
Kiriti V

[karthikeyanp1981]

(I am assuming u r in rel12)
Please login to Applications
Switch Responsibility to System Administrator
Navigate to Concurrent > Program > Define
Query for Program name "Final Payment Register" or Short name "APXPBFPR"
It will return the details of the register
In the output region, you can see a field called FORMAT, it will show the available formats, in which this register can be generated.
I can see the following formats available in my instance ,
FO , HTML, PCL, PDF, PostScript, Text,XML ...
I think this can be customized to accomodate excel format as well, please check with technical gurus.

[luckykiriti]

Hi Karthikeyan,

Thanks a lot for your help. I could not see XSL or excel in the output format list.

So do we need to customize that output in excel? I think technical consultants will do that right.
We need to format the output file for this or wht.

Appreciate ur help.

Regards,
Kiriti V