Custom Reports Article

Custom Reports Article

   Tutorial Link
Purpose: To create custom reports which can include actuals, budgets, variances and comments for an organization. The report is structured to the user's needs.



Reports with a customized Column Format as defined in Define Custom Reports are run and displayed on this screen.

There are two tabs - the Dashboard and the Account Details tab.


Dashboard tab

 1) Select the Search criteria:

a) CompanyDB is a required field;

b) OrgUnit-in order for an OrgUnit be to available for reporting the "InReports" box needs to be checked in Manage OrgUnits;

c) OrgUnit Rollup-these are defined in Manage OrgUnits;

d) Object-in order for an Object to be available for reporting the "InReports" box needs to be checked in Manage Objects;

e) Object Rollups-these are defined in Manage Objects

f) Select the Report.  This drop-down menu lists those Reports for which the "Forms Enabled" checkbox is checked in Define Custom Reports. 

 

Please note that the underlying Column detail can be accessed using the Drill-Formatted Columns functionality.  For example, actual data imported from Great Plains Accounting software. 


In a Budget column, selecting the "Edit Budget" option will open up the Account Details/Assumption tab.

2) "Advanced" search is available.

3) Exclude Zero Values Accounts functionality is available.




Print, Export to Excel, Print to PDF, Auto-fit Columns,  Column Data Sort-Ascending/Descending, Copy, and Expand/Reduce Column Width functionality is available. "Home Currency" is the default setting.


The format of the on-screen data can be customized by using the Display Level, Row Format, Show Roll-up Subtotals and Expand/Collapse Rows.

In addition to the Drill - Formatted Columns functionality the following "Right-Click" menu functionality is available:




Accounts Details tab

The screen has two sections.  The top half is the Assumptions sub-tab and bottom half is the BudgetSummary section.


As reviewed above and below, when in a Budget column selecting the "Edit Budget" option for a given row will open up the Account Details/Assumptions tab for the selected account number.



And below is the Account Details tab that opens up for the above selection:



Please note that the cells are white in color which means that could be edited.  To prevent editing Lock the Budget and Accounts in Manage Budgets and the cell color will change to grey.


A) Assumptions tab

Saving, Edit Status and Account Approval, Attachments, Confirm Not-Saved Popup, Expand/Reduce Column Width and Print to PDF functionality is available. Data can be copied to/from Excel using the Copy and Paste feature.


Comments and Spread can be viewed on clicking on the below button outlined in red.




Below is what the screen will look like when the above "View Comment" and "Show Spread" buttons are clicked.




Comments can be entered by typing in the “Comments" box and then clicking "Submit". The "View comments" button will change color from white to light beige to indicate that a comment has been saved.

Data can be entered using the Show Spread Calculation-Expanded Spread Method, Simple Spread Methods,  Row-to-Row Calculations, Cell Math Functions, Lookup, Copy and Paste, Apply Number Formatting, and Exclude Row Function. In addition data can be entered using the Import Budget Assumptions, Import Budget Assumptions Multi-Company, and Copy Bulk Assumptions.


When "Lookup" data is changed/edited, the Refresh Look-up Syn Status functionality together with the Budget Summary-Lookup Sync Status can be used to view the change against the original Lookup data.  The Refresh Spread Method Source Values functionality available.

 

The below "Right-Click" menu is available:




B) Budget Summary section.


There are five tabs which provide the following information:

1)  Acct History;

2) Monthly Variances;

3) Lookup Sync Status;

4) Main Acct History; and

5) View Save History.


Please note that appropriate data from the above tabs can be Copy and Pasted. If example, information on a View Save History row could be copied to replace the newest version of the same data in Accounts Details.

Also, please see related article: How Do I Add/Delete BudgetIDs Displayed on the BudgetSummary?


Per below the view of the Budget Summary section: 1) Can be made larger/smaller by dragging the solid black line; and 2) Be hidden or revealed by clicking on these arrows.


The below "Right-Click" menu functionality is available:


    • Related Articles

    • Custom Reports Tutorial

      PDF Tutorials  Interactive Tutorial Cropped Screenshots Full Page Screenshots           Purpose: To create custom reports which can include actuals, budgets, variances and comments for an organization. Other Related Tutorials & Page Links:* Step by ...

    • Define Custom Reports-Actual, Variance, Comments Tutorial

      PDF Tutorials  Interactive Tutorial Cropped Screenshots Full Page Screenshots           Prerequisite Steps: Make use of the reporting tags 1-10 in manage objects, orgunits and master chart of accounts. This helps with the display of desired accounts ...

    • Define Custom Budgets Entry Forms Article

      Custom Budget Entry forms can be designed with user-only specified data columns.  For example, prior year budgets and/or actuals. The process to setup these columns is discussed in the Column Formats article. These Forms are displayed using the ...

    • Custom Report User Access Visibility Tutorial

      PDF Tutorials  Interactive Tutorial Cropped Screenshots Full Page Screenshots           Other Related Tutorials & Page Links: * Step by Step Tutorial-Custom Reports * Knowledge Base Page Link-Custom Reports

    • Custom Budget Entry Article

         Tutorial Link Custom Budget Entry is used for entering and viewing budgets.   As discussed in the Define Custom Budgets Entry Forms, all of the columns can be user defined. Custom Budget Entry has two tabs: Dashboard and Account Details. Other ...