Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

Show Chart of Accounts in Sales and Purchase receipts for Odoo 8.0

By
Franz Bautista
on 11/3/16, 1:10 AM 145 views

Good day!

I have a issue that I need to show all accounts under the Chart of Accounts (Expense, income, liability, assets etc) once I choose the drop down under Sales/Purchase receipts. I tried editing the domain but only succeeded in getting income or expense. Would you have an idea how to do this?  This is the line I edit, and am not sure if this is all I need to edit:

<field name="account_id" domain="[('user_type.report_type','=','income'),('type','!=','view')]" widget="selection"/>

1
Sarga
On 11/3/16, 6:10 AM

Hi,

if you need to get the entire accounts in drop down avoid domain.Just redefine the field account_id and replace the field in xml with out domain.

1
fasluca
On 11/3/16, 7:07 AM

Make this line like this
<field name="account_id" widget="selection"/>

I had better include full script for Sales receipt:

<?xml version="1.0"?>

<form string="Sales Receipt">

<header>

<button name="proforma_voucher" string="Validate" states="draft" class="oe_highlight"/>

<button name="293" context="{'narration':narration, 'title':'Customer Payment', 'type':'receipt', 'partner_id':partner_id, 'reference':reference, 'amount':amount}" type="action" string="Validate Payment" attrs="{'invisible':['|',('pay_now','=','pay_now'),'|',('state','=','draft'), ('paid','=',True)]}" class="oe_highlight"/>

<button name="cancel_voucher" string="Cancel Receipt" states="draft,proforma"/>

<button name="cancel_voucher" string="Cancel Receipt" type="object" states="posted" confirm="Are you sure you want to cancel this receipt?"/>

<button name="action_cancel_draft" type="object" states="cancel" string="Set to Draft"/>

<field name="state" widget="statusbar" statusbar_visible="draft,posted" statusbar_colors="{&quot;proforma&quot;:&quot;blue&quot;}"/>

</header>

<sheet string="Sales Receipt">

<h1><label for="number" string="Sales Receipt"/> <field name="number" class="oe_inline" readonly="1"/></h1>

<group>

<group>

<field name="type" invisible="True"/>

<field name="company_id" widget="selection" on_change="onchange_company(partner_id, journal_id, currency_id, company_id)" groups="base.group_multi_company"/>

<field name="partner_id" domain="[('customer','=',True)]" on_change="onchange_partner_id(partner_id, journal_id, amount, currency_id, type, date, context)" string="Customer" context="{'search_default_customer':1, 'show_address': 1}" options="{&quot;always_reload&quot;: True}"/>

<field name="account_id"/>

/*<field name="account_id" domain="[('type','in', ['liquidity', 'receivable'])]"/>*/

<field name="pay_now" on_change="onchange_payment(pay_now, journal_id, partner_id)" required="1"/>

<field name="date_due" attrs="{'invisible':[('pay_now','=','pay_now')]}"/>

<field name="reference" attrs="{'invisible':[('pay_now','!=','pay_now')]}"/>

</group>

<group>

<field name="journal_id" domain="[('type','in',['sale','sale_refund'])]" widget="selection" on_change="onchange_journal(journal_id, line_cr_ids, tax_id, partner_id, date, amount, type, company_id, context)" groups="account.group_account_user"/>

<field name="date" on_change="onchange_date(date, currency_id, currency_id, amount, company_id, context)"/>

<field name="name"/>

<field name="paid" invisible="1"/>

<field name="paid_amount_in_company_currency" invisible="1"/>

<field name="currency_id" invisible="1"/>

</group>

</group>

<notebook>

<page string="Sales Information">

<field name="line_cr_ids" on_change="onchange_price(line_cr_ids, tax_id, partner_id)" context="{'journal_id':journal_id, 'type':type, 'partner_id':partner_id}">

<tree string="Sales Lines" editable="bottom">

<field name="account_id" widget="selection"/>

<field name="name"/>

<field name="amount" sum="Total"/>

<field name="account_analytic_id" groups="analytic.group_analytic_accounting"/>

</tree>

</field>

<group>

<field name="narration" placeholder="Internal Notes" nolabel="1"/>

<group class="oe_subtotal_footer oe_right">

<field name="tax_id" on_change="onchange_price(line_cr_ids, tax_id, partner_id)" widget="selection" nolabel="1" placeholder="Tax" domain="[('type_tax_use','in',('sale','all')), ('parent_id', '=', False)]"/>

<field name="tax_amount" nolabel="1"/>

<div class="oe_subtotal_footer_separator">

<label for="amount"/>

<button type="object" class="oe_link oe_edit_only" name="compute_tax" string="(update)" attrs="{'invisible': [('state','!=','draft')]}"/>

</div>

<field name="amount" class="oe_subtotal_footer_separator" nolabel="1"/>

</group>

</group>

</page>

<page string="Journal Items" attrs="{'invisible': [('state','!=','posted')]}">

<group col="4">

<field name="period_id"/>

<field name="audit"/>

</group>

<field name="move_ids" readonly="1">

<tree string="Journal Items">

<field name="move_id"/>

<field name="ref"/>

<field name="date"/>

<field name="statement_id"/>

<field name="partner_id"/>

<field name="account_id"/>

<field name="name"/>

<field name="debit"/>

<field name="credit"/>

<field name="state"/>

<field name="reconcile_id"/>

</tree>

</field>

</page>

</notebook>

<group col="4" invisible="1">

<field name="is_multi_currency" invisible="1"/>

<field name="currency_help_label" invisible="1"/>

<field name="payment_rate" invisible="1"/>

<field name="payment_rate_currency_id" invisible="1"/>

<field name="paid_amount_in_company_currency" colspan="4" invisible="1"/>

</group>

</sheet>

<div class="oe_chatter">

<field name="message_follower_ids" widget="mail_followers"/>

<field name="message_ids" widget="mail_thread"/>

</div>

</form>

Changing the above only showed all cash and receivable accounts, income accounts can not be seen now. It did not show all chart of accounts. I think since this a sales receipt there is another parameter which i am missing. Any ideas?

Franz Bautista
on 11/17/16, 1:49 AM

Then try making the domain like this

[('user_type.report_type','in',['expense','income','liability','asset']),('type','!=','view')]

fasluca
on 11/17/16, 6:39 AM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 11/3/16, 1:10 AM
Seen: 145 times
Last updated: 11/3/16, 7:07 AM