Siirry sisältöön
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Kaikki kirjoitukset Ihmiset Merkit
Tunnisteet (Näytä kaikki)
odoo accounting v14 pos v15
Tietoa tästä foorumista
Tämä kysymys on merkitty
invoicefieldv7orderfunctional
2 Vastaukset
18035 Näkymät
Avatar
N

I want to obtain in a account.invoice the value of a field of the sale order which has created the invoice.

class account_invoice(osv.osv):
    _name = "account.invoice"
    _inherit = "account.invoice"

    def _get_n_ref(self, cr, uid, ids, field_name, arg, context=None):
        origin = self.pool.get('account.invoice').browse(cr, uid, ids, context=context)[0].origin # recuperer attribut 'origin' qui correspond au nom de la commande
        order_id = self.pool.get('sale.order').search(cr, uid, [('name', '=', origin)], context=context)[0] # recuperer id de la commande
        return self.pool.get('sale.order').browse(cr, uid, order_id, context=context)['n_ref'] # retourne n/ref de la commande

    _columns = {
        'n_ref': fields.function(_get_n_ref, string='N/Ref', type='char', store=True),
    }

account_invoice()

I have the error : 

Server Traceback (most recent call last):
    File "C:\Program Files (x86)\OpenERP 7.0-20130513-231009\Server\server\openerp\addons\web\session.py", line 90, in send
    File "C:\Program Files (x86)\OpenERP 7.0-20130513-231009\Server\server\.\openerp\netsvc.py", line 293, in dispatch_rpc
    File "C:\Program Files (x86)\OpenERP 7.0-20130513-231009\Server\server\.\openerp\service\web_services.py", line 626, in dispatch
    File "C:\Program Files (x86)\OpenERP 7.0-20130513-231009\Server\server\.\openerp\osv\osv.py", line 188, in execute_kw
    File "C:\Program Files (x86)\OpenERP 7.0-20130513-231009\Server\server\.\openerp\osv\osv.py", line 131, in wrapper
    File "C:\Program Files (x86)\OpenERP 7.0-20130513-231009\Server\server\.\openerp\osv\osv.py", line 197, in execute
    File "C:\Program Files (x86)\OpenERP 7.0-20130513-231009\Server\server\.\openerp\osv\osv.py", line 185, in execute_cr
    File "C:\Program Files (x86)\OpenERP 7.0-20130513-231009\Server\server\openerp\addons\test_nouveau_devis\nouveau_devis.py", line 367, in create_invoices
    File "C:\Program Files (x86)\OpenERP 7.0-20130513-231009\Server\server\openerp\addons\test_nouveau_devis\nouveau_devis.py", line 186, in manual_invoice
    File "C:\Program Files (x86)\OpenERP 7.0-20130513-231009\Server\server\.\openerp\workflow\wkf_service.py", line 119, in trg_validate
    File "C:\Program Files (x86)\OpenERP 7.0-20130513-231009\Server\server\.\openerp\workflow\instance.py", line 43, in validate
    File "C:\Program Files (x86)\OpenERP 7.0-20130513-231009\Server\server\.\openerp\workflow\workitem.py", line 60, in process
    File "C:\Program Files (x86)\OpenERP 7.0-20130513-231009\Server\server\.\openerp\workflow\workitem.py", line 175, in _split_test
    File "C:\Program Files (x86)\OpenERP 7.0-20130513-231009\Server\server\.\openerp\workflow\workitem.py", line 183, in _join_test
    File "C:\Program Files (x86)\OpenERP 7.0-20130513-231009\Server\server\.\openerp\workflow\workitem.py", line 40, in create
    File "C:\Program Files (x86)\OpenERP 7.0-20130513-231009\Server\server\.\openerp\workflow\workitem.py", line 52, in process
    File "C:\Program Files (x86)\OpenERP 7.0-20130513-231009\Server\server\.\openerp\workflow\workitem.py", line 127, in _execute
    File "C:\Program Files (x86)\OpenERP 7.0-20130513-231009\Server\server\.\openerp\workflow\wkf_expr.py", line 67, in execute
    File "C:\Program Files (x86)\OpenERP 7.0-20130513-231009\Server\server\.\openerp\workflow\wkf_expr.py", line 57, in _eval_expr
    File "C:\Program Files (x86)\OpenERP 7.0-20130513-231009\Server\server\.\openerp\tools\safe_eval.py", line 241, in safe_eval
    File "", line 1, in <module>
    File "C:\Program Files (x86)\OpenERP 7.0-20130513-231009\Server\server\.\openerp\osv\orm.py", line 374, in function_proxy
    File "C:\Program Files (x86)\OpenERP 7.0-20130513-231009\Server\server\openerp\addons\test_nouveau_devis\nouveau_devis.py", line 170, in action_invoice_create
    File "C:\Program Files (x86)\OpenERP 7.0-20130513-231009\Server\server\openerp\addons\test_nouveau_devis\nouveau_devis.py", line 223, in _make_invoice
    File "C:\Program Files (x86)\OpenERP 7.0-20130513-231009\Server\server\openerp\addons\mail\mail_thread.py", line 242, in create
    File "C:\Program Files (x86)\OpenERP 7.0-20130513-231009\Server\server\.\openerp\osv\orm.py", line 4478, in create
    File "C:\Program Files (x86)\OpenERP 7.0-20130513-231009\Server\server\.\openerp\osv\orm.py", line 4627, in _store_set_values
    File "C:\Program Files (x86)\OpenERP 7.0-20130513-231009\Server\server\.\openerp\osv\fields.py", line 1137, in get
    AttributeError: 'unicode' object has no attribute 'get'

How to fix that ? Thanks

Avatar
Hylkää
Borni DHIFI

test_nouveau_devis\nouveau_devis.py , line 223 ? test_nouveau_devis\nouveau_devis.py, line 170?

N
Tekijä

it is a module i have created

Borni DHIFI

no , what is code lines 170,223 ?

Avatar
le_dilem
Paras vastaus

hi I think it is best to fill the field when creating an invoice

in sale.order

 def _make_invoice(self, cr, uid, order, lines, context=None):
        """Add a ref in the invoice after creation
        """
        inv_obj = self.pool.get('account.invoice')
        # create the invoice
        inv_id = super(sale_order, self)._make_invoice(cr, uid, order, lines, context)
        # modify the invoice
        inv_obj.write(cr, uid, [inv_id], {'n_ref': order.n_ref}, context)
        return inv_id
Avatar
Hylkää
Avatar
Sudhir Arya (ERP Harbor Consulting Services)
Paras vastaus

Try this:

def _get_n_ref(self, cr, uid, ids, field_name, arg, context=None):
    res = {}
    for id in ids:
        origin = self.pool.get('account.invoice').browse(cr, uid, id, context=context).origin # recuperer attribut 'origin' qui correspond au nom de la commande
        order_id = self.pool.get('sale.order').search(cr, uid, [('name', '=', origin)], context=context)[0] # recuperer id de la commande
        res[id] = self.pool.get('sale.order').browse(cr, uid, order_id, context=context)['n_ref'] # retourne n/ref de la commande
        return res
Avatar
Hylkää
Aiheeseen liittyviä artikkeleita Vastaukset Näkymät Toimenpide
Invoice description field not available
invoice field v7 description
Avatar
1
maalisk. 15
5027
purchases in pcs get invoiced by total kg?
invoice sale v7 order uos
Avatar
0
elok. 16
9457
Additional Field in invoice line
invoice v7
Avatar
Avatar
1
maalisk. 15
6115
Sending or printing quote and invoices returns a Nonetype error
invoice v7
Avatar
Avatar
Avatar
Avatar
4
maalisk. 15
7764
set unit price to integer
invoice v7
Avatar
Avatar
1
maalisk. 15
5253