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. |
