Hi guys
We are looking for an elegant solution to interface Donations from the CRM System into Fin Ops. The GL journal needs to be posted at an aggregated level (Business Unit, Department, Location, Program, Account code) and not at an individual donation level.
Power automate seems like a clunky solution because we would have to create a file/extract first that would then feed into the Power Automate process.
Dual Write has been discussed but unclear if it will work as we don't have the Customer Field in Fin Ops.
What do people suggest as alternatives? all ideas are good ideas at this stage.
thanks
Keith
Hello Andre. Thanks for getting back to me. And yes, this is a question about both aggregation and posting, we would like to do both as part of the integration process.
Hi Keith,
Is your question about the posting or also aggregating the details in the journal lines itself already? When ledger account, dimensions, date, and transaction text are the same, the accounting entries can be posted as a summary.
Do you need to have the journal lines summarized already?
Good question - and Yes - we are using the NFP accelerator.
Curious - are you using the Microsoft nonprofit accelerator (learn.microsoft.com/.../nfp) or have you developed something yourself?
André Arnaud de Cal...
292,162
Super User 2025 Season 1
Martin Dráb
230,962
Most Valuable Professional
nmaenpaa
101,156