Hello experts
i have created an ER invoice and it works great however the generated electronic report still show all lines , even the empty once , meanwhile i have some other electronic reports automatically hide the empty rows , i tried the VBA of excel on the template of the ER report but it doesn't really work , just wanna know where is the setup of hiding empty rows in these ranges , see screenshots
thanks in advance
Hi Ahmed,
What do you mean as you said it doesn't really work? Do the macros in the Excel template operation fit your requirements? Did you try the event macro triggered by a change in values for a cell within a worksheet. Does this make sense?
the way to fix it is to use this field , any setup in the excel template will not fix it
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 683 Super User 2025 Season 2
CA Neeraj Kumar 620
Martin Dráb 563 Most Valuable Professional
