Solved

Round currency DOWN to nearest dollar in GI

M
Rank
Userlevel 5
Badge +1

Is it possible in a GI to round a value DOWN to the nearest dollar? If I try using the available “Round( x, decimals)” function it will only round UP to the nearest dollar.

Anyone have any workarounds for this?

icon

Best answer by lauraj46 7 April 2023, 20:18

View original

2 replies

lauraj46
Rank
Userlevel 7
Badge +7

Hi @mikeho ,

You can use the floor function for this purpose.   

=floor([SOOrder.CuryLineTotal])

Hope this helps!

Laura

Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
M
Rank
Userlevel 5
Badge +1

Thanks, @lauraj46! That got me most of the way there. I’m doing some grouping in the GI and that was causing some issues that I had to work out. Also, I’m working with the ARTran.NetSalesAmount field so I had to convert any negative values to positive first before using the Floor function, and then convert them back to negative. But I think I have it all squared away now.

Reply


Terms & ConditionsCookie settings
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