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 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.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,537 Super User 2024 Season 2
Martin Dráb 228,520 Most Valuable Professional
nmaenpaa 101,148