This topic describes the steps to bill your first multicurrency invoice and enter a payment for that invoice.
Costpoint recognizes the following three currency types for recording billing and accounts receivable transactions:
Functional Currency - Your functional currency was selected when your company originally installed Costpoint. This is the currency used for your company's financial statements. Once the functional currency is selected, you should not change it. (If you are unsure what your functional currency is, display the Configure General Ledger Settings screen.)
Transaction/Billing Currency - When you prepare invoices, this currency displays on the outgoing invoice.
Transaction/Receipt Currency - This is the currency in which your customer pays the invoice.
For more information on using multiple currencies, see Currencies in Costpoint.
Before you start the billing process, determine the billing currency. For this example, we assume the following:
Your functional currency is United States dollars.
You are creating an invoice with a billing currency of Japanese yen.
You have not initialized any portion of Costpoint Multicurrency.
Use the Manage Currencies screen to select the currencies that will be used in Costpoint. Costpoint has loaded over 150 currency ISO codes into your system. An ISO code is a three-letter abbreviation selected by the International Standards Organization to identify each currency.
Use Lookup in the Currency ISO Code field to select JPY (Japanese yen). Accept or override the formal and informal names for this currency. In addition, you need to review the four formatting group boxes on this screen to make sure that your transaction currency (Japanese yen) adheres to the formatting standards of that country (Japan). The Decimal Digits field in the Currency group box is the most important. This field determines the rounding that occurs when this currency is displayed or printed in Costpoint. Some currencies with a relatively low value do not show any numbers to the right of the decimal point. You can choose to display two, one, or no digits to the right of the decimal.
Use the Manage Currency Status screen to activate this currency. You do not need to enter an activation or expiration date for this currency in the Currency Status group box. However, if you do enter an activation and expiration date, transactions in that currency are only allowed within that date range. If you enter only an activation date, no transactions in the currency are allowed before the activation date but there is no expiration date. If you enter only an expiration date, transactions in the currency are allowed from the current date until the expiration date.
Use the Manage Exchange Rate Sources screen to specify sources for your exchange rates. You can have any number of sources, but you must designate one as the default source.
While there are dozens of sources for exchange rates, most companies select one source and use it as the exclusive source for their rates.
In the Manage Exchange Rate Groups screen, create a rate group. The rate group links a rate source (already selected in step 3) to one or more currency relationships (from United States dollars to Japanese yen in our example).
For each transaction currency you use, create a relationship (and later enter a rate) between those currencies and your functional currency. All billing and accounts receivable transactions are processed through the functional currency, not directly from billing transaction currency to receipt transaction currency.
If this is your first accounts receivable transaction, review the settings on the Configure Multicurrency Settings screen. (These settings are usually established when you initialize Costpoint Multicurrency.) Your company's functional currency (in this example, United States dollars) is displayed in the Functional Currency field in the Currency Settings block. The default transaction currency should be the currency that you most frequently use as your billing and accounts receivable currency. Though this invoice will be transacted and paid in Japanese yen, you should not enter JPY in Default Transaction unless most of your foreign currency transactions occur in yen.
In Default Rate Group, select the group you created in step 4, but you should also confirm that the currency relationships you need (for this example, yen to dollars and dollars to yen) exist in that rate group. The settings for overriding rates and computing gains/losses are extremely important. If you select the Allow users to override exchange rates check box, users can override the rates entered on the maintenance and rate entry screens. If allowed, this override can occur in screens such as:
Manage Accounts Payable Vouchers screen (to edit currency of an A/P voucher)
Edit Voucher Payment Status screen (to edit currency to pay an A/P voucher)
Manage Standard Bills screen (to edit the billing currency)
Manage Cash Receipts screen (to edit a cash receipt)
Unrealized gains and losses are calculated at each period end but can be posted in one of two ways. The Net Change method posts each period gain or loss at the end of the period. The ITD Balance (Inception to Date Balance) method posts the running total of gains and losses and reverses that posting in the following period.
In the Manage Multicurrency Accounts screen. follow your company's procedures to assign the gain and loss accounts and organizations. If your company uses Ref 1 and Ref 2 as additional data entry fields, you can assign reference numbers to the gain and loss fields in the Reference No block. These settings determine the posting location of gains and losses on currency transactions.
Enter the exchange rates for the currencies of your billing and accounts receivable transactions. You can maintain currency on a regular schedule (possibly daily or weekly) or enter currency rates on an as-needed basis. Use either the Manage Period Exchange Rates screen or the Manage Daily Exchange Rates screen.
For billing transactions, exchange rates must exist from the functional currency (U. S. dollars in this example) to the billing currency (yen in this example).
Accounts Receivable transactions may result in cash receipts in any currency, and the receipt currencies are then "translated" to functional currency. Therefore, exchange rates must exist from the receipt currency (yen in this example) to the functional currency (U. S. dollars in this example).
Your company's policy should determine whether you maintain exchange rates by period or by date. You can keep rates by both date and period, but Costpoint first looks for daily rates and then, if none are available, it uses the period rates. (Costpoint only uses period rates by default in this situation if the Use period rate, if available check box is selected on the Configure Multicurrency Settings screen.) For the most accurate accounting of gains and losses, enter the rates for each business day.
Display either the Manage Exchange Rates by Date screen or Manage Exchange Rates by Period screen, and use Query to search for the rate group you created in step 4. Complete the table with the yen-to-dollar rate.
Enter your bill as usual. Use the Exchange Rates subtask to select yen for your billing currency. Multicurrency invoicing is available for Project Product, Customer Product, Standard, Milestone/Percent Complete, and Manual bills. Before posting the bill, open the Currency Line subtask and review each line of the bill. That subtask provides an item-by-item comparison of your billing and functional amounts. Post the bill.
Before the end of the fiscal period, run the Update Open Accounts Receivable Exchange Rates process. If you do not run this process between the billing posting process and the end-of-period computation of gains and losses, Costpoint does not record exchange gains or losses.
When payment is received, post as usual. If necessary, use the Exchange Rates subtask on the Manage Cash Receipts screen to select the currency received. The currency must exist on the Manage Currencies screen and the from/to relationships must exist in the Manage Exchange Rate Groups screen.
After posting cash receipts, run the Compute/Post Unrealized Gains/Losses process. Since this process includes all multicurrency transactions, run it only after you have completed all accounts payable, purchase order, billing, and accounts receivables transactions for the fiscal period.