{"id":18676,"date":"2026-05-29T11:34:50","date_gmt":"2026-05-29T11:34:50","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=18676"},"modified":"2026-06-05T10:49:48","modified_gmt":"2026-06-05T10:49:48","slug":"how-to-configure-currency-and-conversion-rate-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-to-configure-currency-and-conversion-rate-in-idempiere\/","title":{"rendered":"How to Configure Currency and Conversion Rate in iDempiere"},"content":{"rendered":"\n

Learn how the Currency window in iDempiere supports retail businesses by managing multiple currencies, exchange rates, precision settings, and currency conversions across purchasing, sales, and financial transactions.<\/p>\n\n\n\n

Introduction<\/strong><\/h2>\n\n\n\n

The Currency window in iDempiere defines and manages all monetary units recognised by the system. Each currency record stores its ISO code, symbol, precision settings, and rounding rules that govern how monetary values are displayed and calculated across all transactions.<\/p>\n\n\n\n

Accurate Currency and Conversion Rate setup is essential for correct inventory valuation, tax reporting, and foreign exchange accounting in any iDempiere-powered retail operation.<\/p>\n\n\n\n

Prerequisites<\/strong><\/h2>\n\n\n\n

Before starting, ensure the following:<\/p>\n\n\n\n

    \n
  • Initial Tenant Setup completed successfully<\/li>\n\n\n\n
  • Accounting Schema configured with a Base Currency defined<\/li>\n<\/ul>\n\n\n\n

    Business Rules<\/strong><\/h2>\n\n\n\n

    Currency<\/strong><\/h3>\n\n\n\n
      \n
    • Every currency record must have a unique ISO currency code (e.g., INR, USD, EUR); duplicate codes are not permitted.<\/li>\n\n\n\n
    • A currency must be marked Active to be available for selection in transactions, price lists, and business partner records.<\/li>\n\n\n\n
    • The precision field controls how many decimal places are recorded and displayed in transaction amounts for that currency.<\/li>\n<\/ul>\n\n\n\n

      Currency Rate (Conversion Rate)<\/strong><\/h3>\n\n\n\n
        \n
      • A conversion rate must exist between the transaction currency and the accounting currency for any transaction posted on that date; a missing rate will block posting.<\/li>\n\n\n\n
      • Each rate record requires a valid From Currency, To Currency, and Rate Date range (valid-from and valid-to); overlapping date ranges for the same currency pair are not permitted.<\/li>\n\n\n\n
      • The rate type (Spot, Period End, Average, etc.) determines which rate is applied \u2014 the rate type must match what is configured on the document or price list.<\/li>\n\n\n\n
      • If no rate is found for the exact transaction date, iDempiere uses the most recent active rate whose valid-from date is on or before the transaction date.<\/li>\n<\/ul>\n\n\n\n

        Navigation<\/strong><\/h2>\n\n\n\n

        Access the Currency configuration from the iDempiere main menu:<\/p>\n\n\n\n

        Currency:<\/strong> Menu \u2192 Performance Analysis and Accounting \u2192 Accounting Rules \u2192 Currency

        Conversion Rate:<\/strong> Menu \u2192 Performance Analysis and Accounting \u2192 Accounting Rules \u2192 Currency Rate<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

        Step-by-Step Configuration<\/strong><\/h2>\n\n\n\n

        Step 1: Open the Currency Window<\/strong><\/h3>\n\n\n\n

        Navigate to:<\/p>\n\n\n\n

        Menu \u2192 Performance Analysis and Accounting \u2192 Accounting Rules \u2192 Currency<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

        The window displays all currency records currently defined in the system. iDempiere includes a default set of ISO currencies. Review the list before creating new records to avoid duplication.<\/p>\n\n\n\n

        \"\"<\/figure>\n\n\n\n
        Note: <\/strong>iDempiere ships with a pre-loaded set of common ISO 4217 currencies. Search before creating a new record to confirm the currency does not already exist in the system.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

        Step 2: Create a New Currency Record<\/strong><\/h3>\n\n\n\n

        Click: New Record (+)<\/p>\n\n\n\n

        The form opens in edit mode. Complete the required fields as described below.<\/p>\n\n\n\n

        Field Definitions<\/strong><\/h3>\n\n\n\n
          \n
        • ISO Currency Code<\/strong> \u2014 Three-letter ISO 4217 code (e.g., USD, INR, EUR, AED). This is the primary identifier used across all transactions.<\/li>\n\n\n\n
        • Symbol<\/strong> \u2014 Currency symbol displayed on printed documents and screen forms (e.g., $, INR, EUR).<\/li>\n\n\n\n
        • Description<\/strong> \u2014 Full name of the currency for internal reference (e.g., US Dollar, Indian Rupee).<\/li>\n\n\n\n
        • Standard Precision<\/strong> \u2014 Number of decimal places used for standard monetary amounts (typically 2).<\/li>\n\n\n\n
        • Costing Precision<\/strong> \u2014 Number of decimal places used in cost calculations. Set higher than Standard Precision when unit costs have more decimal accuracy.<\/li>\n\n\n\n
        • Active<\/strong> \u2014 Enables the currency for use in transactions. Inactive currencies are excluded from lookup lists.<\/li>\n<\/ul>\n\n\n\n

          Step 3: Configure Indian Rupee (INR)<\/strong><\/h3>\n\n\n\n

          Enter the following values to create the Indian Rupee record:<\/p>\n\n\n\n

          Field<\/strong><\/td>Value<\/strong><\/td><\/tr>
          ISO Code<\/td>INR<\/td><\/tr>
          Symbol<\/td>INR<\/td><\/tr>
          Description<\/td>Indian Rupee<\/td><\/tr>
          Standard Precision<\/td>2<\/td><\/tr>
          Costing Precision<\/td>4<\/td><\/tr>
          Active<\/td>Yes<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

          Purpose<\/strong><\/h3>\n\n\n\n

          INR is the base transaction currency for all domestic retail sales, local vendor payments, and statutory tax reporting in India. Defining INR with Costing Precision 4 ensures accurate unit cost capture when dealing with low-value items purchased in bulk.<\/p>\n\n\n\n

          Step 4: Configure US Dollar (USD)<\/strong><\/h3>\n\n\n\n

          Enter the following values to create the US Dollar record:<\/p>\n\n\n\n

          Field<\/strong><\/td>Value<\/strong><\/td><\/tr>
          ISO Code<\/td>USD<\/td><\/tr>
          Symbol<\/td>$<\/td><\/tr>
          Description<\/td>US Dollar<\/td><\/tr>
          Standard Precision<\/td>2<\/td><\/tr>
          Costing Precision<\/td>4<\/td><\/tr>
          Active<\/td>Yes<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

          Purpose<\/strong><\/h3>\n\n\n\n

          USD is used for international supplier invoices, import purchase orders, and foreign exchange settlements. Retail chains importing branded electronics, apparel, or FMCG goods from US-based distributors will reference USD on those purchase orders.<\/p>\n\n\n\n

          Step 5: Configure Euro (EUR)<\/strong><\/h3>\n\n\n\n

          Enter the following values to create the Euro record:<\/p>\n\n\n\n

          Field<\/strong><\/td>Value<\/strong><\/td><\/tr>
          ISO Code<\/td>EUR<\/td><\/tr>
          Symbol<\/td>EUR<\/td><\/tr>
          Description<\/td>Euro<\/td><\/tr>
          Standard Precision<\/td>2<\/td><\/tr>
          Costing Precision<\/td>4<\/td><\/tr>
          Active<\/td>Yes<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

          Purpose<\/strong><\/h3>\n\n\n\n

          EUR supports procurement from European suppliers. Retail businesses sourcing luxury goods, fashion, or specialty food products from European brands will use EUR-denominated purchase orders and vendor invoices.<\/p>\n\n\n\n

          Step 6: Save the Currency Record<\/strong><\/h3>\n\n\n\n

          After entering all field values, click:<\/p>\n\n\n\n

          Save (floppy-disk icon or Alt + S)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

          The record is saved and assigned a system-generated Currency ID. The currency is now available for selection on accounting schemas, price lists, bank accounts, business partners, and conversion rates.<\/p>\n\n\n\n

          Step 7: Open the Conversion Rate Window<\/strong><\/h3>\n\n\n\n

          Navigate to:<\/p>\n\n\n\n

          Menu \u2192 System Admin \u2192 General Rules \u2192 Conversion Rate<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

          The window lists all active conversion rate records. Each record defines the exchange rate between a source currency and a target currency for a specific date range and conversion type.<\/p>\n\n\n\n

          \"\"<\/figure>\n\n\n\n

          Step 8: Create a New Conversion Rate Record<\/strong><\/h3>\n\n\n\n

          Click:<\/p>\n\n\n\n

          New Record (+)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

          Field Definitions<\/strong><\/h3>\n\n\n\n
            \n
          • Currency<\/strong> \u2014 The source currency (From Currency) for this rate.<\/li>\n\n\n\n
          • Currency To<\/strong> \u2014 The target currency (To Currency) for this rate.<\/li>\n\n\n\n
          • Currency Type:<\/strong><\/li>\n<\/ul>\n\n\n\n
            Field<\/strong><\/td>Value<\/strong><\/td><\/tr>
            Average<\/td>The exchange rate calculated as the average over a period of time (daily, monthly, yearly, etc.). Used mainly for accounting and reporting. Example: Average USD\u2192INR rate for May = 83.12<\/td><\/tr>
            Company<\/td>A company-specific exchange rate maintained internally by an organization instead of using market rates. Some ERPs allow companies to define custom rates for transactions.<\/td><\/tr>
            Period End<\/td>The exchange rate at the end of an accounting period (month-end, quarter-end, year-end). Used for financial closing and balance sheet valuation.<\/td><\/tr>
            Spot<\/td>The current live market exchange rate for immediate currency exchange. Usually the real-time or near real-time rate used for trading and immediate transactions.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
              \n
            • Valid From Date<\/strong> \u2014 The first date on which this rate applies to transactions.<\/li>\n\n\n\n
            • Valid To Date<\/strong> \u2014 The last date on which this rate applies. Leave blank for open-ended rates.<\/li>\n\n\n\n
            • Multiply Rate<\/strong> \u2014 The factor applied to convert From Currency to To Currency (e.g., 1 USD = 83.50 INR means Multiply Rate = 83.50).<\/li>\n\n\n\n
            • Divide Rate<\/strong> \u2014 Automatically calculated as 1 \/ Multiply Rate. Used for reverse conversion.<\/li>\n<\/ul>\n\n\n\n

              Step 9: Configure USD to INR Conversion Rate<\/strong><\/h3>\n\n\n\n

              Enter the following values:<\/p>\n\n\n\n

              Field<\/strong><\/td>Value<\/strong><\/td><\/tr>
              Currency (From)<\/td>USD<\/td><\/tr>
              Currency To<\/td>INR<\/td><\/tr>
              Conversion Rate Type<\/td>Spot<\/td><\/tr>
              Valid From Date<\/td>01\/07\/2025<\/td><\/tr>
              Valid To Date<\/td>31\/07\/2025<\/td><\/tr>
              Multiply Rate<\/td>83.50<\/td><\/tr>
              Divide Rate<\/td>0.01198 (auto-calculated)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

              Purpose<\/strong><\/h3>\n\n\n\n

              This rate enables iDempiere to automatically convert USD amounts on import purchase orders to INR in the accounting entries. When a purchase order is raised in USD, the system applies this rate to generate the INR-equivalent journal entries for the Accounts Payable and Inventory accounts.<\/p>\n\n\n\n

              Step 10: Configure EUR to INR Conversion Rate<\/strong><\/h3>\n\n\n\n

              Enter the following values:<\/p>\n\n\n\n

              Field<\/strong><\/td>Value<\/strong><\/td><\/tr>
              Currency (From)<\/td>EUR<\/td><\/tr>
              Currency To<\/td>INR<\/td><\/tr>
              Conversion Rate Type<\/td>Spot<\/td><\/tr>
              Valid From Date<\/td>01\/07\/2025<\/td><\/tr>
              Valid To Date<\/td>31\/07\/2025<\/td><\/tr>
              Multiply Rate<\/td>90.25<\/td><\/tr>
              Divide Rate<\/td>0.01108 (auto-calculated)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

              Purpose<\/strong><\/h3>\n\n\n\n

              This rate supports EUR-denominated vendor invoices from European suppliers. The system uses this rate to post the INR equivalent to the Accounts Payable and Goods Receipt accounts, maintaining accurate local-currency financials.<\/p>\n\n\n\n

              Step 11: Save the Conversion Rate Record<\/strong><\/h3>\n\n\n\n

              After entering all field values, click:<\/p>\n\n\n\n

              Save (floppy-disk icon or Alt + S)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

              The conversion rate is saved and immediately available for document processing. Repeat Steps 7 through 11 for each additional currency pair and each new rate period.<\/p>\n\n\n\n

              Business Flow Overview<\/strong><\/h2>\n\n\n\n

              Currency and Conversion Rate configuration underpins the complete multi-currency procurement and finance flow in a retail operation:<\/p>\n\n\n\n

              At each document stage, iDempiere looks up the applicable Conversion Rate record matching the document date and rate type. If no rate is found for the document date, the system raises a conversion rate not found error and prevents posting.<\/p>\n\n\n\n

              Configuration Examples<\/strong><\/h2>\n\n\n\n
              ISO Code<\/strong><\/td>Symbol<\/strong><\/td>Description<\/strong><\/td>Std Precision<\/strong><\/td>Costing Precision<\/strong><\/td><\/tr>
              INR<\/td>INR<\/td>Indian Rupee<\/td>2<\/td>4<\/td><\/tr>
              USD<\/td>$<\/td>US Dollar<\/td>2<\/td>4<\/td><\/tr>
              EUR<\/td>EUR<\/td>Euro<\/td>2<\/td>4<\/td><\/tr>
              GBP<\/td>GBP<\/td>British Pound<\/td>2<\/td>4<\/td><\/tr>
              AED<\/td>AED<\/td>UAE Dirham<\/td>2<\/td>4<\/td><\/tr>
              SGD<\/td>SGD<\/td>Singapore Dollar<\/td>2<\/td>4<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
              From<\/strong><\/td>To<\/strong><\/td>Type<\/strong><\/td>Multiply Rate<\/strong><\/td>Period<\/strong><\/td><\/tr>
              USD<\/td>INR<\/td>Spot<\/td>83.50<\/td>Jul 2026<\/td><\/tr>
              EUR<\/td>INR<\/td>Spot<\/td>90.25<\/td>Jul 2026<\/td><\/tr>
              GBP<\/td>INR<\/td>Spot<\/td>105.80<\/td>Jul 2026<\/td><\/tr>
              AED<\/td>INR<\/td>Spot<\/td>22.72<\/td>Jul 2026<\/td><\/tr>
              USD<\/td>INR<\/td>Company<\/td>83.00<\/td>Jul 2026<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

              Common Issues<\/strong><\/h2>\n\n\n\n
              Issue<\/strong><\/td>Resolution<\/strong><\/td><\/tr>
              Conversion rate not found for document date<\/td>Check that a rate record exists with a Valid From Date on or before the document date and a Valid To Date on or after it. Create the missing period rate.<\/td><\/tr>
              Divide Rate shows 0 after saving<\/td>Enter the Multiply Rate first, then save. iDempiere auto-calculates the Divide Rate on save. Do not enter Divide Rate manually.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

              Best Practices<\/strong><\/h2>\n\n\n\n
                \n
              • Define all required currencies before configuring any Accounting Schema, Price List, or Business Partner records, as these reference Currency records.<\/li>\n\n\n\n
              • Set Costing Precision to 4 or higher for currencies used on high-volume, low-value goods to avoid rounding accumulation in inventory valuation.<\/li>\n\n\n\n
              • Create monthly Conversion Rate records aligned with your finance team’s approved rate calendar. Never leave rate gaps between periods.<\/li>\n\n\n\n
              • Use the Company rate type for internal transfer pricing and treasury-approved rates, and keep Spot rates for real-time or bank-feed sourced rates.<\/li>\n<\/ul>\n\n\n\n
                Important: <\/strong>Never delete Conversion Rate records that have been used in posted documents. Deletion breaks re-posting and period-close reconciliation. Set the record to Inactive instead.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

                Naming Convention<\/strong><\/h2>\n\n\n\n

                ISO 4217 defines the standard three-letter currency codes. Always use these codes as the ISO Code field value. For Conversion Rate Description fields, use the following pattern:<\/p>\n\n\n\n

                Next Steps<\/strong><\/h2>\n\n\n\n

                After completing Currency and Conversion Rate setup, continue with the following configurations:<\/p>\n\n\n\n

                  \n
                • Payment Term \u2014 Define payment terms (immediate, net-30, net-60) used on vendor and customer invoices.<\/li>\n\n\n\n
                • Business Partner \u2014 Configure supplier and customer records, specifying the invoice currency for each foreign partner.<\/li>\n\n\n\n
                • Price List \u2014 Create purchase and sales price lists in the appropriate currency for domestic and international transactions.<\/li>\n\n\n\n
                • Accounting Schema \u2014 Confirm the Realized Gain, Realized Loss, and Unrealized Gain\/Loss accounts are mapped for multi-currency postings.<\/li>\n\n\n\n
                • Bank Account \u2014 Define bank accounts with their operating currency to support multi-currency payment processing.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

                  Learn how the Currency window in iDempiere supports retail businesses by managing multiple currencies, exchange rates, precision settings, and currency […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[67,68],"tags":[],"class_list":["post-18676","post","type-post","status-publish","format-standard","hentry","category-retail","category-masters"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/18676","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/comments?post=18676"}],"version-history":[{"count":2,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/18676\/revisions"}],"predecessor-version":[{"id":18730,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/18676\/revisions\/18730"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=18676"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=18676"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=18676"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}