Can we create secondary ledger in D365 FO?

Question

Is there a functionality of having dual ledger in D365 FO. Have a primary ledger and another secondary ledger for reporting purpose??

Answer 1

Dynamics 365 is not currently supported here on QnA. The product group for Dynamics actively monitors questions over at
https://community.dynamics.com/f

--please don't forget to upvote and Accept as answer if the reply is helpful--

Answer 2

Concept of different/dual ledgers is covered in F&O by using posting layers, where each ledger (LocalGAAP, USGAAP, Local Tax etc.) is then covered by one or combination of posting layers. Mainly used for Fixed Assets, but can be used for all GL transactions.
https://learn.microsoft.com/en-us/dynamics365/finance/fixed-assets/post-fixed-asset-transactions-posting-layers .

Each GL journal is then posting into specific posting layer, and by using "derived books", you can post transactions to different posting layers at the same time. This way you can have USGAAP and LocalGAAP depreciation, adjustments or Tax specific transactions posted in different layers and use them appropriately in Trial Balance, electronic reporting, financial reports etc.

--------------------------------------------------------------------------

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 3

in addition to the posting layer method you can use another method put the second ledger account as a financial dimension, assign and fix each dimension to a main account, so you can use both on reporting. i use both solution in parallel.
in journal name creat journal for the retraitement transaction with opperation layer and use it.
in balance sheet select actual for local gaap and operation for the second ledger account

If the answer is helpful, please click "Accept Answer" and upvote it.