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?
Best answer by ray20
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])
+19Hi
Can you please change the below configuration to 2 decimals in the Companies screen and verify once.
Hi
Can you please change the below configuration to 2 decimals in the Companies screen and verify once.
other places is fine, in screen, I mean.
but when comes to export by scenario, it is not as expected.
Hi
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
Hi
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
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?
sorry, in the subject line should be “field” not “filed”
can anyone give me some suggestion on it?
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])
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
