Anybody has a script that develops opening closing balance for balance sheet accounts. I have developed a script based on SQL MAX function but this only gives a latest closing balance. I need a script that allows a range for a Power Bi report.
I have seen in Report Designer that for the Trial Balance it pulls from a field called “AHLast” but have no idea where this comes from