Skip to main content

Next Generation - Utilise the Purchase Ledger Enquiry to its best

Access the Purchase Transactions Enquiry screen

  1. Click Creditors then Enquiries then click Purchase Transactions.
    Note: All transactions are displayed. You can narrow down you search using advanced filters. You can also search on the columns directly by pointing the mouse to the name of the column and click on the icon and choose from the available filter list, then click OK.

The Purchase Transactions Enquiry screen holds all the transactions for all your suppliers and enables you to make enquiries about purchase transactions in your data file.

All of our enquiries use the same screens for consistency purposes.

  • You can run enquiries against all records or just a specific record.

  • You can apply filters to ensure that only the transactions you're interested in are displayed in the enquiry window.

  • You can look at just the header information, or you can open the transaction to see all the detail lines it contains by clicking on the icon.

  • Access to enquiry windows is controlled by your Security Profile.

You can set a transaction on dispute by selecting the checkbox against the transaction on the On Dispute column and selecting a query reason.

To remove the dispute flag, click on the selected checkbox against a disputed transaction. If the on-dispute column is not displayed as a default, you can add it through the configure columns under the cog icon.

To access a supplier' transactions directly from the supplier record, please refer to access transactions directly from a supplier.

Note: When clicking anywhere on a row, the action panel automatically opens from the right. You can close the action panel by clicking on the in the middle of the panel.

The purchase transaction enquiry is made up of the following sections:

Sections

Description

Record Count

  • Shows the number of transactions listed in the grid for the provided filter criteria.

  • Updates depending on the filter criteria.

  • Updates when you select transactions.

Search field

  • Search on Account Name or Header Reference which is the same as the Invoice, Credit Note Number field or Payment, Debit and Credit Adjustment Reference field.

  • When accessing the enquiry directly from a supplier record, the account name and header reference only searches on the selected record.
    Tip: You have to know the first few characters or numbers to be able to search as these searches are what we refer to as Begins With searches.

  • You can search for the beginning of each word in the available quick search fields, no matter where they are.

  • Example:

    • If you wish to search for an Account Name of "The Access Group", you can now enter the words "The", "Access", or "Group" and Financials will intelligently find this result.

    • Note: This search contains a Begins with search on each word, and is available for the Account Name and excludes the Header Reference.

Saved Filters List

  • A list of any saved filters that are available.

  • Filters are saved using the advanced filter panel, for more information please refer to how to use the advanced filter.

Advanced Filter

image.png
  • Opens the advanced filter panel for advanced filtering.

  • Number indicator displays the number of applied filter criteria to the enquiry list.

  • For more information, refer to the advance filter articles we linked above.

Cog

image.png
  • Contains a list of actions which can be carried out on the enquiry.

    • Configure Columns - Customise the displayed columns in the best order to suit your needs. For more information please refer to Configure Columns.

    • Clear Criteria - Clears all the filter criteria that you have added directly for a column displayed. Doesn't clear the filter you have added to the Advanced Filter panel.

    • Reset Sorting - Removes any sorting that you've set on all displayed columns.

    • Reset Default Column Width - Resets all column widths to their default size.

    • Export to Excel - All - Exports all the transactions on the purchase ledger for the columns displayed on the screen.

      • If you wish to see all columns available on your export, you have to add all columns in the configure column option.

        • The current limit is set at 500,000 rows to protect the performance.

        • You can run several exports at the same time, even from the same screen and you'll be notified individually as each one is completed.

    • Export to Excel Current View - Exports the currently displayed or loaded transactions and columns, the default is to load 100 transactions.

      • If you wish to see all columns available on your export, you have to add all columns in the configure column option.

      • Once you scroll past the 100th transaction, this loads another 100 transactions. This is done to make sure that you don't come across any performance issues when you have hundreds of thousands of records.

Hide Grouping

  • You can select to group by any column when this option is on by dragging a column into the drag and drop columns header for grouping field.

  • You can group multiple columns.

  • You can turn this option off to allow for more space for your transactions by clicking on Hide Grouping.

  • You can turn grouping back on by clicking on Show Grouping.

The Grid

  • Default columns are displayed when the Enquiry screen opens. You can change by manually dragging and dropping the columns to where you want them or alternatively you can customise your columns using the Configure Columns.

  • Each column is sortable, and you can sort on multiple columns at the same time.

    • To sort on multiple columns, hold down the Shift key on your keyboard and click on the column you want to sort.

  • You can filter on all of the columns by pointing to the column label and clicking on the

    image.png

    icon to open the filter window.

  • You can increase and decrease the column width and the settings are saved for you so you to only have to do this action once.

  • The Totals at the bottom right-hand side of the screen are made up of the Net, VAT, Gross and Outstanding values of the displayed transactions.

    • When you select a transaction which has a different currency to your database's currency, you can see a currency switcher in the Totals section at the bottom of the enquiry screen.

  • You can open the detail lines on a transaction by selecting the arrow

    image.png

    in front of a transaction.

  • You can change the configuration of the columns displayed for the Detail line from the Cog

    image.png

    which is at the end of the detail section.

Hyperlinks - Account Code and Account Name

  • You can click on the hyperlinks on the account code or supplier name to view the supplier record. The record opens in View mode and if your security permissions has edit permissions, you can edit the supplier.

    • If you don't have access to edit supplier records, instead of an Edit button, you will see a Close button on the supplier record.

Action Panel -
Access Corrections and other options

  • Select the checkbox in front of a transaction to open it.

  • The Action Panel automatically opens on the right-hand side of the screen where you can access action cards.

  • The Actions tab displays all action cards that are available for your security permissions.

  • The Notes tab, you can add notes for the selected transaction. You can only select one transaction at a time. For more information on how the action panel works, please refer to access the action panel from enquiries.

  • On the Documents tab, you can upload, download, preview, delete, and view a list of documents for a transaction. For more information on how to use documents, please refer to Documents.

  • You can close the Action Panel by clicking on the

    image.png

    icon in the middle of the panel. You can also open it again manually by clicking on the

    image.png

    icon on the right-hand side in the middle of the Enquiry screen.

Did this answer your question?