Solved

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

  • 7 December 2020
  • 7 replies
  • 467 views

Userlevel 6
Badge +4

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 7
Badge +12

Hi @ray20,

 

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

 

Userlevel 6
Badge +4

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 +8

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 +4

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?

 

Userlevel 6
Badge +4

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

Userlevel 6
Badge +4

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 7
Badge +12

Hi @ray20 

 

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

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 — 2022  Acumatica, Inc. All rights reserved