AI Powered-ERPNext(Open Source)-Automated Testing(No RPA)-Projects Data Generation & Posting(Python+Gemma LLM+API)

This is Quick Demo of How we can use API with AI for Testing & Data Entry Automation without RPA, In Current Demo two separate python scripts are used (1 for AI Powered data Generation & 2 for Automatically Posting data in ERPNext). I will later merge every script in single master script.

What is ERPNext?

Free and Open Source Enterprise Resource Planning (ERP). ERPNext includes the following areas for managing businesses:

  1. Accounting
  2. Warehouse Management
  3. CRM
  4. Sales
  5. Purchase
  6. HRMS
  7. Project Management
  8. Support
  9. Asset Management
  10. Quality Management
  11. Manufacturing
  12. Website Management
  13. Customise ERPNext

ERPNext is built on the Frappe Framework, a full-stack web app framework built with Python & JavaScript.

Where is Repository?

Here is the link for Repository

https://github.com/frappe/erpnext

Where is the Official Website?

https://frappe.io/erpnext

How can I quickly Install and Run on MacOS/Ubuntu/Windows

Here are Step by Step Instructions to Quickly run ERPNext with Docker Compose on Ubuntu, For Windows there will be separate article. For MacOS refer below article.

“https://medium.com/free-or-open-source-software/erpnext-open-source-erp-install-and-run-with-docker-compose-on-macos-1c5d234d034a

Step 01: I have created two python scripts, 1 for AI Powered data Generation & 2 for Automatically Posting data in ERPNext via API and also type of data required to be posted in ERPNext, we can use AI Powered data generation for multiple use case.

Step 02: Here is the format in which I need AI to generate data for me.

Step 03: Now I will run AI powered script which is connected with Docker AI & Gemma3n LLM to generate data for me with basic interaction.

Step 04: I have Instructed AI to ask from me how many test data transactions need to be created, which one will be fixed or variable or need to be from the data range.

Step 05: AI will generate CSV file that needs to be uploaded in ERPNext.

Step 06: Here is How CSV will appear after test data generation.

Step 07: Now I have 100 Test Project based on my preference, I will run next Python script so that data can be uploaded via API in ERPNext.

Step 08: This is How Project looks in ERPNext before executing script.

Step 09: This is how Projects will be updated after script execution.

Here is Quick screencast of this Article.

Stay tuned for more updates.