RE and FE Integration: Reconciling Account Receivables question

David Dines

The org I support recently adopted FENXT and we've been using the integration process to send revenue from RE to FE since January. One of the areas we're still trying to figure out is how to produce timely and easily run reports on A/R.


One report that our finance department regularly ran in Quickbooks was an aging report that showed not only how far past due pledges were but also the amount for those that were both current or not yet past due.  I've not yet been able to figure out how to easily run a report that provides this info in the canned reports in RE.  While I can run the Pledge Status Report to get the balance of pledges as of any date and can concurrently run the Past Due Report to show what portion of pledges are past due, our Finance team would like to have some combination of the two so that we can both reconcile A/R totals in both systems as of certain dates but also have that aging data for that date, too.


Is this doable with any of the canned reports in RE, or should I start training myself in Crystal Reports to build one that serves this need?


Thank you!

Bill Connors

The Pledge Status Report is the report you want.  Pay attention closely to the settings on the Gift Types tab, such as the bottom two checkboxes -- I find I need to use a query to get the final results I want with these two checkboxes.  Also, on the Format tab, I find that I and my clients prefer format 2.  But when this report is set up well, this report will give you the AR balance as of a specific past date (last day of last month, last day of last fiscal year, etc.).