News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) General ledger drill down

Microsoft Dynamics GP (Archived)

General ledger drill down

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

Hello,

I just started with a company that recently converted to GP. I came from a company that used Navision. In Navision, we had the ability to view the general ledger account balances and was able to drill down into the accounts from the general ledger and export the data to excel. Is this something that is available in GP? Being new to GP, no one is really sure if this is a function that can be used, or if it just isn't set up yet.

Thanks!

Vicky Fry

Senior Financial Analyst

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Redbeard 12,931 on at

Like (0)

Report

RE: General ledger drill down

The best way to accomplish what you're likely trying to do is to use SmartLists. SmartLists is Accessible by clicking on the Microsoft Dynamics GP button and selecting SmartLists.

Once SmartLists is open, you can browse down the left hand pane to view various data in Dynamics GP. You are looking for Financial > Account Transactions. You can filter by data, account, add the main account segment, etc. Once you have the results you are looking for simply press the Excel button to export the data to Excel.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans