After installing PostgreSQL, run this command in terminal to install PgAdmin4 on Ubuntu, sudo apt install pgadmin4 pgadmin4-apache2 -y During installation, it will ask for Email Address and Password to access. Give any email address that will be used as username and Password that will be used to access admin panel. After that you can access pgadmin4 by entering: localhost/pgadmin4/ in […]
How to configure source code of iDempiere?
Its a simple but tricky process. There are some common mistakes that a beginner usually do, significantly the one, not coming from Java background. So here is the step by step process to configure iDempiere source code and avoid common mistakes. Prerequisites of iDempiere are as follow: Windows and Ubuntu both works fine Postgre SQL Java Maven Eclipse IDE Environment […]
Create Callout to deduct withholdoing on Payment in iDempiere
Here is a scenario: Write a callout for payment window to calculate following withholding Taxes & Security on Payment Voucher: GST PST Income Tax Security Note: After deduction of taxes, the Payment Amount will become lesser than Invoice Amount but the iDempiere doesn’t knows it becasue we are doing calculations using custom Callouts. Due to it, there will be a […]
How to concatenate a string in a database column?
UPDATE m_product SET “value”=concat(‘IUB-‘,value) WHERE ad_client_id!=’11’
How to import GL Journal in iDempiere
Click this link to download sample file template to import: GL Journal Import Template This article is not completed yet!
Press Release – Training of iDempiere – A Series of Events
Training of iDempiere – A Series of Events The Directorate of IT successfully conducted a series of events regarding iDempiere – an ERP solution to automate the Finance Department. It was the 12th event of the series of seminars and training, conducted by Mr. Rana Faraz Ahmed (Programmer). They were held at Ghotvi hall and Conference Room of Abbasia Campus. […]
How to post budget in iDempiere?
Note: This process is for iDempiere deployed at IUB not don’t follow standardised approach. Open Calender Year and Period window of iDempiere and create a new calender. After that create a new Year agaisnt that calender. Then create Periods by giving exact Months and Dates of Fiscal Year. Then open GL Budget window and create new Budget. Then add a […]
Flow of Procurement in iDempiere
Step by step process to manage procurement and store using iDempiere: Create Warehouse against Organization. Add Business Partners and check them as Vendor, using Business Partner window. Must and Location. Add Products using Product window and register it against a Price List. Create RFQ Topic = A Head for multiple RFQs being announced under same publication. Create RFQ = Request for […]
How to import products into iDempiere?
Importing products into iDempiere is a tricky but simple process. One can easily import as many products as he/she wants by following steps given below: You need to set an importing format by using Import Loader Format Window of iDempiere. In this window you need to set the sequence of columns in which you need to import products using .CSV […]
Programming Languages You Should Learn in 2020
Programming languages and computer coding have made life simpler for us. Whether it’s automobiles, banks, home appliances, or hospitals, every aspect of our lives depends on codes. No wonder, coding is one of the core skills required by most well-paying jobs today. Coding skills are especially of value in the IT, data analytics, research, web designing, and engineering segments. 1. […]