web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Column Type "Year to Date" Pulling Fiscal Year/Period not Date in Edit Column Layout Setup

(0) ShareShare
ReportReport
Posted on by 90

Our company has not yet closed out their fiscal periods, or ran their year end closing procedures, and I was told that they may not for several months.  However, they still have a need to pull an Account Schedule based off the Income Statement with a particular Column Layout that we had set up.  This layout shows "3 Months with YTD & LYTD with Percentages", and it seemed to be working fine as it was set up to be based on date and not fiscal periods.  Just recently one of the accounting assistance pulled this report and it seemed that the column "YTD" with the Column Type "Year to Date" is including last years posted transactions.  As I mentioned, accounting has not closed the periods from last year, but I thought this Column Type pulled records based on date not fiscal period.  The amount pulling in is the current balance of the account, which would be fine if we closed the year/periods.

Should this be pulling this way, or is the a bug from the most recent upgrade?  I do not remember, nor did anyone complain last year that this report was incorrect and we never close until after June many times. 

Should they be closing the periods and then just opening them back up if they need to post items to last year?  I did not want to close the periods if this would not allow them to make changes to 2020 if needed.

EditColumnLayout.PNG 

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    on at

    Terri,

    This is not a bug. When running an Account Schedule, that pulls Year-to-Date information, remember that any Income Statement Account will include those entries and balances from the prior year that you have NOT performed the Close Income Statement function. So, for example, if I had an Account called Office Expense and in 2020 the Balance was 10,000 and in January 2021 I booked 1,000, my YTD = 11,000. If I ran the Close Income Statement for 2020, then the YTD balance would = 1,000.  

    Note that I would recommend and I teach all my users to run the Close Income Statement after all the entries are posted. You can rerun the Close Income Statement again after you receive any External Accountant entries in future months. You might want to explain this to your Accounting Team.

    Hope this helps.

    Thanks,

    Steve

  • tww Profile Picture
    90 on at

    Thank you for quick response, I have just forwarded your suggestion to our accountant.  I think the fear is that you cannot open an accounting period back up after you close for the year, as they are still needing to make gl entries to 2020

  • Suggested answer
    Community Member Profile Picture
    on at

    Terri,

    Please update them not to fear or be concerned. You can close Accounting Period and Close Income Statement. You can set the User Setup/Posting From and Posting To dates to include the December (assuming your are a Calendar Year) and post any transaction into that Period. This is very normal for all BC Users.

    Thanks,

    Steve

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,238

#2
YUN ZHU Profile Picture

YUN ZHU 773 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 630

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans