Click Go to run the report.This report lists sales and receivable transactions on a client by client basis.
The following information is listed for each Client included on the report:
Job Id Invoice Id Invoice Date Payment Due Date Description
Transaction Type Transaction Id Effective Date
Debits Credits Balance Retainage Transaction Description
Customer and Report totals are also included.
Report Options:
The Report Options selector pane controls how the report will be output. Click Report Options to learn more.
Range:
Enter a unique, alphanumeric name to save and identify your customized report Range. Ranges are defined by the contents of the ID field(s).
Hint: You can create user-defined report ranges that are available to all users with access to that report. To do so, the first character of the named range should be an asterisk. Named ranges beginning with an asterisk will appear on all users' report ranges options so that they can be selected (but not altered) by any user with access to that report. Only the user that created the report range is allowed to alter it.
Client Id:
If you only wish to list history for a specific Client, enter the Client Id. Several Clients may be listed by entering their Id's separated by commas (Acme,Megahome,Zorro). A range of Clients can be defined by the first and last items of the range separated by an underscore (Megahome_Zorro).
Job Id:
If Jobs are implemented on your system, you can list the history for a specific Job by entering its Id. Several Jobs can be specified by entering their Id's separated by commas (1005,1007,1020). A range of Jobs can be defined by the first and last items of the range separated by an underscore (1010_1015).
Invoice Id:
You can list the history for a specific Invoice by entering its Id. Several Invoices can be specified by entering their Id's separated by commas (1005,1007,1020). A range of Invoices can be defined by the first and last items of the range separated by an underscore (1010_1015).
Effective Date
To only show transaction history for a specific effective date, enter it in yyyy-mm-dd format. Date Ranges: should be entered using the following format: yyyy-mm-dd_yyyy-mm-dd. For example, to show transactions with effective dates in June of 1997, the range would be entered as 1997-06-01_1997-06-30.
Lines:
This informational field displays the number of lines per page for this report under the current font setting.
Multiple Fields
You can optionally enter Id's in more than one field. By default, items will appear on the report only if they fit all the criteria set in the ID fields.
Example: Assume the first ID field is for Clients, and the second is for Invoices. Let's suppose you set these fields as follows:
databasics0001_databasics9999
1004_1020
A receivable will appear in the report only if its Client ID is within the range databasics0001 to databasics9999 and if the invoice number is between 1004 and 1020.
Power-User Reporting Tip:
You may also use the comparison operators >,<, = and ! in your report ranges to control the information output to your report. Click Comparison Operators for details.
Click Go to run the report.