cats:procedures:currencies

This is an old revision of the document!


CATS allows you to use multiple currencies in the system. To do this, you set up a default currency (usually USD) and any other currency products you want to use. CATS asks you to input currency rates to figure out the amount for conversion to the default currency.

Currencies are used for determining prices and amounts throughout the entire system.

A bank code can only use one currency. This means that all transactions into one bank must use a single currency. This same restriction also applies to G/L numbers.

To begin using currencies, you must first add the currency as an exchange product and an exchange, then you can enter a default currency rate to be used.

Adding an Exchange Product for the Currency

First, you will need to add an exchange product for this currency. From the Main menu, go to Exchange Trades > Exchange Products.

Go to Exchange Trades > Exchange


The Exchange Products scan will pop up. Select Add from the toolbar menu to create a new exchange product. In the next box, enter a code for the new currency, such as CAD, for CATS to use as the exchange name.

For CATS to recognize this product as a currency, the Exchange field must be filled in as CUR.
Enter a code for the new currency.


Pick Apply to continue. Enter more details about the CAD exchange product you have added on the next screen, then pick Apply to proceed.

Enter details about the new currency.


CATS will return to the list of exchange products so you can review your changes. Pick Exit to leave this scan.

Select Exit after reviewing the newly added exchange product.

Adding an Exchange for the Currency

Next, you will need to add an exchange for each currency. From the Main Menu, go to Exchange Trades > Exchange.

Choose Exchange Trades, then Exchange from the File menu.

Choose Add from the toolbar menu to create a new exchange.

Pick Add to create the new exchange.


Enter a code for the new exchange. To make this easier, you should use the same code you used for the exchange product above.

Enter a code for the new exchange.

Select Apply to proceed. On the next screen, you can input more details about this currency exchange. When you have finished, pick Apply to return to the list of exchanges.

Enter details about this exchange, then select Apply.

You will see the new exchange on the list.

The exchange will be added to the list.

Select Exit to leave this scan.

CATS uses several ways to find the exchange rate for currencies.

Positions on the Exchange

You can set up default rates on a daily or monthly basis for CATS to use with currencies. This is done by adding these rates as positions in the Positions on the Exchange area. Starting from the main menu, go to Exchange Trades > Positions on the Exchange.

Go to the Positions on the Exchange area.


This is a list of positions currently active in CATS that are used to value material, or, for our purposes, currencies. Next, select Add from the toolbar menu to create a new position for the currency.

Select Add from the toolbar menu to create a new position for the currency


Enter details about the new exchange position here:

  • Enter the Exchange as CUR.
  • Enter the Product as CAD (or your chosen currency code).
  • Enter a position date.
  • Choose Not an option from the drop-down menu.
Enter details about the currency position to be added.

When finished, click Apply to continue.

Rates on Contract Items

Rates on Invoices

Rates on Broker Commissions

Currency Rate Table

Contact New Data Systems to see how to turn on the setting to allow you to use multiple currencies.
  • cats/procedures/currencies.1551898316.txt.gz
  • Last modified: 2019/03/06 18:51
  • by amanda