• Products
    • Sage Intelligence Reporting
      • Enrolment
    • Velixo
      • Enrolment
        • Velixo for Acumatica
        • Velixo for Sage Intacct
  • Services
    • Consulting
    • Training
    • Development
  • Support
    • Support Overview
    • Create Support Ticket
    • Book A Session
    • Knowledgebase
  • About
    • About Us
  • Contact
  • Products
    • Sage Intelligence Reporting
      • Enrolment
    • Velixo
      • Enrolment
        • Velixo for Acumatica
        • Velixo for Sage Intacct
  • Services
    • Consulting
    • Training
    • Development
  • Support
    • Support Overview
    • Create Support Ticket
    • Book A Session
    • Knowledgebase
  • About
    • About Us
  • Contact
Quick Support
Book Demo

Learn how to flag missing accounts in your Sage Intelligence Financial Report Designer report layouts

By admin on April 24, 2018April 19, 2019

Depending on your Sage business solution, you may or may not have the Missing Accounts feature in your Financial Report Designer report.  Even if you have this functionality, you are still not automatically alerted that account level detail may be missing from your layout.  In this tip, I’m going to share a way to identify missing accounts using account categories/classes and conditional formatting.

The first step is to create a report using account categories/classes and account level detail.  If you’re interested in finding out more on how to do this, take a look at our Learning Portal.

Here is a report where account categories/classes have been used for the subtotal rows, and account level detail is shown for the Revenue group.  You can see that adding up the values for the account level detail does not match the subtotal for the group.  The subtotal is correct, as a formula that is based on a category/class will automatically include any new GL accounts.  This implies that accounts are missing at the detail level.

Here is a way you can identify that there are missing accounts in your report:

1. Insert a row between your subtotal row and above the account level detail.

2. Then, sum the values for accounts together so you have a total to compare with the subtotal.

3. Select the subtotal cell and on the Home tab on the menu ribbon, click Conditional Formatting.

4. Select the Greater Than option and reference the cell which has the sum of the accounts in it. You can then format the cell by clicking Custom Format.

5. Then, click on Conditional Formatting under the Home tab again, this time select the Less Than option, reference the cell which has the sum of the accounts in it, and format appropriately.

You will now easily see that you have accounts missing, as if you do, the subtotal will appear according to the select formatting.  You can also then hide the row containing the sum of the accounts to keep your layout tidy.

To find any missing accounts you can use the Missing Accounts tool if your product has it, or you will need to identify the account manually and add it.

To find out more on how to add missing accounts, check out this short video:

Sage Intelligence Reporting – Identify and Add Missing Accounts

And If you would like more information on the subject, check out the following webcast which was done for Sage Enterprise Management:

Learn how to set up account details in your Sage Intelligence layouts

The post Learn how to flag missing accounts in your Sage Intelligence Financial Report Designer report layouts appeared first on Sage Intelligence.

Source: Sage Intelligence

Post navigation

Learn how to extract more than one column of data with a single VLOOKUP formula in Excel
Learn how to quickly save your Excel management pack as a PDF

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recent Posts

  • Why Working In Excel Works
  • Alchemex Welcomes Velixo 6 For MYOB Advanced
  • Welcome to Velixo Reports Version 4.2
  • Part 3 of 3: Learn how to create a Management Pack in Sage 50cloud Intelligence
  • Part 3 of 3: Create and customize reports easily with the Financial Report Designer

Search

Contact Us

Phone: +61 2 9890 2339
Email: sales@alchemex.com.au
Address: PO Box 212, Deaken West, Canberra, Australia, 2600

Products

  • Intelligence Reporting
  • Velixo Reports

Services

  • Consulting
  • Training
  • Development

About

  • About Us
  • Partners
  • Blog

Support

  • New Ticket
  • Community (Coming Soon)
  • Knowledgebase

Phone: +61 2 9890 2339
Sales: sales@alchemex.com.au
Support: support@alchemex.com.au

Facebook-f Linkedin

© All rights reserved Alchemex Pty Ltd 2020

Made with ❤ by Unfazed Ltd