Background: Currency Codes Maintenance

Use the Currency Codes Maintenance (TCU) program to add or change, and copy codes that you can use as criteria for posting inventory to the general ledger and set up exchange rates. See Road Map for work flow.

This topic has these subtopics:

Currency Activation
Setting Up Exchange Rates
Deleting Codes
Reports
Audit Trail

Currency Activation

If you activated multi-currency during installation or database conversion the Currency field in other programs will be active. If multi-current is inactive, then the first time you run Currency Codes Maintenance (TCU), the program displays the message Multiple currency is not active. Run to activate.

Setting up Exchange Rates

Be sure to set up two conversion records for each currency you create. For example, if you create a Euro currency code, enter the exchange rate to convert to your base currency (US). You also need to enter the exchange rate to convert from US to Euros.

You should set up exchange rates for all combinations of the currencies you plan to use. If you do this, the system will be more flexible when you post invoices or other transactions, print financial reports in any currency, and consolidate general ledger accounts for reporting.

For example, if your base currency is US dollars and you also do business in Canadian dollars and Euros, you will need exchange rates for the following:

TO currency	FROM currency
US	US (exchange rate 1.00) Added by the system; it cannot be deleted or changed
US	CD
US	EU
CD	CD (exchange rate 1.00) Added by the system; it cannot be deleted or changed
CD	US
CD	EU
EU	EU (exchange rate 1.00) Added by the system; it cannot be deleted or changed
EU	US
EU	CD

New rates may only be added in an open general ledger period. Exchange dates must be in an open period. A record can not be modified if the exchange date is in a closed period.

Deleting Codes

Before you delete a code be certain that no customer, pricing, sales rep, or vendor records reference the code. When you delete a currency code, its rate records are also deleted.

Reports

A number of reports throughout the system allow you to print the currency used for transactions or convert to the currency you select. For example:

GL Activity Report (GAR) to print a report that shows debits, credits, net change, current balance, and profit for a period.
Financial Reports Print (GP) to print financial reports.
GL Trial Balance (GTB) to print trial balances in detail, summary, or worksheet format for an accounting period.
Inventory Valuation Inquiry (IVQ) to display the current value of inventory based on standard, actual, or average cost.
AP Aged Trial Balance Report (NTB) to print an aging schedule for selected vendors by invoice date or due date.
AP Transaction Inquiry (NTI) to display invoices, credit memos, fixed expenses, payments, and discounts taken.
AR Transaction Inquiry (RTI) to display AR transactions.
Sales Analysis by Month (SAM) to print a report that shows invoiced sales for the current month, previous 11 months, and total for the year.
YTD Sales Comparison (SAY) to print a report that compares sales to-date for the current year with the previous year by region or product class.
Sales Margin Report (SC) to print a report that shows the gross and net, discount amount and percent, cost, margin amount and percent for sales shipments.
Cost of Goods Sold Report (SCOG) to print a report that shows the total cost, standard labor, labor overhead, machine overhead, and outside service cost for the quantity of an item that you shipped.
Sales by Item Report (SI) to print a list of sales orders by item.
Sales by Product Class (SPC) to print a list of sales shipments by product class.
Regional Sales by Product Subclass (SPCR) program to print a report of sales by region and product subclass.
Sales Analysis by Sales Region (SR) program to print a list of shipments by sales region.
Sales by Rep Report (SS) to print a sales commission report that includes orders for which shipments have been created.
Sales by Item with Commission Split (SSI) program to print an item sales report that shows commission splits.
WIP Valuation Inquiry (WIVQ) to display work in process quantity and costs for each open manufacturing order.

Audit Trail

To activate an audit trail, select one of the files listed below in the Audit Trail Maintenance (XAT) program. The system records all transactions. You can then run the Audit Trails (ATR) program and select that file to print a report of these transactions.

C2D: Currency Codes
C2R: Currency Exchange Rate