OpenERP

Creating Graph and Calendar View in OpenERP 7.0

Posted on

Graph and Calendar view is a very useful view in OpenERP. Calendar view allows us to see an “agenda” like of documents. Graph view will show a snapshot of statistics performed by the document. Example below is the Calendar view of Session model:   And this is the Graph view showing the total number of […]

OpenERP

Searching for multi-level relation on OpenERP 7.0

Posted on

On the relation: Attendee –>(many2one) -> Session –> (many2one) -> Course How to find attendees which belongs to a Course? Ie, performing search and grouping on attendee list which attend a Course. The solution is to add a new column on attendee.py, with type of related and define the relation to Course model:   ‘course_id’: […]

OpenERP

Setting up Filters and Grouping in OpenERP 7.0

Posted on

 Grouping and Filtering on OpenERP 7.0 now move to a simpler Search Panel. Example below is to filter and group Session object: To make a filter panel, create a new record in the XML file with arch element of <search> <record id=”view_session_filter” model=”ir.ui.view”> <field name=”name”>session.filter</field> <field name=”model”>my_openacademy.session</field> <field name=”arch” type=”xml”> <search string=”Search Session”> <filter icon=”terp-mail-message-new” […]

OpenERP

Setting Up Gantt Chart in OpenERP 7.0

Posted on

Gantt view in OpenERP is a great thing to view scheduled documents so we can monitor the activity and progress date by date. Example below is a gantt chart for Session model. To make Gantt view of the model, add the following record on the XML file:   <record model=”ir.ui.view” id=”view_session_gantt”> <field name=”name”>session.gantt</field> <field name=”model”>my_openacademy.session</field> […]

OpenERP

OpenERP Import BCA Bank Statement

Posted on

Dengan setting yang betul, OpenERP dapat dibuat meng-import langsung statement bank BCA (dari download bank statement internet banking BCA). Pada prinsipnya statement bank BCA didownload dan disimpan dalam bentuk file CSV. Kemudian di OpenERP statement tersebut diimport menggunakan module ea_import. Module ea_import disetting agar memiliki template untuk master bank statement dan bank statement line. File […]