Currency - SuperOffice

If the sale has a quote, you will not be able to set or change the currency of that sale.

View base currency

NSListAgent listAgent;
printLine("Base currency: " + listAgent.GetBaseCurrency().GetName());

Make sure the currency-related preferences are set before using GetBaseCurrency(). Otherwise, you might end up with a default value that produces some interesting conversion results!

List currencies and their conversion rate

Using the SearchEngine

SearchEngine se;
se.addFields("Currency", "Currency_id,name,rate,units");
print(se.executeTextTable());

Using the listAgent

NSListAgent listAgent;
NSCurrencyEntity[] currencyList = listAgent.GetAllCurrencies(false);
for(Integer i = 0; i < currencyList.length(); i++) {
  printLine(currencyList[i].GetCurrencyId().toString() + " | " + currencyList[i].GetName() + "\t Rate: " + currencyList[i].GetRate().toString(1) + "\t Units: " + currencyList[i].GetUnits().toString(1));
}

Calling GetCurrencies() will give you the slim NSCurrency items. If you need more info than name and ID - such as the rate and units - then you need to retrieve the complex NSCurrencyEntity.

How currency conversion works

Get the amount and currency ID from the sale.
Using the list agent, get the relevant NSCurrencyEntity and extract the rate and currency unit.
Do the math.

Convert to the base currency

Divide by rate and multiply by units.

NSListAgent listAgent;
NSSaleAgent saleAgent;

NSSaleEntity sale = saleAgent.GetSaleEntity(4);

NSCurrencyEntity currency = listAgent.GetCurrencyEntity(sale.GetCurrency().GetId());

Float amount = sale.GetAmount();
Float rate = currency.GetRate();
Float units = currency.GetUnits();

Float result = amount/rate*units;

printLine(amount.toString(1) + " in " + currency.GetName() + " equals " + result.toString(2) + " in " + listAgent.GetBaseCurrency().GetName());

Convert from the base currency

Divide by units and multiply by rate. In this case, you need to call GetCurrencyEntity() with the ID of the target currency, not the one obtained from the sale!

NSListAgent listAgent;
NSSaleAgent saleAgent;

NSSaleEntity sale = saleAgent.GetSaleEntity(4);

NSCurrencyEntity currency = listAgent.GetCurrencyEntity(77);

Float result = sale.GetAmount()/currency.GetUnits()*currency.GetRate();

printLine(amount.toString(1) + " in " + listAgent.GetBaseCurrency().GetName() + " equals " + convertedAmount.toString(2) + " in " + currency.GetName());

Convert between any 2 currencies

You can either do a two-step conversion via the base currency or calculate the relative rate between those 2 currencies and apply that directly. The latter is more efficient if you’ll be doing multiple conversions In this example, we assume we know the ID of the start and target currency and also the amount to be converted. Thus, we don’t go via the sale object.

Integer startCurrencyId = 76;
Integer targetCurrencyId = 27;
Float amount = 1000.0;

NSListAgent listAgent;
NSCurrencyEntity currencyA = listAgent.GetCurrencyEntity(startCurrencyId);
NSCurrencyEntity currencyB = listAgent.GetCurrencyEntity(targetCurrencyId);

Float conversionRate = (currencyA.GetRate()*currencyB.GetUnits())/(currencyA.GetUnits()*currencyB.GetRate());

Float result = amount*conversionRate;

printLine(amount.toString(2) + currencyA.GetName() + " is " + result.toString(2) + currencyB.GetName());
printLine("Relative exchange rate: " + conversionRate.toString(2));

This works even if one of the IDs represents the base currency! Thus you could wrap it up in a reusable function:

Float convertCurrency(Float amount, Integer startCurrencyId, Integer targetCurrencyId) {
  NSListAgent listAgent;
  NSCurrencyEntity currencyA = listAgent.GetCurrencyEntity(startCurrencyId);
  NSCurrencyEntity currencyB = listAgent.GetCurrencyEntity(targetCurrencyId);

  Float conversionRate = (currencyA.GetRate()*currencyB.GetUnits())/(currencyA.GetUnits()*currencyB.GetRate());

  return amount * conversionRate;
}

Float amount = 1000.0;
printLine(convertCurrency(amount, 76, 27).toString(2));

​View base currency

​List currencies and their conversion rate

​Using the SearchEngine

​Using the listAgent

​How currency conversion works

​Convert to the base currency

​Convert from the base currency

​Convert between any 2 currencies

View base currency

List currencies and their conversion rate

Using the SearchEngine

Using the listAgent

How currency conversion works

Convert to the base currency

Convert from the base currency

Convert between any 2 currencies