How Do I Calculate a Budget Line Item/s Based on Budgeted/Actual Data of Another Line Item/s? Article

How Do I Calculate a Budget Line Item/s Based on Budgeted/Actual Data of Another Line Item/s? Article

Lookup is the standard functionality which provides the ability to access data that is within the system and then fetch the data to the appropriate budget Assumptions Sub-tab.  Non-system data can also be imported in the Assumptions Sub-tab using the Import Budget Assumptions screen.  Then using the Row-to-Row Calculations functionality, math functions can be applied to the accessed data. 



    • Related Articles

    • Budget Details - Account Line Items Article

      This report displays both the Assumptions sub-tab and Budget Summary data from the Account Details tab according to the Search criteria.  Accounts Details tab is found in Budgeting Dashboard, Basic Budget Entry, Custom Budget Entry, Custom ...

    • Export Budget to GP Article

          Tutorial Link Note: For recovery purposes, Dynamic Budgets maintains an audit trail of all export sessions.  A snapshot of the before state of the records in Great Plains is captured as well as the batch of account records transmitted during the ...

    • Assumptions Data Monitoring Article

      This Tool allows a current Snapshot of the Assumption Data to be taken.  Prior Snapshots can be showed and/or deleted. A) To Take Snapshot Now From the dropdown menus select the CompanyDB and BudgetID for which you wish to take a Snapshot; Click the ...

    • Spread Annual Budget Article

      This screen provides the Administrator the ability to spread budget data entered by users.  In other words, users can enter a budgeted number for the year in a single month, say January, and the Administrator can then spread this number using the ...

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