Accounting Settings (`akoya_accountingsettings`)¶

Accounting Settings is the organization-level configuration record that controls GL account routing for akoyaGO's accounting rules engine. There is typically one active record per organization (it's effectively a singleton). Partners generally read it to learn the GL defaults for gifts, grants, fees, interfund transfers, and net-asset-sweep operations; they don't typically write to it.

At a glance


Display name	Accounting Settings
Logical name	`akoya_accountingsettings`
Primary ID attribute	`akoya_accountingsettingsid`
Entity set name (Web API)	`akoya_accountingsettingses`
Ownership	UserOwned
Change tracking	Enabled
Audit	Enabled (selective)

Unusual entity set name

The entity set name is akoya_accountingsettingses (Dataverse pluralizes "settings" as "settingses" when the logical name already ends in "s"). Confirm against the live Web API before hardcoding.

Web API¶

GET  {org}/api/data/v9.2/akoya_accountingsettingses
GET  {org}/api/data/v9.2/akoya_accountingsettingses({settingsid})
PATCH {org}/api/data/v9.2/akoya_accountingsettingses({settingsid})

Partners usually retrieve the single active record and cache the GL account IDs.

Attributes¶

Core¶

Display name	Logical name	Type	Required	Description
Accounting System	`akoya_accountingsystem`	String (100)	ApplicationRequired	Free-text identifier for the external ERP / accounting system the foundation uses.
Clear as of Date	`akoya_clearasofdate`	DateTime	None	Automated clear-down effective date.
Reapportion From Date	`akoya_reapportionfromdate`	DateTime	None	Effective date for rebalancing.
Reversal Override Date	`akoya_reversaloverridedate`	DateTime	None	Date after which reversal logic overrides apply.

GL account defaults — gifts¶

Display name	Logical name	Target
Default Endowed Gift Account	`akoya_defaultendowedgiftaccount`	`akoya_account`
Default Non Endowed Gift Account	`akoya_defaultnonendowedgiftaccount`	`akoya_account`
Default Pledge Receivable Account	`akoya_defaultpledgereceivableaccount`	`akoya_account`
Default Gifts Receivable Account	`akoya_receivableaccount`	`akoya_account`

GL account defaults — grants / scholarships¶

Display name	Logical name	Target
Default Grant Expense Account	`akoya_defaultgrantexpenseaccount`	`akoya_account`
Default Grants Payable Account	`akoya_payableaccount`	`akoya_account`
Default Scholarship Expense Account	`akoya_defaultscholarshipexpenseaccount`	`akoya_account`
Default Scholarship Payable Account	`akoya_defaultscholarshippayableaccount`	`akoya_account`
Default Program Expense Account	`akoya_defaultprogramexpenseaccount`	`akoya_account`
Default Program Expense Payable Account	`akoya_defaultprogramexpensepayableaccount`	`akoya_account`

GL account defaults — interfund¶

Display name	Logical name	Target
Default Interfund Endowed Gift Account	`akoya_defaultinterfundendowedgiftaccount`	`akoya_account`
Default Interfund Non Endowed Gift Account	`akoya_defaultinterfundnonendowedgiftaccount`	`akoya_account`
Default Interfund Expense Account	`akoya_defaultinterfundexpenseaccount`	`akoya_account`

Net assets and sweeps¶

Display name	Logical name	Target / Type
Accumulated Earnings Net Asset Account	`akoya_accumulatedearningsnetassetaccount`	`akoya_account` (typically account 3010)
Spendable Net Asset Account	`akoya_spendablenetassetaccount`	`akoya_account`
Net Asset Clear To Account	`akoya_netassetcleartooaccount`	`akoya_account`
Net Asset Sweep	`akoya_netassetsweep`	Choice (inline — enable/disable rules)
Undeposited Funds Account	`akoya_undeposittedfundsaccount`	`akoya_account`
Due to / Due From Error Account	`akoya_duetoduefromeerror`	`akoya_account`

Fund references¶

Display name	Logical name	Target
Operating Fund	`akoya_operatingfund`	`akoya_fund`
Rebalancing Fund	`akoya_generalfund`	`akoya_fund` (label says "Rebalancing Fund")
Interfund Payee/Payor	`akoya_interfundpayeepayor`	`contact` / `account`
Fundweb Contact	`akoya_fundwebcontact`	`contact`
Notification Recipient	`akoya_notificationrecipient`	`contact`
Default Gift Function	`akoya_defaultgiftfunction`	`akoya_function`
Default Grant Function	`akoya_defaultgrantfunction`	`akoya_function`

Admin manual-clear columns¶

Used by back-office staff for one-off clear operations. Partners typically don't interact with these.

Display name	Logical name
Admin Clear as of Date	`akoya_adminclearasofdate`
Admin Clear Fund	`akoya_adminclearfund`
Admin Clear From Account	`akoya_adminclearfromaccount`
Admin Clear To Account	`akoya_admincleartooaccount`
Admin Clear Endowed Status	`akoya_adminclearendowedstatus`
Admin Fund Fetch XML	`akoya_adminfundfetchxml`
Admin Fund Selection	`akoya_adminfundselection`

Supported messages¶

Message	Supported
Retrieve	✓
RetrieveMultiple	✓
Update	✓
Create	— (effectively a singleton; created during solution install)
Delete	— (never delete)

Privileges¶

Most partners only need:

Privilege	Purpose
`prvReadakoya_accountingsettings`	Read the active record to discover GL defaults

Examples¶

Conventions

Examples assume ORG (env URL), access_token (valid bearer), headers (standard Dataverse headers dict), and service (a ServiceClient instance). See Authentication.

Read active settings with GL defaults¶

Web APIcurlPythonC#

GET {org}/api/data/v9.2/akoya_accountingsettingses?
  $select=akoya_accountingsystem,akoya_clearasofdate&
  $expand=akoya_DefaultEndowedGiftAccount($select=akoya_accountnum,akoya_accountname),
          akoya_DefaultNonEndowedGiftAccount($select=akoya_accountnum,akoya_accountname),
          akoya_DefaultGrantExpenseAccount($select=akoya_accountnum,akoya_accountname),
          akoya_PayableAccount($select=akoya_accountnum,akoya_accountname),
          akoya_OperatingFund($select=akoya_fundname,akoya_fundcode)&
  $filter=statecode eq 0&
  $top=1
Accept: application/json
OData-Version: 4.0
OData-MaxVersion: 4.0

curl "https://{org}.crm.dynamics.com/api/data/v9.2/akoya_accountingsettingses?\$select=akoya_accountingsystem,akoya_clearasofdate&\$expand=akoya_DefaultEndowedGiftAccount(\$select=akoya_accountnum,akoya_accountname),akoya_DefaultNonEndowedGiftAccount(\$select=akoya_accountnum,akoya_accountname),akoya_DefaultGrantExpenseAccount(\$select=akoya_accountnum,akoya_accountname),akoya_PayableAccount(\$select=akoya_accountnum,akoya_accountname),akoya_OperatingFund(\$select=akoya_fundname,akoya_fundcode)&\$filter=statecode%20eq%200&\$top=1" \
  -H "Authorization: Bearer $ACCESS_TOKEN" \
  -H "Accept: application/json" \
  -H "OData-Version: 4.0" \
  -H "OData-MaxVersion: 4.0"

r = requests.get(
    f"{ORG}/api/data/v9.2/akoya_accountingsettingses",
    params={
        "$select": "akoya_accountingsystem,akoya_clearasofdate",
        "$expand": (
            "akoya_DefaultEndowedGiftAccount($select=akoya_accountnum,akoya_accountname),"
            "akoya_DefaultNonEndowedGiftAccount($select=akoya_accountnum,akoya_accountname),"
            "akoya_DefaultGrantExpenseAccount($select=akoya_accountnum,akoya_accountname),"
            "akoya_PayableAccount($select=akoya_accountnum,akoya_accountname),"
            "akoya_OperatingFund($select=akoya_fundname,akoya_fundcode)"
        ),
        "$filter": "statecode eq 0",
        "$top": 1,
    },
    headers=headers,
)
settings = r.json()["value"][0]

var query = new QueryExpression("akoya_accountingsettings") {
    ColumnSet = new ColumnSet(
        "akoya_accountingsystem",
        "akoya_clearasofdate",
        "akoya_defaultendowedgiftaccount",
        "akoya_defaultnonendowedgiftaccount",
        "akoya_defaultgrantexpenseaccount",
        "akoya_payableaccount",
        "akoya_operatingfund"),
    Criteria = {
        Conditions = {
            new ConditionExpression("statecode", ConditionOperator.Equal, 0)
        }
    },
    TopCount = 1
};
var result = service.RetrieveMultiple(query);
var settings = result.Entities.FirstOrDefault();

Change history¶

Schema extracted from the Akoyanet solution XML on 2026-04-24. The akoya_netassetsweep inline option set values are pending the Phase 2 metadata generator.

Accounting Settings (akoya_accountingsettings)¶