Home Author
Author

karani

CEO and Founder of Upeosoft Limited

Developer CornerFrappe/ERPNext

How to solve the IntegrityError(1062) issue when installing a frappe app

by karani
written by karani

If you’ve ever encountered the frustrating “module integrity issue” while installing a Frappe app, you’re not alone. This error can often be a roadblock to getting your app up and running.

Fortunately, there’s a solution, and it’s been demonstrated in a helpful YouTube video. In this brief guide, we’ll walk you through the steps to resolve this issue and successfully install your Frappe app.

Whether you’re a developer or just someone looking to set up a Frappe app, this solution will help you overcome this obstacle and get your project back on track. Let’s dive in and make module integrity issues a thing of the past!

0 comment
0 FacebookTwitterPinterestEmail
Developer CornerFrappe/ERPNext

Effective Error Reporting in Frappe Framework and ERPNext Development

by karani
written by karani

Error reporting is a fundamental aspect of the development process when working with the Frappe Framework and ERPNext. As a developer, encountering errors is not a matter of “if” but “when.” How you handle these errors can significantly impact your efficiency and the overall quality of your projects. In this concise guide, we’ll delve into the how of error reporting within the context of Frappe Framework and ERPNext development.

Like any other python powered application, Frappe applications track errors through logging. Logging is an indispensable tool for diagnosing and resolving errors. Implement detailed logging throughout your codebase, using appropriate log levels to capture essential information. The Frappe framework provides a logging module that supports various log levels, allowing you to track the flow of execution and pinpoint the source of errors.

Mastering error reporting in Frappe Framework and ERPNext development is an essential skill. Your meticulous documentation, collaborative spirit, and commitment to improvement contribute not only to your projects but also to the wider developer community. By transforming errors into opportunities for growth, you’ll elevate your proficiency and the quality of the software you create.

Below is an example of logging you can use when you want to log different levels of errors:

from frappe import log, _

log.debug(_("Debug message"))
log.error(_("Error message"))

In the below video, I will demonstrate how you can quickly get started with error reporting. If you need to report the exact level of the error, use the example I have already provided above.

0 comment
1 FacebookTwitterPinterestEmail
Developer CornerFrappe/ERPNext

PDF Printout Doesn’t Show Header in Frappe/ERPNext

by karani
written by karani

It is quite frustrating to have your printouts looking all well only to get broken when you try to render them into a PDF that can be downloaded. If you have a similar case in your ERPNext or Frappe instance, where the letterhead doesn’t show on the PDF format, it is because your wkhtmltopdf package needs to be updated. In this article, I will summarize how you can quickly do this in different versions of Ubuntu.

After you have successfully completed the two stages, restart the supervisor if on production or restart your instance if in development to ensure changes take effect.

Ubuntu 22.02

wget https://github.com/wkhtmltopdf/packaging/releases/download/0.12.6.1-2/wkhtmltox_0.12.6.1-2.jammy_amd64.deb

sudo apt install -f ./wkhtmltox_0.12.6.1-2.jammy_amd64.deb

Ubuntu 20.04

wget https://github.com/wkhtmltopdf/packaging/releases/download/0.12.6-1/wkhtmltox_0.12.6-1.focal_amd64.deb

sudo apt install -f ./wkhtmltox_0.12.6-1.focal_amd64.deb

Ubuntu 18.04

wget https://github.com/wkhtmltopdf/packaging/releases/download/0.12.6-1/wkhtmltox_0.12.6-1.bionic_amd64.deb

sudo apt install ./wkhtmltox_0.12.6-1.bionic_amd64.deb

Ubuntu 16.04

wget https://github.com/wkhtmltopdf/packaging/releases/download/0.12.6-1/wkhtmltox_0.12.6-1.xenial_amd64.deb

sudo apt install ./wkhtmltox_0.12.6-1.xenial_amd64.deb

0 comment
2 FacebookTwitterPinterestEmail
Technology

Simplifying Financial Management: Automating Bank Reconciliation in ERPNext

by karani
written by karani

Introduction

In today’s fast-paced business environment, efficient financial management is crucial for the success of any organization. Bank reconciliation, a vital component of financial record-keeping, can often be time-consuming and prone to errors when performed manually. However, thanks to the power of automation, this process can now be streamlined and made more accurate than ever before. In this blog post, we will explore a video by Geoffrey Karani, the esteemed founder of Upeosoft Limited, as he demonstrates how bank reconciliation can be automated within ERPNext—an all-in-one ERP system. Get ready to witness the transformative potential of automation in financial management.

Overview

In his video, Geoffrey Karani expertly guides viewers through the process of automating bank reconciliation in ERPNext. With his vast knowledge and experience in the field, Geoffrey highlights the key steps and features that make this automation possible. Let’s delve into the video’s key highlights:

  • Bank Statement Import:
    • Geoffrey demonstrates how ERPNext simplifies the bank reconciliation process by allowing users to import bank statements directly into the system. He showcases the flexibility of the import feature, accommodating multiple file formats, such as CSV or Excel, making it easy to bring in bank transaction data.
  • Automatic Matching:
    • Geoffrey highlights ERPNext’s intelligent algorithms that automatically match bank transactions with corresponding accounting entries. He explains how the system factors in transaction amounts, dates, and references to identify potential matches, reducing the need for manual intervention. This automation significantly speeds up the reconciliation process while maintaining accuracy.

Conclusion

Through his insightful video demonstration, Geoffrey Karani, founder of Upeosoft Limited, sheds light on the automation possibilities within ERPNext for bank reconciliation. By showcasing the system’s import functionality, automatic matching algorithms, exception handling, real-time updates, and reporting capabilities, Geoffrey highlights how this ERP solution can revolutionize financial management. With ERPNext’s bank reconciliation automation, businesses can save time, reduce errors, and gain valuable insights into their financial position.

As Geoffrey Karani demonstrates, embracing automation in ERPNext empowers organizations to focus on strategic financial decisions rather than getting lost in the intricacies of manual reconciliation. Streamline your financial management processes today and unlock the full potential of your business with ERPNext.

0 comment
0 FacebookTwitterPinterestEmail
ERPNext for Business

Bank Reconciliation In ERPNext

by karani
written by karani

In very simple terms, a bank reconciliation statement is one that shows you the differences in your bank statement that you get from your bank, and the balances that are showing in your accounting software.

There are two types of Bank Reconciliation in ERPNext. The Manual and the Semi-automated types. In today’s article, we will only look at the semi automated bank reconciliation, but we may mention one or two things about the manual bank reconciliation.

See more details from this ERPNext documentation link.

0 comment
2 FacebookTwitterPinterestEmail
Technology

How to Set-up Promotional Schemes (Free Items) in ERPNext

by karani
written by karani

In this video I will demonstrate how you can setup promotional schemes in ERPNext. This setup will allow you to offer free items to your customers when they hit a pre-determined threshold when buying a given product.

In this example we are going to give:

  • 1 item when a customer buys 5 – 10 items
  • 2 free items when a customer buys 11 – 20 items
  • 3 free items when a customer buys 21 – 30 items
  • 4 free items when a customer buys 31 – 40 items
  • 5 items when a customer buys more than 40 items.
0 comment
3 FacebookTwitterPinterestEmail
ERPNext for BusinessFrappe/ERPNext

How to create a Purchase Invoice in ERPNext

by karani
written by karani

A purchase invoice is an invoice that is used in conjunction with a purchase order. It is used to indicate how much money the buyer owes to the seller. Purchase invoices are also commonly known as bills, statements or sales invoices.

In ERPNext, the process of creating this document is easy and almost straightforward, and this video is a step by step demonstration on how you can create it.

0 comment
1 FacebookTwitterPinterestEmail
Frappe/ERPNextTechnology

ERPNext Installation Issue – ERROR: There was a problem while creating karani

by karani
written by karani

When installing ERPNext, you may run into an issue that displays the message:

ERROR: There was a problem while creating karani

This error message is then followed by the following message:

 Do you want to rollback these changes? [y/N]:

See below screenshot:

This can be a frustrating feeling especially because there isn’t a clear reason why your installation is failing. This is the reason I put up this brief article to help.

The issue here is squarely a pip issue, and it can most of the time be solved by running the following command.

pip3 install --upgrade --user pip

If that doesn’t seem to save the day, run the following command:

pip3 install --user "setuptools<45"
0 comment
4 FacebookTwitterPinterestEmail
Developer CornerFrappe/ERPNext

Custom Buttons – Client Scripts in Frappe Framework and ERPNext

by karani
written by karani

Client scripts are powerful! They give you the flexibility to control how you want your application to behave. With these pieces of code we can even alter how our application works currently.

In this video, we are going to have a quick introduction to the Frappe Framework and ERPNext client scripts. We will also explore the following topics in custom buttons:

  • How to create a custom button
  • How to create a group of buttons
  • How to add a custom button to a group button created by Frappe or ERPNext
  • How to rename a button created by Frappe or ERPNext

See more from Documentation

Client Script: Click here to view

Adding Custom Buttons: Click here to view

0 comment
1 FacebookTwitterPinterestEmail
Newer Posts
Older Posts
Close