Follow

Customer Specific Currency

This article describes the process to manage currency values and number formats by customer in Demand Planning. This is applicable to companies running DemandCaster across multiple locations across the globe. This supplements the current currency and number format settings managed in DemandCaster's company settings.

To enable this feature, please contact DemandCaster support.

Company Settings

The base number and currency formats are managed in company settings.

  1. Culture sets the number format, date format, and currency symbol format in DemandCaster as a default.
  2. Upload culture changes the date format of the upload. The numbers format is the same as the company culture.

Customer Specific Currency

As defined in the data tables article, DemandCaster supports customer specific currency in Demand Planning. There are two tables provided below that set the currency symbol and number format by customer.

Multi-Currency Rates (currencyrates.txt)

DemandCaster supports multi-currency. This table sets the rates by currency that is in use at the company level (global currency).

  • Column A: Currency Name
  • Column B: Rate against the global currency

Currency by Customer (customercurrency.txt)

DemandCaster supports multi-currency. This table sets the currency basis by customer. Please note that if this option is used, the customer order table must represent each sales order line in its local currency.

  • Column A: Customer Code
  • Column A: Currency Name  should exists in the system ( uploaded via the currencyrates.txt file )

Result

As you can see below, once enabled, each customer presents it's data in its own currency. In the example below, the first line presents its currency and number format in British pounds. The second line is presented in Euro's.

To view the details of the currency and number format, please click edit. The second image presents the selected currency.

Clicking on the currency drop down allows users to change the selected currency.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments