When Multi Currency is enabled

The Multi Currency feature in R2 will be available only if the option "Apply Multi Currency " is set as true in configuration settings. If set as false, the options/fields/tabs related to Multi Currency will be either hidden or disabled.

User cannot enable/disable the multi-currency field. If they want to enable/disable, they must reach out to UBS. 

Apply Multi-Currency - True

Configuration

Multi Currency Tab will be active if the “Apply Multi Currency” option in Configuration is set as True.

Orders

In Orders , a tab called Multi Currency is displayed which allow the user to see Multi Currency information.

In the Order Cost tab, the cost will be displayed according to the currency code type chosen in the Currency dropdown.

For the item lines added to the order, the Site Price column will show the item price in the site's currency, while the Unit Price will reflect the price in the transaction currency.

In the Sub total tab of the order, the field Site Amount will be available wherein the user can define the Site Currency based amount for Damage Waiver , Service Charge and Consumable.

In the Update Line details dialog which is invoked from within an order, the user will be able to view and modify the Site Currency amount defined/present for the item in the order.

Purchase Orders

In Purchase Order, the Multi-Currency tab will be displayed wherein the user can set the Multi Currency settings.

For the Item Lines added to the purchase order, the column Site Price  will display the item price based on site currency and the unit price will be displayed based on the Transaction Currency.

Voucher

In Vouchers, the currency information will be displayed in the Multi-Currency tab as shown below.

While importing a Purchase Order into a voucher, the site price present on the Purchase Order  will be displayed in the PO site Price field and the Site Currency field will display the voucher price based on voucher site currency.

R2 Reports

While generating reports in R2, the user can select a currency based on which the report will be generated. In R2 standard reports, the option for selecting currency is provided in the respective report options dialog box and all custom reports will be generated based on the currency selected in the configuration module.

Standard Reports Illustration

Custom Reports

To generate the custom reports based on Multi-Currency,   the user has to preset the currency  in the field " Generate Reports based on Currency" which is present in the Multi-Currency Tab of configuration settings (as shown below).

Site

In Site Edit window, the field Currency will be available using which the user can set default currency for a site.

Pricing

The user can define pricing based on Site currency  also define the Pricing for transactions based on different currency conversion rates which will be defaulted to the order for item / vendor whenever the corresponding currency code is selected.

Item Pricing Dialog

Vendor Pricing Dialog

Scan Items Dialog ( Displayed while receiving items)

In Scan Items Dialog the user can define cost / item received  in Site cost (Cost based on Site Currency) and Base Cost (Base Currency based cost). On defining Site Cost for the item , the Base Cost will be automatically  calculated based on the conversion rates in the configuration from  the Site Currency (Currency of the site in which Item is received) to the Base Currency and the cost defined  would be considered while calculating Site Av.Cost   and Base Av. Cost  for the item respectively.

Av.Cost : - Average Cost of item based on the cost defined and the quantity received.

Item Edit Window

In Item Edit window, the average cost  per item will be displayed based on the Site Cost and Base Cost defined while receiving the item in the highlighted fields and the Site Retail field will display the retail pricing based on the site in which the item is opened for editing.

By default the Average Site Cost for the item will be calculated as the (Sum of  Site Cost of all Item Received) / No: of Item Received) and Base Cost will be calculated based on the conversion rates in the configuration from  the Site Currency (Currency of the site in which Item is received) to the Base Currency. The user can also manually define the Average Site Cost for the item on which the Average Base Cost will be recalculated based on the conversion rates applicable, however on modifying the Average Site Cost, system will not re-calculate the Average Base Cost.

Asset Edit Window

In Asset edit window, the user can define Site Currency based Cost (Site) and Base Currency based cost (Base ) in the highlighted fields above.

Apply Multi-Currency - False

Configuration

Multi Currency Tab will be active if the option is set as False.

Orders

In Orders , the  toggle button Multi Currency / Payment will be hidden.

In the Cost Tab of the Order , the field Currency field will be hidden.

The column Site Price  in order window will hidden if the option "Apply Multi-Currency" is de-selected in Configuration.

In the  Sub Total Tab of the order the field Site Amount will be hidden for Damage Waiver , Service Charge and Consumables.

In the Update line details dialog , the field Site Price will be hidden, if the option " Apply Multi Currency " is de-selected in Configuration.

Purchase Orders

In Purchase Order, the Multi Curr tab will be hidden if the option "Apply Multi-Currency" is de-selected in Configuration.

For the Item Lines added to the purchase order, the column Site Price column will be hidden if the option "Apply Multi-Currency" is de-selected in Configuration.

Voucher

In Vouchers, the Multi-Currency Tab Will  be hidden if the option "Apply Multi-Currency" is de-selected in Configuration.

While importing a Purchase Order into a voucher, the site price  will be hidden if the option "Apply Multi-Currency" is de-selected in Configuration.

R2 Reports

In R2 Standard Reports the currency field will be disabled if the option "Apply Multi-Currency" is de-selected in Configuration.

Illustration

Site

In Site Edit window, the field currency will be disabled if the option "Apply Multi-Currency" is de-selected in Configuration.

Pricing

The Tool Bar Icons and the field Site Currency  will be disabled in the Item Pricing and Vendor Pricing Definition window  if the option "Apply Multi-Currency" is de-selected in Configuration.

Item Pricing

Vendor Pricing

Scan Item Dialog ( Displayed while receiving items)

In Scan Items Dialog the user can define cost / item received  in Site cost (Site based cost of the item) . The price defined  would be considered while calculating Site Av.Cost  for the item.

Item Edit Window

In Item Edit window, the average cost  per item will be displayed based on the Site Cost  defined while receiving the item in the highlighted field.

R2  Fields/Features with Fixed Currency types

R2 will always consider the value defined in global / regional  fields (Fields which would be used for Multi-Currency calculation) always in Fixed currency  type i.e., as either Base Currency/ Site Currency.   

Fields / Features with fixed currency type as Base Currency

Customer

• Credit Limit  - This would be considered while approving credit for orders.

• Credit Available

• Balance Due - On clicking the importable button in the Balance due field, user will be able to view the details of the Orders in different currency.

• Ins.Amount

• Deductible Amount

Security

• Approvable amount  in Purchase Order Policies (Amount >)

Fields / Features with fixed currency type as Site Currency

Item

Average Cost (Avg.Cost):

By default the Average Site Cost for the item will be calculated as the (Sum of  Site Cost of all Item Received) / No: of Item Received) and Base Cost will be calculated based on the conversion rates in the configuration from  the Site Currency (Currency of the site in which Item is received) to the Base Currency. You can  also manually define the Average Site Cost for the item on which the Average Base Cost will be recalculated based on the conversion rates applicable , however on modifying the Average Site Cost, system will not re-calculate the Average Base Cost.

Receiving Cost per Item ( Cost defined in while receiving items into the inventory):

While receiving Items, the cost per item can be defined in multiple currencies as in Site Currency and Base Currency in the Scan Items Dialog (Displayed while receiving items).  On entering the Site Cost for the Item , the Base Cost will be automatically calculated based on the conversion rates from the Site Currency (Currency of the site in which Item is received) to the Base Currency, however on modifying the Base Cost , system will not re-calculate the Site Cost for the item.

On receiving items via purchase orders , the Purchase Order Site Price will be defaulted as the Site Cost (Site Currency Cost )and the  Base Cost (Base Currency Cost) will be updated by the conversion of Site Currency to Base Currency in the Purchase Order.

Site Retail Price:

Illustration:

Item Pricing Definitions

System will display retail pricing for the item based on the currency of the site in which the item is opened for editing. Refer illustration below for detailed functionality

Replacement Cost (Repl.Cost)

The replacement cost defined for the Item, Asset will be always considered for all the sites, and will be considered while applying Pricing Formula and Update Replacement Cost for the item.(Click here for more information)

Asset

• Cost

Site

• Service Charge , Consumables Amount of type Fixed.