Development of Trial Balance Report in BC D365:
(1) In this blog, we will see how to develop a new Trial Balance Report in excel format.
(2) First of all Take DataItem: “G/L Account”.
(3) Write code in “OnAfterGetRecord” for calculating Opening, Debit, Credit and Running Balance.
Header Part:
Body Part:
Footer Part:
Excel Sheet Creation Function:
(4) After doing the above steps, publish the report and Go to the web client and run the report in excel format as shown.
(5) Select the report from the drop-down list and apply the Date filter as per the requirement and press the “OK” button as shown.
(6) Excel Worksheet in the process as shown.
(7) After that excel was generated in the below format, as shown.
