I am trying to create a reminder letter based on the default 'Statements and Advice (Single)' layout in Sage 200 report designer. At the moment the statement layout shows all unallocated transactions whether they're due or not.
What I need is to only show transactions that are due within the next 7 days or that already due. I only have limited experience with the tables used in this layout so I cannot think of an easy way of achieving this.
Does anyone know how I might be able to achieve this?