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?