Skip to main content
Solved

Remove Null Lines on Export

  • 24 January 2023
  • 1 reply
  • 53 views

My issue is when using the export feature the table fills with empty values. So, we get these gaps of information.

 

I tired making a line of code to cancel the line entry if the value was null but it doesn’t seem to be working. This causes a different problem where the table is only populated with one or two entries. 

The bottom code is  

=IIF([ItemCode]<>null, '',  '<Action: Cancel>')

I think it may have something to do with the restrictions but not sure on what exactly. 

Even trying to add a restriction to not pull empty values isn’t fixing the issue. 

 

Any help would be greatly appreciated. 

Best answer by ed.goodman

Hello @Obrewer,

Another option here would be to just set up a custom generic inquiry to only pull the data you want to export, rather than exporting from the sales orders (SO301000) screen).

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

ed.goodman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Employee
  • February 8, 2023

Hello @Obrewer,

Another option here would be to just set up a custom generic inquiry to only pull the data you want to export, rather than exporting from the sales orders (SO301000) screen).


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