AX 2012, having troubles on configuring Balance Sheet report- cannot get closing balance.

Hi AX guys,

When configuring Balance Sheet report on structure designer, I, select period code ro be “close”. When running the repor, all balance account is 0, but if i run trial balance report, closing balance is shown as below, with no 0 value. Can anyone tell me how to fix this problem?

I know if i want to configure income statement report, i have to select period code to “Net” and then the report will show me the movement of the organisation, but can anyone tell me what’s about BS?

Opening balance Debit Credit Net difference Closing balance
250 100 50 50 300
500 300 100 200 700
150 50 200 -150 0