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

how to format quantity

(0) Share

Report

Posted on by Yael Suarez

115

Hello community, first of all thank you very much for reading my question and taking the time.

I currently have a decimal type variable and I want to give it the following format: 0000000000000.01

Example if my variable brings the amount 1678.32 it would have to be displayed in my text type variable as follows:
00000000001678.32

currently try something like this:

But I can't get the expected result, I get something like this:
'39088.0000000000000'


and it should look something like this:
0000000039088.00

Thank you for your time and I remain attentive to any kind of idea. Thank you and have a good day.

All responses (3)

Answers (0)

Suggested answer

Nitin Verma 21,091 Super User 2024 Season 1 on at

Like (0)

Report

RE: how to format quantity

Hi,

You can try something like this, I am giving you idea, you can write your own logic with the help of below methods and variables.

length: Integer

Amt: Text

length := 8;

Amt := '39088.00';

MESSAGE('%1%2',PADSTR('',8,'0'),Amt);

Answer is - 0000000039088.00
Suggested answer

Marco Mels on at

Like (0)

Report

RE: how to format quantity

Hello,

We currently do not have dedicated Dev support via the Dynamics 365 Business Central forums, but I wanted to provide you some additional resources to assist. If you need assistance with debugging or coding I would recommend discussing this on one of our communities.

www.yammer.com/dynamicsnavdev

www.dynamicsuser.net/.../14

I will open this up to the community in case they have something to add.

Thanks.
Yael Suarez 115 on at

Like (1)

Report

RE: how to format quantity

Hi I use this:

PBAMonto := Format(PBATbDiarioPagos.Amount, 0, '<Precision,2:2><Filler Character,0><Integer,13><Filler Character,0><Decimals>');