Need Help?
  • Application Remote Support
  • Infrastructure Remote Support
  • Sage HRMS Remote Support
  • Helpdesk
  • General Inquiry
1-800-719-3307
Net at Work Net at Work
  • Solutions & Services
    • ERP/Accounting

      ERP Services
      Acumatica
      NetSuite
      Sage X3
      Sage Intacct
      Sage 100 ERP
      Sage 300 ERP
      Sage 500 ERP

      CRM

      Strategic Advisory Services
      Digital Marketing Solutions
      CRM Training Camp
      Salesforce
      Microsoft Dynamics 365 CRM
      Sage CRM
      Infor CRM (formerly Saleslogix)

      Employer Solutions

      Sage HRMS
      Sage People
      Criterion
      Miviva

      Enterprise Content Management

      Imaging / Scanning
      Document Management
      Workflow Automation
      Solutions

      Nonprofit Solutions

      Abila by Community Brands
      NetSuite
      Sage
      Salesforce

      IT and Security Services

      Managed IT Services
      Fractional CIO Services
      Cloud Services
      Cloud at Work
      DR/Business Continuity Planning
      Compliance & Security
      Storage & Recovery
      Networking
      IT Security Services
      Communications

      Web Solutions

      Services Overview
      B2B Technology Suite
      Magento eCommerce
      WordPress CMS
      Systems Integration
      Website Managed Services
      Online Marketing & SEO
      ERP eCommerce Integration

      Additional Solutions

      Enterprise Business Intelligence
      Avalara Automated Tax Solutions
      Fortis Payments
      LeaseQuery Lease Accounting
      Sage Fixed Assets
      Vertex SMB Sales and Use Tax
  • Industries
    • Industries

      Healthcare
      Chemicals
      Food & Beverage
      Medical Devices
      Nonprofit
  • Learning Center
    • Online Resources

      Recorded Webinars
      Whitepapers
      Ebooks

      Upcoming Events

      Live Webinars
      Seminars
      Virtual Training Courses

      Training Courses

      View all available training course options
  • Company
    • Why Us

      Who We Are
      Management
      Our Partners
      Locations
      Careers

      News

      Press Releases
      Success Stories
      Net at Work Blog

      Contact Us

      1.800.719.3307
      Email Us

      Programs

      Alliance Partnership Program
      Women at Work
      Diversity and Inclusion
  • Blog
  • Contact Us
  • Contact Us

Home » Newsletters » Sage Enterprise Management Newsletter – Q1 2019 » Sage Enterprise Intelligence (SEI) – Adding A New Field to A SEI Design Process & Report View

Sage Enterprise Management Newsletter – Q1 2019

Keeping You Up-To-Date With Information About Sage X3

Sage Enterprise Intelligence (SEI) – Adding A New Field to A SEI Design Process & Report View

By: Net at Work Team

Before getting started working with the below Sage Enterprise Intelligence product functionality – please use caution. Always make changes in the PILOT folder test and if working properly copy to LIVE, never make change directly to LIVE before testing. If necessary, seek our assistance, or that of your network administrator.

SEI has an abundance of out of the box, design processes and views.  Unfortunately, not every field that you need has been added to the process, therefore it may not be an available selection to add to your reports.

In this article, we show an example of how to add a new field to a design process, followed up with adding it to the report view.

Sage Enterprise Intelligence   Watch Recorded Webinar:
Sage Enterprise Intelligence for Sage Enterprise Management
Watch Now

Recommended Pre-Requisite:

To complete the steps below, it is recommended that you have the knowledge of finding tables and field names in Sage Enterprise Management (EM).

Please refer to our December 2018 newsletter for additional information: “Tips and Tricks: Finding Tables and Field Names in Sage Enterprise Management”

Let’s start with some definitions:

  • Design Process: A design process is a SQL arrangement of tables from your data source (EM) that includes two main sections.
  • Section One: SQL arrangement view of tables and links.

  • Section Two: Defined fields from the SQL arrangement that will be used in reports, views, and dashboards

  • Report View: A report view is created based on your defined process.
    • Report and view will be used interchangeably throughout this article.

Example:

Company A is interested in adding a new field, Product Stat Group to the Invoice by Product view that is not on the design process or view.

Below are the steps to add new fields to a design process.

  • Navigate to the Command Center
  • Right click over the design process (our case, Invoice Analysis) that you want to add the field

  • Locate the table that contains your field in the top section of the design process
    • ZINVOICE

  • Click on the  to see the available fields that are located in the table
  • “Scroll” or “Search” for the field that you are adding to the report
    • TSICOD_0 -> This is the product stat group 1 field

  • Double-click on the new field,
  • It will be added to the bottom field section of the design process as the furthest right column
    • You can click and drag on the ‘TSICOD_0’ to move the location of the column (Optional)

  • Modify the field that you have just added based on your needs for the view (OPTIONAL)

Column Group Heading: Product Stat
Column Heading: Group
Prompt Query: Product Statistical Group 1

  • Select ‘Save’ in the top left corner
    • The field has now been successfully added to the design process

Next Steps, add the new field to the report view (Two Methods)

  • Select the view that you want to add the new field
    • Invoice by Product

First Method

  • Click on the ‘Dimensions and Measures’ Icon on the right panel bar

  • Search or ‘Open’ the Column type to locate the field
  • Click down on the new field, ‘Product Stat group’ and drag it to either ‘Groups’, ‘Pivots’, or ‘Columns’
    • I will be dragging to ‘Columns’

  • Click down and drag field to the ‘Columns’ row to place in desired location for the view

  • Click on the save button on right panel bar
    • You have now successfully added a new field to the report view

Second Method

  • Click on the ‘Worksheet Properties’ Wrench Icon on the right panel bar

  • Select ‘Columns’ then ‘+ Add’
  • Locate and select the new field, Product Stat group
  • Hit ‘Ok’
  • You can move the field order on how it is displayed on the report within the Columns section by “Click down and drag”

  • Save the view, and you have successfully added a new field to the report

« Return to Newsletter

In This Issue
  • From the Desk of the Sage Enterprise Management Practice Director
  • Sage Enterprise Intelligence (SEI) – Adding A New Field to A SEI Design Process & Report View
  • ERP and B2B eCommerce Integration Best Practices
  • Sage Enterprise Management v12 New Version Release!
  • Field Service Solutions
  • Restarting Web Services in Sage Enterprise Management
  • Sage Enterprise Management: The ERP for the Heavy Building Materials Industry
  • Chemical Corner: Regulation Management & Reporting with Sage Enterprise Management
  • Support for Sage X3

    Helpdesk:
    P: 888.494.9479
    E: helpdesk@netatwork.com


    Upcoming Live Webinars & Events

    Sage X3 and the Power of the Cloud
    Date: Jan 8, 2020
    Time: 2 – 3 PM ET
    Learn More

    3 CRM Themes for Manufacturers in 2020
    Date: Jan 25, 2020
    Time: 2 – 3 PM ET
    Learn More

    Better Budgeting, Forecasting & Planning in Sage X3
    Date: Feb 12, 2020
    Time: 2 – 3 PM ET
    Learn More

    Be Prepared for 2020 Sales Tax Changes
    Date: Feb 26, 2020
    Time: 2 – 3 PM ET
    Learn More

    Popular Recorded Webinars

    Sage ERP & CRM Integration: Seamless, Real Time, and Bi-Directional

    Sage X3 Document Management by Altec

    Sage X3 Integrated Credit Card & Payment Processing

    Sage X3 Webinar Archive

    View our library of on-demand recorded webinars.

    Refer a friend, get a $100 Gift Card!

    Submit a Referral / Learn More!
    Do you have a friend or colleague whose company might benefit from utilizing a Net at Work service or solution? If so, refer them to us below and receive a $100 gift card or donation to your charity of choice!

    Connect With Us

    Business Applications

    • Overview
    • ERP/Accounting
    • Cloud ERP
    • CRM
    • Employer Solutions
    • ECM
    • Nonprofit Solutions

    Learning Center

    • White Papers & Guides
    • Ebooks
    • Training Courses
    • Virtual Training Courses
    • Success Stories
    • Live Webinars
    • Recorded Webinars
    • Trials

    Infrastructure Solutions

    • Overview
    • Solutions
    • Managed IT Services
    • Fractional CIO & Advisory Services
    • Cloud Services
    • Cloud at Work
    • Compliance & Security
    • DR/Business Continuity

    Support

    • Application Remote Support
    • Infrastructure Remote Support
    • Sage HRMS Remote Support
    • General Inquiry
    • Helpdesk

    Web Development

    • Services Overview
    • Magento eCommerce
    • WordPress CMS
    • Systems Integration
    • Website Managed Services
    • ERP eCommerce Integration

    Company Information

    • Why Us
    • Alliance Partnership Program
    • Women at Work
    • Diversity and Inclusion
    • Partners
    • Careers
    • News
    • Blog
    • Privacy Policy
    • Contact Us

    Additional Solutions

    • Enterprise Business Intelligence
    • Avalara Automated Tax Solutions
    • Fortis Payments
    • LeaseQuery Lease Accounting
    • Sage Fixed Assets (Sage FAS)
    • Vertex SMB Sales and Use Tax

    Industries

    • Healthcare
    • Chemicals
    • Food & Beverage
    • Medical Devices
    • Nonprofit
    Net at Work
    Net at Work (HQ)
    575 8th Ave
    New York, NY 10018

    P: (800) 719-3307
    info@netatwork.com
    Locations Across North America »
    Visit our sister companies:
    Cloud at Work - Sage Application Hosting
    Pixafy - An eCommerce Agency
    Docutrend
    WordPress Image Lightbox Plugin