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.Was this helpful?
0/255
Upload Attachment
File Upload
Maximum file
size allowed is 3 MB.
Supported file types:
Documents (.txt, .doc, .docx, .pdf), Images (.jpg, .png), Comma Separated Files
(.csv) Speadsheets (.xlsx, .xls)
Are you sure you want to cancel the case creation?
Case closed successfully
File Upload
Maximum file size allowed is 3 MB.
Supported file types:
Documents (.txt, .doc, .docx, .pdf), Images (.jpg, .png), Comma Separated Files
(.csv) Speadsheets (.xlsx, .xls)
Are you sure you want to close this case
| Products | Region | Phone Numbers |
|---|---|---|
| FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield |
North America * |
+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America) |
| Europe * |
+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe) |
|
| Japan * | +81 3-4540-5335 (select option 2) | |
| Australia * |
+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia) |
|
|
Usage Intelligence (formerly
Revulytics) Compliance Intelligence |
Please use the Case Portal to submit your support ticket or reach out to your Revenera contact. | |
File Upload
Maximum file
size allowed is 3 MB.
Supported file types:
Documents (.txt, .doc, .docx, .pdf), Images (.jpg, .png), Comma Separated Files
(.csv) Speadsheets (.xlsx, .xls)
Case id: 00001065
Activity: Status change: 2 hours ago