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
v6.1pythonrmlaccount.invoicesale.order
1 Vastaa
7656 Näkymät
Avatar
bernard

In our sales order we have a customer Purchase order number for reference, we need to customise the invoice to add this. As far as I know, this field exists only in the sales order table. So far, I can edit the RML of the invoice but the problem comes trying to pull this reference. I think* the logic should be: if origin = SO130025 (our sale order number) then char = sales_order.customer_ref (sales order table, customer_ref field) else remove node

But I'm having trouble with putting it into code.

Anyone come across this?

Avatar
Hylkää
Avatar
Naresh Soni (nch)
Paras vastaus

Hi Bernard,

This should not be static. You should call a function (get_customer_ref(origin)) and the function returns the correct ref after searching for the correct sale order. So in your rml you should just have something like.

[[ o.get_customer_ref(origin) or RemoveParentNode(para) ]]

Thanks,

Avatar
Hylkää
bernard
Tekijä

So the function is declared in the python script that is used as the parser? sorry, first time developing for openerp.

Naresh Soni (nch)

Hi Bernard, yes right, you will need a parser to be written.

bernard
Tekijä

I've tried to use the following but I think my syntax is off: in RML: [[o.getcustomerPO(origin) or '' ]]

in parser.py: def getcustomerPO(self,so_num): saleorder = self.pool.get('sale.order') sale_oID = saleorder.search(self.cr, self.uid,[('name','=','so_num')],context=context) customerPO = saleorder.browse(self.cr, self.uid, sale_oID, context=context) return customerPO Really confused on where to go next...

Aiheeseen liittyviä artikkeleita Vastaukset Näkymät Toimenpide
How to change a Billing method in sales module ?
v6.1 account.invoice sale.order
Avatar
0
maalisk. 15
6189
Field link from Sales order to Invoice Ratkaistu
v6.1 account.invoice onchange windows7 sale.order
Avatar
Avatar
Avatar
2
helmik. 24
12559
Sales Order Create/Edit is executing multiple times when inheriting module Ratkaistu
python inherit sale.order
Avatar
Avatar
1
jouluk. 22
5414
Odoo 13: Customize delivery slip print pdf Ratkaistu
python sale.order deliveryslip
Avatar
Avatar
1
elok. 22
5672
add many2many in invoice using _prepare_invoice
account.invoice many2many sale.order
Avatar
0
elok. 17
3577