using RML to Pull data from other tables

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Księgowość
Zapasy
PoS
Project
MRP

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 pos v15

O tym forum

Pomoc

using RML to Pull data from other tables

v6.1 python rml account.invoice sale.order

1 Odpowiedz

6865 Widoki

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?

Naresh Soni (nch)

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,

bernard

Autor

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

Autor

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...

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
How to change a Billing method in sales module ? v6.1 account.invoice sale.order	0 mar 15	5366
Field link from Sales order to Invoice Rozwiązane v6.1 account.invoice onchange windows7 sale.order	2 lut 24	11930
Sales Order Create/Edit is executing multiple times when inheriting module Rozwiązane python inherit sale.order	1 gru 22	4564
Odoo 13: Customize delivery slip print pdf Rozwiązane python sale.order deliveryslip	1 sie 22	4986
add many2many in invoice using _prepare_invoice account.invoice many2many sale.order	0 sie 17	2904

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!