Unit conversion tables

Create a unit conversion table

1. In the Navigation pane, highlight the General Ledger > Setup > Unit Conversion Tables folder.
2. Click . The New Unit Conversion Table window opens.

   

3. In the From Unit field, select the unit being converted from.
4. In the To Unit field, select the unit being converted to.
5. Enter a Description of the unit conversion table.
6. In the Operation field, select the operation to use to convert from the "from" currency to the "to" currency. Your options are:
   • Multiply
   • Divide
7. In the Translation Use section, mark the types of translation which the table is used for. Your options are:
   • Current. Uses the rate in effect at the end of the accounting period. The calendar used to determine the period is the one associated with each account (if one of the segments requires a calendar) or the default calendar.
   • Historical. Uses the rate in effect on the transaction date.
   • Average. Uses a per period average rate. The calendar used to determine the periods is the one associated with each account (if one of the segments requires a calendar) or the default calendar. The following calculation is used:

     SUM(Rates)/Number of Rates

   • Days Weighted Average. Uses a per period weighted average rate. The calendar used to determine the periods is the one associated with each account (if one of the segments requires a calendar) or the default calendar. The following calculation is used:

     SUM(Rate*Days)/SUM(Days)

8. In the Rates table, define the date-driven conversion rates to apply to the "from" currency value to derive the "to" currency value. Perform the following for each conversion rate you need to define:
   1. In the Date column, select the effective date of the unit conversion rate.
   2. In the Rate field, enter the conversion rate as a positive number. The conversion rate has a precision of 19 and scale of 7 (xxx,xxx,xxx,xxx.xxxxxxx).
   3. In the Expires column, select the date the unit conversion rate expires.
   4. In the Memo column, enter a note about the rate if desired.
9. When you finish, save the new unit conversion table.

Purpose

The Unit Conversion Tables Listing provides a list of unit conversion tables defined in the General Ledger.

Content

For each unit conversion table included on the report, the listing shows:

• "from" unit
• "to" unit
• description
• operation (multiply or divide)
• translation use.

In addition, you can include one or more of the following:

• rates (effective dates, rate, memo)
• timestamps
• memos
• custom fields.

The following total appears on the report:

• record count.

Print the report

1. In the Navigation pane, highlight the General Ledger > Setup > Unit Conversion Tables folder.
2. Start the report set-up wizard.
   • To report on all or a filtered subset of unit conversion tables:
     1. Right-click the Unit Conversion Tables folder and select Select and Report > Unit Conversion Tables Listing from the shortcut menu.
     2. On the Selection tab, define any filters to apply to the data.

        

   • To report on specifically selected unit conversion tables:
     1. In the HD view, select the unit conversion tables to include on the report. You can use Ctrl and/or Shift selection to select multiple records.
     2. Click .
   • To report on a particular unit conversion table from the Unit Conversion Table window:
     1. In the HD view, locate and double-click the unit conversion table to report on. The Unit Conversion Table window opens with the unit conversion table loaded.
     2. Click .
3. Select the Options tab.

   

4. Mark the checkbox(es) for the additional information to include:
   • Rates
   • Timestamps
   • Memos
   • Custom Fields (only visible if custom fields are set up)
5. Select the Output tab.
6. In the Design field, look up and select the report design to use.
In the toolbar, click the icon for the type of output you want:
• - Provides access to two preview options.
  • Preview - Click the icon or click the drop-down arrow and select Preview from the drop-down menu to view the report in the Crystal Reports viewer.
  • Preview to PDF - Click the drop-down arrow next to the icon and select Preview to PDF to view the report in the PDF reader.
• - Opens the Print dialog so that you can select and configure a printer and then print a paper copy of the report.
• - Opens the Report Email dialog so that you can address and compose an email that the report will be attached to. For best results, ensure your email client is running before you attempt to send a report via email.
• - Opens the Export Report dialog so that you can save the report to a file. File types include Crystal Reports (.rpt), PDF (.pdf), Microsoft Excel (.xls), Microsoft Word (.doc), rich text (.rtf), and XML (.xml).

Data extensions

The following data extensions are available for the report:

• Unit conversion tables
• Unit conversion rates