{"id":422,"date":"2022-11-23T13:54:41","date_gmt":"2022-11-23T13:54:41","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/acumatica\/?p=422"},"modified":"2024-11-29T05:46:34","modified_gmt":"2024-11-29T05:46:34","slug":"multi-currency-setup-and-payment-processing-with-currency-rates-in-acumatica","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/11\/23\/multi-currency-setup-and-payment-processing-with-currency-rates-in-acumatica\/","title":{"rendered":"Multi-Currency setup and payment processing with currency rates in Acumatica"},"content":{"rendered":"\n

Acumatica has introduced a feature of multiple base currencies. The feature is available in the financial module where we can automatically compute realized and unrealized currency gains and losses, perform account revaluations and translate complete financial statements<\/p>\n\n\n\n

Enable Multi-Currency Accounting Features:<\/u><\/strong><\/p>\n\n\n\n

Navigate to System Management > Licensing > Enable\/Disable Features.<\/p>\n\n\n\n

The initial step would be to enable Multi-Currency Accounting Features where we can activate foreign currencies in the system, which will be used for accounting and reporting purposes. The base currency will be used for reviewing journal transactions made in foreign currencies and for calculating and converting amounts in imported records.<\/p>\n\n\n\n

If the Multicurrency Accounting feature is not enabled then only one currency, which is called the base currency, is used for accounting.<\/p>\n\n\n

\"Sales<\/a><\/center><\/p>\n\n\n

<\/p>\n\n\n\n

Currency Management Preferences and Currency Rate Types:<\/u><\/strong><\/p>\n\n\n\n

For Currency Management Preferences, Navigate to Currency Management > Preferences > Currency Management Preferences.<\/p>\n\n\n\n

For Currency Rate Types, Navigate to Currency Management > Preferences > Currency Rate Types.<\/p>\n\n\n\n

Setting up the Realized Gain and Loss account and Rate type to be used for each kind of invoice and payment transaction.<\/p>\n\n\n

\"02<\/a><\/center><\/p>\n\n\n

SPOT (Floating Exchange Rate) is the current price for changing one currency for another. It is automatically installed by Acumatica and the default rate type is used for all transactions. This setup is done when the multi-currency feature is enabled.<\/p>\n\n\n\n

Currency Setup:<\/u><\/strong><\/p>\n\n\n\n

Navigate to Currency Management > Profiles> Currencies.<\/p>\n\n\n\n

When a company is set up, the base currency will be set automatically. Transactions on Acumatica<\/a> will convert to the base currency. Transactions can be done using other currencies, but the difference is the conversion rate between the two currencies. Create Currency ID as an internationally accepted currency id to perform automatic processing of currency rates. Provide Description, Symbol, Decimal precision, and check Use for Accounting checkbox for live processing.<\/p>\n\n\n

\"03<\/a><\/center><\/p>\n\n\n

Currency Rate Setup<\/u><\/strong><\/p>\n\n\n\n

Navigate to <\/strong>Currency Management > Profiles > Currency Rates<\/p>\n\n\n

\"04<\/a><\/center><\/p>\n\n\n

Currency Rate History By Date to View Reports<\/u><\/strong><\/p>\n\n\n\n

Navigate to Currency Management > Reports > Currency Rate History by Date. Enter From Date To Date and click on the Run Report button to view the historical data of currencies for a selected date range.<\/p>\n\n\n

\"05<\/a><\/center><\/p>\n\n\n

Customer setup for setting Multi-currency and Rates<\/u><\/strong> <\/p>\n\n\n\n

Navigate to Receivables > Profiles > Customers.
Choose the customer and navigate to the Financial tab and make sure Currency Id, Currency Rate Type is entered and checkboxes are checked for Enable Currency Override and Enable Rate Override.<\/p>\n\n\n

\"05<\/a><\/center><\/p>\n\n\n

Processing Invoice<\/u><\/strong><\/p>\n\n\n\n

Navigate to Receivables > Transactions > Invoices and Memos. Create an invoice with the Date (Nov 2021) and choose the customer that is set up for multi-currency and release the invoice. Navigate to Financial Tab and click on Batch Number to view journal transactions with Credit and Debit amounts of EUR currency.<\/p>\n\n\n\n

\"07\n<\/a><\/center>\n\n\n\n

Processing Payments<\/u><\/strong><\/p>\n\n\n\n

Create payment against an invoice with the Date (Nov 2022) and navigate to journal transaction by clicking the batch Number on the Payment screen.
When payment is done with the same currency then there is no Gain or loss. Click on the View Base button on the currency field to check the Gain\/loss achieved based on exchange rates.<\/p>\n\n\n

\"08<\/a><\/center><\/p>\n\n\n

This blog helps us in setting up multi-currency and process payments with currency rates in Acumatica.<\/p>\n\n\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

Acumatica has introduced a feature of multiple base currencies. The feature is available in the financial module where we can automatically compute realized and unrealized currency gains and losses, perform account revaluations and translate complete financial statements Enable Multi-Currency Accounting Features: Navigate to System Management > Licensing > Enable\/Disable Features. The initial step would be to enable\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15,3],"tags":[119,117,116,115,113,118,112,114,120],"class_list":["post-422","post","type-post","status-publish","format-standard","hentry","category-acumatica-customization","category-acumatica-erp","tag-base-currency","tag-currency-management-preference","tag-currency-rate","tag-currency-rate-setup","tag-currency-rate-types","tag-currency-reports","tag-multi-currency","tag-multicurrency","tag-processing-invoice-and-payments"],"yoast_head":"\nMulti-Currency Setup & Payment Processing in Acumatica<\/title>\n<meta name=\"description\" content=\"Optimize multi-currency setup and payment processing in Acumatica with streamlined currency rates. Enhance financial efficiency effortlessly.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/11\/23\/multi-currency-setup-and-payment-processing-with-currency-rates-in-acumatica\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Multi-Currency Setup & Payment Processing in Acumatica\" \/>\n<meta property=\"og:description\" content=\"Optimize multi-currency setup and payment processing in Acumatica with streamlined currency rates. Enhance financial efficiency effortlessly.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/11\/23\/multi-currency-setup-and-payment-processing-with-currency-rates-in-acumatica\/\" \/>\n<meta property=\"og:site_name\" content=\"Acumatica \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-23T13:54:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-29T05:46:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2022\/11\/01-Enable-Multicurrency-Accounting-Features.png\" \/>\n<meta name=\"author\" content=\"greytrix\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greytrix\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/11\/23\/multi-currency-setup-and-payment-processing-with-currency-rates-in-acumatica\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/11\/23\/multi-currency-setup-and-payment-processing-with-currency-rates-in-acumatica\/\",\"name\":\"Multi-Currency Setup & Payment Processing in Acumatica\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/11\/23\/multi-currency-setup-and-payment-processing-with-currency-rates-in-acumatica\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/11\/23\/multi-currency-setup-and-payment-processing-with-currency-rates-in-acumatica\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2022\/11\/01-Enable-Multicurrency-Accounting-Features.png\",\"datePublished\":\"2022-11-23T13:54:41+00:00\",\"dateModified\":\"2024-11-29T05:46:34+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/#\/schema\/person\/c49d53021d39726d820c6fd517b2c2ec\"},\"description\":\"Optimize multi-currency setup and payment processing in Acumatica with streamlined currency rates. Enhance financial efficiency effortlessly.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/11\/23\/multi-currency-setup-and-payment-processing-with-currency-rates-in-acumatica\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/11\/23\/multi-currency-setup-and-payment-processing-with-currency-rates-in-acumatica\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/11\/23\/multi-currency-setup-and-payment-processing-with-currency-rates-in-acumatica\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2022\/11\/01-Enable-Multicurrency-Accounting-Features.png\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2022\/11\/01-Enable-Multicurrency-Accounting-Features.png\",\"width\":532,\"height\":415},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/11\/23\/multi-currency-setup-and-payment-processing-with-currency-rates-in-acumatica\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Multi-Currency setup and payment processing with currency rates in Acumatica\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/\",\"name\":\"Acumatica \u2013 Tips, Tricks and Components\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/#\/schema\/person\/c49d53021d39726d820c6fd517b2c2ec\",\"name\":\"greytrix\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g\",\"caption\":\"greytrix\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/author\/greytrix\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Multi-Currency Setup & Payment Processing in Acumatica","description":"Optimize multi-currency setup and payment processing in Acumatica with streamlined currency rates. Enhance financial efficiency effortlessly.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/11\/23\/multi-currency-setup-and-payment-processing-with-currency-rates-in-acumatica\/","og_locale":"en_US","og_type":"article","og_title":"Multi-Currency Setup & Payment Processing in Acumatica","og_description":"Optimize multi-currency setup and payment processing in Acumatica with streamlined currency rates. Enhance financial efficiency effortlessly.","og_url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/11\/23\/multi-currency-setup-and-payment-processing-with-currency-rates-in-acumatica\/","og_site_name":"Acumatica \u2013 Tips, Tricks and Components","article_published_time":"2022-11-23T13:54:41+00:00","article_modified_time":"2024-11-29T05:46:34+00:00","og_image":[{"url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2022\/11\/01-Enable-Multicurrency-Accounting-Features.png","type":"","width":"","height":""}],"author":"greytrix","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greytrix","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/11\/23\/multi-currency-setup-and-payment-processing-with-currency-rates-in-acumatica\/","url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/11\/23\/multi-currency-setup-and-payment-processing-with-currency-rates-in-acumatica\/","name":"Multi-Currency Setup & Payment Processing in Acumatica","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/11\/23\/multi-currency-setup-and-payment-processing-with-currency-rates-in-acumatica\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/11\/23\/multi-currency-setup-and-payment-processing-with-currency-rates-in-acumatica\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2022\/11\/01-Enable-Multicurrency-Accounting-Features.png","datePublished":"2022-11-23T13:54:41+00:00","dateModified":"2024-11-29T05:46:34+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/#\/schema\/person\/c49d53021d39726d820c6fd517b2c2ec"},"description":"Optimize multi-currency setup and payment processing in Acumatica with streamlined currency rates. Enhance financial efficiency effortlessly.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/11\/23\/multi-currency-setup-and-payment-processing-with-currency-rates-in-acumatica\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/11\/23\/multi-currency-setup-and-payment-processing-with-currency-rates-in-acumatica\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/11\/23\/multi-currency-setup-and-payment-processing-with-currency-rates-in-acumatica\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2022\/11\/01-Enable-Multicurrency-Accounting-Features.png","contentUrl":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2022\/11\/01-Enable-Multicurrency-Accounting-Features.png","width":532,"height":415},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/11\/23\/multi-currency-setup-and-payment-processing-with-currency-rates-in-acumatica\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/acumatica\/"},{"@type":"ListItem","position":2,"name":"Multi-Currency setup and payment processing with currency rates in Acumatica"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/#website","url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/","name":"Acumatica \u2013 Tips, Tricks and Components","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/acumatica\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/#\/schema\/person\/c49d53021d39726d820c6fd517b2c2ec","name":"greytrix","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g","caption":"greytrix"},"url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/author\/greytrix\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/posts\/422","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/comments?post=422"}],"version-history":[{"count":6,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/posts\/422\/revisions"}],"predecessor-version":[{"id":3028,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/posts\/422\/revisions\/3028"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/media?parent=422"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/categories?post=422"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/tags?post=422"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}