Appropriate journal entry setup for Cost of Revenue

Hi! Can anyone help me how to setup the journal entries for Cost of Revenue in odoo 9.0 in order to reflect the amount when generating accounting reports particularly in statement of profit or loss? Because we are experiencing an inaccurate financial reports in odoo. Thank you. I am hoping for your best feedback.

0

31 October 2016, by

Mark Jason de Paz

| 0 Answers | 4,387 Views

Shall we create ledger account for customers in odoo

Hello im new to odoo - 9. shall we make ledger accounts for each customer and vendor or assign existing receivable and payable accounts to it ?

0

7 March 2017, by

Bineesh

| 1 Answer | 3,959 Views

Add a message in "oe_chatter" (Messaging and Communication History Box)

Add Module HRM

Hi everyone!

I noticed that at the end of the view for Leave Request (example) there is a "Messages and communication history" box.

Below the code:

I want to create a new custom module that whenever the button "Save" is clicked (the leave request is saved), it will add a message in 'oe_chatter' (chatterbox) saying that "New leave request has been created" (attached is the example message)

Kindly let me know if you have an idea. Thanks in advance! :)

0

16 August 2022, by

Samantha

| 0 Answers | 5,444 Views

Where to download Hotel Management module for odoo 10 and how to use it ?

I have downloaded Hotel management module from https://apps.openerp.com/apps/modules/10.0/hotel/ ,now where should I unzip it or Copy these files so as to start using Hotel management module .

0

10 January 2017, by

Shreya

| 1 Answer | 5,554 Views

Odoo Development-Awesome Timesheet - I want to put activity status adjacent to the task

in the odoo awesome timesheet app, i want to put the status of the tasks so that at the end of the i can see the completed tasks, progress tasks.

https://www.odoo.com/page/timesheet-mobile-app

please guide me if this is possible

0

16 August 2022, by

Venkat

| 0 Answers | 4,413 Views

How to Set Default Debit Account and Default Credit Account for Opening Entries Journal in odoo 8

How to Set Default Debit Account and Default Credit Account for Opening Entries Journal in odoo 8
And I want to know
"Opening Expense Account" Internal Type="Regular" and Account Type="Expense" and set Default Debit Account
Account Code ? and Parent Account ?

"Opening Income Account" Internal Type="Regular" and Account Type="Income" and set Default Credit Account

Account Code ? and Parent Account ?

Please Answer me

0

30 May 2016, by

Md Abul Hossain Hashem

| 0 Answers | 4,052 Views

How to get paypal transaction in Odoo and how to reconcile it?

Paypal Kế toán Odoo Integration Email Integration Odoo 10 reconcilation

We are currently using Odoo 10 Enterprise edition . We need to reconcile paypal transactions with the sale order invoice and for that we need to get the paypal transaction from Paypal account (Not talking about paypal configuration which can be used in odoo e-commerce).We referred this link https://www.odoo.com/documentation/user/9.0/accounting/bank/feeds/paypal.html and it didn't helped us. We need to get the same thing happening in link . But not sure how to achieve it .

0

6 July 2017, by

Sunil Kumar TC

| 0 Answers | 4,459 Views

Extending a osv_memory and use that column in xml

..py file

class mrp_product_produce(osv.osv_memory):
    _inherit = "mrp.product.produce"

    _columns = {
        'test': fields.char('test')
    }

…xml file

 <record id="view_mrp_product_produce_wizard_sss" model="ir.ui.view">
            <field name="name">MRP Product Produce</field>
            <field name="model">mrp.product.produce</field>
            <field name="inherit_id" ref="mrp.view_mrp_product_produce_wizard"/>
            <field name="arch" type="xml">
                <data>
                	<xpath expr="(//field[@name='product_id'])[2]" position="after">
                		<field name="test"/>
                    </xpath>
                </data>
            </field>
        </record>

gives next error ;-(

2016-01-21 11:06:12,725 6351 INFO db_20160107 openerp.modules.module: module SSS_po_project_task: creating or updating database tables
2016-01-21 11:06:13,758 6351 INFO db_20160107 openerp.modules.loading: loading SSS_po_project_task/views/mrp_view.xml
2016-01-21 11:06:14,347 6351 ERROR db_20160107 openerp.addons.base.ir.ir_ui_view: Veld test` bestaat niet

Fout context:
Weergave`MRP Product Produce`
[view_id: 1288, xml_id: SSS_po_project_task.view_mrp_product_produce_wizard_sss, model: mrp.product.produce, parent_id: 907]
2016-01-21 11:06:14,348 6351 DEBUG db_20160107 openerp.models: Exception while validating constraint
Traceback (most recent call last):
File "/media/disk2/workspace/odoo8_sss/openerp/models.py", line 1251, in _validate_fields
valid = valid or fun(self._model, cr, uid, ids)
File "/media/disk2/workspace/odoo8_sss/openerp/addons/base/ir/ir_ui_view.py", line 202, in _check_xml
self.postprocess_and_fields(cr, uid, view.model, view_doc, view.id, context=context)
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 250, in wrapper
return old_api(self, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/addons/base/ir/ir_ui_view.py", line 806, in postprocess_and_fields
fields_def = self.postprocess(cr, user, model, node, view_id, False, fields, context=context)
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 250, in wrapper
return old_api(self, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/addons/base/ir/ir_ui_view.py", line 716, in postprocess
fields.update(self.postprocess(cr, user, model, f, view_id, in_tree_view, model_fields, context))
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 250, in wrapper
return old_api(self, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/addons/base/ir/ir_ui_view.py", line 716, in postprocess
fields.update(self.postprocess(cr, user, model, f, view_id, in_tree_view, model_fields, context))
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 250, in wrapper
return old_api(self, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/addons/base/ir/ir_ui_view.py", line 643, in postprocess
xarch, xfields = self.postprocess_and_fields(cr, user, field.comodel_name, f, view_id, ctx)
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 250, in wrapper
return old_api(self, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/addons/base/ir/ir_ui_view.py", line 832, in postprocess_and_fields
self.raise_view_error(cr, user, message, view_id, context)
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 250, in wrapper
return old_api(self, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/addons/base/ir/ir_ui_view.py", line 360, in raise_view_error
raise AttributeError(message)
AttributeError: Veld test` bestaat niet

Fout context:
Weergave`MRP Product Produce`
[view_id: 1288, xml_id: SSS_po_project_task.view_mrp_product_produce_wizard_sss, model: mrp.product.produce, parent_id: 907]
2016-01-21 11:06:14,362 6351 ERROR db_20160107 openerp.http: Exception during JSON request handling.
Traceback (most recent call last):
File "/media/disk2/workspace/odoo8_sss/openerp/http.py", line 537, in _handle_exception
return super(JsonRequest, self)._handle_exception(exception)
File "/media/disk2/workspace/odoo8_sss/openerp/http.py", line 574, in dispatch
result = self._call_function(**self.params)
File "/media/disk2/workspace/odoo8_sss/openerp/http.py", line 310, in _call_function
return checked_call(self.db, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/service/model.py", line 118, in wrapper
return f(dbname, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/http.py", line 307, in checked_call
return self.endpoint(*a, **kw)
File "/media/disk2/workspace/odoo8_sss/openerp/http.py", line 803, in __call__
return self.method(*args, **kw)
File "/media/disk2/workspace/odoo8_sss/openerp/http.py", line 403, in response_wrap
response = f(*args, **kw)
File "/media/disk2/workspace/odoo8_sss/addons/web/controllers/main.py", line 948, in call_button
action = self._call_kw(model, method, args, {})
File "/media/disk2/workspace/odoo8_sss/addons/web/controllers/main.py", line 936, in _call_kw
return getattr(request.registry.get(model), method)(request.cr, request.uid, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 250, in wrapper
return old_api(self, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/addons/base/module/module.py", line 534, in button_immediate_upgrade
return self._button_immediate_function(cr, uid, ids, self.button_upgrade, context=context)
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 250, in wrapper
return old_api(self, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/addons/base/module/module.py", line 495, in _button_immediate_function
registry = openerp.modules.registry.RegistryManager.new(cr.dbname, update_module=True)
File "/media/disk2/workspace/odoo8_sss/openerp/modules/registry.py", line 370, in new
openerp.modules.load_modules(registry._db, force_demo, status, update_module)
File "/media/disk2/workspace/odoo8_sss/openerp/modules/loading.py", line 351, in load_modules
force, status, report, loaded_modules, update_module)
File "/media/disk2/workspace/odoo8_sss/openerp/modules/loading.py", line 255, in load_marked_modules
loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules, perform_checks=perform_checks)
File "/media/disk2/workspace/odoo8_sss/openerp/modules/loading.py", line 176, in load_module_graph
_load_data(cr, module_name, idref, mode, kind='data')
File "/media/disk2/workspace/odoo8_sss/openerp/modules/loading.py", line 118, in _load_data
tools.convert_file(cr, module_name, filename, idref, mode, noupdate, kind, report)
File "/media/disk2/workspace/odoo8_sss/openerp/tools/convert.py", line 901, in convert_file
convert_xml_import(cr, module, fp, idref, mode, noupdate, report)
File "/media/disk2/workspace/odoo8_sss/openerp/tools/convert.py", line 987, in convert_xml_import
obj.parse(doc.getroot(), mode=mode)
File "/media/disk2/workspace/odoo8_sss/openerp/tools/convert.py", line 853, in parse
self._tags[rec.tag](self.cr, rec, n, mode=mode)
File "/media/disk2/workspace/odoo8_sss/openerp/tools/convert.py", line 763, in _tag_record
id = self.pool['ir.model.data']._update(cr, self.uid, rec_model, self.module, res, rec_id or False, not self.isnoupdate(data_node), noupdate=self.isnoupdate(data_node), mode=self.mode, context=rec_context )
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 250, in wrapper
return old_api(self, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/addons/base/ir/ir_model.py", line 1025, in _update
model_obj.write(cr, uid, [res_id], values, context=context)
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 250, in wrapper
return old_api(self, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/addons/base/ir/ir_ui_view.py", line 273, in write
context)
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 250, in wrapper
return old_api(self, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 372, in old_api
result = method(recs, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/models.py", line 3787, in write
self._write(old_vals)
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 248, in wrapper
return new_api(self, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 565, in new_api
result = method(self._model, cr, uid, self.ids, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/models.py", line 3959, in _write
recs._validate_fields(vals)
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 248, in wrapper
return new_api(self, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/models.py", line 1272, in _validate_fields
raise ValidationError('\n'.join(errors))
ParseError: "ValidateError
Field(s) `arch` failed against a constraint: Invalid view definition

Meer info over fout:
Veld test` bestaat niet

Fout context:
Weergave`MRP Product Produce`
[view_id: 1288, xml_id: SSS_po_project_task.view_mrp_product_produce_wizard_sss, model: mrp.product.produce, parent_id: 907]" while parsing /media/disk2/workspace/odoo8_sss/custom_artissan/SSS_po_project_task/views/mrp_view.xml:21, near
<record id="view_mrp_product_produce_wizard_sss" model="ir.ui.view">
<field name="name">MRP Product Produce</field>
<field name="model">mrp.product.produce</field>
<field name="inherit_id" ref="mrp.view_mrp_product_produce_wizard"/>
<field name="arch" type="xml">
<data>
<xpath expr="(//field[@name='product_id'])[2]" position="after">
<field name="test"/>
</xpath>
</data>
</field>
</record>
2016-01-21 11:06:14,370 6351 INFO db_20160107 werkzeug: 10.0.0.64 - - [21/Jan/2016 11:06:14] "POST /web/dataset/call_button HTTP/1.1" 200 -
2016-01-21 11:06:32,661 6351 INFO db_20160107 openerp.modules.loading: loading 1 modules…
2016-01-21 11:06:32,684 6351 INFO db_20160107 openerp.modules.loading: 1 modules loaded in 0.02s, 0 queries
2016-01-21 11:06:33,400 6351 DEBUG db_20160107 openerp.modules.loading: Updating graph with 107 more modules
2016-01-21 11:06:33,440 6351 INFO db_20160107 openerp.modules.loading: loading 108 modules…
2016-01-21 11:06:41,515 6351 INFO db_20160107 openerp.modules.module: module SSS_po_project_task: creating or updating database tables
2016-01-21 11:06:42,663 6351 INFO db_20160107 openerp.modules.loading: loading SSS_po_project_task/views/mrp_view.xml
2016-01-21 11:06:43,565 6351 ERROR db_20160107 openerp.addons.base.ir.ir_ui_view: Veld test` bestaat niet

Can anyone help me please????

0

21 January 2016, by

Gert

| 0 Answers | 3,812 Views

How to distribute cost to a product or a purchase order

Dear all,

I want to add extra cost other than the product cost, such as transportation, freight, loading, or even customs.
I want to add these costs together, and then distributed to the products or POs i choosed, in order to recalculate the price in the PO itself, and update it in inventory.
I tried to use Landed Cost but i couldn't perform such calculation, I also tried to perform it using Purchase Cost Distribution but when click on Update i got that error:

Integrity Error

The operation cannot be completed, probably due to the following:
- deletion: you may be trying to delete a record while other records still reference it
- creation/update: a mandatory field is not correctly set

[object with reference: journal_id - journal.id]

Can any one help me with this please.
Thanks

0

15 May 2016, by

Yossef Elsherif

| 1 Answer | 4,297 Views

Odoo suitability for our company

Sales Order Warehouse Management Purchase Management

Hi All,

My name is Fadli, my company assigning me to set up integrated distribution system covering sales, inventory/warehouse, manufacturing (Master Production Schedule, Material requirement Planning), I think the rightness and perfectness it must be integrated with accounting too. But for now, I’ll focusing on sales, inventory/warehouse and manufacturing.

I don't know specifically and sure detailed about proper choice open source ERP that suitable for our company business process. The fast way it's absolutely hiring professional ERP consultant that can help us more accurate, fast to decide. But, the company trust me to learn and finding first, before hiring consultant. It's good for the company and me too.

From the middle December 2015, I Have 3 candidates open source ERP. Openbravo, Adempiere and Odoo. I don't have good method in deciding and comparing and have no a lot of time what the best from 3. But I spent a few days to learn from my coach, mentor, colleague and google also.

So, in the end of December 2015 I'm decided to choose odoo. The reasons is :
1. Absolutely open source and have proprietary product too.
2. Web based
3. Have all basic functionality between community and proprietary versions.
4. Have all database and all core applications.
5. The software covers all the standard warehousing, manufacturing, and sales channels
6. Powerful web interface I think
7. Better I have chosen one than no one.
8. If you asked me, is this the most suitable than Adempiere or Openbravo, I will answer "I need more time to learn 3 of that", but I have looking in mailing list, forum, community from other people experience.

I have several questions, but before that I'll illustrate my company :
1. Our company is manufacturing factory
2. From raw material until finish good, the product through many production section, its about 9 work centers production.
3. Our production method based on customer order, it seems "make to order", cmiiw. But, on production, we can't producing using fixed number or sure number of goods production, we need to defining yield percentage before production. For example if we want to produce 1000 goods, we must planning about 1100. Because we have pareto in production like defect, broken or failed goods and etc. We can take temporarily conclusion, although our method is "make to order", our production section will create some stock of goods after production, it's means, in next production, before we are planning production, we need to check last stock first.
4. We have many work center, it means, we have multilevel bill of material. For illustration, the picture below I hope can help to understand what its need.

Odoo-suitability-for-our-company

For last two months, I've installing, try to understand odoo 9 using my existing business case in our company, I try to create sales order then automatically create manufacturing order. I have some big question.
The question is :
1. When the sales order created, can we check stock first? If the needs ready on stock, so no need to create manufacturing orders. But if the stock only have some, then then the system create automatically the rest of needs.
2. Can system automatically create multi level manufacturing orders, of course in every levels always checking the stock first? The trigger is not the minimum stock limit, but the sales orders from customer. So, if the stock has 0, if no orders from customer, no need to create stock. But, if you have stock 1500, and the orders is need 2000, so system will automatically create the rest of needs, 500. See the picture below to illustrate.

Odoo-suitability-for-our-company

The question is :
3. Which the suitable version of odoo, 9 or 8 ? since odoo 9 still lack of documentation and forum/mailing list.

4. I'm very appreciated if somebody sharing to me link tutorial / pdf / video. How to proper setup the "setting" in each module like sales, purchase, warehouse/inventory, manufacturing, so I can learn how to setup the right setting for my business case from example.

5. I would appreciate too, if somebody wanna discussing with me using skype, email, facebook or anything.

0

10 August 2022, by

Fadli

| 2 Answers | 4,641 Views

Help

Welcome!