Report builder - Change field Name

ERPNext
1

Hi All,

I am creating new report using “Report Builder” . Is there any way I can change field name in report . I don’t want to change label of fields.

image
image1069×514 20.7 KB

Regards,
Satish Aralkar

2

A work around to achieve what you want would be to use a custom translation.

Translate “ID” to “Document No.” in Translation.

All your reports would now show ID as “Document No.”

I would not use “Invoice No.” for obvious reasons.

Regards.

3

You can achieve this in script/query report.

e.g - Script report.

tabSales Invoice.name as “Invoice No:Link/Sales Invoice:120”

2 Likes
4

Thanks @H_N for the reply. Can you please explain more where is translation in report. I am fine if this effected to all reports.

Thanks
Satish

5

Thanks Sangram, I am having little programming knowledge so I decided to use report builder. Is there any way out to change field name in report builder.

Regards,
Satish

6

There is a doctype called Translation.

You just enter the term you need translated and the translation you want it to be.

Pretty neat feature where you can customize terms to your local requirements. Eg. Sales Invoice translated to Sales Bill or Receipt or whatever you want.

Try it out.

7

Thanks @H_N
I just tried for below fields in Translation doc. For example, for Rate, it should translate to Net Rate but no success.

image
image1733×558 31.5 KB

Here is the result.

image
image1733×401 20.6 KB

I tried with single field translation as well but same result as above.

Request you to please help.

Regards,
Satish

1 Like
8

@satisharalkar,

You should do it one item at a time and you should not add “(Sales Invoice Item)” after the data to be translated.

Example:

Source Text: “Rate”
Translated Text: “Net Rate”

1 Like
9

Thanks everyone, translation is working for me.

Regards,
Satish