Following article describes way of working with currencies for daily use operations and purchasing.
There are two types of currencies which can be set:
- System default currency
- Vendor specific currency
System default currency
System default currency can be specified in System settings, General information tab. It is the base currency used for all transactions, calculating stock value in assignments reporting data source and stock history data source and defining standard cost of items. Value of all transactions (including total value and value per piece) is always shown in this type of currency.
If not set otherwise, all vendors are using this type of currency by default for defining purchase and service price of items.
Vendor specific currency
If the system default currency is not suitable for a vendor, specific currency can be created in System settings, Purchase tab, and then set for a vendor in vendor detail. The specific currency must be always created with conversion ratio from the system default currency. Date of last update of the conversion ratio is stored and shown for each specific currency in the system settings.
Vendor’s currency cannot be changed if there are any items for this vendor already existing.
Once specific currency is set for a vendor, it will be used on following places instead of the system default currency:
- Purchase price per unit on item detail will be set in the vendor currency. Recalculation to system currency will be shown bellow the price.
- Service price per unit on item detail will be set in the vendor currency. Recalculation to system currency will be shown bellow the price.
- Price per unit and total price of item in order will be shown in vendor currency, including orders generated to PDF, Excel or XML formats.
- Price per unit and total price of item in order will be shown vendor currency in orders reporting data source.
- Total price of ordered items provided by sending interface will be in vendor currency.
Once order is changed to Active (is sent to a vendor), purchase price for all items in the order is recalculated to system default currency using conversion ratio valid in the time of the activation. All transactions related to ordering (transactions of types purchase, restock, goods received, cancelled ordered quantity or scrapped service quantity) will have main price of a transaction shown in system default currency, but will contain also price in vendor currency, which will be stored for these transactions in separate fields (as purchase price and purchase total price).
Changing conversion ratio between system currency and vendor specific currency will not affect existing orders in Active state.
Price per unit optionally shown in SFI during picking is always shown in system default currency, calculated from vendor specific currency by actual conversion ratio.