A late Friday posting, but hopefully I get some feedback. For projections purposes, I have created a pledges receivable report that looks out over the next few FYs based on the payment schedules of our open pledges. This report works fine for those pledges with one allocation. However, it gets tricky if there is more than one allocation, and that allocation is split over UNRESTRICTED vs RESTRICTED purposes. In other words, I have no problem saying that "In FY18, we are expecting $x in pledge payments" but I hit an issue if I need to say "In FY18, we are expecting $x in unrestricted pledge payments, and $y in restricted pledge payments." I can manually work this out for multi-allocation pledges, but would rather not if it can come right out of MILL.
Has anyone had the same challenge, and if so, can you share how you addressed it (in MILL or not)? Maybe I need to be one a different track?
Thanks in advance.