Sage 200 retro reports don’t work!.
The problem is that the allocation date, which is set within the top right section of Sage 200’s allocation screens, defaults to the current date. This is really easy to overlook, and calls to our Sage 200 support team suggest most users are, quite reasonably, unaware of the implications of that date. However, this can cause a few hiccoughs if left unchanged, affecting retrospective debtors/creditors reports, retrospective statements, and any view of average times to pay by customers (visible in the account details report).
With this in mind, it is generally a good idea to change the allocation date from the default of the current system date to that of the latest transaction in the batch being allocated, to keep analyses based on transaction and allocation dates consistent. Sage 50 does this automatically, so perhaps this is something the software developers need to talk to each other about!
There is a fix, however, if you forget to do this when allocating. You can always go into the Amend Allocation option under the Adjust Transactions menu on the sales or purchase ledgers and either undo or amend the date on the problem allocations