Hi Everyone,

The purpose of this post is to remind me later when I need a query to create missing costing records. Copy execute the below query into pgadmin:

select ‘insert into m_cost
values(‘||p.ad_client_id||’, 0, ‘||p.m_product_id||’, 1000000, 1000000, ‘||ce.m_costelement_id||’, 0, ”Y”,
now(), 1053269,now(), 1053269, 0,0,0,0,0,”Mass Import”, 0,0,null,”N”, null, null, null);’
from m_product p
inner join m_costelement ce on (p.ad_client_id = ce.ad_client_id)
left outer join m_cost co on (p.m_product_id = co.m_product_id and ce.m_costelement_id = co.m_costelement_id)
where p.ad_client_id = 1000000
and co.m_product_id is null

Next steps:

  1. Copy the results of the above query
  2. Paste the results back into pgadmin
  3. Execute the query (insert statements)
  1. Costing is maintained at the client level. If not, you simply modify the above query to include the org.
  2. Costing is not at the AttributeSet or batch level. If so, the query gets a little more complex. At this point you should contact me.

I hope this helps!!!

ADempiere vs iDempiere vs Openbravo vs Compiere

Please note that ADempiere, iDempiere and Openbravo are forks or copies from Compiere. Therefore, they have similar abilities mentioned above. The biggest difference is that ADempiere and iDempiere are pure open source. There are no features held behind a commercial or paid license.

About Chuck Boecking: I am an ERP educator. I believe that open source ERP have achieved mainstream capabilities, and as a result, more companies can create greater efficiency across their organization. I started using the iDempiere code base in 2003. Back then, it was called Compiere. In 2006, I started my first multi-million dollar installation. Since then, ADempiere has helped me create great success with distribution and manufacturing companies all over the world. My vision of success is to find companies that can best use open source ERP to help them achieve a single, global instance that drives a discontinuous increase in profitability. I believe that organizations win when they own their technology.

If you have questions, comments or concerns, let me know. I definitely want your feedback.

You can contact me by phone using 512.850.6068.

My email is chuck@chuboe.com.

You can complete the form on this page.

Thank you for taking the time. I look forward to speaking with you.

Chuck Boecking



Leave a Reply

Your email address will not be published. Required fields are marked *