Solved

Formatted Decimal Data issue when exporting from Report to Excel

  • 19 June 2021
  • 5 replies
  • 46 views

Userlevel 5
Badge +2

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 ChandrasekharM 1 July 2021, 22:43

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

 

View original

5 replies

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 5
Badge +2

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.

Userlevel 2
Badge

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

 

Userlevel 5
Badge +2

@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 2
Badge

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

Thanks

 

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