03-27-2012 3:20 PM
My client wants to be able generate donor financial statement reports in Grants management but the standard report seems to only capture P&L accounts(Commitment items) which does not satisfy the requirement since the client wants to see the balance sheet items(banks,advances etc) as well as the P&L items for each grant. Any ideas how we can achieve this? Whta is the best practice approach? Can profit center accounting be used here?
03-27-2012 10:23 PM
Hello,
I believe you will have to create your own Report Painter report. The library you want to use is 4FC because the underlying table of this library is PSGLFLEXT, which has all the characteristics necessary for creating a grant wise balance sheet.
Regards,
Ming
03-28-2012 7:48 AM
Hi, which total table are you using for FI? If this is PSGLFLEXT then you can build such report in FI(of cause if you activate scenario for grands)