Sales Consolidated Invoice Report ranges and options

Ranges

SeeReports - Ranges overview.

Options

Enter List of Invoices to Reprint?
Specify Yes to enter a list of order numbers to reprint. Click List to display the Order List window. This option overrides any ranges that you specified.
Consolidate Unprinted Invoices Only?

Specify Yes to include only those orders that have not been printed in the consolidation.

Note: If you printed invoices due for consolidation from the Sales Demand Invoices Report by entering a list of invoice numbers, they are not consolidated.

Specify No to consolidate all orders that meet the other criteria, including orders that have already been printed.

Consolidate Order Credits?

Specify Yes to include orders with negative totals that fall within the consolidation period in the consolidated invoice.

Specify No to print orders with negative totals as separate invoices after the consolidated invoice is printed.

Note: The data summary on the report is not a statement. It is a report of the activity during the consolidation period.
Consolidate Paid Orders?

Specify Yes to include non-credit orders paid in Customer Cash Receipt Entry or tendered in Sales Order Entry in the consolidated invoice.

Specify No to exclude those types of paid orders. Partially paid orders are in the Invoiced stage and do not apply, but the payments are included in the totals. The summary report section displays an invoice total followed by a payments applied line. If a payments-applied line is displayed, a net amount line is displayed after the payments to reflect the actual consolidated invoice total.

All RM orders that have not been consolidated are included when the report is run, regardless of these factors:

  • The date on the RM
  • Whether the credit that was generated by the RM was applied to the invoice

If the credit has been applied, the amount from the RM is not included in the Payments/Ord Credits or Net amount on the report. After RMs are included in a consolidation, they are not included again.

Posting Date?

Today's date defaults into the Posting Date?. It does not affect the Posting Period. The Posting Date can be overridden, but should correspond to the Posting Period.

The posting date is assigned to these transactions that are created during the session:

  • Accounts Receivable
  • Inventory Control
  • General Ledger history

The posting date should correspond to the posting period. The date is also the invoice date on the order.

To back-date up to 7 days, specify -1 to -7 for the day. For example, if you specify **/-7/**, the current date less 7 days for the date.

Posting Period?

Specify the current General Ledger posting period. You can only post a journal to one period at a time. The Posting Period is based on this hierarchy of settings in SA Administrator Options-Financials-Period Structure:

  1. Current period only
  2. First Valid Period and Last Valid Period
  3. Periods Forward and Periods Backward

If Current Period only is selected, you can only post to the current period. If it is not selected, the First Valid Period and Last Valid Period fields are checked to determine the correct Posting Period range. If valid periods are not specified, the Periods Forward and Period Backward fields are used.

If you manually override the Posting Period and you use a calendar or fiscal year, the valid periods are 1-12 within the previously-explained boundaries. If you use a 13-period GL year, the valid periods are 1-13. To go back one period, specify -1 in this field.

Print Promotion Message (in Title)?

Select Yes to print the value in the Report Title field on the Information page as a promotional message.

Unless you run a stored report, you must specify the promotional messages each time you process consolidated invoices.

Print to EDI Where Appropriate?

Specify Yes to use EDI to transmit the consolidated invoices to customers.

EDI must be selected in the Invoices field in the eCommerce view on customer and ship to setup records. A flat file is created automatically in the EDI format that is specified in SA Administrator Options-Documents-Sales Orders-Printing. The Partner Code for the customer or ship to is used, depending on whether the invoice is billed to the customer or ship to address.

Print to Email-Fax Where Appropriate?

Specify Yes to send a copy of your customer’s invoice by email or fax.

Email or Fax must be selected in the Invoices field in the eCommerce view on customer and ship to setup records. The email address or fax number from the customer or ship to records is used to generate and transmit the invoice.

Note: On the Information page, you must specify Print in the Print Type field and then specify a valid printer device, or this option is ignored. If Email or Fax is specified, this option is ignored. The invoice is sent to the email or fax that is specified on the Information page.

If Hard Copy is selected for the invoice printer in SA Company Setup-Faxing, the invoices are printed for your files.

To fax multiple copies, the value in the Invoice Copies field in Customer Setup must be greater than 1.

When you fax a batch of sales orders, one cover page and one fax per fax number are sent.

Suppress "Duplicate" Message?

Specify Yes to not print the Duplicate on the invoice header when you reprint invoices.

Honor Customer Number of Copies?

Specify Yes to print the number of copies that have been set up for the customer.

Specify No to print only one copy of the invoice.

EDI Flat File Directory?

Specify the directory in which to save the EDI flat files. If you do not specify a value, the files are saved to the Outbound EDI directory that is specified in SA Company Setup.

Printer for Consolidation Report?

Specify the printer name to which the report should print, or click Printer Options. Each time invoice processing is completed, an exception report prints. Each message is associated with an order number, product, customer number, or ship to, to help you identify the problem.

C)onsolidate, F)ulfillment or B)oth

Specify one of these options to determine the types of order to process:

  • C: Consolidates orders, based on the consolidation settings on customer and ship to setup records
  • F: Consolidates tied fulfillment orders, based on the billing code and stage on the original fulfillment orders
  • B: Consolidates both types of orders