Afternoon Andrei,

Thank you for using the Sage 200 Sage City Community.

There isnt a report which gives a Credit/Debit split direct from the Customer Module, but there is another report which may give you the information needed, this report can be found in Nominal > Reports > Account Analysis > Transaction Listing, Transaction Listing (Current if you are using 200 Pro, once the criteria window appears, you will see there is multiple criteria's which you can select, but the one you will need to make sure you change, is the 'Source' if you change this option to ‘is’ and select 'Sales Ledger' this will list all customer transactions in a debit/credit split.

I hope this helps, if this is not the sort of report you are looking for, I will include 2 links below, the first link is a list of every report within the program with a brief description and there report values, the second link is to the 200 reports library, which you have access to as part of your package.

Sage 200 Report Designer - Standard Reports within Sage 200

https://gb-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=200427112324226

Sage 200 Report Library

https://gb-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=200427112316008

Do not forget you do have additional support options available to you from your support provider, usually a Business Partner of Sage.

Please can you mark this thread as being verified by clicking More and Verify Answer. This will show the community this is the correct process to follow if they encounter a similar issue in the future with their Sage 200 program.

Regards

Dale

Hi Dale,

Thanks a lot for this, will give it a try as soon as possible, from my understanding it't not the ideal report as it does not provide the data at the invoice level, however it might still be useful to me as it gives it at the account level and from there i can just o and do my thing.

All the best,

Andrei