Financial Edge NXT - Integration Features and Requirements

Requirements and Capabilities Financial Edge 

Segmented Account 

The FE account is segmented, including segments for various dimensions and the natural GL account. The dimension segments are defined as dimensions within Martus, and the GL account is Martus’ account. 

Dimension Setup 

Martus supports these dimensions: Fund, Department, Sub-Department, Project, and Transaction Codes. 

• Dimensions that are part of the segmented account are set up with the Entity named Custom, the External Name of Segment, and an appropriate segment name which corresponds to the sequence number for that segment. 
• The dimension Project is set up with the Entity of Project. 
• Any Transaction Code dimensions are set up with the Entity of Custom, the External Name of Txn Code, and the appropriate External ID for the dimension value to be defined in Martus. 
• No dimension can have the same name in Martus as another dimension (i.e., you cannot call the FinEdge NXT Department “Fund”, although you can call it “Funds”). 

Fund Setup 

Martus must be configured to define the first account number segment with the entity of Fund. This may be known by an alias in Martus (i.e., the name used within Martus could be Entity). 

Project Setup 

Martus must be configured to define projects with the entity of Project. This may be known by an alias in Martus (i.e., the name used within Martus could be Program). Projects are set to Inactive in Martus if they are set to “Inactive & prevent data entry and/or “Inactive & prevent data entry and posting”. 

Transaction Codes Setup 

Martus must be configured to define the transaction codes with the entity of Custom and the appropriate TxnCode. Each Transaction Code is a separate dimension within Martus. 

Segments Not Used 

Martus can be configured to ignore any account segments not used within Martus. Even the first segment of the account number (Fund) can be ignored (not configured in Martus). 

GL Accounts 

Martus pulls all accounts (balance sheet as well as P&L) from Financial Edge. 

Bank Accounts 

Bank account balances are not available via the API, so Martus cannot be configured to support the Bank Balances dashboard widget. 

Vendor 
The vendor is not provided to Martus via the API, so Martus cannot display Vendor on transaction detail drilldown. 

Budgets 

Budget information can be uploaded from Financial Edge into Martus; Martus can upload both fiscal-year budgets and budgets that are defined for a range of periods; if necessary, these are combined by the implementer into the default Planner budget for each fiscal year in Martus. Once a budget is completed in Martus, it is exported to Excel and the Blackbaud Budget Creator Excel Add-In is used to format the budget for import into Financial Edge.

Financial Edge NXT - Integration Notes & Troubleshooting

Chart of Accounts

For a standard Financial Edge NXT integration, the nightly chart of accounts sync builds account mappings in Martus that correspond to your Financial Edge NXT segmented accounts. While you may see the Account Mapping page in Martus, you should not need to adjust it from Martus.

Since the chart of accounts sync builds and maintains account mappings for most clients in Financial Edge NXT, it is important that your segmented accounts in Financial Edge NXT are correctly tied to all appropriate dimensions.

To confirm you have a standard Financial Edge NXT Integration:

• Navigate to Setup > Account Mappings 
• Verify that you don't have the option to edit any account mappings or import an account mapping file.

Dim & Account Errors

If you receive an error in the Martus Updater like "Dims and Account are mapped to 00-00-00-5100 and 00-00-10-5100", you will need to update one or both accounts in Financial Edge NXT for the Martus Account Sync to correctly process them. 

To remedy this:

• View both accounts in Financial Edge NXT 
• Ensure that the combination of dimensions associated with each account is unique for every dimension used in Martus (Fund, Department, Segment, T-Code, etc). 
• From Martus - go to Dashboard > Updater
• Click Account Sync 
• Ensure the task runs without error 

Non-Standard Configuration

Note that in rare cases, Martus will use a non-standard configuration for Financial Edge NXT customers with legacy charts of accounts. In this case, the nightly account sync does not build your mappings. At the time of implementation, Martus Support will help you with initial setup and guide you on how to add new mappings. (To confirm that you have a non-standard configuration, navigate to Setup > Account mappings and confirm that you have the option to import account mappings.)

If you are using this non-standard configuration and get an error message on editing or importing account mappings, ensure that each account mapping has a unique combination of accounts and dimension items.