Solved

How to make a filed 2 decimal places in export scenarios?

  • 7 December 2020
  • 7 replies
  • 884 views

Userlevel 6
Badge +5

Hello, I am using a GI as the data source of a export scenario.

When in GI, if I assign the schema field, then I could get the 2 place decimals as I expected.

However, when run by export by scenario,

 I still get more than 2 place decimals, which I don’t like.

 

How can I make the decimals become 2 places?

icon

Best answer by ray20 21 December 2020, 07:42

View original

7 replies

Userlevel 6
Badge +5

Hello, to who may be interested in.

Thanks to Acumatica support team, I can get the results using the below script:

 

=Format('{0:f2}',[Results.APTran_Formulacde5b41a26f84a6ba6c2fa940ce6f0cb])

Userlevel 6
Badge +5

sorry, in the subject line should be “field” not “filed”
can anyone give me some suggestion on it?

Userlevel 7
Badge +17

Hi @ray20 

 

Thank You Very Much for this info. Its really useful :)

Userlevel 7
Badge +17

Hi @ray20,

 

Can you please change the below configuration to 2 decimals in the Companies screen and verify once.

 

Userlevel 6
Badge +5

Hi @ray20,

 

Can you please change the below configuration to 2 decimals in the Companies screen and verify once.

 

@naveenb74  Hello, Naveen,  we are setting to 2 places in the screen you showed.
other places is fine, in screen, I mean.
but when comes to export by scenario, it is not as expected.

Userlevel 7
Badge +11

Hi @ray20 

Find a column which reflects 2 decimal on UI, set that as ‘Schema Field’ (you may add that object to list of objects on GI if its not added yet). I guess APTran.curyTranBal should reflect 2 decimal. You may check.

Hope this helps.


Regards
 

Userlevel 6
Badge +5

Hi @ray20 

Find a column which reflects 2 decimal on UI, set that as ‘Schema Field’ (you may add that object to list of objects on GI if its not added yet). I guess APTran.curyTranBal should reflect 2 decimal. You may check.

Hope this helps.


Regards
 

@vkumar  Hello, unfortunately, this time, the set “schema field” on GI does NOT work on export by scenario screens.
I tried another method, using “Round” function in “export scenario” like below:

=Round( CDec([Results.APTran_unitCost]), 2 )

 

It works almost fine, however,

it leaves the integer as integer, NO .00 in the end,

 

I’d like 68 to be 68.00
any suggestions?

 

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved