Error when trying to change quantity

[tivada...@gmail.com]

Hello,

Whenever I try to change the quantity field for example to 33 in this case (see screenshot) the system constantly puts extra 3 pieces of zeros to the end with the following server error: 

Could you please tell me what is that and how can I fix it?

Thank you,

Tivadar

[Log] Traceback (innermost last): (frappe.min.js, line 339)

  File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/frappe/frappe/app.py", line 46, in application

    response = frappe.handler.handle()

  File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/frappe/frappe/handler.py", line 66, in handle

    execute_cmd(cmd)

  File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/frappe/frappe/handler.py", line 84, in execute_cmd

    ret = frappe.call(method, **frappe.form_dict)

  File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 521, in call

    return fn(*args, **newargs)

  File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/erpnext/erpnext/accounts/doctype/pricing_rule/pricing_rule.py", line 112, in apply_pricing_rule

    out.append(get_pricing_rule_for_item(args_copy))

  File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/erpnext/erpnext/accounts/doctype/pricing_rule/pricing_rule.py", line 137, in get_pricing_rule_for_item

    pricing_rules = get_pricing_rules(args)

  File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/erpnext/erpnext/accounts/doctype/pricing_rule/pricing_rule.py", line 193, in get_pricing_rules

    transaction_type=args.transaction_type, conditions=conditions), args, as_dict=1)

  File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/frappe/frappe/database.py", line 107, in sql

    self._cursor.execute(query, values)

  File "/home/ortiv/public_html/erp/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/cursors.py", line 185, in execute

    for key, item in args.iteritems())

  File "/home/ortiv/public_html/erp/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/cursors.py", line 185, in <genexpr>

    for key, item in args.iteritems())

  File "/home/ortiv/public_html/erp/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/connections.py", line 278, in literal

    return self.escape(o, self.encoders)

  File "/home/ortiv/public_html/erp/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/converters.py", line 133, in quote_tuple

    return "(%s)" % (','.join(escape_sequence(t, d)))

 TypeError: sequence item 0: expected string, dict found

[Anand Doshi]

When was the last time you ran update?

--
You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-fo...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/4856b1e2-b648-4758-b57e-12b60b3a6e3f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Tivadar Orosz]

Hello Anand,

Thanks for trying to help. Actually I never ran update yet. I installed ERPNext around 2 or 3 weeks ago. How can I update ERPNext? Could you help me, please?

--
You received this message because you are subscribed to a topic in the Google Groups "ERPNext User's Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/erpnext-user-forum/D4E4-lQVvkE/unsubscribe.
To unsubscribe from this group and all its topics, send an email to erpnext-user-fo...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAAQzbF12FtehAnu7qR2MLtkC8khPDaS4zCdMWJSUWMh5r8p8sA%40mail.gmail.com.

[Rushabh Mehta]

Follow instructions here to update:

https://erpnext.com/download

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAJXg0TrGqVjN7yaSy5-p%2Bw7JjP5%2B%2BYpBP%3DGYiWN9twz7sZ-EjA%40mail.gmail.com.

[Tivadar Orosz]

Hello Rushabh,

I did update ERPNext but the error is still there. Do you have any idea why is that?

Thanks,

Tivadar

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/4FD7F3B6-56B8-4AEC-B7FF-983A23501D8A%40gmail.com.

[Rushabh Mehta]

Could be a big, can you raise an issue in GitHub

https://github.com/frappe/erpnext/issues

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAJXg0TpwEdTFQg-MrPitRgAi0JnYF17CLJHgxeQ_Zu%3Dvz%2BeOzQ%40mail.gmail.com.

[Tivadar Orosz]

Hello Rushabh,

I opened a ticket in GitHub per your request. It's #1877

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/94644899-E848-457E-9F95-292C18FD995B%40gmail.com.

[wa...@xavierltd.com]

‎Hi guys, 

We have a setup for a client who is into retail and has multiple outlets. Our approach ‎was to define a warehouse for each store and restrict sales people in each of the stores to Sales Invoices linked with their respective warehouses. 

The issue now is that store managers would like to have Stock Balance and Stock Ledger reports for their individual stores. 

Question 1: how do we go about allowing a user to only view Stock Reports for a particular warehouse? 

Question 2: is it also possible to give restricted access to financial/transactional reports using the same criteria above? 

Kind regards,
‎

[Anand Doshi]

Hi Wale,

In version 4, it should be possible to restrict the standard Stock Ledger report based on User Permissions on Warehouse.

Regarding Financial / Transactional reports, which specific reports do you intend to restrict?

-Anand.

--
You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-fo...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/20140702082410.5386372.78283.8220%40xavierltd.com.

[Olawale Olowu]

Hi Anand,

Thanks for your response. For financial reports, I'm referring to all the main reports under Accounts:

General Ledger

Trial Balance

Financial Statements

Accounts Receivable

Accounts Payable

Sales Register

Purchase Register

I'm aware that 'Warehouse' may probably not be applicable in this case but can we restrict access to these reports by Cost Center perhaps?

 

Kind regards,

---

From: Anand Doshi <an...@erpnext.com>
To: ERPNext User's Forum <erpnext-u...@googlegroups.com>
Sent: Wednesday, July 2, 2014 1:59 PM
Subject: Re: [erpnext-user-forum] Restricted report access

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAAQzbF3mhQJ7y6XwhogSZrWRuWar9wGsopkG8zW_sjk%2BHekumg%40mail.gmail.com.

[Anand Doshi]

Yes. These too will get restricted based on User Permissions. 

Financial statement won't most likely since it is a summary report. 

Sent from my phone

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/1404307545.36508.YahooMailNeo%40web122202.mail.ne1.yahoo.com.

[wa...@xavierltd.com]

Great, thanks! 

Kind regards,
Olawale Olowu
wa...@xavierltd.com
Tel: 08075390014

From: Anand Doshi Sent: Wednesday, July 2, 2014 3:35 PM To: erpnext-u...@googlegroups.com Reply To: erpnext-u...@googlegroups.com

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/37FE597C-31D1-44AD-BE90-37D0FB40BC9D%40iwebnotes.com.

[Olawale Olowu]

Hi Team,

Is there any way to restrict access to the Activity Module either by role or by user? This has been an issue for us and

for some of our clients.

For example, an employee is able to see every expense claim raised by others including status and comments! Even

though they can't see the actual content of the expense claims, there's still too much information exposed.

Any solution please?

 

Kind regards,

Wale

[Rushabh Mehta]

Hi Team,

Should be "Hi Community" :) We hope to make this a two way conversation.

You can hide permission on pages (by Opening the Page) or hide the module.

 

Kind regards,

Wale

--
You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-fo...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/1404368105.788.YahooMailNeo%40web122202.mail.ne1.yahoo.com.

[wa...@xavierltd.com]

‎Hi Rushabh, 

Thanks for the quick response. I however require further clarification on 'hide‎ permission on pages'. When I open the Activity page, I don't see any options for permissions? 

Hiding the module on the other hand would mean that no user gets t‎o see the activity stream at all.

Kind regards,
Wale‎

From: Rushabh Mehta Sent: Thursday, July 3, 2014 7:27 AM

To: erpnext-u...@googlegroups.com Reply To: erpnext-u...@googlegroups.com

Subject: Re: [erpnext-user-forum] Restrict Access to Activity Module

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/C385C8B1-C547-4E12-B518-8807BF8B601E%40gmail.com.

[Rushabh Mehta]

Thanks for the quick response. I however require further clarification on 'hide‎ permission on pages'. When I open the Activity page, I don't see any options for permissions? 

Open The Page via #List/Page

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/20140703072002.5390469.68482.8275%40xavierltd.com.

[Anand Doshi]

Hi Wale,

Activity feed is filtered based on permissions in ver 4. 

It should address your concern. 

I think you should test out version 4. There are many improvements related to permissions. 

-Anand. 

Sent from my phone

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/C1D4A33A-A7B6-4393-9C35-34CC9EF7B6A4%40gmail.com.