Reason

When dealing with significant numbers of Creditor Payments or reviewing past Payment Batches, it is possible to sort Payment Batch tables in various ways and exclude payment amounts with negative value.

Prerequisites

How to Create a New Creditor

How to Create an Expense

How to Run Payment Batches

Solution

Working with existing Payment Batches

  1. Go to Accounting >> Accounting Form >> Money Out >> Payment Batch
  2. Set up the Filter to search:
    • For Creditor
    • For Sites
    • Show Batches From and To
  3. Click Get Data

  1. Click on the icon to open the Payment Batch
  2. On the Creditor Payment Batch page, Click on View Creditor Totals
  3. On the Creditor Payment Totals page, click on  Creditor Name or Total to Pay to sort in ascending or descending order

Sorting and Managing a New Payment Batch

Filtering and Sorting the New Payment Batch
  1. Go to Accounting >> Accounting Form >> Money Out >> Payment Batch >> New Payment Batch
  2. You can refine the payment included in the new Payment Batch by applying filters based on the following criteria :
    • Pay Creditor(s)
    • Payment Site
    • Bank Account
    • Restrict to Items from and to - Dates
    • Restrict to this sites transactions only
    • Show excluded Expenses
    • Show Items that are on Hold
  3. If necessary, there is the option to modify the Payment Date. After configuring the desired filters, proceed by selecting Get Data

  1. To assist in reviewing items in the New Payment Batch, you can click on each column header to sort in ascending or descending order

  1. Click on View Creditor Totals to see the amount that is going to be paid to each Creditor
Removing Creditors with Negative Values
  1. Click Remove Creditors with Negative Totals to eliminate negative values >> Click Yes on the confirmation screen.

  1. The payment rows will now be displayed with the negative values removed

Reviewing Expenses & Removing Payments from the New Batch
  1. Click on the icon to review the Expense.  Changes can be made if required
    Note: If the Expense is related to a Commission Batch, you are unable to Edit the item from this screen.  You will need to review the Commission Batch.  For more information see Managing Commissions
  2. To Remove an Expense from the Payment Batch click the icon on the relevant row
    Note: This action does not Delete the Expense, but rather removes it from being paid in this batch
  3. Once you have completed reviewing your New Payment Batch, click Save

  1. The Payment Batch will be generated and can be viewed in the Payment Batches search table

 


Updated:20-Feb-25

Copyright © 2024 Gensolve Pty Ltd