Summary
This knowledge base article describes a workaround for a current limitation of FlexNet Manager Suite when an operator tries to use one-off spreadsheet upload with financial figures. Currently spreadsheet upload only supports your default currency.
Synopsis
There is a current limitation of FlexNet Manager Suite when an operator tries to use one-off spreadsheet upload with financial figures. Currently spreadsheet upload only supports the single currency that you have set as your corporate default currency.
The highlighted column value is imported as your default currency type.
Discussion
Current limitations of spreadsheet uploads include:
1. Any financial value is imported as your default currency type. For example, if you have set USD as your default currency in FlexNet Manager Suite, all financial values in an imported spreadsheet are in USD.
2. There is no support for one spreadsheet containing multiple items (such as purchase orders) that refer to different currencies. All spreadsheet rows use the same default currency.
Workaround
Instead of using spreadsheet imports for multi-currency scenarios, use a business adapter created through the Business Adapter Studio. Business adapters have a more mature data model, and support mapping items to multiple currencies.