Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Generate Account Schedules

Posted on by 5

I've just set up all my account categories and assigned my general ledger account to them. It's great that i can click the generate account schedules button and everything is updated automatically. 

What's not so great is that vital settings such as "opposite sign" are lost.

Additionally - gross profit is correctly calculated as revenue less cost of sales but net profit at the bottom doesn't seem to be taking off the overheads as expected.

How can i get around both of these issues?

Thanks!

NAV 2017 10.0

  • Brian Wick Profile Picture
    Brian Wick on at
    RE: Generate Account Schedules

    I understand where you are coming from.  There have been others that have voiced that same concern.  I would enter this as a suggestion to the Product Group and ask your colleagues to vote it up.  The Product Group are very open to new suggestions on features for the product.

    aka.ms/BusinessCentralIdeas

    There's also another suggestion out there that is similar to your request that can be voted up although it doesn't touch on customizations, but you could add a comment to it.

    experience.dynamics.com/.../

    Thanks,

  • Plugin Profile Picture
    Plugin 5 on at
    RE: Generate Account Schedules

    Thanks for your answer.

    It does seem strange that the default settings that the "generate account schedules" uses cannot be changed. This means the only customisation that can take place is AFTER the generate account schedules button is clicked but will then be subsequently lost the next time the account schedules are generated.Seems quite ill thought out to me.

  • Suggested answer
    Brian Wick Profile Picture
    Brian Wick on at
    RE: Generate Account Schedules

    Hello,

    Yes, unfortunately when you click the Generate Account Schedules it will overwrite customizations if that account schedule is selected on the Reporting Fasttab in General Ledger Setup.  If you don't want the customizations overwritten, I would not list the account schedule in this location or make sure to have a backup copy of the account schedule listed in G/L Setup so the customization can be re-added.  Maybe the community has some other tricks for getting around this that they can share.

    docs.microsoft.com/.../bi-how-work-account-schedule

    For the other issue we would need to see more details of the account schedule itself, the calculations, etc.   A support incident may need to be created to provide further assistance.

    Best Regards,

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans