Skip to Content
This question has been flagged
fieldprintselectionstring
2 Replies
10680 Rodiniai
Portretas
babis peroukas

Hello

I have two more questions (I dont want to spam post questions):

1) How can can I recieve the string value of a selection field ( [('1','Our base'), ('2','Client's base')] )? In this case I want to print for example "Our base". In my report I use [ o.x_loadbase ]] (the name of the field) but it prints just the key (1) intead of the value (Our base). Even if I send it to another model (its in the sale.order and i send it to account.invoice) it shows the key value.

2) Is there any way to assign a journal and sequence to the cancelled invoices?

Thanks

Portretas
Atmesti
Portretas
David Warner
Best Answer

Add these lines in your RML file where you are trying to fetch Value of your field (i.e.selection field).

<para style="terp_header">Our Base[[ ((o.x_loadbase == '1') or removeParentNode('para')) and '' ]]</para>

<para style="terp_header">Client's Base[[ ((o.x_loadbase == '2') or removeParentNode('para')) and '' ]]</para>

And also add one more line in Your RML file in header

<paraStyle name="terp_header" fontName="Helvetica-Bold" fontSize="7.0" leading="15" alignment="LEFT" spaceBefore="12.0" spaceAfter="6.0"/>

It"ll, Surely Solve your problem

Portretas
Atmesti
babis peroukas
Autorius

Hello and thanks for the answer, but isnt there any other way so I dont do this for every selection field I create? Also I want those values to pass from a model to another (from sale.order to account.invoice) so I ve put the fields in sale.order vals, but they are just passed with their keys and not with theit strings. In this case the printed field is not selection type... its char. Thanks :)

David Warner

May I know all your selection values are constant throughout?

Portretas
riess82
Best Answer

Easier and more flexible is [ o.x_loadbase == '1' and 'Our base']

Portretas
Atmesti
Related Posts Replies Rodiniai Veikla
field visible as text for manager and dropdown for employee
field selection
Portretas
0
kov. 15
4339
get Id in field selection
field selection
Portretas
Portretas
1
kov. 15
9288
Can you show the string of a selection field in Report Editor, or write it to another field?
field openoffice selection
Portretas
1
kov. 15
8849
Create Menu dialog plus define selection items
xml field selection
Portretas
1
kov. 15
4937
Selcetion Fields With Many2One RelationShip ?
field relationship selection
Portretas
Portretas
1
kov. 15
4735