Notifications
Announcements
No record found.
Hi, I would like to check if there is an option to exclude the reverse entries when we print/ download General Ledger entries to excel? Thanks.
Can you try the following
Go to General Ledger Entries then filter by date range you need and then Source Code <>Reversal
I am not sure if this is what you needed.
Hi Mah Gah, thank you for your reply.
May I check how am I able to print the general ledger entries report by showing each G/L account total amount? Thanks.
Hi
I could not find a report for that. My suggestion is either:
1) Take it to Excel then sum it up.
2) Use free QuickSum app. Then filter each account and sum it up : appsource.microsoft.com/.../PUBID.webcom|AID.bc001|PAPPID.0b613ad6-def9-43ec-994c-1db094d086d8
The other methods are
1) Customer report which require development
2) Use ODATA and Excel. You can use General Ledger Entries ODATA (Web Service). Then take the data to Excel, then use Power Query to filter the data they way you want to. Format them then reuse the report. See below for example
thatnavguy.wordpress.com/.../
archerpoint.com/.../
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 Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 3,229
Jainam M. Kothari 1,867 Super User 2025 Season 2
YUN ZHU 1,153 Super User 2025 Season 2