Share
Report
22,647WE are managing a very large dollar value grant issuing agnecy's funding currently in Payables Management with all of the grant receipiants set up as vendors. We current import the monthly payment invoices from the grant tracking and we are done. This solution has been in place for the past 10 years with no errors and no reason to change - client is happy and it works.
Now business is changing and rather than providing a monthly payment, the grant receipiants are set up with a 'possible' yearly total that they could earn. The amount that is released is based on performance and peer reviews and report submissions to the agency.
The grant could be for 100,000 per year for each of the next 5 years. In the old system they would have taken the total of the 5 year grant - 500,000 and divided by 60 months and imported each of the 60 invoices in to the payable system. This sets up the current period and each fiscal period commitment and it all hits the balance sheet and P/L correctly.
Now in the new system rather than just making the payment each month - the agency makes an evaluation and releases certain portion of the current years 100,000 as it is 'earned'
Accounting difference now is that full 500,000 is not in the GL
The only thing that would hit the GL would be the current amount to be paid.
Here is the question - thanks for reading to this point.
The Agency would like to still be able to report at the Finance level the total dollar value of the commitments - ie the full 500,000 not just this period or what has happened in the past.
So our consideration is to create the 100,000 per year documents as Purcahse Orders and then as earned, receive an invoice, record and issue the payment.
We are then hoping that with Commitment or Grant Managment we can pull the total PO values over to Management Reporter as well as the current expenditure to get a picture of where the full 500,000 is at this time. Part is expensed while part remains on the Balance Sheet as future liability.
What I am looking for (the real question) is what modules considering the client is runnign Microsoft Dynamics GP2013 Perpetual, without Project Costing, and has Intregration Manager, what can we use in that suite of modules to accomplish this task.
I would like to hear from as many of you as possible and would entertain after consideration in general some in-private email communications to fine tune the details.
Thanks for your time and attention to this request.
*This post is locked for comments
All responses (
Answers (
