Solved

Formatted Decimal Data issue when exporting from Report to Excel

  • 19 June 2021
  • 6 replies
  • 591 views

Userlevel 6
Badge +5

Hello,

       I am not an excel expert, so I do not know whether the issue I met is related to the below idea:

 

        The issue I met is as below:

1, I formatted a data field in report designer, using “0.00”

 

2,  It is looked nice in screen and when exporting to PDF

However, the data is only displayed in integer format, while it is indeed having 2 decimals value.

 

on the contrary, the data filed without formatting is looked bad on screen, but it is OK when exporting to excel

 

icon

Best answer by ChandraM 1 July 2021, 22:43

View original

6 replies

Userlevel 7
Badge +9

Hi @ray20 Please try setting the Format to ‘c’ (Small case), as shown in the below screenshot. Also, try setting the Format #0.00 

 

Badge +16

Thank you @ray20 and @ChandrasekharM !

My whole number (Number of Days) field was fine on screen but adding .00  (like 365.00 Days) when exported to excel.  This thread helped me!  👍

Laura

Userlevel 2
Badge

I’ve seen this issue too, occasionally, when I export from Generic Inquiries. If you change the format in Excel, it’s fine but by default I’ve also seen that behavior. This becomes an issue with automated exports (like bank feeds). I’m not sure Acumatica can actually do anything about it though since at least in my experience it’s controlled in the Excel application.

Userlevel 6
Badge +5

@ChandrasekharM 
Thank you , you solved my problem

below is my update:

format ‘c’  displays great on screen and pdf,  ‘c’ stands for currency, so it is shows $ in front of number. But, unfortuantely, it is also shrinked in excel

format ‘#0.00 ’  perfectly showed 2 decimals in everywhere:screen, pdf and excel, Great, Thank you.

Userlevel 7
Badge +9

Hi @ray20 Glad to know that the solution resolved the issue.

Thanks

 

Userlevel 6
Badge +5

I’ve seen this issue too, occasionally, when I export from Generic Inquiries. If you change the format in Excel, it’s fine but by default I’ve also seen that behavior. This becomes an issue with automated exports (like bank feeds). I’m not sure Acumatica can actually do anything about it though since at least in my experience it’s controlled in the Excel application.

@arlinewelty93 
Hello, thank you for sharing your experience.
Currently, I am working around it by removing the format control.
It would display 2 decimals in excel.

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