Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Reporting Ledger
Finance | Project Operations, Human Resources, ...
Suggested answer

Reporting Ledger

(0) ShareShare
ReportReport
Posted on by Rosemary 10

Reporting-ledger.png

Good day all,

We do not have Reporting Ledger enabled in production. In our test system I am working on the setting up of Fixed Asset Module and this message came up.

My concerns are

  • How exactly does this affect GL transactions 
  • If it is not enabled would I be able to post to the GL in FA
  • Whenever I create a Book and I select the reporting ledger as 'BASE', this message comes up. I take the yes to continue.

I have read a couple of articles on this but I would still like to hear from the Community.

Regards

Rosemary

  • Rosemary Profile Picture
    Rosemary 10 on at
    RE: Reporting Ledger

    Thanks for your response , will go through the setup again as per the link.

    One other question, our accounts structure is per location, so there are depreciation costs for each location, per assets.

    How does that affect the default accounts in the Corporate book? I hope  I am phrasing this correctly.

    Regards

    Rosemary

  • Hokuminaria Profile Picture
    Hokuminaria 2,950 on at
    RE: Reporting Ledger

    Hello Rosemary,

    There are a couple things i can point out. Please see below:

    1. Only the Corporate book will flow to the General Ledger.
    2. The Process to move the Depreciation to the GL is not automatic. It has be moved using the GL Posting Routine.
      1. Financial | Routines | Fixed Assets | GL Posting.
      2. See chapter 14 of the link below.

    docs.microsoft.com/.../fixed-assets

    1. There is no automatic posting setting to have the Depreciation moved and posted in the General Ledger automatically.

    I hope this helps!

    Thank you!

  • Rosemary Profile Picture
    Rosemary 10 on at
    RE: Reporting Ledger

    Thank you for your response and my apologies for the late acknowledgement.

    I am in the process of implementing Fixed Assets, I would set up in Test and test,  and subsequently implement in live.

    As I setup I would test how the system responds. Assets were entered and a depreciation by one asset was run, but, I was unable to get to the posting to the GL. The option was greyed out in the company setup.

    Therefore I took the option to activate the reporting ledger and this is where the questions started. I appreciate the manner in which you dealt with my questions.

    I don't think our GL reporting requirements are such that what you have described, is necessary.

    I think I may have missed a step, a depreciation is completed, a batch is then created to post to the GL, this is what was not happening.

    Regards

    Rosemary

  • Suggested answer
    Hokuminaria Profile Picture
    Hokuminaria 2,950 on at
    RE: Reporting Ledger

    Hello Rosemary,

    With the information provided, are you saying the Reporting Ledgers are turned on in test but not in live? If yes, are you planning on turning Reporting Ledgers on in live?

    If you are not planning on turning Reporting Ledgers on in live, i would create a test company with a fresh copy of live to accurately test with how live will be when you do implement Fixed Assets.

    Now, you can have Multiple ledgers turned on but only use the base ledger in Fixed Assets. This is a setting in the Fixed Assets Setup called 'Allow Reporting Ledgers'. You could look at unmarking this in the FA Setup if you dont want to use Multiple Ledgers in Fixed Assets.

    To answer your concerns.

    1. How exactly does this affect the GL Transactions.
      1. Using multiple reporting ledgers are used to identify transactions for local (Gaap), IFRS, or other accounting purposes and define reporting ledger for each purpose.
      2. Once reporting Ledgers are activated, by default all transactions entry use the BASE ledger selected as the reporting ledger. 
      3. This will add Ledger Options in your reporting. These will be used to report on each ledger to see the transactions entered.
    2. If it is not enabled, would you be able to post to the GL in FA.
      1. Yes, you do not need multiple ledgers turned on to post to FA. The default ledger would be what you assign to the book. This would be the ledger that gets updated in the GL.
      2. You would need to report on this ledger for your FA transactions.
    3. Whenever I create a Book and I select the reporting ledger as 'BASE', this message comes up. I take the yes to continue.
      1. If your not using Multiple Ledgers in live, this message should not come up. You must have multiple ledgers turned on in test.
      2. If you dont want to see this in test, do not assign a ledger to a book. If it is already assigned, there is no turning it off with SQL scripting. You would need to create a new book.

    I hope this helps!

    Microsoft Support Engineer | Brandon Jarrett

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

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 601 Most Valuable Professional

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 416

#3
Adis Profile Picture

Adis 384 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans