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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Using a prior year-end...
Microsoft Dynamics AX (Archived)

Using a prior year-end balance in Income Statement

(0) ShareShare
ReportReport
Posted on by accountinguser2018 151

Hello,

I appreciate everyone's help with my questions in the past few months.

I have created a trial balance as of 6/30 - the equity section has an account which requires a balance as of "December 31 prior year", so a prior period balance. In Row Definitions, is there a way to link a prior balance for this equity account, but all the other accounts will be the normal 6/30 balances?

Thank you.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi,

    You can link specific rows to periods in the row definition. This can be achieved via the row modifier. Example:

    rowdef.png

    Best regards,

    Ludwig

  • accountinguser2018 Profile Picture
    accountinguser2018 151 on at

    Thank you, Ludwig!

  • accountinguser2018 Profile Picture
    accountinguser2018 151 on at

    Lastly, which row modifier would I use to get an account balance for x # of periods? For example, I want the balance for periods 1-6 but to NOT include the balance carried forward from PY. Would I have to manually update this setting for each subsequent period?

    Example: carried forward balance from 12/31 is $50,000. Net Activity for periods 1-6 for a certain account is $100. I want the balance to ONLY reflect the $100. To clarify, this is for a Balance Sheet account.

    Thank you.

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello accountinguser2018,

    Can't this be achieved with 3 rows:

    Row 1:

    - Non printing row

    - Filter on YTD balance with the help of the row modifier shown above

    Row 2:

    - Non printing row

    - Filter on the /BB with the help of the row modifier

    Row 3:

    - This is not the row that is printed in the report

    - It is a calculated row and subtracts row 2 from row 1

    Would be great if you could test and check if this works out for you.

    Best regards,

    Ludwig

  • accountinguser2018 Profile Picture
    accountinguser2018 151 on at

    Thanks for your reply - I'm almost there.

    I have 2 equity line items on the balance sheet, each consisting of the sum of 2 accounts. In total after making the changes suggested, the two line items sum to the correct total. However, the two amounts showing do not match my manual spreadsheet.

    To confirm: BB = beginning balance for the year (12/31/17)? YTD = YTD balance at 6/30/18 if I chose period 6?

    Is the correct formula for subtracting as follows: @502-@503 ?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello accountinguser2018,

    Can this outcome be caused by the way how your columns are setup and the periods for which you run the report?

    Can you possibly share the setup that you currently have for your rows, columns and the way how you run the report.

    Many thanks and best regards,

    Ludwig

  • accountinguser2018 Profile Picture
    accountinguser2018 151 on at

    7178.2.png7178.2.png2437.3.png

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi,

    Many thanks for the screenprints.

    The setup seems actually ok as the column setup does not put a restriction on the row calculations.

    The BB should be the value that is posted in the opening period as on 1 Jan 2018. This requires of course that the year end closing process has been run. Has this been done? Do you see a value in the opening period for your accounts?

    You mentioned that you have a difference to your Excel calculated data. What are those differences? If you drill down to the transactions that are summarized in the MR report, Can you identify the difference? How has the Excel calculation been build up?

    Best regards,

    Ludwig

  • accountinguser2018 Profile Picture
    accountinguser2018 151 on at

    Hi,

    Thank you very much for your quick replies. I really appreciate all of your help.


    Yes - year-end process took place in Great Plains. I do see beginning balances in Great Plains when I look up account numbers.

    How do I drill down to the transactions summarized in MR? I click the link (the balance showing) and it doesn't give much helpful information. Again, I just want the 6/30/18 balance less the 12/31/17 balance. I pulled a TB from GP, and I think everything in GP is correct.

    Excel file is just grabbing the net activity for accounts 3710 & 3720, and accounts 3700 & 3730

  • accountinguser2018 Profile Picture
    accountinguser2018 151 on at

    Hello - it seems the balance is picking up all entities, whereas the spreadsheet maybe isn't.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 16

#2
GiacomoRovai Profile Picture

GiacomoRovai 4

#3
Douglas Noel Profile Picture

Douglas Noel 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans