Solved

Column sets formatting bug when export to Excel

  • 16 July 2021
  • 1 reply
  • 128 views
W
Rank
Userlevel 2
Badge

Version: 21.106.0024

We use “No Rounding” for rounding and “#,##0” as formatting to display whole dollar amount on the report and but need 2 decimal when export to Excel for analysis. 

This works fine in 20R1 version, but 21R1, only whole number got exported to Excel, seems formatting actually truncated the decimals.

icon

Best answer by woodyg84 22 August 2021, 16:33

View original

1 reply

W
Rank
Userlevel 2
Badge

only solution is changing the format to #,##0.00 that will show whole number on report but can show decimal in Excel by changing the format. not clean solution at allthough

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