Page 1 of 1
AP Final payment register
Posted: Fri Aug 08, 2008 1:45 pm
by 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
Posted: Fri Aug 08, 2008 2:56 pm
by 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.
Posted: Fri Aug 08, 2008 3:45 pm
by 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