Lookup Article

Lookup Article

This standard functionality provides the ability to access data that is within the system and then copy the data to the appropriate Assumption Grid.

The general process will be discussed first followed by a review of the available data.


The Lookup functionality is available wherever the magnify glass icon is displayed on a selected Assumption Grid.



Click on the magnify glass icon to access the below Lookup Budget Assumptions screen. 



1) Select the type of data you wish to add to the Assumptions Grid.  This will be discussed in detail below.

The ability to display or hide data tabs as well as their left to right viewing order is managed in App Config/Menu Editor.  Please see A. Application Configuration Tab/item number 7.

2) Search for the required data.  Please note the Exclude Zero Values Accounts functionality is available.

3) An Advanced Search is available.

4) Once the search process is complete the requested data will appear in the yellow highlighted box area;

5) The process is now to select the required data and move it into the Data Shopping Cart.  There are two ways to select the data:

i) Double click the lookup row in any of the grids in the Lookup tab (highlighted in yellow above) - this will select a specific row; or

ii) Select all the data using the Copy and Paste functionality described in part B) of this article, and then right click and select the below option



Once the data is selected it will move in the Data Shopping Cart per below:



6) Click the button to move the data in the Data Shopping Cart to the Assumption Grid.  The Assumption Grid is the same place from where the Lookup Magnify Glass was originally clicked into.  Select 7) below before moving data.

7) The Exclude Row Function is available, namely the option to either add the data to the totals on the Assumption Grid or not.


The below shows data that was moved from the Data Shopping Cart to the Assumptions Grid on the Account Details screen.  Please note that the Green box that is highlighted indicates that the data on this line has the same values as the data it was copied from.  This data can now be changed and the Refresh Lookup Syn Status as well as the Monthly Summary - Lookup  Sync Status functionality can be used to determine whether the Lookup data is the same as its source data or has been changed.


Per 1) above the following data is available for selection:

a) Financial  - this data is by the full general ledger account string. 

b) Main Account - this data is totaled by Objects;

c) Object Rollup  - this data is totaled by Object Rollup as defined in Manage Objects ;

d) Vendor and Customers - data is totaled by Vendor and Customers;

e) Payroll Details;

f) Fixed Assets

Depreciation Summary - this is the summarized version of the depreciation forecast data imported from Great Plains Accounting Software;

Depreciation Details - this is the detailed version of the depreciation forecast data imported from Great Plains Accounting Software;

Capex Depreciation - please see Manage Capex; and

Capex Cost - cost data; please see Manage Capex.

g) Global Variances - as defined in Manage Global Variables ;

h) Analytical Accounting Code - additional lookups can be added to the system including third party add-on software to Great Plains Accounting Software.

i) Job Cost - as defined in Great Plains Accounting Software;

j) CRM   -  as defined in Dynamic Budgets;

k) Auto Forecast.


Related Article/s:

How Do I Add/Delete BudgetIDS that are Available in Lookups?

    • Related Articles

    • Refresh Lookup Sync Status Article

      When the Lookup functionality is used and the data is copied over from the Data Shopping Cart to the Account Details/Assumptions screen it appears as below, namely, the Green box indicates that the data is the same as the source data. The above data ...
    • Budget Summary-Lookup Sync Status Article

      When the Lookup data is edited on the Account Details/Assumption screen, the Refresh Lookup Syn Status functionality can be used to confirm that the data has been changed.  When the data has been changed the box turns from "Green" to "Red" as per the ...
    • Lookup Functions - Financial & Variables Video

      Click the brackets icon [  ] in the lower right of the video to expand to full screen,  hit escape to return to this page
    • InLookups Article

      In order for CompanyDB, BudgetID, Object, and Account Number (Budget Account Number)  data to be available for Lookup, the "InLookup" box needs to be respectively checked on Manage Company Databases, Manage Budgets, Manage Objects, and Manage Budgets ...
    • Basic Budget Entry Article

          Tutorial Link   Basic Budget Entry  is used for entering and viewing budgets within two tabs:  Dashboard  Account Details  Other entry and viewing screen options are the  Budgeting Dashboard , and the Custom Budget Entry .  The Dashboard tab ...