The ChangeThis 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 ChangeThis 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 AffectedCustomers that have locations in differing currencies will now be able to operate within a single portal. All other customers should be unaffected.
Release NotesChanges 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.
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:
All conversions will be based on the effective exchange rate set under Setup > Currencies > Exchange Rates:
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.
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
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:
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.
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
Please sign in to leave a comment.