Calculate opoening balance

Dynamics 365 Business Central/NAV Developers Forum
#1

Hi…

Please let me know how to calculate the opening balance from customer ledger entry table in a report, for the fields ‘Debit Amount (LCY)’ and ‘Credit Amount (LCY)’…

I’ve designed a report with ‘Customer Ledger Entry’ table…Request filter fields- Customer no., Posting date

#2

Hi Bijoy,

The fields ‘Debit Amount (LCY)’ and ‘Credit Amount (LCY)’ are flowfields off the Detailed Cust. Ledg. Entry table. Either use the Detailed Cust. Ledg. Entry table or use the CALCFIELDS command to calculate the values.