Skip to content

Rebdev, LLC

A Better Way Forward

  • Blog
  • Solutions
    • Add-ons
    • Custom Development
    • Integrations
  • Consulting
    • Optimization Review
    • Sage X3 Consulting
    • Project Management
  • Endorsements
  • Careers
  • Contact
Rebdev, LLC

Tag: rebdev

What’s New in SEI V9- Finance UDM Pt. 1

The UDM is a powerful feature that allows a user to create consolidated reports that use multiple data sources. This means, you can create a comprehensive report with details from sales, inventory, CRM, etc!

In a previous blog(Financials on the Web), I showed you what was possible to create using the UDM. In this post, and the following, I will break down the steps to create your financials on the web.

While there are various out of the box reports, it is advantageous to configure the cube to what you need and create your own reports.

Out-of-the-box reports

Start by mapping your accounts. Navigate to the Universal Data Model folder > Finance > Configuration > Report Account Mapping > Account Setup

Account Setup

Double click to open this view and begin mapping your accounts. Default accounts have been defined but you may define your own. Start by entering the group/account name, i.e., WIP_Inv. Then enter in the account description, i.e. WIP Inventory, and the account numbers associated. If there are accounts to be excluded, those can be defined as well

Account Mapping

When defining accounts, here are a few ways to list them. If you want to include every account that begins with a ‘2’, type 2*

If you’d like to define a range of accounts, type the beginning account and ending account to include, separated by a ‘:’

You can also simply define each account number separated by a comma

These rules also apply for accounts to exclude.

As you are making changes, be sure to save your work! Under worksheet properties, auto save can be toggled on so that changes are saved to the view as they are made.

Activate Auto Save

Otherwise, changes will appear highlighted in green and you must manually save the view.

Unsaved Change

If manually saving, two steps must be taken. The first is ‘Save Data’ then ‘Save’. If ‘Save Data’ is not first clicked, your data entered will not be saved.

Defining your account set up is the first step to take in utilizing the Finance UDM, whether you are going to use the standard reports, or create your own.

Check back to see the next step!

Author adminPosted on October 26, 2020Categories How-tos, SEI V9Tags account, development, finance, rebdev, Sage, Sage Enterprise Intelligence, Sage X3, sagepartners, sagex3, SEI, seiv9, udm, universal data model
  • Blog
  • Solutions
    • Add-ons
    • Custom Development
    • Integrations
  • Consulting
    • Optimization Review
    • Sage X3 Consulting
    • Project Management
  • Endorsements
  • Careers
  • Contact
Rebdev, LLC Proudly powered by WordPress