Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
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 73,565 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 73,565 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,272 Super User 2024 Season 1 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans