Maintain Currency Table (CC22)


Index
Maintain Currency Table (CC22)

The Maintain Currency Table (CC22) is the centralized location to enter the currency exchange rates for the Accounts Payable, Accounts Receivable and Purchasing systems.

Note: If an invoice cycle is still open the message ‘You must finish all invoicing cycles before changing the AR exchange rate. OK’ displays upon the initial entry into the CC22 Currency Table program. Click ‘OK’ to clear the message and open CC22. When CC22 opens the Accounts Receivable Exchange Rate field is disabled and you will not be able to change it until all invoice cycles are completed. The follow describes every field in the Maintain Currency Table:

  • Currency Code - Enter or select from the query the appropriate Currency Code. This field can be a maximum of four characters.

  • Description - Enter a maximum of 20 characters as the Description of the Currency. The description can be changed at any time.

  • Type - This field defaults to ‘Domestic’ but you can select the ‘Foreign’ currency from the drop list. If you select ‘Domestic’, the three rate fields are disabled and defaulted with a value of 1.000000. If you select Foreign, the three rate fields are enabled for entry of the exchange rates.

    Note: The Type field is disabled and cannot be re-assigned if the currency code is already assigned to one or more of the following programs:

    • AP bank Code (AP01)
    • A/R Bank Code (AR02)
    • Purchasing Record (PO13)
    • Landing Factor (PO03)
    • Open PO Receipt Batch (PO60)

The Exchange Rates allows you to enter exchange rates for the foreign currency with up to 6 decimals places.

The following fields are available in the Exchange Rates section:

  • Accounts Payable - Enter the rate to use in the AP system.

  • Accounts Receivable - Enter the rate to use in the AR system. Note: : If an invoice cycle is still open then the Accounts Receivable Exchange Rate field is disabled.

  • Purchasing - Enter the rate to use in the PO system. Note: : The purchasing exchange also may be changed at the point of receiving in Enter Receipts/In-Transits (PO60).

The following table outlines the functionality of each button on the Maintain Currency Table panel:

Button Label Icon Functionality
Update Update Saves the information entered for the current record.
Delete Delete Deletes the current record. Note: : You cannot delete the record under the following circumstances:

  • The currency is assigned to Price lists in Maintain Price Lists (IM18). The message ‘Price Lists are using currency xxx. Deletion of xxx cannot continue. OK’ displays. Click ‘OK’ to clear the message.
  • The currency is assigned to a record in Maintain Payment Methods (IN08) . The message ‘You must delete the references to this Currency from IN08. OK’ displays. Click ‘OK’ to clear the message.
  • The currency is assigned to a record in Maintain Bank Codes (AP01). The message ‘AP Bank Codes are using currency xxx. Deletion of xxx cannot continue. OK’. Click ‘OK’ to clear the message.
  • The currency is assigned to a record in Maintain Bank Codes (AR02). The message ‘AR Bank Codes are using currency xxx. Deletion of xxx cannot continue. OK’. Click ‘OK’ to clear the message.
  • The currency is assigned to a record in Maintain Purchasing Info (PO13). The message ‘Purchasing Masters are using currency xxx. Deletion of xxx cannot continue. OK’. Click ‘OK’ to clear the message.
  • The currency is assigned to a record in Enter Receipts/In-Transits (PO60). The message ‘Purchase Orders are using currency xxx. Deletion of xxx cannot continue. OK’. Click ‘OK’ to clear the message.
New New Clears all of the fields that are not defaulted to specific values.

Maintain Currency Table (CC22)
Maintain Currency Table (CC22)