Order Entry > Screen Guides > Statistics and Inquiries > Sales Statistics

O/E Sales Statistics Screen

Learn more

About Sales Statistics

About Transaction History

O/E Sales Statistics Report Screen

O/E Sales History Screen

ClosedTo open this screen

Open Order Entry > O/E Statistics and Inquiries > Sales Statistics.

ClosedFields and controls
ClosedButtons
ClosedDelete

Click Delete to delete all sales statistics for the selected year, period, and currency.

ClosedRefresh

Click Refresh to update the sales statistics for the selected year, period, and currency in the Sales and Invoices and Credit/Debit Notes detail tables.

ClosedSave

Click Save to save changes you have made to sales statistics for the selected year, period, and currency.

Note: You can add and edit sales statistics only if you selected the Allow Edit of Statistics option on the O/E Options screen.

ClosedCurrency

If you use multicurrency accounting, select the currency in which you want to add or view statistics. You can add statistics in the customer's currency or in your company's functional currency.

ClosedPeriod

Select the period for which you want to add or view statistics.

Note: You specify on the Processing tab of the O/E Options screen whether to accumulate sales history and statistics by calendar year or fiscal year, and the period type to use.

ClosedYear

Select the year for which you want to add or view statistics.

Note: You specify on the Processing tab of the O/E Options screen whether to accumulate sales history and statistics by calendar year or fiscal year, and the period type to use.

ClosedInvoices, Credit Notes, and Debit Notes table

This table displays statistics for invoices, credit notes, and debit notes for the selected year and period.

If you use multicurrency accounting, statistics appear in the customer's currency and your company's functional currency.

ClosedAverage

Displays the average amount of invoices, credit notes, and debit notes posted during the selected year and period.

ClosedCustomer

Displays the customer number of the customer to whose account the document in the preceding row (that is, Largest or Smallest) was posted.

ClosedLargest

Displays the amount of the largest invoice, credit note, and debit note posted during the selected year and period.

Note: The customer number of the customer to whose account the document was posted appears in the Customer row below this field.

ClosedNumber

Displays the number of invoices, credit notes, and debit notes posted during the selected year and period.

ClosedSmallest

Displays the amount of the smallest invoice, credit note, and debit note posted during the selected year and period.

Note: The customer number of the customer to whose account the document was posted appears in the Customer row below this field.

ClosedSales table

This table displays sales statistics for the selected year and period.

If you use multicurrency accounting, statistics appear in the customer's currency and your company's functional currency.

ClosedAverage Sales Lost

Displays the average amount of lost sales for the year and period.

Sales amounts are lost when you make either of the following changes (whether or not quantities were shipped):

  • Reduce amounts in the Quantity Backordered field on an order without reducing the amount ordered.
  • Cancel an order that had quantities entered in the Quantity Backordered field.

When you enter or edit statistics, Order Entry calculates average sales lost from the figures you enter.

When an order is complete, information about lost sales is updated during Day End Processing and reported as lost sales on the O/E Sales Statistics report.

ClosedCost of Sales

Displays the total cost of goods sold on invoices less the total cost of goods sold on credit notes.

Note: To view this field, you need Cost Inquiry authorization in Inventory Control.

ClosedMargin Percent

Displays the calculated profit (margin) percentage for the year and period. When you enter or edit statistics, Order Entry calculates this percentage from the figures you enter.

ClosedNet Invoice Amount

Displays the total invoice amounts (including taxes) for the year and period.

ClosedNet Quantity Sold

Displays the number of units of items shipped on invoices less the number of units returned on credit notes.

ClosedNet Sales Amount

Displays the total sales amounts on invoices (excluding taxes and miscellaneous charges) less the total sales amounts on credit notes.

ClosedNumber of Orders

Displays the number of sales orders posted during the selected year and period.

ClosedTotal Sales Lost

Displays the total of all quantities ordered that will not be shipped, multiplied by their unit prices.

ClosedRelated tasks

Overview

Use the O/E Sales Statistics screen to:

If you selected the Keep Sales Statistics option on the O/E Options screen, Order Entry keeps sales statistics for posted orders, invoices, credit notes, and debit notes.

You can review statistics for all years and periods for which you keep this information by printing the O/E Sales Statistics report.

Last published: 4/8/2016