Show product Pricelist on Purchase Order Go to System profile, Windows, Tabs & Fields Select Purchase Order Tab (header tab) Remove the statement from the Sql Where field. C_Order.IsSOTrx=’N’
We user Jasper Reports on multiple projects: We have a stand-alone Jasper Server that runs all types of reports from our server We have an Openbravo ERP Instance We have an iDempiere ERP Instance Running (same fork root as Openbravo). […]
This code shows how to delete duplicate rows on pgsql DELETE FROM m_product WHERE sku in( SELECT sku FROM ( SELECT sku, count(*) FROM m_product GROUP BY sku HAVING count(*) > 1 ) a ) AND em_mg_manufacturer = 1000012 […]
It’s a pain to add all the roles to the Admin Role (I had to re-create this role because I messed up the original role and had to hack my way back to the system). The role is divided in […]
The following tables use space on my database and for the use I have for the system I will not use them (I don’t need accounting because I use another system for this). So I’ll delete them. “adempiere”.”m_product_acct” 5904 kB […]
Inventory is on iDempiere Script to get inventory on CSV File Script to upload CSV File from iDempiere’s server to webstore SSH to Remote Webstore to execute update Script Current Problems… Script to Export puts ” ” on the String. […]