Sage 200 Roadmap
AlphaLogix News – Sage 200 Roadmap
26th June 2017
Sage 200 Demo
AlphaLogix News – Sage 200 Demo
3rd August 2017
Sage 200 Roadmap
AlphaLogix News – Sage 200 Roadmap
26th June 2017
Sage 200 Demo
AlphaLogix News – Sage 200 Demo
3rd August 2017
Show all

Sage 200 Tips – Transaction Enquiry

Sage 200 Transaction Enquiries

The Sage 200 Transaction Enquiry is a useful feature designed to provide assistance with financial investigations and account balance reconciliations. This feature is available from many areas of the core Financials suite of modules; Sales, Purchase and Nominal Ledgers and also within the Cash Book.

There are various types of Reconciliation features available within Sage 200. Last year we wrote about the trusted Creditor & Debtor Reconciliation Enquiry which enables users to reconcile their Aged Creditor and Debtor balances with the associated Nominal Accounts. Earlier this year we wrote about how to get more out of Sage 200 Business Intelligence – the powerful and increasingly popular extension to MS Excel with a focus towards strategic company data analysis.

But sometimes we’re only seeking a small piece of information for a particular transaction; a reference, a transaction date or perhaps a nominal account that was posted to in error…


Sage 200 Transaction Enquiry

Cue the long-standing Transaction Enquiry for Sage 200.

This feature is available throughout the Financials suite of modules but in this example I’ll be focusing on the Sales Ledger Transaction Enquiry. From within the Sales Ledger, select Sales Enquiries > Transaction Enquiry

Use the Account drop-down lists to locate your Customer account – Wildcard Symbols can be used here to save you some time.

Selecting a Customer account will populate the form with various pieces of information that Sage believe could be useful to you in your investigation.

Sage 200 Transaction Enquiry

Questioning and understanding the information presented within this form is crucial to the understanding and managing of your transactions within Sage 200 Transaction Enquiry.


Sage 200 Current / Archived Transaction Enquiries

A ‘Current’ transaction is one that has not been archived, once a transaction has been archived it resides in the ‘Historical’ part of the Sage 200 database. Transactions can be archived periodically or in fact at any time and this can make the system a little more efficient for businesses with a high-frequency of transactions. However, generally speaking the archiving feature is not used regularly as these ‘archived’ transactions need to be enquired and reported upon a little differently.

When you are accessing the Transaction Enquiry for the first time there are a few important items to point out.
Transaction Enquiry

Current/Historical Transactions – By default you will be presented with Current Transactions i.e. those that have not been archived. Selecting the Historical tab will present you with a list of archived transactions.

Show Outstanding Only – Whilst this tick box is selected only outstanding transactions will be presented in the list.

Maximum number of transactions to display – The Transaction Enquiry feature places a looking glass to the recent transactional activity within your business and it does this very well. By default the ‘number of transactions to display’ value will default to 100 so you may wish to increase this if you don’t immediately find what you’re looking for.


Sage 200 Transaction Detail

Selecting the transaction from the list above will populate this Transaction Detail area with lots of important information. By default this will show you the summary transaction information such as references, dates and values.

Sage 200 Transaction Detail

Use the drop-down list to choose from a selection of useful areas:
Sage 200 Enquiry Drill Down

For example selecting the Nominal item will present you with a list of all of the nominal postings that have been made for the highlighted transaction.

Sage 200 Nominal Enquiry

Select the Print Drilldown button to print a summary report of this transaction.

Sage 200 Transaction Drilldown

Sage have made other features available from this Transaction Enquiry via the buttons located at the bottom of the form:

Sage 200 Transaction Enquiry Form

Account Enquiry – A general overview of the Customer/Supplier/Nominal/Cash Book Account

Find – A useful search facility for instances when you only have a small piece of information such as a reference

View Orders & Returns – A quick-link to viewing Sales and Purchase Orders/Returns from the Commercials Suite

Reprint – Reproduce important documents such as invoices and credit notes

If you have already invested in Sage 200 and have only recently discovered this Transaction Enquiry feature then I hope this blog has helped. For those that are considering investing in Sage 200 I hope this demonstrates yet another useful feature available in Sage 200, which enhances this dynamic and powerful solution.


Keep an eye out for future blogs from the team at AlphaLogix!

Our team of Accredited Sage 200 Product Specialists have many years of experience and are here to help, from initial consultation through to: development, implementation, training and on-going support.

If you would like any further information or a demonstration of Sage 200, please contact us:


Tel: 0845 259 3141

Kind Regards,

Richard Owens | Product Specialist