Hope, you are safe amidst the COVID-19 disruption!
We are here with yet another minor release which we do every month. Thanks to all the developers who have worked hard and contributed so many new features, fixes, and documentation. And special thanks to those who helped to test the changes.
ERPNext v12.7.0
Enhancements
Allow Purchase/Sales Invoice without Purchase/Sales Order against a specific Supplier/Customer #20865
The address is now mandatory to place an order from Shopping Cart #20922
Target Warehouse for finished goods in Manufacture type Stock Entry now can be different from Work Order #21002
Qty in Stock Entry must always be positive #21004
Enhanced UX for Manufacturing module #19802
Default calendar for Job Card
Changed Timer Position, Added Pause, Resume Button
Progress Bar for Work Order Operations
Create Multiple Job Cards from Work Order
Removed Projected Quantity Formula Section from Production Plan and Added Doc Link Next to Field
Grouped relevant fields
Allowed customized Order Type in Sales Order #18096
Added Serial No Status field for the filter in List and Report view #21201
Enabled new regions (UAE, BR, MX) to amazon MWS connector #21195
Added Scan Barcode field in Purchase Receipt #21181
Added Cost Center, Warehouse and Item Group filters in Purchase Register report #21177
Show filtered items in Material Request based on Request Type #21173
Set Qty To Manufacture field as non-mandatory in job card #21080
Fetch batch no automatically from serial no, if the item has both serial and batch no #20757
Fixes:
The payment status of Expense Claim considering Employee Advance amount
Fixes in BOM Comparison Tool #20992
UOM fixes in Sales Order, Material Request and Production Plan #21015
Passive Italian e-Invoicing #19334
Batch selection popup not coming for stock entry #21036
Place of supply validation in GSTR-1 report (for India) #21057
On changing qty, the free item was not removing #21250
If Lead name has leading white space, Contact’s first name was set to blank #21247
Make Message field mandatory in Project, if Collect Progress is checked #21208
Show base received amount only when base paid amount defers from base received amount #21193
Consider reverted entries to cancel out expired leave entries which were reverted #21256
The tax amount after discount amount should be considered for tax calculation in GSTR-3B report #21241
Replace newlines with spaces before evaluation of condition and formula #21166
Get serial nos qty in Stock Reconciliation based on posting date and time #21169
Validate Serial/Batch No naming series in Item itself #21167
When shipping tax is set it does not clear cart and gives error #21035
While creating Sales Invoice from the shopping cart, enable auto allocation of advances #20878
Payment Request status fixes #21100
Add permissions on GSTR-3B report only for India #21163
Since a Customer Provided Item does not have a valuation rate, expenses should not be booked in Stock Entry #21156
Update Received Qty in Material Request as per Stock UOM #21055
Cannot set warehouse while deleting all items from submitted sales order and then adding new items #21078
Serial no scan was not adding the serial nos in stock entry #21082
Healthcare Domain Issues #21112
Appointment Reminders not working
Disabled Patient, Practitioner Schedule, Clinical Procedure Template showed as enabled in ListView.
Batch not getting fetched in Clinical Procedure Item.
Lab Test Template Item creation error
Lab Test Template error while creating a Patient Medical Record
Party details not set in Payment Request in case of payment failed from shopping cart #21085
Allowed Expense accounts with only base currency in Landed Cost voucher #21074
Price list mentioned in Customer Group should get priority over POS Profile #21117
Show proper currency symbol in Total row in Accounts Receivable/Payable report #21090
Add item defaults based on global settings only if default company and warehouse is mentioned #21088
If “Display Items In Stock” enabled, show only available items in POS #21071
Update Requested Qty in Bin based on Material Request Type #21065
Ignored user permission for parent_company and existing_company field in Company #21010
Wrong calculation of depreciation eliminated in Asset Depreciation and Balances report #21032
Frappe 12.5.0
Bug Fixes
Fixed incorrect calculation of week ending date in Dashboard Charts (#9712 )
Fixed issue with default value not getting set from user permission (#9796 )
Fixed report export in excel (#9813 )
Fixed invalid date parsing issue (#9890 )
Fixed issue welcome emails getting sent even after send_welcome_email was unchecked (#9902 )
Fixed print format occasional render failures (#9821 )
Fixed issue with private files being publicly accessible in some cases (#9935 )
Fixed random failures of Filter By option in sidebar (#9892 )
Fixed an issue with Query Report’s custom fields not getting retained (#9787 )
Fixed Webform redirect issue (#9793 )
UI/UX Enhancements
Minor UI fixes (#9699 ), (#9716 ), (#9800 ), (#9825 )
Now Energy Point summary will be sent only if email notifications are enabled (#9893 )
Now, for workflow enabled Document Types, cancel button will only be visible if document is cancellable (#9811 )
Features
Allow System Managers to view Notification Settings list (#9895 )
Added ability to set 0 precision for currency fields (#9725 )
Now fields of type Data, Int & Check can be used for filter by option in the sidebar of List View (#9767 )
Introduced calendar for ToDo (#9807 )
Added more Genders and Salutations (#9870 )
29 Likes
Thanks for the hard work. Just installed the latest version.
Got some error upon starting server : “erpnext.healthcare_healthcare.doctype.patient_appointment.patient_appointment.send_appointment_reminder”
I think it meant to be : erpnext.healthcare.doctype.patient_appointment.patient_appointment.set_appointment_reminder
And after fixed that, got this error :
File “/home/frappe/frappe-bench/apps/frappe/frappe/handler.py”, line 69, in is_whitelisted
01:43:11 web.1 | raise frappe.PermissionError(‘Not Allowed, {0}’.format(method))
01:43:11 web.1 | frappe.exceptions.PermissionError: Not Allowed, <function update_last_known_versions at 0x7f0da058c620>
please remove the reference and proceed till the fix gets merged, thanks
frappe:version-12-hotfix
← akurungadam:patch-1
opened 01:16PM - 19 Apr 20 UTC
Removed scheduler event incorrectly added in this version, method not yet merged… to version-12
as reported via this [discuss post](https://discuss.erpnext.com/t/internal-server-error-and-healthcare-module-missing/60479/6)
Thanks @akurungadam for the fix, merged the fix in version-12 branch.
1 Like
iMoshi
April 21, 2020, 1:32pm
6
Can we expect these changes have also been implemented to the “develop” branches as well?
Yes, all the changes are also included in develop branch.
1 Like
iMoshi
April 21, 2020, 5:49pm
8
Sweet! Thanks guys! Awesome work.
@nabinhait Email notifications for successful backups broken since this update.
@flexy2ky can you elaborate on this issue. Perhaps open a descriptive bug report on frappe
@gavindsouza Issue raised on Github:
opened 04:25PM - 23 Apr 20 UTC
closed 04:11PM - 08 May 20 UTC
bug
<!--
Welcome to the Frappe Framework issue tracker! Before creating an issue, p… lease heed the following:
1. This tracker should only be used to report bugs and request features / enhancements to Frappe
- For questions and general support, use https://stackoverflow.com/questions/tagged/frappe
- For documentation issues, refer to https://frappe.io/docs/user/en or the developer cheetsheet https://github.com/frappe/frappe/wiki/Developer-Cheatsheet
2. Use the search function before creating a new issue. Duplicates will be closed and directed to
the original discussion.
3. When making a bug report, make sure you provide all required information. The easier it is for
maintainers to reproduce, the faster it'll be fixed.
4. If you think you know what the reason for the bug is, share it with us. Maybe put in a PR 😉
-->
## Description of the issue
Mails are no longer sent to predefined recipients for scheduled backups. Mails were sent and received until last sunday after upgrading to Frappe 12.5.0 and ERPNext 12.7.0.
## Context information (for bug reports)
The following is my setup for AWS S3 backup:
![image](https://user-images.githubusercontent.com/32480024/80121683-88788b00-8584-11ea-9f21-9c9a6ad16a14.png)
Same for Dropbox Backup:
![image](https://user-images.githubusercontent.com/32480024/80121883-b8c02980-8584-11ea-9bfd-5a468e1c4268.png)
But mails are no longer received after successful backup even though email recipient is specified.
Checking error log from the front end i see this error:
![image](https://user-images.githubusercontent.com/32480024/80122099-fe7cf200-8584-11ea-9dc8-f73d95bea5b5.png)
![image](https://user-images.githubusercontent.com/32480024/80122161-0fc5fe80-8585-11ea-9410-18d895a37b18.png)
**Output of `bench version`**
```
ubuntu@VPSHOST:~/frappe-bench$ bench version
erpnext 12.7.0
erpnext_customer_statements_sender 0.0.1
frappe 12.5.0
```
## Steps to reproduce the issue
1. Setup backup on Amazon S3 or Dropbox Backup
2. Specify email address for notification of successful backup
3. Trigger backup by clicking take backup now.
### Observed result
Backup completed as expected but no mail notification received.
### Expected result
Mail is supposed to be received on successful or failed backup.
### Stacktrace / full error message
```
[2020-04-23 16:08:24 +0000] [3664] [ERROR] Error handling request /
Traceback (most recent call last):
File "/home/ubuntu/frappe-bench/apps/frappe/frappe/app.py", line 53, in application
init_request(request)
File "/home/ubuntu/frappe-bench/apps/frappe/frappe/app.py", line 108, in init_request
frappe.init(site=site, sites_path=_sites_path)
File "/home/ubuntu/frappe-bench/apps/frappe/frappe/__init__.py", line 150, in init
local.conf = _dict(get_site_config())
File "/home/ubuntu/frappe-bench/apps/frappe/frappe/__init__.py", line 224, in get_site_config
sys.exit(1)
SystemExit: 1
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/home/ubuntu/frappe-bench/env/lib/python3.6/site-packages/werkzeug/local.py", line 72, in __getattr__
return self.__storage__[self.__ident_func__()][name]
KeyError: 'conf'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/home/ubuntu/frappe-bench/env/lib/python3.6/site-packages/werkzeug/local.py", line 309, in _get_current_object
return getattr(self.__local, self.__name__)
File "/home/ubuntu/frappe-bench/env/lib/python3.6/site-packages/werkzeug/local.py", line 74, in __getattr__
raise AttributeError(name)
AttributeError: conf
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/home/ubuntu/frappe-bench/env/lib/python3.6/site-packages/gunicorn/workers/sync.py", line 135, in handle
self.handle_request(listener, req, client, addr)
File "/home/ubuntu/frappe-bench/env/lib/python3.6/site-packages/gunicorn/workers/sync.py", line 176, in handle_request
respiter = self.wsgi(environ, resp.start_response)
File "/home/ubuntu/frappe-bench/env/lib/python3.6/site-packages/werkzeug/local.py", line 231, in application
return ClosingIterator(app(environ, start_response), self.cleanup)
File "/home/ubuntu/frappe-bench/env/lib/python3.6/site-packages/werkzeug/wrappers/base_request.py", line 237, in application
resp = f(*args[:-2] + (request,))
File "/home/ubuntu/frappe-bench/apps/frappe/frappe/app.py", line 96, in application
frappe.monitor.stop(response)
File "/home/ubuntu/frappe-bench/apps/frappe/frappe/monitor.py", line 26, in stop
if frappe.conf.monitor and hasattr(frappe.local, "monitor"):
File "/home/ubuntu/frappe-bench/env/lib/python3.6/site-packages/werkzeug/local.py", line 348, in __getattr__
return getattr(self._get_current_object(), name)
File "/home/ubuntu/frappe-bench/env/lib/python3.6/site-packages/werkzeug/local.py", line 311, in _get_current_object
raise RuntimeError("no object bound to %s" % self.__name__)
RuntimeError: no object bound to conf
```
## Additional information
OS version / distribution, `Frappe` install method, etc.
Ubuntu 18.04 installed using Easy Install Script. Instance running for 9 months.
.NonUniqueError: Address: Field ‘PAN Tax ID’ cannot be set as Unique as it has non-unique values while update.
Just for your ref. same company with 4/5 different branched and separate addresses however same PAN no. how it will work or done. we get errors in update its bug.
arokia
April 27, 2020, 3:52pm
13
Duplicate of Role while creating user - #3 by arokia this also occur in new update. Kindly look into it.
Is it possible if we could also include this feature on the Items? Because sometimes there are suppliers with mixed items which means the item can be received or items are for billing only. Also, if possible to have a checkbox on the item record if it will be included in the printing of the transactions so that it will be automatically not included on the print but still be included or visible on the transaction?