The Change

This feature will allow configuration of different currencies across units within a single portal. The changes will apply across the Inventory aspects of the system.

Release Date: 26/10/2016

Reason for the Change

This change has been made to allow customers that have in locations with differing currencies to operate within a single Inventory portal. Previously this would have required separate implementations per currency.

Customers Affected

Customers that have locations in differing currencies will now be able to operate within a single portal. All other customers should be unaffected.

Release Notes

Changes to support multiple currencies within a single portal apply across the Inventory aspects of the system, in particular the following areas:

• Purchasing – Purchases will be made in the supplier currency with conversion back into the unit currency on approval to stock
• Stock management – Account movements, site transfers and requisitions will be in the unit currency. For site transfers and requisitions the value will be taken from the transferring site
• Management figure reporting – Management figures and management figure reports will be represented in the unit currency
• Master data – “Where Used” values for recipes and batches will be in the unit currency
• Documents – All documents are represented in the supplier currency with on screen conversion to unit currency possible

Note 1: Site the specific recipe cost price global setting must be enabled to support multi-currency functionality.

Note 2: Where no exchange rate is set for monetary values requiring conversion then a rate of “0” will be used, this may result in the value being displayed or updated to stock incorrectly.

Configuration

Where the global setting “Show Internationalisation Configuration” is set to “Yes”, when editing the detail against a unit the unit currency can be set:  
The list of currencies available is relative to the currencies that have been assigned to the organisation, these can be found under Setup > Currencies > Currencies:
  When no currency has specifically been set against a unit it will revert to the organisation currency, else the currency set against the unit is that which will apply to all movements in and out of stock.

All conversions will be based on the effective exchange rate set under Setup > Currencies > Exchange Rates:
 

Stock Management

Changes have been made to Stock Management in order to apply the unit currency to all movements in and out of stock as well as display the correct currency on screen.

The changes apply to the following pages:

• Stock Management > Management Figures
• Stock Management > Management Figures – Account Summary
• Stock Management > Management Figures – Deliveries & Transfers
• Stock Management > Site Transfer
• Stock Management > Account Transfer
• Stock Management > Wastage
• Stock Management > Transfer History
• Stock Management > Import POS Figures
• Stock Management > Enter POS Figures
• Stock Management > Stock Count
• Stock Management > Requisition
• Stock Management > Requisition Management

For requisitions and site transfers, where the transfer is across units operating in different currencies, the value of the transaction will be reflected in the unit currency for the relevant direction of movement.

For example, the below transfer is from “TestingUnit GBP > GBPSite” to “TestingUnit EURO > EuroSite”:
 
When viewing the transfer from the “TestingUnit GBP > GBPSite” the currency is displayed in GBP:
 
When viewing the transfer from the “TestingUnit EURO > EuroSite” the currency is displayed in EUR:  
The effective exchange rate for this transaction is 1 GBP = 0.87 EUR.

The value of the transfer will be based on the issuing site cost for the product or recipe and be distributed to the receiving site accordingly.

Multi-currency Support

Where the global setting “Supports multi-currencies” is set to “Yes”, the toggle between supplier currency and base currency will now convert to the unit currency as base, for example:    
Note, the underlying transaction is still recorded in the supplier currency.

This applies to the following pages:

• Purchasing > Pending Order Entry
• Purchasing > Order Management
• Purchasing > Order History
• Purchasing > Manual Input Order
• Stock Management > Home
• Stock Management > Goods Received Note
• Documents > Record Invoice
• Documents > Invoice Discrepancy
• Documents > Credit Request
• Documents > Record Credit Notes
• Documents > Supplier Return
• Documents > Document Search
• Documents > Document Reconciliation

Master Data

Updates have been made to the following Master Data pages to reflect the currency values are set with:

• Master Product List
• Batch Items
• Menu Items

This applies in particular to the Menu Items and Batch Items “Where Used” tabs, here the value of the batch or menu item will be displayed in the currency and cost to that location.

The following example highlights that the actual cost price is calculated and displayed in the currency for the unit:  

Reporting

The following management figure reports have been updated to reflect the unit currency:

• Accounting Figures
• Actual vs. Theoretical
• Closing Stock Value
• Closing Stock Value for Items Excluding GP
• Cost of Sales Reconciliation
• Stock Reconciliation
• Line Check Reconciliation

Where a report allows selection of more than one location, when multiple locations are selected it will revert to the organisation currency.

Analytics

Exports to Fourth Analytics, in addition to transaction/location currency, will also provide a conversion to the organisation base currency to allow results to be rolled up to a single organisation currency.

This change applies to the following exports:

• Stock Transactions
• Stock History
• Sales Transactions