Try ERPNext Buy Support Partners Foundation

Stock Balance report is not working after upgrade to V12

I have upgraded to V 12 from V11.

Now I can not see any thing in Stock balance report.

It seems the report is preparing but not showing.

I have upgraded several files and got me same thing.

1 Like

Hello !

Can you see any errors in the browser console ? If yes, copy and paste them in your post description.

Also, I have to ask if this instance was a production or a testing ?

Download the Vue Devtools extension for a better development experience:
https://github.com/vuejs/vue-devtools
libs.min.js?ver=1573560941.0:9254 You are running Vue in development mode.
Make sure to turn on production mode when deploying for production.
See more tips at https://vuejs.org/guide/deployment.html
VM1946 logger.js:11 quill Overwriting formats/link with class MyLink extends Link{static create(e){var t=super.create(e);return e=this.sanitize(e),t.setAttribute("href",e),(e.startsWith("/")||e.indexOf(window.location.host))&&t.removeAttribute("target"),t}}
debug @ VM1946 logger.js:11
register @ VM1910 quill.js:90
register @ VM1910 quill.js:82
(anonymous) @ text_editor.js:39
(anonymous) @ meta_tag.js:17
VM1946 logger.js:11 quill Overwriting modules/mention with class Mention{constructor(e,t){this.isOpen=!1,this.itemIndex=0,this.mentionCharPos=null,this.cursorPos=null,this.values=[],this.suspendMouseEnter=!1,this.quill=e,this.options={source:null,renderItem:functi…
debug @ VM1946 logger.js:11
register @ VM1910 quill.js:90
(anonymous) @ comment.js:4
(anonymous) @ meta_tag.js:17
logger.js:11 quill Overwriting formats/link with class MyLink extends Link{static create(e){var t=super.create(e);return e=this.sanitize(e),t.setAttribute("href",e),(e.startsWith("/")||e.indexOf(window.location.host))&&t.removeAttribute("target"),t}}
debug @ logger.js:11
register @ quill.js:90
register @ quill.js:82
(anonymous) @ text_editor.js:39
(anonymous) @ control.js:48
logger.js:11 quill Overwriting modules/mention with class Mention{constructor(e,t){this.isOpen=!1,this.itemIndex=0,this.mentionCharPos=null,this.cursorPos=null,this.values=[],this.suspendMouseEnter=!1,this.quill=e,this.options={source:null,renderItem:functi…
debug @ logger.js:11
register @ quill.js:90
(anonymous) @ comment.js:4
(anonymous) @ control.js:48
assets.js:54 localStorage cleared

I have notice that the report is not showing if I have multiple company files in the same server.
( Not multi tenant)

But it is working perfectly If I have one company in the server.

This instance is a production.

1 Like

Please provide more details along with errors.

Ok this isn’t an error log. It is some log of vue-js.

Do any error messages come when the report is rendering or after some time ?

Queries taking a lot of time in standard reports seem unlikely but can be considered. Do you have a self hosted ? If yes can you check if the query is running for a long time.

Also do you have some backup server with a working erpnext version ? If there is any chance you can go back to it, please do it and don’t upgrade to version 12 until it is stable.

It is working perfectly when I have one company in V12

But it is not showing If I have multiple company in the same file like group company and subsidiaries

I did not receive any error.
it is not showing anything if I run it.

Could you please check browser console ?

Have you set any permissions to restrict users to certain companies ?

I am also facing same issue

XHRPOSThttp://167.86.74.121/api/method/frappe.deferred_insert.deferred_insert[HTTP/1.1 200 OK 240ms]

XHRGEThttp://167.86.74.121/api/method/frappe.desk.form.load.getdoc?doctype=Report&name=Stock+Balance&_=1574667823849[HTTP/1.1 200 OK 349ms]

GEThttp://167.86.74.121/assets/erpnext/images/favicon.png[HTTP/1.1 200 OK 0ms]

XHRGEThttp://167.86.74.121/api/method/frappe.desk.form.load.getdoctype?doctype=Stock+Ledger+Entry&with_parent=1&cached_timestamp=&_=1574667823850[HTTP/1.1 200 OK 428ms]

XHRPOSThttp://167.86.74.121/api/method/frappe.desk.query_report.get_script[HTTP/1.1 200 OK 362ms]

XHRGEThttp://167.86.74.121/api/method/frappe.desk.query_report.run?report_name=Stock+Balance&filters=%7B%22from_date%22%3A%222019-10-25%22%2C%22to_date%22%3A%222019-11-25%22%7D&_=1574667823851[HTTP/1.1 200 OK 308ms]

XHRPOSThttp://167.86.74.121/api/method/frappe.model.utils.user_settings.get[HTTP/1.1 200 OK 675ms]

XHRGEThttp://167.86.74.121/api/method/frappe.desk.query_report.run?report_name=Stock+Balance&filters=%7B%22from_date%22%3A%222019-10-25%22%2C%22to_date%22%3A%222019-11-25%22%7D&_=1574667823852[HTTP/1.1 200 OK 280ms]

XHRGEThttp://167.86.74.121/api/method/frappe.desk.query_report.background_enqueue_run?report_name=Stock+Balance&filters=%7B%22from_date%22%3A%222019-10-25%22%2C%22to_date%22%3A%222019-11-25%22%7D&_=1574667823853[HTTP/1.1 200 OK 644ms]

XHRPOSThttp://167.86.74.121/api/method/frappe.deferred_insert.deferred_insert[HTTP/1.1 200 OK 301ms]

XHRGEThttp://167.86.74.121/api/method/frappe.desk.query_report.run?report_name=Stock+Balance&filters=%7B%22from_date%22%3A%222019-10-25%22%2C%22to_date%22%3A%222019-11-25%22%7D&_=1574667823854[HTTP/1.1 200 OK 2005ms]

Error in parsing value for ‘grid-template-rows’. Declaration dropped. App.css:73:23

Error in parsing value for ‘grid-template-rows’. Declaration dropped.

1 Like

Yes, But I ran this report as an administrator.

Alright so there is no question of permissions.

I think this is a bug and you should report it on GitHub

Still I am facing same issue ?

I had the same issue and was resolved through following:

Go to the report settings and disable the prepared report:

2 Likes

that was awesome…

working perfect now.

But this solution is creating cache problem.

for example if i choose filters ‘From date’ and ‘To date’,and when change the dates in filters it is showing cache data.

Any Solution?

Regards,
Vishakha Mishra

may be that is a problem. any solution

I have same problem. can you find solution