Sage Audit trail problem.

[missscotia]

Hi,

I am trying to print off an audit trail for a customers transactions but it doesnt seem to working properly. I put the customer reference into box then click ok, but it still takes up everyone elses transaction and i only want one companies transaction, help me please!

 

[sheelagh]

I think your a trying to run this report from the Customer module, and you want a full activity report of all transactions on that customer's sales ledger account. I can't really say why your method is not working, but this is what I would do -
Open the Customer module.
Click on the CLEAR button at the bottom of the page to make sure no account are highlighted.
Click on your one customer to highlight that account.
Goto REPORTS
Select the report you want - I think it will be Customer Activity Report (detailed)
Add the date range or transaction number range if necessary, but don't put anything in the Account Range boxes.
That should do it.

Generally, if I want a report on all accounts I make sure there are no accounts highlighted. If I want just a few, I highlight the ones I need before I go to the reports menu.

I hope this helps

 

[missscotia]

i would do this but i am doing a mock assessment for ICB and they want an audit trail. I just can't seem to get the one companies transactions to come through the audit trail and i double check that i have the right criteria on (that pick that company from the list)

 

[sheelagh]

Hi Misscotia
I just opened my Sage and tried to do this. I am getting the same problem as you when I go to FINANCIALS, AUDIT TRIAL and fill in the ranges.
I have also run a SEARCH on one specific customer so that the financials window only displays details for that customer - I still get a full list of all transactions when I run the report.
So, I don't think I can help you to produce the report you need from the Audit trail button in the FINANCIALS window.

However, in practice, an Audit Trail is a list of transactions within a specific range. The report I mentioned earlier is an audit trail, it's just called something different.

I am not familiar with ICB criteria and I'm not sure how flexible they are in their requirements. If you find out how to run this report, I would be interested to know the answer.

Good luck

 

[missscotia]

Thanks for your help. It good knowing it not just me