Sorry. This doesn't make any sense as described. Receivables transactions don't (and never have) consolidate. Please check the "as at" date you are using for the report. It can be backdated.

AR transactions get moved to history.