Using Multiple Currencies in CATS [CATS Knowledge Base]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
=====Using Multiple Currencies in CATS=====
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. 

<note>
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.</note>

====Setting up Currencies in CATS====
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**. 
[{{:cats:procedures:currency:currencies_exchangemenu.png|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. 
<note important>For CATS to recognize this product as a currency, the **Exchange** field must be filled in as **''CUR''**.</note>
[{{:cats:procedures:currency:currencies_exchangeproductcuradd.png|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. 
[{{:cats:procedures:currency:currencies_exchangeproductdetailsadd.png|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. 
[{{:cats:procedures:currency:currencies_exchangeproductscanpostadd.png|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**.
[{{:cats:procedures:currency:currencies_exchangemenu.png|Choose Exchange Trades, then Exchange from the File menu.}}]
Choose **Add** from the toolbar menu to create a new exchange.\\ 
[{{:cats:procedures:currency:currencies_exchangeaddfromscan.png|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.\\ 
[{{:cats:procedures:currency:currencies_exchangecuradd.png|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.\\ 
[{{:cats:procedures:currency:currencies_exchangedetailsadd.png|Enter details about this exchange, then select Apply.}}]
You will see the new exchange on the list. 
[{{:cats:procedures:currency:currencies_exchangeaddedtoscan.png|The exchange will be added to the list. }}]
Select **Exit** to leave this scan.

====Entering Currency Rates====
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**.
[{{:cats:procedures:futures:exchangetrades_positionsontheexchange.png|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. 
[{{:cats:procedures:futures:exchangetrades_addpositiononexchange.png|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.
[{{:cats:procedures:currency:currencies_addingpositionontheexchange.png|Enter details about the currency position to be added.}}]
When finished, click **Apply** to continue. CATS will display the list of positions again. Select **Exit** to leave this area. 

===Rates on Contract Items===
Currency rates can be entered on fixed prices and differentials on individual contract items. This helps CATS calculate the default currency amount. 

<note tip>You can enter either a fixed currency rate **OR** use a currency position you have already added in the system. </note> 

While reviewing a contract item, choose **Price$** from the menu to change the fixed price on the contract item. 
[{{:cats:procedures:currency:currencies_contractitem_selectpricefrommenu.png|Choose Price from the menu to change the fixed price on the contract item.}}]

Enter a currency code in the **''CUR''** box. Then, you can enter either a rate in the **''Rate''** box OR a currency month in the **''Mn''** and year **''Yr''** boxes. In this example, we have entered **''CAD''** and **''5''** **''19''**, which means the currency rate for CAD for position 2019-05 will be used.  
[{{:cats:procedures:currency:currencies_contractitem_yearmonthonfixedprice.png|Entering a currency code and month and year on an item.}}]
Choose **Save** from the menu above to save and continue. CATS will display the currency rate to be used in the P&L box above.
[{{:cats:procedures:currency:currencies_contractitem_rateandyearmonthshown.png|CATS will display the currency rate to be used in the P&L box above.}}]

When viewing the list of contract items, you can also see which currency the item is priced in.
[{{:cats:procedures:currency:currencies_contractitem_currencyonitemlist.png|CATS displays the currency in the item list.}}]

To change the differential price, select **Dffntl$**.
[{{:cats:procedures:currency:currencies_contractitemselectdffntlfrommenu.png|Select Dffntl$ to change the differential price on a contract item.}}]

Enter a currency code in the **''CUR''** box. Then, you can enter either a rate in the **''Rate''** box or leave it blank to use the currency rate for the differential position. 
[{{:cats:procedures:currency:currencies_contractitem_entercurrencyrateondiff.png|Enter a currency code and a rate or use the differential position month.}}]
Pick **Save** from the menu to apply and continue.
<note important>Remember, unless you are using a USD/Lb basis, the differential field is in dollars per unit, not in cents. </note>

CATS will display the rate you have selected.
[{{:cats:procedures:currency:currencies_contractitemdifferentialpricerate.png|Reviewing the currency rate on the differential.}}]



===Rates on Invoices===
===Rates on Broker Commissions===
===Currency Rate Table===

====Multiple Currency Transactions====

====Turning on the Multiple Currency Setting====

<note important>Contact New Data Systems to see how to turn on the setting to allow you to use multiple currencies.</note>