Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Answered

Multiple Customers per Job? Fund accounting with BC

Posted on by 105

Hello Amigos:

Our not for profit is setting up BC as our new ERP, but I've run on to a snag I didn't anticipate and hope you can help me with a work-around or better option.

As a NFP we have to keep up with numerous funds. BC doesn't have native functionality for fund accounting, but several people thought we could handle each fund as a separate job.

The idea was to treat each donor as a "customer." Donations to a particular fund would be treated as a payment to the job-fund. Vendors would be paid from the job-fund and thus we could keep a running total for the job, sort of like viewing one's bank account, with credits, debits, and running balance. Something like this:

XYZ School Construction Fund
Description Donation Expense Running Total
John Smith donation 10,000 10,000
Bill Jones donation 2,000 12,000
architectural fee (3,000) 9000
Mary Garcia donation 50,000 59,000
James Baker donation 40,000 99,000
Contractor draw (29,000) 70,000


Now the problem i've just discovered is that a job in BC can only have one customer and thus we can't create separate "sales invoices" or receipts for each donor, nor can we create a report detailing the separate donations to a particular fund by donor. 

I'd be very grateful for any suggestions for a good way to do this, or a specific work around for this issue.

Thanks in advance for your help!

  • Verified answer
    Atahualpa Profile Picture
    Atahualpa 105 on at
    RE: Multiple Customers per Job? Fund accounting with BC

    We're mostly sold on BC, but not at all sold on handling funds as separate jobs. If there is a better way to do that we'd like to know. I know of an app created to enable BC to do fund accounting, but it's pricey for a small NFP. I've looked briefly at Progressus but it seems like it's all about projects and not really about fund accounting. I may be misunderstanding, but seems like we would be buying a whole lot of machinery to get a small bit of ancillary functionality that we need. But I will take another look at it. I didn't look at it very closely. Thanks for your suggestion.

  • Suggested answer
    JAngle Profile Picture
    JAngle 33,159 on at
    RE: Multiple Customers per Job? Fund accounting with BC

    A fund dimension is the one we’ve used for a collection of our NFP clients. If you’re sold on jobs take a look at: appsource.microsoft.com/.../PUBID.progressussoftware|AID.progressuseu|PAPPID.131f85d1-48f2-481c-8d5a-849b16e388e6

    It allows for multiple customers per job

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans