Skip to main content
Solved

Exporting excel


Forum|alt.badge.img+1

Hi all,

I usually use an existing report to make another, but when I have edited the columns with my own without changing anything from schema or anything, just adding columns and fields, which do not reflect in the excel when I export. Is there sth I need to do for the new columns to display? I appreciate your answers!

Like in this pic, only 3 columns were shown.

Best answer by Naveen Boga

Hi, @paula012  For the Extended field, can you please add the below properties and verify?

  1. Export Visible = true
  2. Excel Cell →  Provide the Row and Column values

 

 

View original
Did this topic help you find an answer to your question?

5 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3377 replies
  • Answer
  • January 10, 2023

Hi, @paula012  For the Extended field, can you please add the below properties and verify?

  1. Export Visible = true
  2. Excel Cell →  Provide the Row and Column values

 

 


Forum|alt.badge.img+1
  • Author
  • Semi-Pro II
  • 92 replies
  • January 10, 2023

Thanks but why do I have only these?

 


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3377 replies
  • January 10, 2023

Hi @paula012  To be honest, I never used these fields, let me check and get back to you OR

 @BenjaminCrisman  Could you please let us know the functionality of this field “Export Columns” ?


BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • 625 replies
  • January 10, 2023

Thank you @Naveen Boga and @paula012! When you are setting up the excel formatting of the report you can choose which columns will be exported and which will not. When there is no setting it will export all columns, but from what I understand you should be able to specify in the Excel Columns collection editor, which columns are to be expected on export.

@paula012 In your case you have not selected any specific section or field, so this is the options available at the report level. If you click on specific fields and sections it will show the options Naveen mentioned


Forum|alt.badge.img+1
  • Author
  • Semi-Pro II
  • 92 replies
  • January 11, 2023

Thank you, sir @BenjaminCrisman! Saw it and I chose the Auto, where it just shows it all. A great info though! Now I know what to do next time when I only need some fields to show. And thanks to sir @Naveen Boga once again!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings