Revised 06/26/2026

 

This Knowledge Article covers how Fund Fee Formulas built with the new Fund Fee Builder (released in June 2026) will calculate and process in Business Central.
*Please note this Knowledge Article is specific to the new Fund Fee Assessment tool. For information about the Legacy Fund Fee Assessment process, see Fund Fees Assessment (Legacy).

• Before You Start
• Fund Fees in Business Central – User Guide
  1. Key Terms
  2. View Fund Fee Formulas in Business Central
     • Batch Statuses at a Glance
  3. Calculate a Fund Fee Batch (Step by Step)
  4. Review the Batch Before You Post
     • Reading the Batch Lines
     • Calculation Log
     • How the Fee Amount Is Calculated
     • Reviewing the Balance Amount
     • Other Review Tools
  5. Fixing Batch Errors & Adjusting Lines
     • Batch-Level Tools (on Fund Fee Batch)
  6. Post from General Journal 
  7. Reverse a Posted Batch
  8. Common Error Messages
     • Calculation Runs
     • Funds and Dimensions
     • Line Validation
     • Posting

  Before You Start

In akoyaGO CRM, confirm the formula is ready:

• The Fund Fee Formula is Active and uses a supported Frequency: Monthly, Quarterly, Semi-Annually, or Annually.
• The formula has been assigned to the appropriate Fund records.
• All required fields are filled in on the Fund Fee Formula form using the Fee Formula Builder.

For more information on setting up Fund Fee Formulas, please see Fund Fee Assessment Quick Start Guide (for consolidated instructions) and/or Fund Fee Formula Builder Administrator Guide (for full detailed instructions)

  Fund Fees in Business Central – User Guide

The following sections cover how to calculate, review, correct, post, and reverse fund fee batches in Business Central.

As mentioned above, fund fee formulas are built in akoyaGO CRM. Business Central uses those formulas to calculate, review, and post the actual fees each period. 

1. Key Terms

Term	What it means
Fund Fee Formula	The rule set built in akoyaGO CRM: defines frequency, fee type, how the balance is measured, tiers, minimum fee, rounding, and the revenue/expense accounts.
Assigned Funds	The funds a formula applies to. Business Central creates one fee line per active connected fund.
Fund Fee Batch	The Business Central record for one formula for one period. It holds the status, dates, totals, the staged fee lines, and the calculation history.
Batch Line	The calculated fee for a single fund. If the related fund record in akoyaGO specifies an Alternate Fund Fee Fund, the fee will post to the alternate fund.

2. View Fund Fee Formulas in Business Central

Choose Fund Fees Assessment from the akoyaGO action in Business Central. This opens the akoyaGO Fund Fee Formulas page.

The Fund Fee Formulas screen displays a list of all active Fund Fee Formulas, including a summary of information for each.

 

a. Last Period End Date is the ending date of the last period for which the fee was posted. Next Period End Date represents the ending date of the next period to post.
b. Batch Status indicates where the batch currently sits in the process. Current Batch Errors counts the number of calculated fees with an error to be resolved.
c. Active Funds shows how many active funds are assigned to this formula.

 

Actions available from the formula list include:

• View Assigned Funds - Displays funds assigned to a formula
• View History - Displays past batches for that formula
• Open Fund Fee Formula - Displays the fund fee formula details (and tiers if applicable) for the formula based on setup in akoyaGO CRM
• View All Batches

Batch Statuses at a Glance

A Fund Fee Batch moves through the following statuses. The current status tells you what to do next.

Status	Meaning
None	There is no active batch for this formula.
New	The batch exists but hasn’t been calculated yet.
Queued	A background calculation has been scheduled.
Calculating	The calculation is running.
Calculated	Amounts are ready to review. Once errors are cleared, you can move the batch to the General Journal.
Failed	The calculation didn’t finish. Open the job for the reason, fix it, and queue again.
General Journal	Fee lines have been staged in the journal and are ready to post.
Posted	The fees were posted to the general ledger.
Reversed	A posted batch was reversed through the standard reversal process.
Canceled	The batch was canceled and removed from current processing.

3. Calculate a Fund Fee Batch (Step by Step)

1. From the akoyaGO action, choose Fund Fees Assessment to open the akoyaGO Fund Fee Formulas.
   
2. Select a formula (or multiple formulas) and choose Queue Calculation. The system lines up a background job and creates or reuses the current batch for the period.
   
   
    
3. Choose Refresh periodically until the status changes to Calculated or Failed.
    
4. Open the batch to review it. If the status is Failed, open the calculation job to see the reason before trying again.
   

 

Important: If you are running several formulas, select multiple rows and queue them together – each gets its own batch, and you’ll see a summary message.

4. Review the Batch Before You Post

Open the calculated batch. Confirm that Batch Errors is 0; a batch can only proceed when it has no errors. Then review the lines. For additional details, reference the calculation log.

Reading the Batch Lines

Each line is the fee for one fund. Primary columns include:

Column	Definition
Fund / Fund Name	The fund the fee will post to. Usually the same as the source fund – but will differ only if the fund record in akoyaGO is designated as an Alternate Fund Fee Fund.
Fee Amount	The calculated fee. Click it to open the calculation log for that line.
Balance on Period End	The ending balance for the fund as of the Period Ending Date; used to determine whether the calculated Fee Amount exceeds the fund's balance.
Balance Type (conditionally visible)	The balance type selected in the Fund Fee Formula. This value is shown after the Calculation is run.
Balance Amount (conditionally visible)	The calculated balance based on the Balance Type and Balance Type Filter defined in the Fund Fee Formula. This value is shown after the Calculation is run.
Fund Balance Basis	Indicates whether the fee was calculated using the Fund's balance (blank value), or if a Fund Group balance was used as selected on the Fund record.
Bypass Error	If a calculated fee results in an error, users can check this box to allow the fee to be assessed in spite of the identified error.
Error Message	If a line is invalid, the reason appears here.

The Calculation Log

The calculation log is a step by step audit of how the fee amount was calculated. Select a line and choose View Calculation Log (or click the Fee Amount) to see exactly how that fee was built, in order.

How the Fee Amount Is Calculated

For each fund, the system builds the fee in a set order:

1. Find the balance basis. The balance is measured the way the formula specifies – for example, an ending balance, a beginning balance, a highest balance, a change in value, or an average (daily, monthly, or quarterly.)
2. Run the base calculation. A fixed amount uses the set amount; a fixed percent multiplies the balance by the percent; tiered formulas apply flat-tier or stacked-tier logic.
3. Apply fund group allocation (if the fund is part of a group) – the fee is shared based on the fund’s portion of the group balance.
4. Apply the minimum fee (if set) – if the amount is below the minimum, it is raised to the minimum.
5. Annualize for the frequency – Monthly divides by 12, Quarterly by 4, and Semi-Annually by 2. (Annual formulas aren’t divided.)
6. Round – the amount is rounded by the formula’s rounding rule (to the cent, or to the nearest one, ten, or hundred).

The calculation log shows each of these steps for every fund, ending with the final amount that appears on the batch line.

Reviewing the Balance Amount

To review the balance details for a line, click the Balance Amount value. This opens the Fund Balance Review page.

Here, you can review the posted activity that makes up the calculated balances by date and account; you can also adjust filters and recalculate to confirm the numbers.

*The Fund Balance Review page can also be accessed via the Fund list in Business Central.

Other Review Tools

• View Stored Formula – the formula as it was when you calculated. A change summary flags anything edited in akoyaGO CRM since the calculation, so you know if a recalculation would differ.
• Post-Calculation Entries – G/L entries posted after the fee was calculated, so you can spot activity that was not considered during the calculation.

5. Fixing Batch Errors & Adjusting Lines

1. If Batch Errors is greater than zero, open the batch and read the Error Message on each line, and the calculation log if you need more detail. Most errors come from formula setup, fund/account setup, or a fund balance.
    
2. If the error is related to setup issues, correct the setup and use Recalculate Line or Queue Calculation for the entire batch again.
    
3. If the error is related to the fund balance, the Fee Amount can be edited directly on the Fund Fee Batch. These errors can be addressed one by one, or they can be corrected as a batch using the Cap Fees to Balance function. This will reduce staged fees that exceed a fund’s available net asset balance. Each capped line is recorded in the log.
    
4. If it is appropriate to assess the calculated Fee Amount in spite of the identified error, use the Bypass Error option. The error message is retained, but this will allow the fee to be assessed as calculated. This is recorded in the calculation log.

Batch-level tools (on Fund Fee Batch)

• Reset to New – for a batch stuck in Queued/Calculating or a failed job; resets it so you can queue again.
• Reset to Calculated – from General Journal status, removes the unposted journal lines, and returns the batch to editable review.
• Cancel – cancels a batch you don’t intend to post (removes any unposted journal lines)

6. Move to the General Journal & Post

When the batch is Calculated and Batch Errors is zero, you are ready to proceed.

1. Choose Move to General Journal. The system stages the journal lines and sets the batch status to General Journal. It creates one expense line per nonzero fee (using the post-to fund) and one revenue offset line for the total (using the formula’s revenue account and revenue fund). Zero-dollar lines are skipped.
   
   
    
2. Choose Open General Journal and review the staged lines – confirm one expense line per fund and a single balancing revenue line.
3. Post the journal lines. The batch number is used as the document number, so the posted entries are easy to trace. The batch status becomes Posted. 
4. If you need to change something after staging but before posting, use Reset to Calculated to pull back the journal lines and return to review.

Important: If Auto Post Fund Fees is enabled in General Ledger Setup, the separate move and post actions are replaced by a single Move to General Journal and Post action that stages and posts in one step. We recommend auto-posting is disabled while you are reviewing results/confirming setup.

7. Reverse a Posted Batch

If there is an error or a batch needs to be recalculated after posting, you can reverse the posted batch. Choose View History from the Fund Fee Formulas screen. Open the batch to be reversed by clicking on the No., then choose Reverse. The system finds the posted G/L entries by document number and runs the standard Business Central reversal. When it finishes, the batch status becomes Reversed. If you cancel the reversal dialog, nothing changes and the batch stays Posted.

11. Common Error Messages & What They Mean

Below are common error messages, grouped by when they happen.

Calculations

Error Message	Recommended Steps
The formula is a legacy formula, or its frequency isn’t set up correctly.	In akoyaGO CRM, set the formula’s frequency to Monthly, Quarterly, Semi-Annually, or Annually.
No active funds are connected to the formula.	Check the formula’s Assigned Funds in akoyaGO CRM. Confirm all Assigned Funds are active.
The formula is missing a calculation type, amount/percent, or balance type.	Complete the missing setting on the formula in akoyaGO CRM, then queue calculation again.
A tiered formula has no active tiers, or no tier covers the balance.	In akoyaGO CRM, add or activate tiers, or add a higher tier so the full balance is covered.
Couldn’t connect to CRM / the formula wasn’t found.	This is an integration or sync issue – contact your administrator or akoyaGO support.

Funds and Dimensions

Error Message	Recommended Steps
A fund (or alternate fund) has no matching FUND dimension value in Business Central.	Create or sync the FUND dimension value for that fund, then recalculate.
A connection references a fund that can’t be found in CRM.	Correct or remove the assigned fund in CRM.

Line Validation

Error Message	Recommended Steps
The fee exceeds the fund’s available net asset balance (single line, or several lines to one fund together.)	Review the balance, formula, and amount. Use Cap Fees to Balance, or Bypass Error only after review.
A source fund’s balance is greater than its fund group balance.	Review the fund group assignments and the underlying G/L balances.
The fund’s available balance is negative.	Validation treats this as zero. Review the fund’s G/L balance and the Default Fund Balance Filter.
“Error Bypassed by User” / “Error Bypass Reverted”.	Informational – a line’s validation error was bypassed (or the bypass was undone.) Make sure the override was reviewed and documented.

Posting

Error Message	Recommended Steps
The batch must be Calculated / has errors / has invalid lines – resolve before moving to the journal.	Clear the batch errors first (see Section 8), then move it.
The batch has no nonzero lines to move.	All fees calculated as zero. Review the formula and balances. Zero-dollar lines aren’t staged.
Missing expense account, revenue account, or revenue fund.	Set on the akoyaGO CRM formula and recalculate.
The journal template or FUNDFEES batch isn’t set up correctly.	An administrator should confirm the General Ledger Setup.
After posting: “the posted total doesn’t match the batch total.”	A non-blocking warning that journal lines may have been edited before posting. Review the posted G/L entries against the batch.

Important: Messages about job queue entries (“a job is already running,” “the linked job no longer exists,” etc.) almost always resolve by waiting for the job to finish, or using Reset to New and queueing again. If they persist, contact support.