idempiere: allow sales pricelist on purchase order
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’
Category: idempiere
jasper reports: java compatibility
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). […]
idempiere: restart server
sudo service idempiere stop sudo service idempiere start
delete duplicate rows on pgsql and mysql
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 […]
idempiere: alter sequence
Update M_Product_ID UPDATE ad_sequence SET currentnext = 1026150 WHERE ad_sequence_id = 114 Update Product PriceList UPDATE ad_sequence SET currentnext = 1026138 WHERE ad_sequence_id = 165
idempiere: callout function to customize system
http://www.adempiere.com/Callout I need to create a new Callout and add it to the Markup Field I created
idempiere: add all roles to admin
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 […]
idempiere: cleaning demo data
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 […]
idempiere: configuring webservices
First if services are enabled: http://host:port/osgi/system/console/bundles See Available WebServices http://host:port/ADInterface/services
erp to webstore integration
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. […]