Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Account Schedule values doesn't change in a monthly column layout

Posted on by 5

Hello, I have an Income Statement Account Schedule with a monthly comparative column layout with all my fiscal year months, the setup is as follow:

Column Type: Net Change

Ledger entry type: Entries

Amount Type: Net Amount

Comparison Period Formula: FY[1] .. FY[12] one for each corresponding month.

The problem is that in the preview, the values shown in each month column, are the same for each account, even upcoming months like November and December are showing the same data, which can't be because there's no data yet for those months. 

The same Account schedule works fine using a different (non comparative) column layout i.e. a dimensional  column layout.

A'm I missing something?

I'll appreciate your help.

*This post is locked for comments

  • mmv Profile Picture
    mmv 11,465 on at
    RE: Account Schedule values doesn't change in a monthly column layout

    Hi,

    Please refer the below:

    http://dynamicsnavfinancials.com/account-schedule-formulas/

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans