Purpose
A sample Account
Transaction Report (sorted by Type) and description of the fields are listed
below.
Note: The sample
report may differ from the actual report. The options used to configure the
report will determine the actual output of the report.
Figure
8.121 Sample Account Transaction by Type Report
|
|
|
|
|
|
|
|
|
|
Account Transaction for
3/3/200X
|
|
|
Focus Cafe
|
created
at 3/6/200X 12:04:46 PM
|
Page 1 of 1
|
|
Date
|
Time
|
Check
|
Amount
|
Employee
|
Account
|
|
|
Purchases
|
|
3/5/200X
|
12:17
|
2
|
9.58
|
Installer I.
|
7842784 (Kovo, Matt)
|
|
|
3/5/200X
|
12:32
|
3
|
54.99
|
Installer I.
|
7842547 (Baker, Becky)
|
|
|
Total
|
|
64.57
|
|
|
|
|
|
|
|
|
|
|
|
|
Payments
|
|
|
|
|
|
|
|
3/4/200X
|
17:09
|
|
-75.00
|
Installer I.
|
7842784 (Kovo, Matt)
|
|
|
3/5/200X
|
12:32
|
|
-554.99
|
Installer I.
|
7842547 (Baker, Becky)
|
|
|
Total
|
-629.99
|
|
|
|
|
|
Net Amount
|
-565.42
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Figure 8.122 Sample Account Transaction by Type Report Fields
|
Transaction
Type
|
Field
|
Description
|
|
Purchases
|
|
Date
|
The Date the Purchase occurred.
|
|
Time
|
The Time the Purchase occurred.
|
|
Check
|
The Check associated with the Purchase.
|
|
Amount
|
The Amount of the Purchase.
|
|
Employee
|
The employee that authorized the Purchase.
|
|
Account
|
The Account Number for the Purchase. If the Account Number is blank
then the customer’s last name followed by a slash and then first name are
displayed.
|
|
Total
|
|
Amount
|
The sum of all the Amounts.
|
|
|
|
Payments
|
|
Date
|
The Date the Payment occurred.
|
|
Time
|
The Time the Payment occurred.
|
|
Check
|
Not Used.
|
|
Amount
|
The Amount of the Payment. Payments are displayed as a negative
value.
|
|
Employee
|
The employee that authorized the Payment.
|
|
Account
|
The Account Number for the Payment.
If the Account Number is blank then the customer’s last name
followed by a slash and then first name are displayed.
|
|
Total
|
|
Amount
|
The sum of all the Amounts.
|
|
|
|
New
|
|
Date
|
The Date the New Account was created.
|
|
Time
|
The Time the New Account was created.
|
|
Check
|
Not Used.
|
|
Amount
|
The initial starting balance of the New Account.
|
|
Employee
|
The employee that created the New Account.
|
|
Account
|
The Account Number associated with the New Account. If the Account Number is blank then the customer’s
last name followed by a slash and then first name are displayed.
|
|
Total
|
|
Amount
|
The sum of all the New Account Amounts.
|
|
|
|
Net Amount
|
Total Purchase Amount plus New Account Total Amount (initial balance)
minus Total Payments Amount.
|
Figure 8.112.1 Sample Account Transaction by Type Report Setup Options
|
Fields Used
|
Description
|
|
Sort
|
Type
|
Related Topics (none)
Sample Account Transaction Report (by Type)