Skip to main content

Notifications

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

How to get current year data into a monthly income statement

Posted on by 10

I have  tried everything I have read on this topic and nothing brings in current monthly data, only prior year.

I've tried FY[1] FY[2] routine,  I've tried -1P  -2P  all it does is bring in prior year...  how do you get the program to show current year data?

There must be a way.....    And you can't use CP, you get an error message.

pastedimage1684512854302v1.png

The above gave me Dec as period -1P and Nov as -2P and so forth all of prior year.

  • Lynn G. Profile Picture
    Lynn G. 10 on at
    RE: How to get current year data into a monthly income statement

    I closed the last year correctly and am in the new accounting year (2023) yet it keeps giving me last year's data.

    So far no one seems to be able to solve this issue.  I would be glad to screen share with you to let you see it...

    it really is frustrating.

  • TWBlaisdell Profile Picture
    TWBlaisdell on at
    RE: How to get current year data into a monthly income statement

    Hello Lynn,

    Thank you for posting on the Community Forum.

    Did you set up your Accounting Periods by creating the New Fiscal Year for January 1, 2023 through December 31, 2023? 

    That is the one thing I can think of that may lead to challenges here. To report on a period, the Period must be defined in the Accounting Periods Table.

    I hope this helps.

    Thank you!

    Tom

  • Suggested answer
    Jun Wang Profile Picture
    Jun Wang 7,437 Super User 2024 Season 2 on at
    RE: How to get current year data into a monthly income statement

    if you are trying to get the monthly net change, the formula doesn't seem to be correct. Try the below. It will give you net change of Jan, feb, mar, and apr. of 2023. FY means current financial year 

    pastedimage1684528806968v1.png

  • Jun Wang Profile Picture
    Jun Wang 7,437 Super User 2024 Season 2 on at
    RE: How to get current year data into a monthly income statement

    what do you try to achieve using -4p, -3p, -2p, -1p?

    from the title, it seems you want to get the monthly income, so I guess you need net change of income Jan, Feb, Mar, Apr of 2023?

  • Lynn G. Profile Picture
    Lynn G. 10 on at
    RE: How to get current year data into a monthly income statement

    Yes.  I set the date filter in the print from 1/1/2023 to 4/30/2023

    Sent you a screen shot via email

  • Jun Wang Profile Picture
    Jun Wang 7,437 Super User 2024 Season 2 on at
    RE: How to get current year data into a monthly income statement

    did you check if the date filter is correct ?

    pastedimage1684518587987v1.png

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!

Community AMA December 12th

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

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans