Manage Exchange Rates Article

Manage Exchange Rates Article

The functionality on this screen allows:

1) The ability to convert the currency the budget is budgeted in (the "Home Currency") to another currency (the "Parent Currency") upon export to Great Plains Accounting Software.

2) Upon exporting to Great Plains Accounting Software, the ability to control the implementation date of Budget when it is unknown at the time the budget was prepared.


1) Currency Conversion


i) In the below example the budget for the "000-Corp" OrgUnit was budgeted in Canadian Dollars, and we wish to convert the budget to US Dollars on export.


ii) To setup the conversion on the Exchange Rates screen:



A) Search for the budget you wish to convert;

B) Type in the currency you wish to convert to; therefore type over the "Default" setting;

C) Select the Rounding Method and Rounding Precision you wish to use.  Please see Manage Budget Accounts items 13) and 14) for more details;

D) Enter the conversion rate of the Home Currency to the Parent Currency.  In our example, 1.34 Canadian Dollars equals 1 US Dollar; and

E) Save your work.



iii) On the Export Budget to ERP screen, search for the budget you wish to export including selecting "Parent Currency" to export the budget in US Dollars.  As you can see below this search criteria converts the budgeted amounts into US Dollars.  For example, the beginning balance for Account Number 000-4110-02 was budgeted above at CAN$ 45 and below it is converted to US$ 34.  The calculation is 1/1.34 * 45 = 34.


Please note if you wish to export the budget in Canadian Dollars change the Currency selection to "Home Currency" and then Search.



2) Controlling the Implementation Date


i) Below we have created a budget for OrgUnit "100-Administration" starting in January.  However, this is new OrgUnit and therefore we wish to use the Manage Exchange Rate screen functionality to control the implementation of the budget. 



ii) On the Exchange Rates screen:

A) Search for the budget that you wish to manage;

B) Keep the "Native Currency" as "Default" or change it to "Default";

C) Select the required Rounding Method and Rounding Precision.   Please see Manage Budget Accounts items 13) and 14) for more details;

D) Enter the required percentage of the budget you wish to implement by month.  In our example, 0% in January, 25% in February etc; and

E) Save you work.



iii) On the Export Budget to ERP screen, Search for the Budget you wish to export including selecting the "Home Currency".  As you can see below, while above $6,250 was budgeted in January for account number 100-5100-00 the below search criteria results in $0 as the percent implementation in January was 0%.  And in February while $6,723 was budgeted above $1,681 is available for export as the percent implementation was 25% in February.



iv) If you wish to export 100% of the original budget change the Currency section to "Parent Currency" and then search.


    • Related Articles

    • Manage Capex Article

      Please note that in Manage Company Databases/Company Definitions, both Fixed Assets and Capex Labels need to be setup to activate this functionality.  For example, if the Capex Labels are not setup the following error message will appear: Please note ...
    • 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. ...
    • Manage OrgUnits Article

         Tutorial Link Purpose: During Client Configuration, the client's OrgUnits or Depts need to be added to Dynamic Budgets to make them available for budgeting and reporting purposes. They are managed in the Manage OrgUnits tab. ​ Once OrgUnits has ...