Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 2

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 2 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 2 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

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

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans