Small and medium business | Business Central, N...

Custom sale report fields

(1) Share

Report

Posted on by CU15061552-0

Hello,

I have 2 problems. I know that i am newbie, but still.

I need somehow to create field on business-central Standard Sales - Invoice word report.

1. i want to create label but with translation. yes i created labels (simple extenreport, then { label{and label names}}), generate translation file, but. File only translate by user language, not customer language. how to change that ?

2. i need create document no but without text. ( now documentno is spi0001, but i want to make just 0001)

maybe someone could give me lesson how to do this ?

Categories:

Dynamics 365 Business Central

All responses (5)

Answers (0)

CU15061552-0 12 on at

Like (0)

Report

Custom sale report fields

@YUN ZHU, yes in advanced settings when i choose en-us, report is translating, but by default( when advanced settings is empty), translating by user language and looks weird, because half invoice by customer language and another half (which i tried to program) is translating by user language.. :/
Suggested answer

YUN ZHU 84,274 Super User 2025 Season 1 on at

Like (1)

Report

Custom sale report fields

Hi, Please try the following settings again. If it still doesn't work, I suspect the report has not been translated.

PS: Dynamics 365 Business Central: How to install a Language Pack (SaaS and On-Premises)

https://yzhums.com/9970/

Thanks.

ZHU
CU15061552-0 12 on at

Like (1)

Report

Custom sale report fields

Hello,

@YUN ZHU, yes in page inspection language code is enu but still report field is translated by user language...
Suggested answer

YUN ZHU 84,274 Super User 2025 Season 1 on at

Like (2)

Report

Custom sale report fields

As for the first question, is the Language Code of the invoice empty? The language of the report does not refer to the Customer master data, but the language of the order/invoice. If it is empty, the language set by the user in My settings will be used. You can check it first.

As for the second question, if you want to modify the definition of all numbers, just go to No. Series and modify it.

But if you just want to hide the text when printing, this requires some text processing.

For example, DelChr Method

https://yzhums.com/6471/#toc3

Hope this helps.

Thanks.

ZHU
Tech_BC_Gokul 331 on at

Like (0)

Report

Custom sale report fields

Hi

for 2nd question you can change the no series in setup for the no’s to be changed from spi0001 to 0001

but it’s recommended to have characters in front of the numbers

for 1st questions please refer the below
https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-work-with-translation-files

thanks

gokulnath