Stock entry Not showing

1

Hello,

      I have create a new stock entry for two items,fill the details and save.
But when i am trying to search that stock entry,this stock entry is not showing,insted it is giving following error on the console.

Traceback (innermost last):

File “…/lib/webnotes/handler.py”, line 132, in handle

execute_cmd(cmd)

File “…/lib/webnotes/handler.py”, line 172, in execute_cmd

ret = call(method, webnotes.form_dict)

File “…/lib/webnotes/handler.py”, line 189, in call

return fn(**newargs)

File “…/lib/webnotes/widgets/reportview.py”, line 35, in get

return compress(execute(**get_form_params()))

File “…/lib/webnotes/widgets/reportview.py”, line 67, in execute

return webnotes.conn.sql(query, as_dict=not as_list, debug=debug)

File “…/lib/webnotes/db.py”, line 130, in sql

raise e

OperationalError: (1054, “Unknown column ‘tabStock Entry.transfer_date’ in ‘field list’”)

Please give me solution.
Thanks


–

Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note

    —

    You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

    For more options, visit https://groups.google.com/groups/opt_out.

     

     
2
Check if transfer_date is mentioned in search fields via Setup / Customize Form / Stock entry

Sent from my phone

On 27-Jul-2013, at 6:49 PM, Sharad Vishe <sh...@indictranstech.com> wrote:

Hello,
      I have create a new stock entry for two items,fill the details and save.
But when i am trying to search that stock entry,this stock entry is not showing,insted it is giving following error on the console.

Traceback (innermost last):
  File "../lib/webnotes/handler.py", line 132, in handle
    execute_cmd(cmd)
  File "../lib/webnotes/handler.py", line 172, in execute_cmd
    ret = call(method, webnotes.form_dict)
  File "../lib/webnotes/handler.py", line 189, in call
    return fn(**newargs)
  File "../lib/webnotes/widgets/reportview.py", line 35, in get
    return compress(execute(**get_form_params()))
  File "../lib/webnotes/widgets/reportview.py", line 67, in execute
    return webnotes.conn.sql(query, as_dict=not as_list, debug=debug)
  File "../lib/webnotes/db.py", line 130, in sql
    raise e
 OperationalError: (1054, "Unknown column 'tabStock Entry.transfer_date' in 'field list'")

Please give me solution.
Thanks


–

Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note

    —

    You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    For more options, visit https://groups.google.com/groups/opt_out.

     

     

–

Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note

    —

    You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

    For more options, visit https://groups.google.com/groups/opt_out.

     

     
3

transfer_date is present in search field of stock field.

On Saturday, July 27, 2013 6:49:10 PM UTC+5:30, Sharad Vishe wrote:

Hello,
      I have create a new stock entry for two items,fill the details and save.
But when i am trying to search that stock entry,this stock entry is not showing,insted it is giving following error on the console.

Traceback (innermost last):

File “…/lib/webnotes/handler.py”, line 132, in handle

execute_cmd(cmd)

File “…/lib/webnotes/handler.py”, line 172, in execute_cmd

ret = call(method, webnotes.form_dict)

File “…/lib/webnotes/handler.py”, line 189, in call

return fn(**newargs)

File “…/lib/webnotes/widgets/reportview.py”, line 35, in get

return compress(execute(**get_form_params()))

File “…/lib/webnotes/widgets/reportview.py”, line 67, in execute

return webnotes.conn.sql(query, as_dict=not as_list, debug=debug)

File “…/lib/webnotes/db.py”, line 130, in sql

raise e

OperationalError: (1054, “Unknown column ‘tabStock Entry.transfer_date’ in ‘field list’”)

Please give me solution.
Thanks


–

Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note

    —

    You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

    For more options, visit https://groups.google.com/groups/opt_out.

     

     
4
Remove it, click on update, refresh and try again. 

Sent from my phone

On 27-Jul-2013, at 7:09 PM, Sharad Vishe <sh...@indictranstech.com> wrote:

transfer_date is present in search field of stock field.

On Saturday, July 27, 2013 6:49:10 PM UTC+5:30, Sharad Vishe wrote:
Hello,
      I have create a new stock entry for two items,fill the details and save.
But when i am trying to search that stock entry,this stock entry is not showing,insted it is giving following error on the console.

Traceback (innermost last):
  File "../lib/webnotes/handler.py", line 132, in handle
    execute_cmd(cmd)
  File "../lib/webnotes/handler.py", line 172, in execute_cmd
    ret = call(method, webnotes.form_dict)
  File "../lib/webnotes/handler.py", line 189, in call
    return fn(**newargs)
  File "../lib/webnotes/widgets/reportview.py", line 35, in get
    return compress(execute(**get_form_params()))
  File "../lib/webnotes/widgets/reportview.py", line 67, in execute
    return webnotes.conn.sql(query, as_dict=not as_list, debug=debug)
  File "../lib/webnotes/db.py", line 130, in sql
    raise e
 OperationalError: (1054, "Unknown column 'tabStock Entry.transfer_date' in 'field list'")

Please give me solution.
Thanks


–

Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note

    —

    You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    For more options, visit https://groups.google.com/groups/opt_out.

     

     

–

Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note

    —

    You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

    For more options, visit https://groups.google.com/groups/opt_out.

     

     
5
I removed it and working fine .Thank U


On Sat, Jul 27, 2013 at 7:30 PM, Anand Doshi <an...@iwebnotes.com> wrote:
Remove it, click on update, refresh and try again.

Sent from my phone

On 27-Jul-2013, at 7:09 PM, Sharad Vishe <sh...@indictranstech.com> wrote:

transfer_date is present in search field of stock field.

On Saturday, July 27, 2013 6:49:10 PM UTC+5:30, Sharad Vishe wrote:
Hello,
I have create a new stock entry for two items,fill the details and save.
But when i am trying to search that stock entry,this stock entry is not showing,insted it is giving following error on the console.

Traceback (innermost last):
  File "../lib/webnotes/handler.py", line 132, in handle
    execute_cmd(cmd)
  File "../lib/webnotes/handler.py", line 172, in execute_cmd
    ret = call(method, webnotes.form_dict)
  File "../lib/webnotes/handler.py", line 189, in call
    return fn(**newargs)
  File "../lib/webnotes/widgets/reportview.py", line 35, in get
    return compress(execute(**get_form_params()))
  File "../lib/webnotes/widgets/reportview.py", line 67, in execute
    return webnotes.conn.sql(query, as_dict=not as_list, debug=debug)
  File "../lib/webnotes/db.py", line 130, in sql
    raise e
 OperationalError: (1054, "Unknown column 'tabStock Entry.transfer_date' in 'field list'")

Please give me solution.
Thanks


–

Note:



If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.



    End of Note

    —

You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.



For more options, visit https://groups.google.com/groups/opt_out.




–

Note:



If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.



    End of Note

    —

    You received this message because you are subscribed to a topic in the Google Groups "ERPNext Developer Forum" group.

    To unsubscribe from this topic, visit https://groups.google.com/d/topic/erpnext-developer-forum/S3JkBfmAwhk/unsubscribe.

To unsubscribe from this group and all its topics, send an email to erpnext-developer-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.







-- 
Thanks and Regards,

Sharad N vishe
Contact No.+91-8983496545

–

Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note

    —

    You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

    For more options, visit https://groups.google.com/groups/opt_out.