Stack Overflow
Stack Overflow

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
0
votes
0 answers

Bench init error related to virtualenv [mac os]

i was trying to init a bench on fresh insall of ERPnext, i m new to the framework and my probleme prolly is a missinstall but i cant really face it here is a snipper of my console output : virtualenv : 16.6.0 View screenshot of console $ => bench…
Hamza Adad
  • 1
  • 1
0
votes
1 answer

Best design for generating invoice based on order data?

So, I have an erp endpoint which parses purchase order and then does some pre processing before returning the response. Now, I would like to generate a receipt from the purchase order post data. The question here is 1. Storing the purchase data on…
user3385655
0
votes
2 answers

ERPNext: Join multiple tables using script report

Anyone know what is the ORM function for joining multiple db tables in ERPNext? I need query result from 2 DB tables join using script report *I don't need query report answer since i already have it. I only looking for an example do it using script…
shar_evonz
  • 33
  • 7
0
votes
2 answers

DocType not visible under Module view

I have created two DocTypes inside the education module. I've unchecked the "custom" checkbox to build the js and py files. However, the two DocTypes have not listed inside the education module. If I check the custom they return to list under setup…
Rashed M Omar
  • 21
  • 5
0
votes
1 answer

How to pass data to another doctype

I have 2 doctypes, When i press button i want to send fields data, and items to another doctype, during research i found sample like this. But doesn't working at all. Any suggestion? frappe.ui.form.on('Testdatafrom', { custom_button: function…
Elliot
  • 598
  • 6
  • 25
0
votes
0 answers

How to get child table values in frappe.route_options along with Parent table values

In sales order , I have a button for creating Allotment which is a custom doctype. Using frappe.set_route I am able to get parent table values but not sure how to get child table values along with it. Kindly help, thanks! frappe.ui.form.on('Sales…
Jenisha
  • 1
  • 5
0
votes
1 answer

Setting up ERP-next in Mac

I have followed the GitHub to setup. I have installed pip, MariaDB, bench, Redis. After I run the command bench init frappe-bench and cd frappe-bench I don't allow me to create a new site. The following is an error that IO encountered.…
Binod Paneru
  • 113
  • 1
  • 13
0
votes
1 answer

Insert record from list if not exists in table

cHandler = myDB.cursor() cHandler.execute('select UserId,C1,LogDate from DeviceLogs_12_2019') // data from remote sql server database curs = connection.cursor() curs.execute("""select * from biometric""") //data from my database table lst =…
Aditi
  • 3
  • 7
0
votes
2 answers

How to fetch doctype eg: address or tax rule

I want to fetch the doctype. How do I do this? I want to add a separate column which will give doctype such as sales order, purchase order etc. The first line gives me error what query should be fired. Please help I am new to ERP Next. SELECT …
Ashutosh Halape
  • 19
  • 7
0
votes
1 answer

Use of ERPNext for Rapid ERP development

Want to use any open source stack for rapid erp development for a school. Which can be used for multiple site with multiple deployment. My preferred development stack is java/python/javascript. For that, I choose ERPNext. Is there any hidden cost…
Adnan Rahman
  • 45
  • 1
  • 7
0
votes
1 answer

Uncaught TypeError: Cannot read property 'substr' of undefined (javascript)

I have this error on my console below is the snippet of the code i am working with JAVASCRIPT get_items: function (item_code) if (key) { if (key.length == 13){ if (key.startsWith('221')){ return…
EnSeal
  • 11
0
votes
1 answer

How to set root user password for mysql while installing erpnext?

I am installing Erpnext in my ubuntu 18.04 Lts. I want to know how to set password for MySql root user. I am installing erpnext in my ubuntu 18.04 LTS. while running the command - 'sudo bench new-site site4.local' for creating a new frappe site,…
Nitish awasthi
  • 133
  • 2
  • 10
0
votes
1 answer

ERPNext - How to see iconic dashboard

I have hosted free trial of cloud ERPNext and followed all the tutorial to set basic configuration. As i am very new to this system, How can I see dashboad like below? As I am learning this system and documentation is heavy... Any help in this…
JsLearner
  • 446
  • 2
  • 7
  • 17
0
votes
1 answer

ERPNext OperationalError (2003, "Can't connect to MySQL server on u'localhost' ([Errno 22] Invalid argument)")

I’m getting the below error when trying to install a new site using command bench --site site1.local install-app erpnext This is a new installation on Windows Linux SubSustem running Ubuntu. I’m able to login into mysql through command line using…
Swadeesh
  • 576
  • 1
  • 4
  • 23
0
votes
1 answer

IndexError: tuple index out of range (Frappe/Erpnext)

I am trying to modify code below but I am getting a "tuple index out of range" error. price_list_name = frappe.db.sql("""select name from `tabItem Price` a where a.item_code = %s and a.selling = 1 …
EnSeal
  • 11
1 2 3
…
13 14