Skip to Content
This question has been flagged
fieldprintselectionstring
2 Replies
10765 Zobrazenia
Avatar
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

Avatar
Zrušiť
Avatar
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

Avatar
Zrušiť
babis peroukas
Autor

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?

Avatar
riess82
Best Answer

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

Avatar
Zrušiť
Related Posts Replies Zobrazenia Aktivita
field visible as text for manager and dropdown for employee
field selection
Avatar
0
mar 15
4390
get Id in field selection
field selection
Avatar
Avatar
1
mar 15
9345
Can you show the string of a selection field in Report Editor, or write it to another field?
field openoffice selection
Avatar
1
mar 15
8895
Create Menu dialog plus define selection items
xml field selection
Avatar
1
mar 15
5000
Selcetion Fields With Many2One RelationShip ?
field relationship selection
Avatar
Avatar
1
mar 15
4785