Skip to main content

Notifications

Announcements

Announcing Category Subscriptions!
News and Announcements icon
Dynamics 365 Community / Blogs / MSD365 F&O Learning / Trial Balance with two or m...

Trial Balance with two or more posting layer in Microsoft Dynamics 365 F&SC

Deepak Singh Profile Picture Deepak Singh 164

Table of Contents

 

Business Requirement

There are multiple posting layer at Journal Name like Current, Operations, tax, Custom layer 1, Custom Layer 2 etc. All the custom layer is used for different purpose only current layer is used to regular posting of general ledger account into legal entity for financial reporting purpose but there may be a requirement of posting some transactions for other purpose like business reporting or other legal regulatory requirement like fixed assets depreciation for income tax purpose and lease transaction to non-current posting layer. 
Therefore, most of the time business asks to have the visibility of Trial Balance with two or more consolidated posting layer transaction for some management reporting purposes or to see the net off balance of any vendor from two posting layers.
 

 Introduction

In Dynamics 365 Finance and Operations (D365 FO), posting layers refer to different levels in the general ledger used to categorize and report financial amounts. There are three main types of posting layers:
Current: Used for regular accounting purposes, capturing transactions that contribute to the periodic financial statements.
Tax: Specifically designed for tax-related depreciation entries, ensuring compliance with tax regulations.
Operations: Another layer for standard accounting entries, typically used to record day-to-day operational transactions.
The concept of posting layers allows for a structured and organized representation of financial data in the general ledger. It enables businesses to segregate transactions based on their nature and purpose, facilitating accurate financial reporting and compliance with different accounting standards.
  1.  
  2.  
  3.  
  4.  
  5.  
  6.  
  7.  
  8.  
  9.  
  10.  
  11.  
  12.  
  13.  
  14.  
  15.  
  16.  
  17.  
  18.  
  19.  
  20.  
  21.  
  22.  
  23.  
  24.  
  25.  
  26.  
  27.  
  28.  
  29.  
  30.  
  31.  
  32.  
  33.  
  34.  
  35.  
  36.  
  37.  
  38.  
  39.  
  40.  
  41.  
  42.  
  43.  
  44.  
  45.  
  46.  
  47.  
  48.  
  49.  
  50.  
  51.  
  52.  
  53.  
  54.  
  55.  
  56.  
  57.  
  58.  
  59.  
  60.  
  61.  
  62.  
  63.  
  64.  
  65.  
  66.  
  67.  
  68.  
  69.  
  70.  
  71.  
  72.  
  73.  
  74.  
  75.  
  76.  
  77.  
  78.  
  79.  
  80.  
  81.  
  82.  
  83.  
  84.  
  85.  
  86.  
  87.  
  88.  
  89.  
  90.  
  91.  
  92.  
  93.  
  94.  
  95.  
  96.  
  97.  
  98.  
  99.  
  100.  
  101.  
  102.  
  103.  
  104.  
  105.  
  106.  
  107.  
  108.  
  109.  
  110.  
  111.  
  112.  
  113.  
  114.  
  115.  
  116.  
  117.  
  118.  
  119.  
  120.  
  121.  
  122.  
  123.  
  124.  
  125.  
  126.  
  127.  
  128.  
  129.  
  130.  
  131.  
  132.  
  133.  
  134.  
  135.  
  136.  
  137.  
  138.  
  139.  
  140.  
  141.  
  142.  
  143.  
  144.  
  145.  
  146.  
  147.  
  148.  
  149.  
  150.  
  151.  
  152.  
  153.  

Process

1. There is the possibility to run the Trial  Balance with two or more consolidated posting layer transaction.
 
 
2. Two posting layer is selected with semi colon separator. After clicking on calculate balance all the ledger transaction in both the posting layer will be visible in Trial Balance as a consolidated view.
 
 
Thank You!
Happy Learning ☺ 
 
 

Comments

*This post is locked for comments