{"id":6944,"date":"2014-03-19T17:14:52","date_gmt":"2014-03-19T17:14:52","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=6944"},"modified":"2014-03-19T17:14:52","modified_gmt":"2014-03-19T17:14:52","slug":"how-to-pass-ap-revaluation-entry-in-sage-300-erp","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/03\/19\/how-to-pass-ap-revaluation-entry-in-sage-300-erp\/","title":{"rendered":"How to Pass AP Revaluation entry in sage 300 ERP"},"content":{"rendered":"

Sage 300 ERP provides you to reevaluate multicurrency transactions at new exchange rates, to determine the current value of payables and receivables on specific dates (in multicurrency ledgers only).<\/p>\n

When exchange rates fluctuate, you may need to revalue outstanding documents denominated in other currencies to reflect their present value in your own (functional) currency at a particular time, for example, at financial statement dates. (When you revalue a transaction, sub ledgers like AP, AR etc. recalculate its functional equivalent value at a new exchange rate.)<\/p>\n

New Stuff:<\/strong><\/em><\/span>\u00a0General Ledger (GL) Accounts Distribution in Sage 300 ERP<\/a><\/p>\n

Let\u2019s see how to pass AP Revaluation entry in Sage 300 ERP.<\/span><\/p>\n

Firstly we have to decide that up to which date, we have to reevaluate Multicurrency transaction as per new Exchange rates.<\/p>\n

After deciding revaluation date, we have to define currency code, revaluation date, and exchange rate in AP (or your respective sub ledger module) revaluation.<\/p>\n

For defining AP Revaluation, navigate to-<\/p>\n

Account Payable -><\/b><\/b>\u00a0A\/P Periodic Processing -><\/b>\u00a0Revaluation<\/b><\/p>\n

\"1\"<\/a><\/p>\n

We can process provisional revaluation by click on provisional revaluation as mentioned in above screen shot.<\/p>\n

We can see in above screen shot, we are going to reevaluate USD and EUR Transaction as on 31st Jan 14 with new Exchange rate.<\/p>\n

So after click on process button, system will reevaluate all open documents with new exchange rate which falls up to date 31st Jan 14.<\/p>\n

After provisional revaluation process, we have to see final effect of all AP Transaction<\/p>\n

To see effect of AP Provisional revaluation, navigate to-<\/p>\n

Account Payable -><\/b><\/b>\u00a0A\/P Transaction Reports \u00a0-><\/b><\/b>\u00a0Posting Journals\u00a0<\/b><\/p>\n

\"2\"<\/a><\/p>\n

As we can see in below screen shot, system has revaluate 1 AP Invoice of vendor V0024 with new exchange rate 63 and passed amount in exchange gain (Loss) Account.<\/p>\n

\"4\"<\/a><\/p>\n

Document Source amount = 2665.60<\/p>\n

Prior Exchange rate = 64.15<\/p>\n

Prior functional<\/b> = (2665.60 * 64.15 = 170998<\/b>)<\/p>\n

Effect after passing revaluation entry with new exchange rate<\/p>\n

Document Source amount = 2665.60<\/p>\n

New Exchange rate = 63<\/p>\n

New functional amount<\/b> = (2665.60 * 63 = 167933<\/b>)<\/p>\n

Exchange gain loss<\/b> = (170998 \u2013 167933) = 3065<\/b><\/p>\n

Please Note: – As a Precaution, take database back up from (start-><\/b><\/b>Sage Accpac-><\/b><\/b>Tools-><\/b><\/b>Database dump)\u00a0 \u00a0before Final AP Revaluation process.<\/b><\/p>\n

Hope this blog post provides insight into how A\/P Revaluation works and helps users to do accurate process of A\/P Revaluation.<\/p>\n

Also Read:<\/strong><\/p>\n

1.<\/strong>\u00a0Reverse Receipt and Payment in Sage 300 ERP<\/a>
\n2.\u00a0<\/strong>Control Payments in Sage 300 ERP<\/a>
\n3.<\/strong>\u00a0Default Settings for Accounts Payable Payments in Sage 300 ERP<\/a>
\n4.\u00a0<\/strong>Purchase Register Report<\/a>
\n5<\/strong>.\u00a0AP Vendor Ledger Report for Sage 300 ERP<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Sage 300 ERP provides you to reevaluate multicurrency transactions at new exchange rates, to determine the current value of payables and receivables on specific dates (in multicurrency ledgers only). When exchange rates fluctuate, you may need to revalue outstanding documents denominated in other currencies to reflect their present value in your own (functional) currency at\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-6944","post","type-post","status-publish","format-standard","hentry","category-sage-accpac"],"yoast_head":"\nHow to Pass AP Revaluation entry in sage 300 ERP - Sage 300 ERP \u2013 Tips, Tricks and Components<\/title>\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\/sageaccpacerp\/2014\/03\/19\/how-to-pass-ap-revaluation-entry-in-sage-300-erp\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Pass AP Revaluation entry in sage 300 ERP - Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Sage 300 ERP provides you to reevaluate multicurrency transactions at new exchange rates, to determine the current value of payables and receivables on specific dates (in multicurrency ledgers only). When exchange rates fluctuate, you may need to revalue outstanding documents denominated in other currencies to reflect their present value in your own (functional) currency at\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/03\/19\/how-to-pass-ap-revaluation-entry-in-sage-300-erp\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2014-03-19T17:14:52+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/03\/Untitled19.png\" \/>\n<meta name=\"author\" content=\"sage300\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"sage300\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/03\/19\/how-to-pass-ap-revaluation-entry-in-sage-300-erp\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/03\/19\/how-to-pass-ap-revaluation-entry-in-sage-300-erp\/\",\"name\":\"How to Pass AP Revaluation entry in sage 300 ERP - Sage 300 ERP \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/03\/19\/how-to-pass-ap-revaluation-entry-in-sage-300-erp\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/03\/19\/how-to-pass-ap-revaluation-entry-in-sage-300-erp\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/03\/Untitled19.png\",\"datePublished\":\"2014-03-19T17:14:52+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/03\/19\/how-to-pass-ap-revaluation-entry-in-sage-300-erp\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/03\/19\/how-to-pass-ap-revaluation-entry-in-sage-300-erp\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/03\/19\/how-to-pass-ap-revaluation-entry-in-sage-300-erp\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/03\/Untitled19.png\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/03\/Untitled19.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/03\/19\/how-to-pass-ap-revaluation-entry-in-sage-300-erp\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Pass AP Revaluation entry in sage 300 ERP\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\",\"name\":\"Sage 300 ERP \u2013 Tips, Tricks and Components\",\"description\":\"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! \",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?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\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\",\"name\":\"sage300\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"sage300\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Pass AP Revaluation entry in sage 300 ERP - Sage 300 ERP \u2013 Tips, Tricks and Components","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\/sageaccpacerp\/2014\/03\/19\/how-to-pass-ap-revaluation-entry-in-sage-300-erp\/","og_locale":"en_US","og_type":"article","og_title":"How to Pass AP Revaluation entry in sage 300 ERP - Sage 300 ERP \u2013 Tips, Tricks and Components","og_description":"Sage 300 ERP provides you to reevaluate multicurrency transactions at new exchange rates, to determine the current value of payables and receivables on specific dates (in multicurrency ledgers only). When exchange rates fluctuate, you may need to revalue outstanding documents denominated in other currencies to reflect their present value in your own (functional) currency at\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/03\/19\/how-to-pass-ap-revaluation-entry-in-sage-300-erp\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2014-03-19T17:14:52+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/03\/Untitled19.png","type":"","width":"","height":""}],"author":"sage300","twitter_card":"summary_large_image","twitter_misc":{"Written by":"sage300","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/03\/19\/how-to-pass-ap-revaluation-entry-in-sage-300-erp\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/03\/19\/how-to-pass-ap-revaluation-entry-in-sage-300-erp\/","name":"How to Pass AP Revaluation entry in sage 300 ERP - Sage 300 ERP \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/03\/19\/how-to-pass-ap-revaluation-entry-in-sage-300-erp\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/03\/19\/how-to-pass-ap-revaluation-entry-in-sage-300-erp\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/03\/Untitled19.png","datePublished":"2014-03-19T17:14:52+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/03\/19\/how-to-pass-ap-revaluation-entry-in-sage-300-erp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/03\/19\/how-to-pass-ap-revaluation-entry-in-sage-300-erp\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/03\/19\/how-to-pass-ap-revaluation-entry-in-sage-300-erp\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/03\/Untitled19.png","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/03\/Untitled19.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/03\/19\/how-to-pass-ap-revaluation-entry-in-sage-300-erp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"How to Pass AP Revaluation entry in sage 300 ERP"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/","name":"Sage 300 ERP \u2013 Tips, Tricks and Components","description":"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?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\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5","name":"sage300","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"sage300"},"url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/6944","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/comments?post=6944"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/6944\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=6944"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=6944"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=6944"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}