Refresh Lookup Sync Status Article

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 can now be edited. 

1) Please see below that $50 has been added to June; and

2) The change was saved.



Please note that the box remains "Green" even though the values have been changed.


In order to see whether Lookup values have been changed:

1) Highlighted the row you wish to check; and

2) Right click and select the "Refresh lookup syn status".



Once these actions have been completed as per below, the "Green" box will change to a "Red" box to indicate that the values on the screen are different to the source Lookup values. (Please note this can take a little time as a lot of records are being searched).


 

The Monthly Summary - Lookup Sync Status can now be used to view the variance between the original Lookup values and the Actual values.

    • Related Articles

    • 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 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 ...
    • Refresh Spread Method Source Values Article

      The Simple Spread Methods provides the option to spread a budget over months in the budget year using as the spread basis Actual data from Great Plains Accounting (ERP) software.  Should the selected Actual spread year remain open for posting, ...
    • Edit Status, and Account Approval Article

      Several screens include the ability to notate rows with an Edit Status and/or Account Approval.  1) Select the row to notate with the Edit Status and/or Account Approval; 2) Then use the pulldown menu for either Edit Status or Account Approval and ...
    • Forecast Builder - MultiCo Sync Article

      This screen functionality is the same as Forecast Builder - Design Forecast Templates/Update tab except on this screen multiple CompanyDB can be synchronized at the same time provided the "Selected BudgetIDs" use the same Forecast Template. When a ...