Share
ReportHi, 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.
Categories:
You’re offline. This is a read only version of the page.
55
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.
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,537
Super User 2024 Season 2
#2
Martin Dráb
228,520
Most Valuable Professional
#3
nmaenpaa
101,148
All responses (
Answers (