My issue is when using the export feature the table fills with empty values. So, we get these gaps of information.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/37d71750-6f7f-4c27-9d9c-eb87769df10e.png)
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.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/3fe49813-818e-4d5e-8a1b-f2e14d6d38ef.png)
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.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/9edf5abb-e788-4bea-a336-47d52f7e9e81.png)
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
View original