India

ZestyBeanz Technologies Pvt Ltd Thejaswini, Technopark Thiruvananthapuram,
India – 695581
Phone: +91 471 4063254
Fax : +91 471 2700171

   .

ZestyBeanz Technologies Pvt Ltd, 2987, Manikkath Cross Road, Ravipuram, Kochi, India - 682016, Phone: +91 484 4063254

  UAE

ZestyBeanz Technologies FZE, P.O Box 53261, HFZA, Sharjah, Phone: +971-56-2708993​

  Germany​

ZestyBeanz Technologies UG Fürther Str. 27 90429 Nürnberg Phone: +49-911-28707070

Contact Form


Prajul P T's picture

Advanced Printscreen for OpenERP 7(Analytic Report Printing)

Printscreen has been and is an attractive feature of OpenERP. But unfortunately this feature was available for OpenERP 6.1 GTK Client. OpenERP 7 provide an functionality to print the current view in PDF. You may have already noticed that i have already published a blog named "Printscreen in OpenERP 7 which was a migrated module from web_export_view with few my own functionality added to it. But now we have developed a new module called web_printscreen_zb with some new features that might be helpful to users of OpenERP 7. 

The main features of this module are:

Shyam's picture

Hello, Thanks for this kind

Hello,

Thanks for this kind of nice activity.

I have one little issue regarding this module.

When I print standard report than report is print with proper header which set in company.

But when I print report from this module its gives different header.

SO it is posible to print report with standard header with this module?

Thanks in advance.
Shyam.

Shyam's picture

Hello, I have one question

Hello,

I have one question for this module.

When we print report from standard it gives report header from company rml header.

But when we print report from this module its give another header.

It is posible to set standard header in this module?

Thanks,
Shyam

Shyam's picture

Hello, This module is so so

Hello,

This module is so so useful. Thanks for such kind of activity.

But I have one little issue, If I run module in ubuntu its working fine for me but when I work with Centos that time its not generate excel file only pdf file is generated.

Please do nedful help.

Thanks,
Shyam.

Shyam's picture

Hello, Yes I got solution. I

Hello,

Yes I got solution. I installed xlwt package. Now its working fine.

You can put pre require package in __openerp__.py files description.
So non-python or Non-OpenERP user can use understand easily.

Thanks.
Shyam.

King Wang's picture

Hi Prajul, It is super useful

Hi Prajul,

It is super useful and great module! Nice Job!

Just found a small bug, when I goes to Location->Products by Location, in that Product List, the report won't work. There is no error showing as well.

You may want to check this?

Prajul P T's picture

Hi,     We have already

Hi,

    We have already fixed this bug. Please try with the latest module. The module is attached with the blog. If the problem persist, please get back.

King Wang's picture

Hi the latest module in the

Hi the latest module in the attachment is the same as yesterday, right? It still has the same problem.

Prajul P T's picture

Hi,      I cannot reproduce

Hi,

     I cannot reproduce the error from my side. I tested the report from Warehouse > Configuration > Location. Selected one record. In More dropdown, there is a item called "Product by Location". Which opens up a wizard where i selected "Analyze Current Inventory". This opens up a list of product and its stock levels. The report is printing from here also. Please give me the steps you followed so that i can reproduce the error on my side.

King Wang's picture

It works in another

It works in another server...

I will check myself. Thanks!

Prajul P T's picture

Ok that might be the problem.

Ok that might be the problem. I am using the latest OpenERP 7 server.

Gopakumar N G's picture

Sales Analysis Report

Are you interested in getting the sales details of your firm from anywhere you go . If you want to check out the trend of your business for a month or in the current year, if you need the sales details of particular product or category at the moment in a precise way, OpenERP provides these functionalities with analysis report and graph views.

  Analysis reports are used for creating dynamic reports in OpenERP. The advantages of analysis reports are:

Anonymous's picture

Hi, I Notice one of your

Hi,

I Notice one of your order analysis page shows cost price & total cost column, which is not the default case. I just followed
http://help.openerp.com/question/17156/add-more-fields-to-pos-order-anal...
http://www.zbeanztech.com/blog/sales-analysis-report

unfortunately I keep getting issue, where cost_price is not exist in pos order model - what am i missing? can anyone help?

ProgrammingError: column report_pos_order.cost_price does not exist
LINE 1: ...ort_pos_order"."product_qty") AS product_qty, sum("report_po...

using Openerp7;

Anonymous's picture

Sometimes I loose my patience

Sometimes I loose my patience so fast.
Just updating the db - its working fine.

bobber seat's picture

Hmm is anyone else having

Hmm is anyone else having problems with the images on this blog loading?
I'm trying to find out if its a problem on my end
or if it's the blog. Any responses would be greatly appreciated.

Janeesh A's picture

Check Writing in OpenERP

 

Users can manage their check writing process by installing the account_check_writing module. The module provides users a variety of check writing capabilities:

 

  • Ability to make supplier payments with checks
  • Support printing checks in three formats: Top voucher check, middle voucher check, and bottom voucher check
  • Printing an Individual Check
  • Printing multiple checks in batch

Setup Of Check Writing

Install the account_check_writing module.

Anonymous's picture

Hi, Have a small

Hi,

Have a small clarification.
Even though you selected the currency as INR, cheque is printing the amount in EUR.
What can we do for that?

Anonymous's picture

Thank you so much. It was

Thank you so much. It was very helpful.

Anonymous's picture

printing multiple checks in

printing multiple checks in batch, where ?

Anonymous's picture

can you tell me how to get

can you tell me how to get invoice id from check_wrinting module

phen375's picture

Your style is so unique

Your style is so unique compared to other folks I have read stuff from. Thanks for posting when you have the opportunity, Guess I will just bookmark this page.

phen375 reviews's picture

Hi there it's me, I am also

Hi there it's me, I am also visiting this website on a regular basis, this web page is truly pleasant and the visitors are genuinely sharing fastidious thoughts.

Chandhu Viswanath's picture

Accounting Vouchers in Employee Payslip - OpenERP 6.1

    When it comes to OpenERP 6.1 the pay roll management has witnessed  remarkable changes in  it's way of functioning as compared to it's earlier versions. The absence of  "Pay Salary" button, "Accounting Vouchers" and a lot more. Among them, the absence of "Accounting Vouchers" has created a lot of confusion to the existing users. Here i am trying to explain the changes happened with voucher creation

book keeping adelaide's picture

This is the only time I've

This is the only time I've been to your site. Thank you for sharing more information.

Anonymous's picture

Great thanks a lot!

Great thanks a lot!

Anonymous's picture

What if we want to import

What if we want to import partners with their total receivable and total payable and what if want to import quantity available when importing products. I tried a lot and could not do the same yet. Also I used both import compatible export and export all data export types. If anyone has done RnD on this please reply.

Anonymous's picture

I get the following error

I get the following error whenever I try to import partners and products
ValueError: No such external ID currently defined in the system: __import__.res_partner
ValueError: No such external ID currently defined in the system: 20__export__.product_product_456.
I successfully imported my taxes.

Anonymous's picture

I customize a asset

I customize a asset management functions. However, when I perform import from csv file into the system, the system does not display the data import.
steps are as follows:
Choose imoprt, select file to import, and then select File format option, then click validate. The notification system "Everything Seems valid.". After that I click the Import button. And then the system turn to asset management.
However, the system does not display the data import.
Help me!

pierrecogitae's picture

Another important missing

Another important missing point: how do you read the import wizard from the web interface?

Anonymous's picture

This is great tutorial but

This is great tutorial but it's missing one thing: how to add predefined export as a scheduler job. I know where scheduler is, but I have no idea what should i put into 'Action to trigger' object/function. Any help is welcome :)

Douglas's picture

I am now not positive where

I am now not positive where you are getting your information, however great topic. I must spend a while learning much more or understanding more. Thanks for wonderful information I used to be searching for this information for my mission.

Girish Joshi's picture

Hi, Can anyhelp help in

Hi, Can anyhelp help in Importing Products from CSV in Version 6.1 ? I am not able to import New Product from the List of CSV in 6.1 Version. Also, many2one relationship is set to weird when Updating records via csv in 6.1

Vishnu Devaraj's picture

OpenERP Mass Mail Module ( zb_mass_mail )

      'Mass Mail' is an OpenERP module developed by Zesty Beanz, which addresses the email marketing concerns in a business. The module allows users to flexibly handle  mass emailing. The major features of the module are as follows

 

B'ert's picture

Does this work togeter with

Does this work togeter with openERP 7?

Thank you!

Nellie's picture

Wonderful goods from you,

Wonderful goods from you, man. I've understand your stuff previous to and you're just too magnificent. I really like what you have acquired here, certainly like what you are stating and the way in which you say it. You make it entertaining and you still take care of to keep it smart. I cant wait to read much more from you. This is actually a tremendous site.

netvienna's picture

Hello, I tried to install,

Hello, I tried to install, but it says mail_gateway is necessary, but I cannot find this for 6.1 ?
Any hint
Br
Oliver

Mira's picture

Hi Vishnu, I just

Hi Vishnu,

I just installed your module and it's great but I don't seem to manage to use the "Import Email addresses" function from Members tab. No matter what I use I get an error and the most frustrating part is that it doesn't show me the error it just appears a message letting me know that there's an error. Please let me know if this is a bug or I'm doing something wrong.

Stay At Home's picture

Thаnks foг your peгѕonal

Thаnks foг your peгѕonal marvelous posting! Ι definitely enjoyеd reading it, you саn be a great author.I ωill be ѕure to bookmaгk your blog and will often come back at some point. I ωant to encourage cοntinue your great job, have a niсe mоrning!

Anonymous's picture

Sorry for the stupid question

Sorry for the stupid question but I am novice for Python and OpenERP.
How can xlrd and xlutils be installed on Windows. OpenERP is installed with all-in-one installer. There is no python installation on the server. I see only python25.dll in /OpenERP6.01/Server directory.

latest gadgets reviews's picture

when the next update will

when the next update will come out? Don't forget, software has to be up-to-date all the time, or ppl wont use it anymore.

Anonymous's picture

I'm newby for mass mailing in

I'm newby for mass mailing in OpenERP.

Untill now, I'm using "Phplist". I have a html template on it. How to use the some template in OpenERP email template?

Also, May you show me, step by step, how to send an mass mail to members? I'm confused, because of compaign functionnalities?

Vishnu Devaraj's picture

Once the mass mail module is

Once the mass mail module is installed, you will get the menu  "“Mass Mailing > Mass Mail Templates” . Create a new record. Here you can paste the html code and later choose the record as your template.

Anonymous's picture

Nice to very useful info for

Nice to very useful info for me.Because i'm new in blogging and i'm need good tutorial like your post.

fahad's picture

OpenERP development environment in Windows using Eclipse.

 In this blog we will go through some steps required in setting up OpenERP for customization under eclipse in windows.
Before going into the details, let me remind every one that Linux distros preferably ubuntu is the best platform to do developments in OpenERP. This may be useful to only those insit development to be done in Windows.

Versions Used:

Khin's picture

I installed OpenERP7

I installed OpenERP7 (Allinone),Python25, Eclipse(Indigo) in Window XP. Now I want to customize some feature in existing module (hr_payroll).I can't debug OpenERP in Eclipse. I didn't find this file (openerp-server.py) in my location(C:\Program Files\OpenERP 7.0-20130613-231107\Server\server\..). In Eclipse, I didn't see server folder in browse (Eclipse -> Run -> Debug Configurations -> Python Run -> Double click -> Browse). Can you help me this problem? Thank you very much.

Anonymous's picture

I want to design forms in my

I want to design forms in my project . How can I be able to do this ?

Please help

Titus's picture

I have followed the steps to

I have followed the steps to have openERP on my machine. When I run opeerp-server.py I get this output:

[2013-04-17 15:09:27,352][?] INFO:server:OpenERP version - 6.0.4
[2013-04-17 15:09:27,352][?] INFO:server:addons_path - C:\OpenERP\Server\bin\addons
[2013-04-17 15:09:27,352][?] INFO:server:database hostname - localhost
[2013-04-17 15:09:27,352][?] INFO:server:database port - 5432
[2013-04-17 15:09:27,352][?] INFO:server:database user - Titus
[2013-04-17 15:09:27,352][?] INFO:server:initialising distributed objects services
[2013-04-17 15:09:27,634][?] INFO:web-services:starting HTTP service at 0.0.0.0 port 8069
[2013-04-17 15:09:27,635][?] INFO:web-services:starting HTTPS service at 0.0.0.0 port 8071
[2013-04-17 15:09:27,635][?] INFO:web-services:Registered XML-RPC over HTTP
[2013-04-17 15:09:27,638][?] INFO:web-services:starting NET-RPC service at 0.0.0.0 port 8070
[2013-04-17 15:09:27,638][?] INFO:server:Starting 3 services
[2013-04-17 15:09:27,640][?] INFO:server:OpenERP server is running, waiting for connections...

When I run the openerpclient I get errors as follows

Traceback (most recent call last):
File "C:\OpenERP\Client\bin\openerp-client.py", line 62, in
import gtk
File "C:\Python25\Lib\site-packages\gtk-2.0\gtk\__init__.py", line 38, in
import gobject as _gobject
File "C:\Python25\Lib\site-packages\gtk-2.0\gobject\__init__.py", line 30, in
from gobject.constants import *
File "C:\Python25\Lib\site-packages\gtk-2.0\gobject\constants.py", line 22, in
from _gobject import type_from_name
ImportError: DLL load failed: The specified module could not be found.

Kindly help

pfe2013's picture

hi, I want to install

hi, I want to install Openerp-server (6.0.3) on windows with source. i have already download all python packages; but when I execute

Code: python setup.py install

I have this error:

File "C:\serveur\openerp-server-6.0.3\setup.py", line 269, in
z = zipfile.ZipFile(zipfile_path, 'a')
File "C:\Python25\lib\zipfile.py", line 339, in __init__
self.fp = open(file, modeDict[mode])
IOError: [Errno 2] No such file or directory: 'dist\\library.zip'

PFE's picture

Hi After setting up the

Hi
After setting up the development environment on Windows,
when I come to execute openerp-server.py:
error:

[2013-03-04 11:10:10,776][?] INFO:server:OpenERP version - 6.0.3
[2013-03-04 11:10:10,776][?] INFO:server:addons_path - C:\openerp-server-6.0.3\bin\addons
[2013-03-04 11:10:10,776][?] INFO:server:database hostname - localhost
[2013-03-04 11:10:10,776][?] INFO:server:database port - 5432
[2013-03-04 11:10:10,776][?] INFO:server:database user - Hamdi
[2013-03-04 11:10:10,776][?] INFO:server:initialising distributed objects services
Traceback (most recent call last):
File "C:\openerp-server-6.0.3\bin\openerp-server.py", line 94, in
import report
File "C:\openerp-server-6.0.3\bin\report\__init__.py", line 22, in
import interface
File "C:\openerp-server-6.0.3\bin\report\interface.py", line 32, in
import render
File "C:\openerp-server-6.0.3\bin\report\render\__init__.py", line 22, in
from simple import simple
File "C:\openerp-server-6.0.3\bin\report\render\simple.py", line 27, in
from reportlab.platypus import SimpleDocTemplate, Paragraph, Spacer, Table
ImportError: No module named reportlab.platypus

thanks

pfe2013's picture

hi, I want to install

hi, I want to install Openerp-server (6.0.3) on windows with source. i have already download all python packages; but when I execute
Code: python setup.py install

I have this error: Code:

Traceback (most recent call last):
File "C:\serveur\openerp-server-6.0.3\setup.py", line 269, in
z = zipfile.ZipFile(zipfile_path, 'a')
File "C:\Python25\lib\zipfile.py", line 339, in __init__
self.fp = open(file, modeDict[mode])
IOError: [Errno 2] No such file or directory: 'dist\\library.zip'

thanks

Rami's picture

Hi Fahad, Thanks for the

Hi Fahad,

Thanks for the great article .. I need your help to get the server and the client running without eclipse on windows.
What would be the command to do that.

Thanks,
Rami

fahad's picture

Hi Rami, 1)Use commanfd line

Hi Rami,

1)Use commanfd line and cd to directory of the server.
2)Openerp Server could be started using python openerp-server.py

 

Anonymous's picture

I follow the steps, when i

I follow the steps, when i lunch a debug i have a problems :
I dont understand why i have this problem :'( :
Traceback (most recent call last):
File "C:\Users\slim.slim-PC\Desktop\eclipse\plugins\org.python.pydev_2.6.0.2012062818\pysrc\pydevd.py", line 1392, in
debugger.run(setup['file'], None, None)
File "C:\Users\slim.slim-PC\Desktop\eclipse\plugins\org.python.pydev_2.6.0.2012062818\pysrc\pydevd.py", line 1085, in run
pydev_imports.execfile(file, globals, locals) #execute the script
File "C:\OpenErp\openerp-server-6.0.3\bin\openerp-server.py", line 112, in
service.http_server.init_servers()
File "C:\OpenErp\openerp-server-6.0.3\bin\service\http_server.py", line 233, in init_servers
int(tools.config.get('xmlrpc_port', 8069)))
ValueError: invalid literal for int() with base 10: '8069 (change port here if already allinone setup has been installed,say 8059)'

help me please :'(

fahad's picture

Please remove the round

Please remove the round brackets and their contents, which was meant only for understanding.