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

How to convert decimal to text field in business central

(0) Share

Report

Posted on by Abd Alsameea Nat

175

Hi All,

How to convert decimal to text field in business central, I tried this code ( FORMAT() ) but the result appear (0.00) in QR Code.

BarcodeString := "No." + 'رقم الفاتورة: ' +

                 "VAT Registration No." + ' :الرقم الضريبي' +

                 FORMAT("Due Date") + ' :تاريخ طباعة ' +

                 FORMAT(TotalSubTotal) + 'Total' +

                 FORMAT("Amount Including VAT", 0, '<Precision,2:2><Standard Format,0>') + ' :المجموع ';

Categories:

Sales

Reports and Business Intelligence

Financial Management

Other

All responses (5)

Answers (0)

Suggested answer

YUN ZHU 62,477 Moderator on at

Like (0)

Report

RE: How to convert decimal to text field in business central

Hi, As mentioned above, the "Amount Including VAT" field in the SalesHeader table is FlowField.

When you read its value in a report, you need to use Record.CalcFields(Any [, Any,...]) Method or Record.SetAutoCalcFields([Any,...]) Method.

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/methods-auto/record/record-calcfields-method

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/methods-auto/record/record-setautocalcfields-method

Hope this will help.

Thanks.

ZHU
Suggested answer

TeddyH 12,775 Moderator on at

Like (0)

Report

RE: How to convert decimal to text field in business central

Check your "Amount Including VAT" if it is a value or a flowfield.

If it is a flowfield, you need to call calcfields beforehand.

CALCFIELDS("Amount Including VAT");
Suggested answer

Inge M. Bruvik 32,718 Moderator on at

Like (0)

Report

RE: How to convert decimal to text field in business central

Is it a flowfield you are getting the decimal value from?

And if so, have you run calcfileds ?
Abd Alsameea Nat 175 on at

Like (0)

Report

RE: How to convert decimal to text field in business central

Hi NorthW,

Thank you for response,I tried this code But the result is zero.
Suggested answer

Inge M. Bruvik 32,718 Moderator on at

Like (0)

Report

RE: How to convert decimal to text field in business central

I would try the standard format 9.

format(Amount,9)