Skip to main content

Next Generation - The Allocations screen

The Allocations screen uses the same screen that we use for our record lists and enquiries. Click on enquiry screens explained for more general information on the functionality of the screen.

The term Allocation is used to describe the process of matching related transactions. Each time an allocation is made, a transaction for both sides of the allocation gets created which enable the Aged Credit reports in Creditors to give an accurate picture of any period.

As the Allocations screen is also a processing screen, there are a few differences which are listed below:

  • There is no Action Panel.

  • There is a Process button at the bottom of the screen.

  • Setting a transaction on dispute removes the processing checkbox from in front of the transaction.

  • The screen opens blank ready for you to add in the supplier record you want to work with.


You can access the Allocations screen from some transactions when you tick the Allocate Now option on the Save Options screen which opens after you have clicked Save on any transactions, or you can access directly from the Navigator.

  • When accessing from a transaction, the supplier and the transactions to allocate will be automatically pulled through for you.

  • When accessing directly from the Navigation menu, you can enter the supplier you want to work with on the Advanced Filters panel.

Access Allocations from a transaction

  1. Click Creditors then click Transactions.

  2. Select Invoice and you can enter the supplier account code. If you're unsure of the code, you can click the drop-down arrow and select Show More which displays several more records and offers you to search the code and name of the supplier.

  3. Enter the details then click Save.

    • Note: Don't worry, your transaction is not going to be posted just yet. Saving on the transaction screen takes you to the Save Options screen first where you can select from different options.

  4. Select Allocate Transaction Now.

  5. Click Save.

    • Note: The Cash Allocation screen will open for you with your supplier and transaction displayed.

Access Allocations from a the navigation menu

  1. Click Creditors then click Allocations.

  2. Type in or search for the supplier you wish to work with on the Advanced Filter panel. If you're unsure of the code, you can click the drop-down arrow and select Show More which displays several more records and offers you to search the code and name of the supplier.

  3. If you are using Multi Entity, enter a sub ledger and click Apply at the bottom of the panel.

  4. If you are not using Multi Entity, click on Apply at the bottom of the panel.

  5. Your selected supplier's transactions are displayed for you.

Some transactions are automatically allocated on posting. When using Remittance BACS or Remittance Cheques, the allocation of the invoice and the payment will be done through the processing of the remittances.

For more information on what happens when you have selected the transactions you want to allocate and have clicked on the Process button, please refer to our update allocation processing article.

Allocations default screen

Options

Description

Reverse Allocation

  • A toggle option that gives access to the Reverse Allocation screen where you an unallocate allocated transactions.

  • Permission driven and if you don't have permission to access Reverse Allocations, the toggle button will be visible, but disabled.

Advanced Filters

image.png
  • The Advanced Filter panel opens automatically when you open the screen and can be closed clicking on

    image.png

    at the top of the panel.

  • To view any transactions, you need to populate the Supplier field first and then click on the Apply button to update the screen.

  • The funnel icon

    image.png

    on certain fields opens access to more filter options.

  • The Advanced Filter panel automatically closes as soon as you click Apply or Save and Apply to provide you with more real estate for your transactions.

  • You will only see the Currency field displayed when you locate a currency supplier or any currency supplier.

  • For more information on how to best use the Allocation Advanced Filter, please refer to the how to best utilise the searching topic further down.

Search

  • You can search on the Reference or the Description fields.
    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.

How to best utilise the searching

Filter Options

Description

Invoice & Debit Adj. Date

  • When using this filter option, you can search on the dates of invoices and debit adjustments. All invoices and debit adjustments will be listed together with the other transaction types as the list is ordered based on the Audit Number of the transactions.

  • You will also see the other transaction types not just invoices and debit adjustments being listed and these will not be affected by the date filtering.

  • Example:

    • You search for invoices that fall between the 1st and the 5th of the month and you enter this filter criteria on the Advanced Filter panel in the Invoice and Debit Adj. Date.

    • The grid will display all invoices raised between those dates, but it will also pull through any other transaction types.

    • This is because the grid displays the transaction ordered by the Audit Number.

    • If you have entered an invoice and then a credit note on the 1st of the month one after the other, the credit note will get the consecutive audit number after the invoice, so this will also be displayed on the grid.

Other Transaction Type Date

  • This will do the opposite of the above, meaning that it will sort on the Audit Number, and the other transaction types will be listed that fall into the filter criteria you have specified, while invoices and debit adjustments won't get affected.

Search on all transaction types based on the Date

  • You can search for all transaction types by using both filter options together.

  • The displayed transactions will be in the order of the Audit Numbers assigned to the transactions.

Invoice & Debit Adj. Year/Period From and To

  • The same rules apply as described above for when you use the Date filter.

  • The filter applies to invoices and debit adjustments, but the other transaction types are also listed ordered by the Audit Number.

Other Transaction Types Year/Period From and To

  • The same rules apply as described above for when you use the Date filter.

  • The filter applies to the other transaction types, but invoices and debit adjustments are also listed ordered by the Audit Number.

Search on all transaction types based on the Year and the Period

  • You can search for all transaction types by using both filter options together.

  • The displayed transactions will be in the order of the Audit Numbers assigned to the transactions.

Invoice Number

  • The Invoice Number filter criteria brings back the relevant invoices that match the filter criteria and also all other transactions are displayed based on the Audit Number.

Header Reference

  • The Header Reference filter criteria brings back only the transactions that matches the Header Reference.

The Allocations grid

  • You must locate a supplier before you can display any transactions.
    Note: When Sub Ledgers are enabled on your database and set as compulsory, you will also have to provide the Sub Ledger on the filter.

  • The Year/Period From and To defaults to All, and can be changed manually.
    You can rearrange the default columns, for more information please refer to configure columns.

  • For home currency suppliers, all values are displayed in the home currency.

  • For currency suppliers all values will be displayed in the currency of the supplier.

  • For any currency suppliers all values are displayed in the home currency by default. You can select a specific currency which will then display only the transactions which match that currency with the relevant currency values.

  • For suppliers where you have changed the default currency, all values for all transactions entered with the new and the old currency are displayed.

    • You can check the currency of the transaction on the Currency column.

Did this answer your question?