Sales Invoice Register Report overview

The information is accurate if you have not deleted any of the orders from the file. The Sales Invoice Register Report adds specific totals from each of the orders to give you a grand total from which you may develop analysis information.

These sections are printed on the report:

• Invoice Detail
  Each order within the Order # and Date range is printed with specific sales, returns and cost and margin amount and percent figures. The margin percentage is calculated as:

  (margin/(net sales - returns)) * 100

  Return Merchandise (RM) transactions are shown in the Net Sales Returns Column on the report. If any discounts were adjusted on the RM, they are not included in the discount calculation.

• Invoicing Totals

  These totals contain total sales and cost information from all orders selected to print. The invoicing totals can be directly related to the General Ledger totals that print each time Sales Entry Processing Invoice Processing Report is completed. This is especially true if all the orders that print were invoice processed at the same time. Non-taxable types are at the line item level, so they are included under Nontaxable Net Sales. Tendered COD cash is applied to the COD receivable total.

• Warehouse, Customer Type, Salesrep, and Product Category Totals.

  Each of the four sections print on a separate page. The exact sales and cost information print for each section. The information is grouped by warehouse, customer type, sales representative, and product category.

  The stocking unit fromProduct Setup is always considered to be a single (1) unit. If the selling unit that is specified in Product Setup or a different unit of measure is specified on the line item, these units are used instead of the stocking unit for rounding purposes.

  Differences may exist in totals from each section. This is due to the fact that the current Unit Conversion factor in Product Setup is used to calculate net amounts, not the conversion factor that was available at the time the order was entered.

  Customer and/or vendor rebates are included in margin calculations for the Invoice Detail, Warehouse Totals, Customer Type Totals, Salesrep Totals, and Product Category Totals depending on your SA Administrator Options-Sales History-Rebates/Basis options, Subtract Customer Rebate from Price and Subtract Vendor Rebate from Cost.

  The Cost in the Invoicing Totals section also includes rebates. If the customer or vendor rebate is subtracted, an R is displayed in the Invoice Detail section next to the Margin %. The R is not included in the totals sections, even if rebates have been used in the calculations of costs and margins. Rebate amounts are listed on the Sales Order Master List Report Other Line Information section, and the SM Rebate Report.

  Costs and margins do not display if you do not have security in SA Operator Setup to view costs. The cost specified for the SA Administrator Options-Products-Costs Post to S/M By option is reported on the invoice register.

  Foreign Customers: All currency totals appear in both the domestic and foreign values.