Skip to content

ricardo malla's blog

  • home
  • it
    • o/s
    • databases
    • software
  • life
    • gamechangers
    • tv series
    • blogs to follow
    • books to read
    • health
  • ideas
  • notes
Search

ricardo malla's blog

Close menu
  • home
  • it
    • o/s
    • databases
    • software
  • life
    • gamechangers
    • tv series
    • blogs to follow
    • books to read
    • health
  • ideas
  • notes

ricardo malla's blog

Search Toggle menu

Category: idempiere

November 17, 2018idempiere

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’  

August 19, 2018idempiere, java, openbravo, tibco - jasper reports

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). […]

August 18, 2018November 30, 2019idempiere

idempiere: restart server

sudo service idempiere stop sudo service idempiere start

December 24, 2017December 24, 2017idempiere, postgresql

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 […]

September 8, 2016September 8, 2016idempiere, postgresql

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

August 19, 2016August 19, 2016idempiere

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  

July 28, 2016July 31, 2016idempiere

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 […]

July 28, 2016July 31, 2016idempiere

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 […]

July 27, 2016July 29, 2016idempiere

idempiere: configuring webservices

First if services are enabled: http://host:port/osgi/system/console/bundles   See Available WebServices http://host:port/ADInterface/services

May 31, 2016August 11, 2016idempiere, prestashop

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. […]

Posts navigation

1 2 >

Recent Posts

  • google seo tips
  • google search engine: search engine id.
  • google search using python
  • google developers: api location
  • outlook dasl filter – not like and other nomenclature
  • pimcore or mysql database restore
  • postgresql where multiple values
  • microsoft graph to add emails to spam list
  • excel: extract url from hyperlink
  • lazy loading

Categories

  • adempiere (1)
  • android (1)
  • apache (3)
  • asterisk (11)
  • backup strategies (3)
  • blogs to follow (1)
  • centos (1)
  • documentaries (1)
  • dropbox (2)
  • elasticsearch (1)
  • email marketing (3)
  • emfs (1)
  • esxi (1)
  • fail2ban (1)
  • finance (1)
  • gamechangers (5)
  • gamechanging concepts (2)
  • google (1)
  • google cloud (1)
  • health (1)
  • history (1)
  • ideas (1)
  • idempiere (17)
  • it (1)
  • java (8)
  • legal (1)
  • life (2)
  • magento (6)
  • management (1)
  • mautic (9)
  • microbiome (1)
  • microsoft stack (4)
  • mysql (18)
  • nginx (1)
  • notes (1)
  • o/s (1)
  • openbravo (39)
  • openerp/odoo (6)
  • openvpn (1)
  • outlook (1)
  • pentaho (1)
  • pfsense (6)
  • php (4)
  • phplist (1)
  • phpmyadmin (1)
  • pingdom (1)
  • podcasts (1)
  • podcasts (1)
  • podcasts (2)
  • postfix (1)
  • postgresql (19)
  • prestashop (21)
  • procurement (1)
  • python (3)
  • sales (1)
  • scrapy (1)
  • seo (1)
  • shell (3)
  • software (3)
  • splunk (1)
  • sugarcrm (20)
  • synology (2)
  • sys admin (2)
  • talend (3)
  • tibco – jasper reports (20)
  • tv series (1)
  • ubuntu (26)
  • uncategorized (179)
  • unifi (3)
  • virtualbox (1)
  • virtualization (1)
  • vmware (5)
  • wordpress (2)
  • zoiper (1)
© 2023 ricardo malla's blog. Proudly powered by Sydney