Find/Browse Forms with Currency Controls

Use these guidelines when developing Find/Browse forms that use currency controls.

Ensure that:

• Both domestic and foreign amounts, when both are available, are included in the grid.

• If all records in the grid reflect the same currency, then the currency code, exchange rate, and base currency appear in the header portion of the form.

• If the records potentially have different currency codes, exchange rates, or base currencies, then this information appears in the grid.

• Columns containing more than one currency have no totals.

  Suppress total records, if necessary.

• All currency-related controls and grid columns are hidden (for Dialog is Initialized) when currency processing is turned off.

  To hide the currency-related fields, test the system value for Currency Processing for N.

• Currency Mode (CRRM) does not appear on the Find/Browse form because both foreign and domestic currencies appear.

• If amounts are applicable to the main portion of the grid, then the domestic amount and currency code appear.

  The foreign amounts might exist in the scroll-to grid area.

  Note: If you need to include the Base Currency field (the currency that is defined at the company level) in the QBE row or as a filter field, then consider joining the transaction table to the Company Constants table (F0010). This join provides direct database access to the Base Currency field, which can be used in the QBE.