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 RoundingMethod and RoundingPrecision 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 "NativeCurrency" as "Default" or change it to "Default";

C) Select the required RoundingMethod and RoundingPrecision.   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.