question

TanviSingh-8769 avatar image
0 Votes"
TanviSingh-8769 asked chelhaMohammedabdelhak-0708 edited

Can we create secondary ledger in D365 FO?

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

not-supported
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DSPatrick avatar image
0 Votes"
DSPatrick answered

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


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MilanCvrkal avatar image
0 Votes"
MilanCvrkal answered

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://docs.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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

chelhaMohammedabdelhak-0708 avatar image
0 Votes"
chelhaMohammedabdelhak-0708 answered chelhaMohammedabdelhak-0708 edited

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.