{"id":2256,"date":"2019-08-28T16:28:46","date_gmt":"2019-08-28T10:58:46","guid":{"rendered":"http:\/\/blog.tenthplanet.in\/?p=2256"},"modified":"2026-03-03T10:13:56","modified_gmt":"2026-03-03T10:13:56","slug":"ensure-data-accuracy-between-costing-and-transaction-value-in-compiere-erp","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/blogs\/ensure-data-accuracy-between-costing-and-transaction-value-in-compiere-erp\/","title":{"rendered":"How to ensure costing and transaction data accuracy in Compiere ERP?"},"content":{"rendered":"

During import inventory, the product, and its cost is updated properly in Compiere system.<\/p>\n

After that, we have implemented Customer return without Sales Order reference.<\/p>\n

During posting customer return, system wrongly update the cost value instead of taking opening inventory costing value. So sub-sequence transaction posting with wrong cost.<\/p>\n

In Trial balance, it always fetch the posted value against each transaction<\/p>\n

But stock summary fetch from cost table since cost value is changed<\/p>\n

Trial Balance calculates<\/h2>\n

For e.g. Sales Order doc no 1001, posted with the following values<\/p>\n

Product A : Qty ->10, Cost \u2013> 12, so posted value shown 120 (10*12)<\/p>\n

Sales Return doc no 2100, posted with the following values<\/p>\n

Product A: Qty \u2013> 3, Cost \u2013 >8 (due to issue in Sales Return), so posted value shown 24 (3*8) instead of 36 (3*12)<\/p>\n

TB shown 120-24 =>96<\/strong><\/p>\n

Stock Summary calculates<\/h2>\n

Qty \u2013 >(10-3) * 8 => 56 (it calculates all the qty against latest cost value)<\/p>\n

So report shown mismatch value between Trial balance vs Stock summary report<\/p>\n

Solution<\/h2>\n

Temp<\/p>\n

Identified the customer return without SO reference documents and updated the correct cost value as per opening inventory cost<\/p>\n

Root cause: Not yet identified.<\/p>\n","protected":false},"excerpt":{"rendered":"

During import inventory, the product and it\u2019s cost is updated properly in Compiere system. But, the customer return without Sales Order reference documents sub sequent transaction posting with wrong cost<\/p>\n","protected":false},"author":23,"featured_media":2318,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[350],"tags":[381,382,383],"class_list":["post-2256","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-compiere","tag-costissue","tag-customerreturn","tag-stocksummary"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/posts\/2256","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=2256"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/posts\/2256\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/media\/2318"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/media?parent=2256"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/categories?post=2256"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/tags?post=2256"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}