{"id":17604,"date":"2026-01-29T12:00:52","date_gmt":"2026-01-29T12:00:52","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=17604"},"modified":"2026-08-20T06:39:44","modified_gmt":"2026-08-20T06:39:44","slug":"how-currency-type-works-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-currency-type-works-in-idempiere\/","title":{"rendered":"How Currency Type Works in iDempiere"},"content":{"rendered":"\n

Currency Type<\/strong> controls which exchange rate iDempiere applies during currency conversion. It acts as the decision layer between a currency and its rate, allowing different processes to use Spot<\/strong>, Average<\/strong>, or Period End<\/strong> rates for accurate, compliant reporting.<\/p>\n\n\n\n

Currency Type in the Overall Currency Workflow<\/strong><\/h2>\n\n\n\n

Currency Type sits between Currency and Currency Rate<\/strong>.
It does not store rates itself, but tells the system which rate to pick<\/strong> at runtime.<\/p>\n\n\n\n

Workflow hierarchy:<\/strong><\/p>\n\n\n\n

Currency
\u2192 Currency Type
\u2192 Currency Rate
\u2192 Business Transaction (Order, Invoice, Accounting)<\/p>\n\n\n\n

This design allows the same currency pair (EUR \u2192 USD) to behave differently depending on business context.<\/p>\n\n\n\n

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

Creating and Managing a Currency Type<\/strong><\/h2>\n\n\n\n

A Currency Type represents how rates are interpreted<\/strong>, not the numeric value itself. When creating one, you define its identity<\/strong>, purpose<\/strong>, and whether it should be used automatically.<\/p>\n\n\n\n

Most systems start with Spot<\/strong> as the default Currency Type, which uses the current market rate<\/strong>. Other types are added later to support accounting or reporting needs.<\/p>\n\n\n\n

Key points users must understand while creating a Currency Type:<\/strong><\/p>\n\n\n\n

    \n
  • Search Key<\/strong> and Name<\/strong> uniquely identify the rate logic.<\/li>\n\n\n\n
  • Active<\/strong> must be enabled, otherwise the type is ignored.<\/li>\n\n\n\n
  • Default<\/strong> determines which rate is picked automatically when no type is specified.<\/li>\n<\/ul>\n\n\n\n

    Using Currency Type with Currency and Rates<\/strong><\/h2>\n\n\n\n

    Once a Currency Type exists, it becomes usable only when conversion rates are linked to it<\/strong>. The same currency pair can have multiple rates, each under a different Currency Type.<\/p>\n\n\n\n

    For example:<\/p>\n\n\n\n

      \n
    • EUR \u2192 USD using Spot<\/strong> for sales orders<\/li>\n\n\n\n
    • EUR \u2192 USD using Period End<\/strong> for financial closing<\/li>\n\n\n\n
    • EUR \u2192 USD using Company<\/strong> for internal costing<\/li>\n<\/ul>\n\n\n\n

      At runtime, iDempiere checks:<\/p>\n\n\n\n

        \n
      1. The transaction date<\/strong><\/li>\n\n\n\n
      2. The Currency Type<\/strong><\/li>\n\n\n\n
      3. The valid rate range<\/strong><\/li>\n<\/ol>\n\n\n\n

        It then applies the correct Multiply or Divide rate automatically<\/strong>.<\/p>\n\n\n\n

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

        How Currency Type Is Applied During Transactions<\/strong><\/h2>\n\n\n\n

        Users never manually choose exchange formulas during transactions. Instead, Currency Type is selected implicitly<\/strong> based on document setup or accounting schema.<\/p>\n\n\n\n

        When a document is completed:<\/p>\n\n\n\n

          \n
        • The system identifies the Currency Type<\/strong><\/li>\n\n\n\n
        • Fetches the valid rate<\/strong><\/li>\n\n\n\n
        • Converts amounts consistently across lines, taxes, and postings<\/li>\n<\/ul>\n\n\n\n

          This ensures sales, purchasing, costing, and accounting all remain aligned<\/strong>, even in multi-currency environments.<\/p>\n\n\n\n

          Why Currency Type Is Powerful in Daily Operations<\/strong><\/h2>\n\n\n\n

          Currency Type removes guesswork from currency conversion and replaces it with controlled financial logic<\/strong>. It allows businesses to respond to market volatility while still maintaining accounting discipline.<\/p>\n\n\n\n

          Practical outcomes users experience:<\/strong><\/p>\n\n\n\n

            \n
          • Accurate financial statements<\/strong> using Period End or Average rates<\/li>\n\n\n\n
          • Operational flexibility<\/strong> using Spot rates for live transactions<\/li>\n\n\n\n
          • Clear audit trails<\/strong> showing which rate logic was applied<\/li>\n\n\n\n
          • Consistency across modules<\/strong> without manual intervention<\/li>\n<\/ul>\n\n\n\n

            Things Users Should Be Careful About<\/strong><\/h2>\n\n\n\n
              \n
            • Every Currency Type must have at least one valid conversion rate<\/strong>, otherwise documents fail.<\/li>\n\n\n\n
            • Only one Currency Type should be marked as Default<\/strong>.<\/li>\n\n\n\n
            • Rate valid-from dates must not overlap<\/strong> for the same currency pair and type.<\/li>\n\n\n\n
            • Multiply and Divide rates are linked; users typically maintain only one direction<\/strong>.<\/li>\n<\/ul>\n\n\n\n

              Outcome<\/strong><\/h2>\n\n\n\n

              By configuring Currency Type correctly, users gain full control over how money is converted across the system<\/strong>\u2014without touching each transaction manually. It becomes the foundation for reliable multi-currency operations<\/strong>, supporting daily business activity as well as long-term financial reporting.<\/p>\n","protected":false},"excerpt":{"rendered":"

              Currency Type controls which exchange rate iDempiere applies during currency conversion. It acts as the decision layer between a currency […]<\/p>\n","protected":false},"author":19,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,58],"tags":[],"class_list":["post-17604","post","type-post","status-publish","format-standard","hentry","category-idempiere-product","category-idempiere-accounting"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/17604","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\/19"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/comments?post=17604"}],"version-history":[{"count":2,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/17604\/revisions"}],"predecessor-version":[{"id":27748,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/17604\/revisions\/27748"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=17604"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=17604"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=17604"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}