InLookups Article

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 Accounts.



Below is an example of a Lookup Search screen.



Please note it can be a useful tool to limit the number of available CompanyDBs, BudgetIDs, Objects and Account Numbers in their respective Search dropdown menus to only those that are necessary by unchecking the "InLookups" boxes as this can result in a "decluttered" search dropdown menu.


Below Actuals 2015 and 2016 were selected while the 2014 Forecast and others were not.



Below Actuals 2015 and 2016 appear in the  Search dropdown menu while 2014 Forecast and others do not.



Related Article/s:

How Do I Add/Delete Budget IDs that are Available in Lookups

    • Related Articles

    • Manage Budgets Article

          Tutorial Link Purpose: To provide tools to manage budgets such as budget list, budget creation, delete/purge budget, lock budgets/acct #s, link actual GP data & display setup, display budgetids, forecast setup, create historical avg for spreads. ...
    • Manage Budget Accounts Article

      Standard functionality is Print, Export to Excel, Print to PDF, Auto-fit Columns, Expand/Reduce Column Width, Filter, Column Data Sort - Ascending/Descending, and Copy and Paste. The Right-Click Menu and Short-Cut Keys are: In order to free-up ...
    • Manage Objects Article

          Tutorial Link Purpose:  The client's objects already in GP, are synchronized/added from GP into the Dynamic Budgets manage object screen. Add'l setup procedures are completed including flags, sensitivity levels, object rollups & tag labeling. ...
    • Converting From Negative to Positive Revenue Format Article

      When converting from a Negative to Positive Revenue Format on Manage Company Databases  and you have several years of data where revenues were recorded as negative values, please run the below script. Also, please see How to Convert Revenue Display ...
    • How Do I Add/Delete BudgetIDs that are Available in Lookups? Article

      When using the Lookups functionality, the BudgetID dropdown lists the BudgetIDs that are available for Lookup.    Whether a BudgetID is available for Lookup is determined in Manage Budgets.  1. From the dropdown menu select the CompanyDB; 2.Click the ...