Sales Summary (DSSS)

Purpose: Use the Sales Summary screen to view the number and dollar value of shipments processed:

• for the current day, week, and month

• broken out by order type and entity

Updated continuously: The totals displayed are based on the Invoice Ship To records created when you ship orders. When the BILL_ASYNC job is running, it creates these records as part of initially billing an order. These updates are not deferred based on the setting of the Delay Billing Updates (K85) system control value.

In this topic:

Calculations

Sales Summary Screen

Calculations

Which invoices are included? The totals displayed on this screen include Invoice Ship To records for regular (debit) invoices and their merchandise totals only. This screen does not include:

• Returns, credits, or discounts applied after shipment

• Freight, tax, handling, or other charges

• Any invoice with a merchandise total of $0.00

How is the invoice date determined? This screen organizes shipments based on the Invoice date from the Invoice Ship To record. This date is from the Start date from the BILL_ASYNC job. If the background jobs are running using a previous date because they are not stopped and restarted daily, then the invoices billed today are included under that previous date, not under Today.

How is the number of sales calculated? The total number of sales for a period, order type, or entity is from the total number of Invoice Ship To records billed. This total:

• Excludes (is not net of) credit invoices, such as an invoice created by processing a return. For example, if you process 1000 shipments, 50 returns, and 10 discount credits after shipment, the total displayed here is still 1000.

• Does not include any invoice with a merchandise total of $0.00.:

How is the sales amount calculated? The total sales amount for a period, order type, or entity is from the total dollar value of merchandise billed for the period, based on actual selling price. This total:

• Excludes (is not net of) returns, credits, or discounts applied after shipment.

• Does not include freight, tax, handling, or other charges.

• Includes a two-position decimal.

Sales Summary Screen

How to display this screen: Enter DSSS in the Fast path field at the top of any menu, or select the Sales Summary option from a menu.

Field

Description

Current day, week, and month totals

The top portion of the screen displays totals for the current day, week, and month.

Period

Periods are:

Today = The current date.

This week = The current week runs from Monday through Sunday, and the totals displayed include all days so far for this period.

Note: The calculation of totals for This week occurs regardless of whether a new month starts during the week.

Example: Today is Sunday June 3. The totals displayed under This week include Monday May 28 through the current date.

This month = The totals for the current month to date.

Note: See the note above on how invoice date is determined.

Number

See the Calculations above for a discussion.

Amount

See the Calculations above for a discussion.

Order Type totals for today

The Order Type tab lists the current day’s total number of Invoice Ship To records and dollar amounts for each order type in your company, except for quote order types.

Note: See the note above about how invoice date is determined.

Order type

The code identifying the order type. The description of the order type follows, separated by a hyphen.

Order types are defined in and validated against the Order Type table. See Establishing Order Types (WOTY) for more information.

Quote order types are not listed here, since it is not possible to bill merchandise for a quote. See Entering Pre-Order Quotes for background.

Number

See the Calculations above for a discussion.

Amount

See the Calculations above for a discussion.

Entity totals for today

The Entity tab lists the current day’s total number of Invoice Ship To records and dollar amounts for each entity in your company.

Note: See the note above on how invoice date is determined.

Entity

The code identifying a business entity within your company. The description of the entity follows, separated by a hyphen.

Entities are defined in and validated against the Entity table. See Working with Entities (WENT) for more information.

Number

See the Calculations above for a discussion.

Amount

See the Calculations above for a discussion.

DSSS OROMS 5.0 2018 OTN