Sales Invoice Register Report ranges and options

Ranges

Options

(I)nv #, (C)ust #, or Cust (N)ame Order
This option applies to the Invoice Detail section of the report. Specify:

(I)nv # to print invoices in invoice number, which is the same as the order number.

(C)ust # to print in customer number.

Cust (N)ame to print in customer name order.

Use Actual Rebate Amount at Recon?

Specify whether you want to use the actual rebate received from the vendor to calculate margin and margin percentage instead of the expected rebate from the order header.

Select Yes and the reconciled rebate is used. If the rebate has not been reconciled, the expected rebate is used.

If all lines have been reconciled (reconciled rebate), rr is printed next to the margin.

If part of the lines were reconciled (partial rebate), pr is printed.

If the lines were not reconciled, nr is printed.

Select No and the expected rebate is subtracted from the cost of goods sold even if the rebate has been reconciled and changed. The letters er are printed next to the margin to indicate expected rebate. This is the rebate amount from the order header and is the rebate amount you think you are going to receive.

Register report differences: If you select No, the cost of goods sold and margin may not match. If you select Yes, the sales representative and category may not exactly match because the sales order line (OEEL) records are used to accumulate data for these categories. The sales order header (OEEH) records are used to total the invoice, customer type, and warehouse totals and will match Sales Invoice Register Report values.

Sub-Total Invoices By Currency?
If you select Yes, the banner displays the currency type and exchange rate, and the report is sorted by currency first, then your selected sort order. The detail section includes two totals, one domestic and one non-domestic (no exchange rate applied). These totals are subtotals by currency type. Invoicing totals are shown as domestic but are displayed after each currency type. Grand totals are domestic (with exchange rate applied) and are displayed after all the invoices and domestic invoice totals.

If you select No, totals are domestic (or calculated based on exchange rate).

Warehouse, customer type, product category, and sales representative only display domestic totals.