{"id":2402,"date":"2019-09-27T17:22:33","date_gmt":"2019-09-27T11:52:33","guid":{"rendered":"http:\/\/blog.tenthplanet.in\/?p=2402"},"modified":"2026-03-03T10:13:14","modified_gmt":"2026-03-03T10:13:14","slug":"how-to-handle-compiere-invoice-vs-payment-multiple-currency-in-a-right-way","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/blogs\/how-to-handle-compiere-invoice-vs-payment-multiple-currency-in-a-right-way\/","title":{"rendered":"How to handle Compiere ERP Invoice vs payment multiple currency in a right way"},"content":{"rendered":"<p>Any ERP having rounding issue while allocating invoice vs payment with different currencies<\/p>\n<p>One of our customer, Received invoices in multiple currencies (EUR, USD, JPY) but payment maintained in INR<\/p>\n<p style=\"padding-left: 40px\">Payment doc no# 71517 =&gt; <strong>298150.58 INR<\/strong> (Dt.16\/05\/2019)<\/p>\n<p style=\"padding-left: 40px\">Conversion Currency Rate for <strong>INR to EUR =&gt; 80.34<\/strong><\/p>\n<h2>2 different invoices are below:<\/h2>\n<table>\n<tbody>\n<tr valign=\"top\">\n<td><strong>Doc No<\/strong><\/td>\n<td><strong>Invoice Date<\/strong><\/td>\n<td><strong>EUR<\/strong><\/td>\n<td><strong>INR<\/strong><\/td>\n<\/tr>\n<tr valign=\"top\">\n<td>5519003892<\/td>\n<td>31\/01\/2019<\/td>\n<td>2095.16<\/td>\n<td>(2095.16 * 80.3) = 168325.15<\/td>\n<\/tr>\n<tr valign=\"top\">\n<td>5519003046<\/td>\n<td>31\/01\/2019<\/td>\n<td>1615.95<\/td>\n<td>(1615.95 * 80.3) = 129825.42<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Sum of two invoices = 168325.15 + 129825.42 &#8212;&#8211;&gt; 298150.57<\/p>\n<p>During allocation of Invoice vs Payment &#8212;&#8212;&#8211;&gt; 298150.58 &#8211; 298150.57.<\/p>\n<p>We have got difference = 0.01<\/p>\n<p><strong>Solution:<\/strong> To include this difference amt 0.01 to allocation amount either invoice 1 or invoice 2, So that It will fall either Foreign Gain or loss account<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Any ERP having rounding issue while allocating invoice vs payment with different currencies<\/p>\n","protected":false},"author":23,"featured_media":2410,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[350],"tags":[396,236,397],"class_list":["post-2402","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-compiere","tag-currency","tag-invoice","tag-payment"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/posts\/2402","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/users\/23"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/comments?post=2402"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/posts\/2402\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/media\/2410"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/media?parent=2402"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/categories?post=2402"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/tags?post=2402"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}