Print this report to view a list of all invoices sent to your bill-to customers during a specified period. You can send this report to the customer each month in lieu of separate invoices or a statement, if needed. The report provides detailed information about the products on each invoice, and, depending on the options you select, may also include:
A grand total for each of a customer's ship-to addresses.
Separate pages for each bill-to customer.
Separate pages for each ship-to customer.
The system determines the remit-to address based on the entity specified in the
Note: Totals calculations excludevalues on consolidated invoices, so the totals listed are for line item products on the orders, but not the combined totals on invoices that have been consolidated for invoicing. This prevents a total from including a product more than once.
To run the Product Consolidated Invoices Report:
From the Reports > End of Month Reports #2 menu, select ProductConsolidated Invoices Report to display the Product Consolidated Invoices Report window.
In the Branch field, enter the number that identifies the branch or territory for which to view invoices. To view invoices for all branches and territories, enter ALL.
In the Start Date field, enter the first date in a range of dates for which to view invoices. This field supports variable dates.
In the End Date field, enter the last date in the range of dates for which to view invoices. This field supports variable dates.
The system populates this field with the date entered in the Start Date field, but you can change it, if needed.
In the Bill-To Customer field, do one of the following:
To run the report for one bill-to customer, enter a bill-to customer name.
To run the report for all bill-to customers, leave the field blank.
In the Sort By field, enter one of the following to indicate how to sort the invoices on the report: P/O, Writer, Release #, or Invoice #. The default is P/O.
In the Price Line field, indicate which price line for which you would like to run the report. To run the report for more than one price line use the Multi button. *Multi* displays in the Price Line field.
In the Detail/Summary field, select one of the following to determine the level of detail to print on the report:
Detail - Lists the invoice details for each invoice in the Qty Shipped and Extended Amount columns. This is the default value.
Summary - Prints only the subtotal and total fields for the Qty Shipped and Extended Amount columns.
In the Page on Ship-To (Y/ field, select one of the following:
Y - To insert a page break between each ship-to account. Selecting Y prints totals on each page.
N - To print without page breaks. Selecting N also prints grand totals print for each bill-to address.
See Also:
Completing Tasks Not Available in Solar