Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Katie Spillane]

Hi there!  Has anyone successfully built a functional expense schedule within NAV’s account schedules?  I’m trying to figure out how it would be done (new NAV user).  Any screenshots or helpful information you could share would be much appreciated! Thanks!

——————————
Katie Spillane
Catholic Charities USA
——————————

[Diane Gill]

Hi Katie,

We used Jet Reports to create our Functional expense schedule.  https://insightsoftware.com/jet/jet-reports/    For the account schedules, you would create lines for the expense.  

And then you would create a column layout that would group the expenses by the total, program, management & fund raising.

You can find some videos online that explain Account Schedules.  

Hope this helps.

——————————
Diane Gill
Food Marketing Institute
Arlington VA
——————————
——————————————-

[Michael Carr]

I originally used Account schedule to breakout Balance Sheet, P&L , and all departmental expenses. I have since moved them onto Jet Reports (Basic or Expense).

But the worked fine but I found them less flexible than Jet.

if you need instructions the best source is google ‘youtube NAV Account schedules” and there will be a ton of videos to what.

You may want to check out New View strategies as Kerry (Rosvold) Peter teaches an excellent course on account Schedules and you may want to check out INECTA’s website as well.

——————————
Michael Carr
VP , Finance
Philadelphia Scientific LLC
Montgomeryville PA
——————————
——————————————-