Missing entries in report painter report

Hi,

I'm using report painter for P&L and Balance sheet. The report uses table GLPCT.

There is an entry for downpayment made which is posted to a downpayment account and the other effect to the vendor (with an alternative recon a/c).

Both the downpayment G/L and the alternative recon G/L have are balance sheet accounts and are mapped in the report under appropriate heads.

The problem now is there is a downpayment entry in period 4 which is reflected in FS10N in the respective GL accounts. But in the report only the downpayment GL reflects the period 4 (current balance) whereas the Reconcililation GL shows only period 3 balance. Thus there is a difference in the Balance sheet totals.

Any ideas on how this could be dealt with?

Thanks,

Rajan.