Questions tagged [erpnext]

ERPNext is a generic ERP software used by manufacturers, distributors and services companies. It includes modules like accounting, CRM, sales, purchasing, website + e-commerce, point of sale, manufacturing, warehouse, project management, inventory, and services. Also, it has domain-specific modules like schools, healthcare, agriculture and non-profit.

Among other things, ERPNext will help you to:

  1. Track all Invoices and Payments.
  2. Know what quantity of which product is available in stock.
  3. Identify open customer queries.
  4. Manage payroll.
  5. Assign tasks and follow up on them.
  6. Maintain a database of all your customers, suppliers and their contacts.
  7. Prepare quotes.
  8. Get reminders on maintenance schedules.
  9. Publish your website.

And a lot lot lot more.

203 questions
2
votes
2 answers

pymysql.err.ProgrammingError 1064 in simple multiline SQL query for mariadb

I have tried everything and keep getting this error: pymysql.err.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'INSERT INTO…
racitup
  • 416
  • 4
  • 11
2
votes
1 answer

Is there a way to connect mariadb with python2.7

In my mac OSX i'm trying to use python2.7 and mariadb. I am using pip install mysql-python or pip install mysqlclient as a connector. But system always give me bunch of error. Any other way to overcome this issues? ERROR: Command errored out with…
hizbul25
  • 3,829
  • 4
  • 26
  • 39
2
votes
1 answer

How to execute a .sh file from windows batch file in wsl

I am trying to execute a .sh file inside ubuntu from .bat file inside windows. I have tried following code cd "C:\Program Files\Ubuntu\Ubuntu" start ubuntu1804.exe run ErpStartupService.sh and my ErpStartupService.sh is #!/bin/bash sudo service…
ebk
  • 305
  • 8
  • 20
2
votes
1 answer

Get documentation from GitHub project as a single pdf

I'm looking for a single pdf of the ErpNext and Frappe user manuals. Documentation seems to be provided in html and the source is in markdown. I did find tools to convert markdown to html/pdf, but no reliable solution to generate a SINGLE pdf file…
2
votes
2 answers

Can We use page breaks in for loops?

I wanted to print barcodes using for loop in python. This is my code: `{%- from "templates/print_formats/standard_macros.html" import add_header -%}
{% set a = doc.end %} {% set count = 0 %}
{%- for i in…
LaksHmiSekhar
  • 315
  • 2
  • 7
  • 16
1
vote
1 answer

How to allow print only if student paid in the education module in erpnext

what I want to do is disable print from student applicant document if student still has outstanding balance. I tried this script but nothing happens. frappe.ui.form.on("Student Applicant", { onPrintDocument: function(frm, doc, ev) { // Get…
Khallad
  • 123
  • 4
  • 24
1
vote
0 answers

Is there a way I can create a custom erpnext app without being prompted for the inputs,eg;description, etc... while using the "bench new-app" command?

I want to create an app using a bash script inside my docker-compose.yml file but the problem is I am being prompted for the app details like the App Title,description etc which are usually there by default.This leads to the process getting aborted…
1
vote
2 answers

Please make sure that Redis Queue runs @ redis://localhost:11000

Please make sure that Redis Queue runs @ redis://localhost:11000 bench new-site test1.loc MySQL root password: Installing frappe… Updating DocTypes for frappe : [========================================] 100% Updating country info :…
1
vote
0 answers

How to open dialog (Quick Entry view) on Add New Row from child table of Frappe Webform?

How to open Dialog box (Quick Entry view) on Add New row of child table of Webform like we can open dialog box from Doctype as below. From WebForm it is not allowing me to open dialog box on Add new Row of child table. Can anyone please help me to…
Darshana
  • 662
  • 1
  • 10
  • 29
1
vote
0 answers

How can I add a new new field type "Tree"

I wand add new field type “Tree” … in a new doctype named “Customer” I want add the “Territory” as link but it should be displayed as a “Tree” not drop down list and only the leaf should be selectable. Thanks in advance. I don't know how to start!
Paula Mansour
  • 33
  • 1
  • 6
1
vote
2 answers

How uninstall pip3

I am having some problems with pip when trying to install a python application. It says its not able to find pip3, but its installed Digging deeper I think I have locations where pip3 is installed. While trying to uninstall, even that is not working…
frewper
  • 1,385
  • 6
  • 18
  • 44
1
vote
0 answers

ERPNext School module installation problem

I am trying to install lms app. LMS app has dependency on school app so i have to install both. I have followed this links. https://github.com/frappe/schools https://github.com/frappe/lms But I am getting the error while installing school app as…
Meet
  • 11
  • 2
1
vote
1 answer

Add app into left side menu bar on Frappe ERPNext

I created a frappe bench and installed a new app named Vehicle_Management. I want to show this app module on the left side menu bar on my ERPNext. I am new to this framework. Please let me know how I can do this.
1
vote
0 answers

getting StatusCode: 403, ReasonPhrase: 'FORBIDDEN', when accesing get api through below code

Below is the code sample public string getIssueList(string email) { dynamic JsonContent = ""; string url = baseAddress + "resource/Issue/?fields=[%22subject%22,%22status%22]&filters=[[%22Issue%22,%22raised_by%22,%22=%22,%22" + email +…
Aakash
  • 11
  • 1
1
vote
1 answer

Fetch the latest entry created in a doctype order by the latest date field

I am trying to get and put last four fields value to my new created record from the latest created in my custom doctype, No luck working the client side scripting in ERPNEXT 13. I need this to calculate the difference between today and yesterday…
Michelle
  • 11
  • 3
1
2
3
13 14