Skip to main content
Adaptive Insights
Knowledge and Support - Adaptive Insights

Transactions

Question

Can you explain the Transaction Definition Editor and provide descriptions for the Field Categories?

Answer

The Transaction Field Definition specifies a set of transaction related fields that hold information about each transaction. Although a transaction line item is typically represented by a set of data associated with the transaction such as type and date and sometimes associated with individual lines such as customer name, item quantity, and total, the system does not distinguish between the transactions and transaction lines. The Transaction Field Definition Editor is where you will create and manage the Transaction Definition for your instance.

 

Required Permission: Admin Access, Transactions

Navigation: Modeling > Model Management > Transactions

Transaction Field Definition Editor

The Transaction Field Definition Editor consists the following panes:

  • Left pane, Element Selector: Used to browse for data entry column fields or custom dimensions to add to the transaction definition.

  • Center pane, is design area: The interface for adding elements to the transaction definition list.

  • Right pane, Set Properties: Used to set properties for the select fields in the transaction definition list.

Before you define your transaction fields, it is a good idea to understand the functionality in this screen and how it works. The Transaction Field Definition Editor is much like the Modeled Sheet Builder in that you are selecting specific elements from a list of elements and dragging and dropping them into a design area. In this case, there are preset fields that are required, and you can drag and drop additional Data fields or Custom Dimension fields from the Selector Panel on the left into the transaction field area as needed.

You can include up to 200 fields in your transaction definition. The following table describes these field types:

Field Categories Description

Required Fields

The following field types must be present in the definition and cannot be deleted. These required fields must always be defined and they must be populated.

  • Level Field: Represents the organizational level to which the transaction or line item belongs. Transactions cannot be associated with linked levels.

  • Account Field: Represents the Adaptive account to which the transaction or the line item belongs. The list of valid accounts with which a transaction line item can be associated are General Ledger, Custom, and Assumption accounts that hold Actuals data in Adaptive Planning. Note: Transactions cannot be associated with cube or modeled accounts.

  • Transaction Type Field: A text selector that allows you to specify the type of the transaction such as Bill, Invoice, Journal Entry, etc. This list comes pre-populated with a common list of transaction type values, however you can add, change, and remove entries as needed.

  • Posting Date: Represents the date on which the transaction is posted to the GL. This is a date field used to identify the month and year to which the transaction belongs in Adaptive.

  • Transaction Amount field: Represents the amount for a line item in a transaction. This is a number field.

Data Fields

The following field types can be added to create custom transaction fields.

  • Text Fields:  Contains any characters and limited to 1000 characters per field, in each transaction line. If you attempt to import more than the allowed 1000 characters into a field, the field will be truncated and you will get a warning message informing you of this.

  • Number Fields: Contains only numeric data. You can specify the display format (Number, Currency, or Percent) and the decimal precision.

  • Date Fields: Contains only date data.

  • Text Selector Fields: Contains a predefined set of values as a drop-down list. Administrators can specify the set of values present in the Text Selector list.

Dimension Fields

Any of the custom dimensions present in your model can be used as a field for a transaction. These custom dimensions will be listed on the field panel. Each dimension can appear only once in the transaction definition.

How to Define the Structure and Format of Transactions and Line Items

The following are the high level steps for setting up the Transaction Definition:

  1. Determine the fields related to your GL transactions that you want to import to Adaptive Planning.
  2. Review the default fields and adapt the definition to your needs. You can add new fields from the field panel as needed.
    For example, if you want to add Product, this is most likely a Custom Dimension field. If you want to add a field to display Sales Tax, this would most likely be a Number field and if you want to add a Description field, this would be a Text field.
  3. For each field, you can modify the title. This title will appear on the Transaction Detail Report when drilling down from sheets and the cell explorer. The title also appears in the transaction import template.
  4. Click the Gear icon in the toolbar to edit the Transaction Definition Property. You can review and edit the default message that appears on detail reports when users drill into Transactions. Click Ok to apply the changes and close the dialog.
  5. Click the Save icon from the toolbar to save your changes.

Managing the Field Definition

You can update the Transaction Field Definition for a model at any time. You can add new fields, and delete non-required fields. Deleting a field deletes all data that was previously imported to that field.

Note: Transaction Reporting and Analysis is an add-on feature, available for Adaptive Planning and Adaptive Consolidation. Contact your Account Executive for more information.

See Transaction Reports and Drill Through for more information.

Transaction Definition Toolbar Reference

Icon Name Description

reportViewerSave.png

Save

Save all changes made to the Transaction Definition list.

reportProperties.png

Transactions Definition Properties

Review and modify the message that appears on the Transaction Detail Report.

  transactionMoveUp.png transactionMoveDown.png

Move up, Move down

Move the select field right or left  the list.

deleteTrashCanWhiteOnDark.png

Delete

Remove the select element from the definition.

  • Was this article helpful?