Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV forum
Suggested answer

I just wanted to see Open items in my General ledger for Accrued expenses, currently closing balance is showing me list since beginning.

Posted on by 25

i just wanted to see Accrued expense which is still outstanding to be paid (i.e., just open items and not all the transactions). How can i do that in Navision)

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 69,657 Super User 2024 Season 2 on at
    RE: I just wanted to see Open items in my General ledger for Accrued expenses, currently closing balance is showing me list since beginning.

    As far as I know, there is no such field.
    You can use Dimension to manage, but it is more troublesome to manage.

    Hopefully other experts can give you better advice.

    Thanks.

    ZHU

  • Varunkapoor Profile Picture
    Varunkapoor 25 on at
    RE: I just wanted to see Open items in my General ledger for Accrued expenses, currently closing balance is showing me list since beginning.

    Thanks for your response.

    Yes that’s my concern, some of my expenses are directly posting through general ledger and now i have 9 years of postings.

    Earlier I worked in SAP where we can configure account as an open item managed account or not.

    If an account is setup as an open item managed account then there is an field in which you can see only open items.

    Like, in payable account i have accrued 100 and reverse 100 then later i book 110. Now my closing balance is 110 i only wanted to see one line of 110 as 100 is reversed i want to apply them so that they would be treated as non open item.

    Is there any master GL setting where such type of field can be added ( like open item field in bank account).

    Many thanks in advance

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 69,657 Super User 2024 Season 2 on at
    RE: I just wanted to see Open items in my General ledger for Accrued expenses, currently closing balance is showing me list since beginning.

    Hi, If your expenses are directly posted to the G/L account through the General Journal, as far as I know, there is no way to directly inquire.

    If your expense is posted through Purchase Invoice, you can filter it out in Vendor Ledger Entries.

    pastedimage1671754438731v1.png

    Hope this helps.

    Thanks.

    ZHU

  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 9,217 Moderator on at
    RE: I just wanted to see Open items in my General ledger for Accrued expenses, currently closing balance is showing me list since beginning.

    hi

    look this

    www.youtube.com/watch

    DAniele

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.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans