Load some data to ERPNext to analyze it in Metabase BI

In previous post I installed ERPNext and Metabase on Digitalocean. Now I’m going to load some data into ERPNext and Connect it to Metabase so display the data. I’m not going to use ERPNext data loading tools but do it via API usin Go programming language. I will be creating 1000 Sales orders and customers in ERPNext using API calls. It will also test how well the 5$ Digital Ocean droplet will hold when giving it some work to do....

February 1, 2020 · Villem Heinsalu

Installing ERPNext and Metabase on Digital Ocean to enjoy Open Source Business Applications

Open source is great and there’s so many good stuff out there. I’m going to explore ERPNext and Metabase which are two great open source software’s. ERPNext is Enterprise Resource Planning software which has lots of functionality and they advertise it as Open Source Alternative For SAP, Oracle etc. Metabase is Business Intelligence software to analyze data. I’m going to install both of them on a 5 USD DigitalOcean droplet....

February 1, 2020 · Villem Heinsalu

Showcase: Custom productivity tool made to enhance SAP Cloud ERP productivity

This is a showcase of a tool that we built for customers to be used alongside with SAP Cloud ERP. Quick facts about the tool: Connected to SAP Via SOAP and oData API’s Integrates into the standard business processes Enables very quick data entry, integrations to 3rd parties, enables custom business processes Built with Nodejs as backend and Reactjs as front end and hosted in Heroku Why the tool was built?...

December 24, 2019 · Villem Heinsalu

About Enterprise Resource Planning Systems and how to understand them better

I have been working with ERP softwares for more then 10 years. I have been supporting users using them, implementing them as a consultant, developing them, building integrations into them, doing pre-sale demos to customers to sell them. I have both experience as a business consultant trying to fit customer business into the ERP and as a developer doing extentsions, add-ons etc. to the ERP. So here’s some of my thoughts on the subject of ERP....

December 7, 2019 · Villem Heinsalu

Building an automation - Send Xero invoice to Slack channel via Google Cloud Functions

Xero is a popular cloud based accounting software. Slack is popular cloud based Team chat tool. Slack is also very suitable for building integrations into it and automating business processes. Here is a small example of how to build simple integration where when an invoice is created in Xero then notification with details is posted to a certain Slack channel. I’m going to use Google Cloud Functions with Nodejs to process Xero webhooks and post them to Slack....

November 23, 2019 · Villem Heinsalu

Golang Boilerplate for REST API with JWT, Auth middleware and Postgres

When starting a new project in a technology that you don’t know very well having a small boilerplate that shows how basic stuff work together is very nice to have. Also all projects have some common things such as user profiles, authentication, database, logging etc. Here is a small boilerplate for such things in Golang. More detailed guide on how to get this working is on the project site. Golang REST API Boilerplate...

November 5, 2019 · Villem Heinsalu