Accounts Receivable Invoice History Report - Fields

 

Accounts Receivable Invoice History Report

Report Setting

Enter a report setting, or click the Lookup button to list all report settings. The Standard report setting provides a set of default options, sort criteria, and selection criteria for each report.

 

Description

This field displays the description for the selected report setting. Enter a description that describes the output of the report. The description can be up to 60 characters.

 

Type

This field displays the type of access assigned to the report setting. A Public report setting allows access to all users. This includes the ability to access, modify, save, print, and delete the report setting; however, the Standard report setting cannot be deleted. This field can only be viewed.

 

Default Report

Select this check box to set the current report setting as the default report setting. The default report setting is the first report setting displayed when the report is accessed. Clear this check box if you do not want this report setting to be the default.

When a default report setting is not selected, the Report Setting field displays the Standard report setting.

 

Print Report Settings

Select this check box to print the options, sort criteria, and selection criteria for the selected report setting. This information prints on a separate cover page when the report is printed. Clear this check box if you do not want to print the report settings.

 

Three Hole Punch

Select this check box to print the report with a larger margin. This allows enough space for you to three-hole punch the report. Clear this check box if you do not want a larger margin for this purpose.

 

Number of Copies

Select the number of copies to print.

 

Collated

Select this check box to print each copy of the report or form in proper binding order when printing multiple copies. Clear this check box if you do not want to collate the report or form. This check box is available only if the value selected in the Number of Copies field is greater than 1.

 

Sort Report By

Select an option for sorting the report.

Note The Ship To State, Bill To State, and Sales Order Number sort options are available only if the Sales Order module is integrated with Accounts Receivable. If Bill To State is selected, only invoices created in the Sales Order module are displayed.

 

Page Break

Select this check box to print page breaks each time the customer number changes. Clear this check box to print standard page breaks. This field is available only if Customer Number is selected in the Sort Report By field.

 

Print Summary Format

Select this check box to print summary information only. Clear this check box to include all detail information. If the Job Cost module is integrated with Accounts Receivable, clear this field to include the job number and retention amount on the report.

Note A summary report provides only the invoice number, invoice date, customer number and name, salesperson number, and invoice total for each invoice. If line information is to be printed, the item code, description, quantity, unit price, and extension are provided. A detail listing provides full bill-to and ship-to address information for each invoice, including the general ledger account and unit cost.

 

Print Split Commission Detail

Select this check box to print split commissions entered in Sales Order for multiple salespersons. Clear this check box if you do not want to print split commissions. This field is available only if the Sales Order module is installed and if the Print Summary Format check box is cleared.

 

Print Tax Detail

Select this check box to print the tax detail. Clear this check box if you do not want tax detail to print on the report.

 

Print Internet Information

Select this check box to print information on the report for invoices generated from orders on the Internet. This information includes the customer type, which indicates whether the order came from a .order or .store customer. Clear this check box to exclude this information.

Note This field is available only if the eBusiness Manager module is set up and the Print Summary Format check box is cleared.

 

Print RMA Information

Select this check box to print RMA information. Clear this check box to exclude this information. You can also include only invoices that were generated as a result of a return by clearing the Print Summary Format check box and selecting this check box.

Note  This field is available only if the Return Merchandise Authorization module is set up and if the Print Summary Format check box is cleared.

 

Print Lot/Serial Information

Select this check box to print lot and serial number information, including expiration dates if they are tracked in Item Maintenance.

Clear this check box to exclude lot and serial numbers.

This field is available only if the Sales Order and Inventory Management modules are set up and lot/serial tracking is activated in the Retain Lot/Serial Item Sales History field in Sales Order Options.

 

Print Line Information

Select this check box to print line detail information. Clear this check box to exclude line detail information.

 

Print Comments

Select the type of comments to print on the report.

  • Select Full to print the entire comment on the report.

  • Select None if you do not want to print any comments.

  • Select Partial to print only the first 50 characters of the comment on the report.

Note  This field is available only when the Retain Comment Lines check box is selected in Accounts Receivable Options.

 

Print Warranty Expiration

Select this check box to print the warranty expiration date. Clear this check box to exclude this information.

Note  This field is available only if the Print Line Information check box is selected and the Enable Warranty Tracking check box is selected in Inventory Management Options.

 

Print Cost Detail Information

Select this check box to print the cost code and cost type information. Clear this check box if you do not want to print the cost code and cost type. This field is available if the Print Summary Format and Print Line Information check boxes are selected, and if the Sales Order and Job Cost modules are integrated with Accounts Receivable (with job information entered in the invoice).

 

Print Bill To Customer Number

Select this check box to print the bill-to customer number. Clear this check box if you do not want to print the bill-to customer number. This field is available only if the Enable Bill To Customer Reporting check box is selected in Accounts Receivable Options.

 

Print Purchase Order Information

Select this check box to print the purchase order number and purchase order required date on the report. Clear this check box if you do not want to print purchase order information. This field is available only if the Purchase Order and Sales Order module are set up and the Print Line Information check box is selected.

 

Operand

Select an operand to limit your selection to a particular value or range of values. When selecting a value using the Lookup button or entering a value directly into the Value field (and moving out of the field), the operand automatically changes to Equal to. Likewise, when selecting a value using the Lookup button for a range or entering values directly into both Value fields, the operand automatically changes to Range.

The following operands are available:

Operand

Operand Function

AllSelects all information for the Select Field.
Begins withSelects only the information for the Select Field that begins with the value entered in the Value field.
Ends withSelects only the information for the Select Field that ends with the value entered in the Value field.
ContainsSelects only the information for the Select Field that contains the value entered in the Value field.
Less thanSelects only the information for the Select Field that is less than, but not equal to, the value entered in the Value field.
Greater thanSelects only the information for the Select Field that is greater than or equal to the value entered in the Value field.

Range

When Range is selected, two Value fields are used. Information is selected that is greater than or equal to the first value entered and less than or equal to the second value entered in the Value fields.


Note Entries in the "From" Value field may change to the entry made in the "To" Value field, if the "From" Value contains a lowercase letter and the "To" Value contains an uppercase letter. This occurs because lowercase letters are greater than uppercase letters. For example, if 01a is entered in the "From" Value field and 01C is entered in the "To" Value field, the "From" Value field changes to 01C.

Equal to

Selects only the information for the Select Field that is equal to the value entered in the Value field.

Not Equal to

Selects only the information for the Select Field that is not equal to the value entered in the Value field.

 

Additional operands are available for date Select fields. The system date is used to calculate the date ranges. When one of the date operands is selected, the Value fields automatically default to the appropriate dates.

You can use commas (,) to separate multiple values; however, if your selection values already contain commas, you must use alternate separators to separate them.

Note When alternate separators are used, the value list must end with the alternate separator character.

The alternate separators include the following:

~ ! @ # $ % ^ & * ( ) = [ ] \ ; " / _ + { } | : < > ?

Note If you enter a value that contains a comma (for example, if a vendor number is 01-SAGE,WEST), then you must enclose the value with an alternate separator (for example, %01-SAGE,WEST%). Because the comma is a separator, if the value is not enclosed in alternate separators, the system can search for two incorrect values (for example, "01-SAGE" and "WEST", instead of "01-SAGE,WEST").

If your company uses commas in item codes, use an alternate separator to select one or multiple item codes.

 

Value

Enter a value based on the operand entered, or click the Lookup or Calendar button to select a value from the list. Multiple values can be entered by using a comma or alternate separators to separate values.

Note If Country Code is an option in the Select field, and your source documents have no value in the Country Code field, the default Country Code entered in Company Maintenance is used as selection criteria for those documents.

You can enter single or multiple values as follows:

Operand

Value

All Selects all information for the Select Field.

Begins with

Multiple values are separated by a comma or alternate separator. An OR condition is assumed.

Ends with

Multiple values are separated by a comma or alternate separator. An OR condition is assumed.

Contains

Multiple values are separated by a comma or alternate separator. An OR condition is assumed.

Less than Only single values are allowed.
Greater than Only single values are allowed.
Range Both Value fields are used to define a range. Only single values are allowed at each Value field.
Equal to Multiple values are separated by a comma or alternate separator. An OR condition is assumed.

Not Equal to

Multiple values are separated by a comma or alternate separator. An AND condition is assumed.

Note If you enter a value that contains a comma (for example, if a vendor number is 01-SAGE,WEST), then you must enclose the value with an alternate separator (for example, %01-SAGE,WEST%). Because the comma is a separator, if the value is not enclosed in alternate separators, the system can search for two incorrect values (for example, "01-SAGE" and "WEST", instead of "01-SAGE,WEST").

 

Printer/Output

Select a printer or output method. The following output methods are available:

 

Keep Window Open After Print

Select this check box to keep this window open after you print. Clear this check box if you want this window to close automatically after you print.

Note The selection for this check box is set by user and workstation.

 

Keep Window Open After Preview

Select this check box to keep this window open after you preview the report or form. Clear this check box if you want this window to automatically close after you preview the report or form.

Note The selection for this check box is set by user and workstation.