Creating transaction dimensions and dimension codes

Analysis information is entered via transaction dimensions. In this recipe we will take a look at the types of transaction dimensions that can be created.

There are four types of transaction dimensions that can be created: alphanumeric, numeric, yes/no, and date. An unlimited number of each type of transaction dimension can be created, with alphanumeric ones having codes created and attached.

To create an alphanumeric transaction dimension, perform the following steps:

  1. Open the Transaction Dimension Maintenance window in DynamicsGP by selecting Financial from the navigation pane on the left, and then clicking on Transaction Dimension in the area page under Cards | Financial | Analytical Accounting.
  2. Enter MARKETING in the Trx Dimension field.
  3. Enter Marketing Channels in Description 1.
  4. Leave Create New Codes On The Fly checked to allow users to create new transaction dimension codes, when entering transactions.
  5. Mark the Consolidate balances during Year End close checkbox to transfer analytical data to history during the year-end close.
  6. Click on the Codes button in the bottom-right corner.
  7. When prompted to save changes, click on Save.
  8. Enter ONLINEADS in the Trx Dimension Code field.
  9. Enter Online Adverts in the Description 1 field.
  10. Click on the lookup button next to the Linked to Node field.
  11. Ensure that Marketing Channels is selected, and click on Select.
  12. Click on Save.
  13. Repeat steps 7 to 11 to create transaction dimension codes for TWITTER, FACEBOOK, and GOOGLE+.
  14. Click on Save, and close the Transaction Dimension Code Maintenance window.
  15. Click on Save, and close the Transaction Dimension Maintenance window.
    Note

    Only alphanumeric transaction dimensions can have transaction dimension codes created for them.

    Only numeric transaction dimensions can have the number of decimal places, and a U of M Schedule ID can be specified.