Hello I currently download my G/L change by profit center, department and general ledger for each month. I bring the file (which is a monster) into Excel so I can further massage the data. What I want to do is run the download (which I run out of Reports) and eliminate any lines which equal to zero. Any ideas?? Thanks in Advance Rob
Hi Rob, on the report request form (after having opened the report but before running the report) add a filter on “Net Change” (or “Balance to Date” if you want the year to date data) which should be: <>0 This will then export only the accounts which currently have a balance. Saludos Nils