Account Transactions Report

The Account Transactions report enables you to view the details of transactions completed over a specified range of date.

To generate account transactions report:

1. In the RPM menu, click Reports, and then click Accounts.

2. Select Account Transactions.

The Account Transaction Report dialogue is displayed.

3. Set the Start Date and End Date of the account transaction.

4. Select the account type to view the transaction reports.

All Accounts: This option displays the transactions of all the accounts.
Accounts in Class: This option displays the transactions of accounts within the selected account class. Select the appropriate class from the drop-down list.
Individual Account: This option displays the transactions of an individual Customer. Select Account and then search and select the individual account from the All Accounts dialogue box.

5. Select View Report to view the report.

The Account Transaction report is generated.

Sample of Account Transactions Report

The fields displayed in the sample report can vary depending on your selection. The items displayed have been described in the table below.

Columns	Descriptions
Date	The date of the account transactions.
Invoice #	The invoice number of the transaction. This is a unique, sequential code that is systematically assigned to invoices. The number can be found in the LOTS Audit trail and in LOTS Debtors.
Store Name	The name of the Store where the account transaction has happened.
Account #	The unique ID of the account.
Account Name	The name of account holder.
Description	The description of the items charged. If a payment is received, then the description is displayed as ‘Payment received’.
Qty	The quantity of the item.
GST	The GST amount charged on the Product.
Amount	The amount charged for all the items, calculated as: Item Price (Including GST)×Qty.
Payment	The payment made to the account.