Printing Creditor Remittance Advices
Reports > Creditors Reports > Creditor Remittances
Use the Remittance Advices window to print remittance advices for a single Creditor or all Creditors, for the current period or the last period. A remittance advice contains a summary line for each Creditor, giving totals for the current month and past three months, and balance. It also contains a detailed list of each transaction that make up those balances. You can drill down to view any Creditor invoice.
To print creditor remittance advices:
-
Choose the Statement date.
-
Choose whether to print one or more statements for This Period or the Last Period.
-
You can click
to display
more search options. -
Complete these fields:
Field
Description
Account Selection: From and To Accounts
The range of accounts on which to filter the search. Use the same account number in both fields to select the statement of a single Creditor.
Balances: From and To
The range of balances on which to filter the search. For example, you might decide it's not worth the postage to send out statements with a balance of less than $5.
Include Accounts with: Zero Balances
Select this option to include accounts with zero balances.
Include Accounts with: Credit Balances
Select this option to include accounts with credit balances.
Include Accounts with: Inactive Status
Select this option to include accounts whose Active option is not selected.
Include Accounts with: Current Activity regardless of account balance
Select this option to include accounts with activity in the current period, regardless of the account balance.
Age Balance
You can generate statements for Debtor accounts with an outstanding balance of a particular age — for example, print statements for accounts with outstanding balances for two months.
Account Group
Select this option to include accounts for a specific Account Group.
Custom Filter SQL
Enter a SQL statement to filter the accounts, using any of the fields in the DR_ACCS table. Select whether to Append the SQL query to the default filter using an AND operation or to Replace the default filter.
Note: When selecting the Replace option, your custom filter must be preceded with an AND or OR operation.
-
Click the Search button to refresh the list with your search criteria.
-
Double click a Creditor account line in the top grid of the window to list the transactions that make up the Creditor's account balance.
-
Double click a Creditor Invoice line in the bottom grid to view the printed invoice.
-
If you have selected multiple Debtors, click the Print All button. If you are printing a single statement, click the Print One button. To bulk send remittances by print and/or email, click Mailshot.
