Sales Journal Summary by Order Type

How to print: Run a periodic process that includes the SLSSMOT periodic function (program name = PFSLSSUMOT).

Which date? If the Parameter field for the periodic function specifies a date in MMDDYY format, the report includes sales for that date. Otherwise, the report includes sales for the day before the report is generated (current date - 1). Typically, you would include the periodic function in your daily processing, to review sales for the previous day, but you can also use the Parameter to generate the report for any date.

The report can include data for only a single date.

For more information: See the sample report in PDF format.

Note: This report is also available as a spreadsheet file, which you can open in a spreadsheet application such as Microsoft Excel®. See Reports Available in Spreadsheet Format for more information.

Contents:

• Start date/End date: the date when the sales activity took place. The start and end dates are always the same. Can be specified in MMDDYY format in the Parameter for the periodic function; otherwise, the previous system date is used (current date - 1). See above for a discussion.

For each order type that had sales activity:

• OT: The code identifying the order type. The description of the order type is on the line below the summary totals for the type.

Note: Unless indicated otherwise, the following totals are from the Invoice Ship To records.

• TTL: The total number of shipments or returns for the order type on that date, based on the number of Invoice Ship To records.

Note: Each of the following totals are decreased by credit invoices, if any.

• Merch: the sum of all merchandise amounts on the invoice records for the order type. This total is based on item prices and does not include charges for tax, freight, shipping, etc.

• Tax: the sum of the sales tax on the invoice records for each order type.

• Freight: the sum of the freight on the invoice records for each order type.

• Add’l frt: the sum of the additional freight on the invoice records for each order type.

• Add’l chg: the sum of the extra charges on the invoices for each order type. This total may include service charges (for the source code or offer), additional shipper/item charges, guaranteed service charges, or additional charges/credits applied to the order and billed.

• Hnd: the sum of special handling charges on the invoices for each order type. Special handling might consist of monogramming, hemming, alternations, etc.

• Total: the sum of all Invoice Pay Method records for the order type.

• Cost: the sum of the cost amounts in the invoice records for each order type.

• G/P: the dollar amount of profit realized from the sales for each order type. This is calculated by:

 

Total Merchandise Amount - Total Cost for each order type

 

• G/P%: the percentage of gross profit realized from the sales for each order type. This is calculated by:

 

(Total Gross Profit / Total Merchandise Amount) * 100

See Determining Gross Profit for a discussion.

• Def liab: total amount posted to deferred liability for the order type.

• Credit card: the sum of all Invoice Pay Method records for pay category Credit Card for the order type.