# General Ledger Entries with unique dimensions **URL:** \ **Category:** Business Central/NAV\ **Created:** [April 17, 2024, 3:39pm UTC](https://www.dynamicsuser.net/t/general-ledger-entries-with-unique-dimensions/80553 "2024-04-17T15:39:05Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Vickie\_Morris](https://avatars.discourse-cdn.com/v4/letter/v/8e8cbc/32.png) [@Vickie\_Morris](https://www.dynamicsuser.net/u/Vickie_Morris)\ **Post date:** [April 17, 2024, 3:39pm UTC](https://www.dynamicsuser.net/t/general-ledger-entries-with-unique-dimensions/80553/1 "2024-04-17T15:39:05Z")
I have a client that is looking to pull only those general ledger entries with unique combinations… excluding duplicates. How can we achieve this? ---
**Author:** ![pjllaneras](https://sea1.discourse-cdn.com/flex023/user_avatar/www.dynamicsuser.net/pjllaneras/32/9768_2.png) [@pjllaneras](https://www.dynamicsuser.net/u/pjllaneras)\ **Post date:** [April 17, 2024, 4:49pm UTC](https://www.dynamicsuser.net/t/general-ledger-entries-with-unique-dimensions/80553/2 "2024-04-17T16:49:02Z")
I think we need some more context to help you… what is a duplicated entry for you? what do you consider unique cobinations? and how do you want to pull de data? ---
**Author:** ![Vickie\_Morris](https://avatars.discourse-cdn.com/v4/letter/v/8e8cbc/32.png) [@Vickie\_Morris](https://www.dynamicsuser.net/u/Vickie_Morris)\ **Post date:** [April 17, 2024, 5:19pm UTC](https://www.dynamicsuser.net/t/general-ledger-entries-with-unique-dimensions/80553/3 "2024-04-17T17:19:58Z")
For example, the list has 3,814 rows. If I remove duplicates based on G/L Account No., Fund No., and all the dim codes, I get 52 unique records. That 52 is what I want. If I could export to excel. ---
**Author:** ![Ben\_Baxter](https://sea1.discourse-cdn.com/flex023/user_avatar/www.dynamicsuser.net/ben_baxter/32/9809_2.png) [@Ben\_Baxter](https://www.dynamicsuser.net/u/Ben_Baxter)\ **Post date:** [April 18, 2024, 12:18pm UTC](https://www.dynamicsuser.net/t/general-ledger-entries-with-unique-dimensions/80553/4 "2024-04-18T12:18:51Z")
Why not export it to Excel, then use the Remove Duplicates functionality to cut down the list? ---
**Author:** ![Vickie\_Morris](https://avatars.discourse-cdn.com/v4/letter/v/8e8cbc/32.png) [@Vickie\_Morris](https://www.dynamicsuser.net/u/Vickie_Morris)\ **Post date:** [April 18, 2024, 12:56pm UTC](https://www.dynamicsuser.net/t/general-ledger-entries-with-unique-dimensions/80553/5 "2024-04-18T12:56:14Z")
That’s how they currently do this, but they don’t want to do this every time. Looking for a way to automate it. ---
**Author:** ![pjllaneras](https://sea1.discourse-cdn.com/flex023/user_avatar/www.dynamicsuser.net/pjllaneras/32/9768_2.png) [@pjllaneras](https://www.dynamicsuser.net/u/pjllaneras)\ **Post date:** [April 18, 2024, 4:10pm UTC](https://www.dynamicsuser.net/t/general-ledger-entries-with-unique-dimensions/80553/6 "2024-04-18T16:10:07Z")
Do you mean group data for some fields? Have you tried “Analyze” option in “General Ledger Entries” page? you can group data and sum amounts. You can create a process only report (or codeunit) and use Excel Buffer to export de data to Excel. Or create a new report with an Excel Layout. Or create a Query grouping the fields you need, and view the Query (like a page). I think there are a lot of ways to achive what you need, but most of them will require to develope an extension. ---
**Author:** ![Vickie\_Morris](https://avatars.discourse-cdn.com/v4/letter/v/8e8cbc/32.png) [@Vickie\_Morris](https://www.dynamicsuser.net/u/Vickie_Morris)\ **Post date:** [April 18, 2024, 4:49pm UTC](https://www.dynamicsuser.net/t/general-ledger-entries-with-unique-dimensions/80553/7 "2024-04-18T16:49:08Z")
Thank you. We wrote a jet formula to pull the unique combinations directly from the G/L table.