Financial Edge NXT - Integration Information

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.