5 Customer Service

Active Procedure Log

Purpose: The system generates this report if you attempt to submit a job when another instance of the job (such as membership generation job) is already active within your company. For example, the system generates this report when you select Generate Orders at the Generate Membership Orders Screen if a GEN_ORDERS job is already running.

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

Contents:

• Co # (Company number): The number identifying the company where the job was running when you attempted to run the same job.
• User: The user who generated the job. This is the User from the Job Management (My Jobs) screen.
• Job #: The Job ID from the Job Management (My Jobs) screen.
• Date: From the Date on the Job Management (My Jobs) screen.
• Time: From the Date on the Job Management (My Jobs) screen.

Auto Soldout Register

Select Accept at the Process Auto Sold Outs Screen. If you select the Update orders field at this screen, the words NO UPDATE - LIST ONLY appear in the upper left corner of the report.

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

Contents:

• Item code
• Order number and number of the shipping address
• Line number
• Item quantity
• SKU code(s)
• Item totals: number of order lines and total quantity
• Final totals: number of order lines and total quantity

Auto Sold Out Retained Order Register

You can keep this report as a record of which orders were retained against which items, so that you can sell out the remaining orders when you no longer expect to be able to fulfill them.

Select Accept at the Enter Quantity to Retain Screen.

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

Contents:

• Item code
• SKU code
• Order number
• Quantity retained
• Cancel date from the detail line (If you enter a cancel date in Order Entry, it flows through to the detail line automatically. If you enter a cancel date in Order Maintenance, the date flows through to the detail line only for items you add to the order afterward.)

Backorder Cancellation Register

The system generates this list when you process backorder notifications through Generate Backorder Notices (GBOC); it provides information on each item due to be canceled from an order.

Excluded from the backorder cancellation register: Items/SKUs whose Suppress backorder card field is selected; see Performing Initial Item Entry (MITM).

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

Contents:

• Order number and number of shipping address
• Sold-to customer name (name of person who placed the order)
• Order line number
• Item code
• SKU codes, if any
• Quantity backordered
• Scheduled cancel date

How to use this report: Use this report as a guide for contacting customers to suggest alternative items, or for canceling the backordered items through Order Maintenance.

For more information: See Working with Backorders Pending Cancellation (WBPC).

Backorder Card

How to print: Enter GBOC in the Fast path field at the top of any menu, or select Generate Backorder Cards from a menu.

The Generate Backorder Cards job produces a backorder card for each order containing one or more backordered items if the order is not eligible for an email notification (see Working with E-Mail Notification Templates (WEMT)) or the Outbound Email XML Message (CWEmailOut). Up to four backorder notifications print on each 8 1/2 x 11" page.

For more information see the Order Administration Web Services Guide on My Oracle Support (ID 2953017.1)

Working with forms: See Forms Management (My Forms) for information on displaying or printing backorder notification cards and other forms.

Sample backorder notification cards: See the backorder notification card sample .

Note:

This sample represents the notification that prints when the Backorder Card Print Program (D04) system control value is set to BOCARDS. Depending on your setting, your backorder notifications may appear different.

Form naming: File names for backorder notices indicate the user ID of the person who submitted the job and which notices are included in the file. For example, a file named BOCARDSSECOND.SBROWN.20070214.123456.pdf was generated by SBROWN and contains second notices. See Forms Management (My Forms) for a discussion of form naming conventions.

Contents:

• Order number

• Item code

• SKU code (included if the item has SKUs)

• Item quantity

• Expected ship date. See Purchase Order Layering for a discussion.

• Item description

• Sold To customer name and address (name of person who placed order), including:

• company name

• customer prefix code, first name, middle initial, last name, and suffix

• address line 1

• apartment or suite

• address lines 2-4

• city, state, and postal code

• country

Note:

The cards print in numeric order by order number, regardless of the postal code or country of the customer’s mailing address.

Backorder Report by Descending Dollars by Division/Warehouse

Select the By division/whse field and optionally a division code in the Division field at the Backorder Report by Descending Dollars Screen (PBOD) and select Accept.

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®. This is the only version of the backorder report by descending dollars that is available in this format. See Reports Available in Spreadsheet Format for more information.

Contents: See Backorder Report by Descending Dollars by Entity/Warehouse for a description of the contents of this report.

Backorder Report by Descending Dollars by Entity/Warehouse

How to print: Select the By entity/whse field and optionally an entity code in the Entity field at the Backorder Report by Descending Dollars Screen (PBOD) and select Accept.

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

Contents:

• Selected report: the report you selected at the Backorder Report by Descending Dollars screen. You can select:

  • By entity/warehouse: you selected the By entity/whse field. This report sorts in entity/warehouse/item/descending dollars sequence and displays backordered order detail lines for each entity.

  • By division/warehouse: you selected the By division/whse field. This report sorts in division/warehouse/item/descending dollars sequence and displays backordered order detail lines for each division.

  • By offer/warehouse: you selected the By offer/whse field. This report sorts in offer/warehouse/item/descending dollars sequence and displays backordered order detail lines for each offer.

  • By warehouse: you selected the By warehouse field. This report sorts in warehouse/item/descending dollars sequence and displays backordered order detail lines for each warehouse.

• Offer for pricing: the offer you entered in the Select offer for pricing field. This is the offer the system uses to determine the selling price that prints on this report.

  • If the item is non-SKU’d, the system uses the price from the Item Price table.

  • If the item has SKUs, the system uses the price from the SKU Price table.

  • If a price has not been defined in the SKU Price table for the SKU’d item, the system uses the price in the Item Price table.

  • f a price has not been defined for the Item Price table or SKU Price table, for example with components of a set, the system leaves the price blank.

• Selected Entity, Division, or Offer: the entity, division, or offer that has backordered order detail lines. The system uses the source code on the order header to determine the entity, division, or offer where the order detail lines are backordered.

  • Entity included if you selected the Backorder Report by Descending Dollars by Entity/Warehouse.

  • Division included if you selected the Backorder Report by Descending Dollars by Division/Warehouse.

  • Offer included if you selected the Backorder Report by Descending Dollars by Offer/Warehouse.

• Warehouse: the code for the warehouse where order detail lines are backordered. The system looks at the backorder warehouse in the Order Detail table to determine the warehouse where the order detail lines are backordered.

• Item: the code of the item that is on backorder in the entity and warehouse defined.

• SKU: the SKU of the item that is on backorder.

• Description: the first 19 positions of the description of the item that is on backorder.

• Quantity on backorder: the quantity of the item that is on backorder for the selection criteria you defined. The system uses this calculation to determine the backorder quantity:

quantity ordered - quantity shipped - quantity cancelled - quantity soldout - quantity reserved = quantity on backorder

Note:

The calculation to determine the quantity on backorder does not include drop ship items or items with a future arrival date.

• Unused quantity on purchase order: the purchase order quantity that has not been applied to order detail lines on backorder. For example, if the purchase order quantity is 10 and you have 2 backordered order detail lines, the unused purchase order quantity is 8.

• Purchase order expected date: the date the next purchase order is expected to be received. The system uses the closest future due date to today that will cover the backorder quantity, based on the information in the PO Layering table. If a future purchase order due date is not available, the system uses the purchase order date in the past that is closest to the current date.

• Quantity on hand: the total on hand quantity for the item in the warehouse defined.

• Quantity on reserve: the total reserved quantity for the item in the warehouse defined.

• Selling price: the total selling price of the backordered items in the offer defined. For example, if the price for the item in the specified offer is 22.00 and 2 order detail lines are backordered, the total selling price is 44.00.

  Note:

  The actual selling price used on an order detail line may differ from the selling price defined for the offer, for example the order entry operator may manually change the selling price on the order detail line.

• Cost: The total cost of the backordered items. The system uses the Costing Method (A25) system control value to determine which Cost field (average, standard, or FIFO) to use from the SKU table. For example, if the cost of the item is 15.00 and 2 order detail lines are backordered, the total cost is 30.00.

  cost x backorder quantity = total cost

• Total warehouse: the totals for the order detail lines associated with the warehouse.

  • quantity on backorder

  • unused quantity on purchase order

  • quantity on hand

  • quantity on reserve

  • selling price

  • cost

• Total entity: the totals for the order detail lines associated with the entity. Included only for the Backorder Report by Descending Dollars by Entity/Warehouse.

  • quantity on backorder

  • unused quantity on purchase order

  • quantity on hand

  • quantity on reserve

  • selling price

  • cost

• Total division: the totals for the order detail lines associated with the division. This total is included only on the Backorder Report by Descending Dollars by Division/Warehouse.

  • quantity on backorder

  • unused quantity on purchase order

  • quantity on hand

  • quantity on reserve

  • selling price

  • cost

• Total offer: the totals for the order detail lines associated with the offer. This total is included only on the Backorder Report by Descending Dollars by Offer/Warehouse.

  • quantity on backorder

  • unused quantity on purchase order

  • quantity on hand

  • quantity on reserve

  • selling price

  • cost

• Total number of orders on backorder: the total number of orders that have at least one order detail line on backorder for the selection criteria defined.

• Grand total: the totals for the order detail lines across all selection criteria on this report.

  • quantity on backorder

  • unused quantity on purchase order

  • quantity on hand

  • quantity on reserve

  • selling price

  • cost

Backorder Report by Descending Dollars by Offer/Warehouse

Select the By offer/whse field and optionally an offer code in the Offer field at the Backorder Report by Descending Dollars Screen (PBOD) and select Accept.

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

Contents: See Backorder Report by Descending Dollars by Entity/Warehouse for a description of the contents of this report.

Backorder Report by Descending Dollars by Warehouse

Select the By warehouse field and optionally a warehouse code in the Warehouse field at the Backorder Report by Descending Dollars Screen (PBOD) and select Accept.

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

Contents: See Backorder Report by Descending Dollars by Entity/Warehouse for a description of the contents of this report.

Backorder Report by Item

Select the By item field on the Print Backorder Report Selection Prompt Screen and select Accept. The system submits the program BOR_ITM. Backorder totals are provided at the base item level only, not the SKU level.

Backordered items on quotes: The system does not include items on backorder on quotes; see Entering Pre-Order Quotes for an overview.

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

Contents:

• Item number
• Item description
• Quantity on backorder (cumulative total of all backordered SKUs for the item)
• Quantity on purchase order (cumulative total of all SKUs being ordered from your suppliers)
• Quantity on hand (cumulative total of all SKUs currently available across all warehouses)
• Quantity on reserve (cumulative total of all SKUs already reserved to existing orders)
• Final totals

Backorder Report by Item with SKU Details

Select the By item and Print SKU detail fields on the Backorder Report by Descending Dollars Screen and select Accept. The system submits the program BOR_ITMS. Backorder totals are provided for each base item number and each SKU.

Backordered items on quotes: The system does not include items on backorder on quotes; see Entering Pre-Order Quotes for an overview.

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:

• Soldout control (a code indicating when the system should consider the item sold out)

Note:

Soldout control codes are user-defined and are similar to this: 01 = Sell out immediately; 02 = Include on order quantity in sold out calculation; 03 = exclude on order quantity in sold out calculation.

• Item number
• SKU
• Item description
• Quantity on backorder (cumulative total of all backordered SKUs for the item)
• Quantity on purchase order (cumulative total of all SKUs being ordered from your suppliers)
• Quantity on hand (cumulative total of all SKUs currently available across all warehouses)
• Quantity on reserve (cumulative total of all SKUs already reserved to existing orders)
• Subtotals for the base item
• Final totals

Backorder Report by Vendor

Select the By vendor field on the Print Backorder Report Selection Prompt Screen and select Accept. The system submits the program BORVND.

Note:

Important: A backordered item is included on this report only if a primary vendor has been defined for the item.

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

Contents:

• Item number
• Item description
• Vendor number
• Vendor description
• Quantity on backorder (cumulative total of all backordered SKUs for the item)
• Quantity on purchase order (cumulative total of all SKUs being ordered from your suppliers)
• Quantity on hand (cumulative total of all SKUs currently available across all warehouses)
• Quantity on reserve (cumulative total of all SKUs already reserved to existing orders)
• Subtotals for each vendor
• Final totals for all vendors

Backorder Report by Vendor/SKU/PO

Select the By vendor w/PO and Print SKU detail fields on the Print Backorder Report Selection Prompt Screen and select Accept. The system submits the program BORVNDPOS. Backorder totals are provided for each SKU and each vendor.

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:

• Soldout control (a code indicating when the system should consider the item sold out)

  Note:

  Soldout control codes are user-defined and are similar to this: 01 = Sell out immediately; 02 = Include on order quantity in sold out calculation; = exclude on order quantity in sold out calculation.
• Vendor number
• Vendor description
• Item number
• SKU
• Item description
• Purchase order number
• Purchase order detail line number (on which the SKU was ordered)
• Purchase order due date
• Quantity on backorder (cumulative total of all backordered SKUs for the item)
• Quantity on purchase order (cumulative total of all SKUs being ordered from your suppliers)
• Subtotals for each SKU
• Subtotals for each base item
• Subtotals for each vendor
• Final totals for all vendors

Backorder Report by Vendor w/PO

Select the By vendor w/PO field on the Print Backorder Report Selection Prompt Screen and select Accept. The system submits the program BORVNDPO.

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

Contents:

• Vendor number
• Vendor description
• Item number
• Item description
• Purchase order number
• Purchase order due date
• Quantity on backorder (cumulative total of all backordered SKUs for the item)
• Quantity on order (cumulative total of all SKUs being ordered from your suppliers)
• Quantity on hand (cumulative total of all SKUs currently available across all warehouses)
• Quantity on reserve (cumulative total of all SKUs already reserved to existing orders)
• Subtotals for each vendor
• Final totals for all vendors

Backorder Report by Vendor with SKU Details

Select the By vendor and Print SKU detail fields on the Print Backorder Report Selection Prompt Screen and select Accept. The system submits the program BORVNDS. Backorder totals are provided for each SKU and each vendor.

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:

• Soldout control (a code indicating when the system should consider the item sold out)

  Note:

  Soldout control codes are user-defined and are similar to this: 01 = Sell out immediately; 02 = Include on order quantity in sold out calculation; 03 = exclude on order quantity in sold out calculation.
• Vendor number
• Vendor description
• Item number
• SKU
• Item description
• Quantity on backorder (cumulative total of all backordered SKUs for the item)
• Quantity on purchase order (cumulative total of all SKUs being ordered from your suppliers)
• Quantity on hand (cumulative total of all SKUs currently available across all warehouses)
• Quantity on reserve (cumulative total of all SKUs already reserved to existing orders)
• Subtotals for each base item
• Subtotals for each vendor
• Final totals across all vendors

Backorder Report by Warehouse

Select the By whse/item field on the Print Backorder Report Selection Prompt Screen and select Accept. The system submits the program BORWHSITM.

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:

• Item number
• Item description
• Warehouse code
• Warehouse description
• Quantity on backorder (cumulative total of all backordered SKUs for the item)
• Quantity on purchase order (cumulative total of all SKUs being ordered from your suppliers)
• Quantity on hand (cumulative total of all SKUs currently available across all warehouses)
• Quantity on reserve (cumulative total of all SKUs already reserved to existing orders)
• Subtotals for each warehouse
• Final totals across all warehouses

Backorder Report by Warehouse with SKU Details

Select the By whse/item and Print SKU detail fields on the Print Backorder Report Selection Prompt Screen and select Accept. The system submits the program BORWHSITMS. Backorder totals are provided for each SKU and each warehouse.

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:

• Soldout control (a code indicating when the system should consider the item sold out)

  Note:

  Soldout control codes are user-defined and are similar to this: 01 = Sell out immediately; 02 = Include on order quantity in sold out calculation; 03 = exclude on order quantity in sold-out calculation.
• Item number
• SKU
• Item description
• Warehouse code
• Warehouse description
• Quantity on backorder (cumulative total of all backordered SKUs for the item)
• Quantity on purchase order (cumulative total of all SKUs being ordered from your suppliers)
• Quantity on hand (cumulative total of all SKUs currently available across all warehouses)
• Quantity on reserve (cumulative total of all SKUs already reserved to existing orders)
• Subtotals for each base item
• Subtotals for each warehouse
• Final totals across all warehouses

Batch Release Summary Report

This report lists the orders associated with the credits released and the dollar amount of each credit. The Batch Release Summary report sorts by line of business, order number, ship to number, and invoice number.

You can print this report by selecting Process at the Process Credits by Line of Business Screen.

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

Contents:

• Line of business code and description (this is the line of business you defined at the Process Credits by Line of Business screen)
• Amount to credit (this is the dollar amount you defined at the Process Credits by Line of Business screen)
• Order number
• Ship to number
• Invoice number
• Credit dollar amount
• Total orders for line of business
• Total dollar amount for line of business

Catalog Mailing Labels (MSR0613 or MSR0614)

Purpose: The system prints labels in the following format if you have the Label 2-Up Printing Program (C83) set to MSR0613 or the Label 3-Up Printing Program (C84) set to MSR0614. This format does not conform to Post Office requirements, which specify that the last line of the address should consist only of the country.

Complete the Process Catalog Requests Screen (PCAT).

MSR0613: See the sample labels in PDF format.

MSR0614: See the sample labels in PDF format.

Contents:

• Customer number
• Source code
• Item number, if any

Note:

If the item has three SKUs and you print the labels 3-up, the third SKU element does not print.

• Customer name (prefix, first name, middle initial, suffix; the last name may be truncated or the suffix omitted if the entire customer name exceeds 43 positions)
• Company name
• Customer address (street address, apartment or suite, address line 2, city, state, postal code, and country; the country code, rather than the full name, prints if the address is in the Default Country for Customer Address (B17))

Changed Customers Report

Purpose: Use this report to review the customer address updates that were performed. This report gives you a snapshot of the customer address before and after the update.

How to print: Select Print at the Work with Changed Customers Screen (MBSI).

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

Contents: See the Work with Changed Customers Screen (MBSI).

Check Reconciliation List

Complete the Print Reconcile List Prompt Screen.

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

Contents: This report lists refund checks for the ranges specified on the Print Reconcile List Prompt Screen.

• the range of check dates for unreconciled and reconciled checks, if any were specified
• bank associated with the source code used on the order.
• check number
• refund amount (in the currency used on the order).
• check print date
• check reconcile date, if any
• check void date, if any
• order number and ship-to address number
• customer number (the sold-to customer number, unless there is a bill-to customer associated with the order; in this case, this is the bill-to customer number)
• sold-to or bill-to customer name
• totals for each bank (if you process orders in multiple currencies) or by report (if you do not process orders in multiple currencies). This information is controlled by the Multi Currency by Offer (E03) system control value.

Check Reconciliation List by Bank

Specify a bank code and complete the Print Reconcile List Prompt Screen.

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

Contents: This report lists refund checks for the ranges specified on the Print Reconcile List Prompt Screen.

• the range of check dates for unreconciled and reconciled checks, if any were specified
• bank you selected at the Print Reconcile List Prompt Screen. This is the bank associated with the source code used on the order.
• check number
• refund amount (in the currency used on the order).
• check print date
• check reconcile date, if any
• check void date, if any
• order number and ship-to address number
• customer number (the sold-to customer number appears here unless there is a bill-to customer associated with the order; in this case, the bill-to customer number prints)
• sold-to or bill-to customer name
• totals for the bank

Credit Card Credit Acknowledgment

Purpose: You can print a credit card credit acknowledgment to notify the customer that a credit has been applied to the credit card. The system might generate an email notification instead of a printed acknowledgement, depending on customer preference and your company setup; see When Does the System Generate an Email Notification?

Complete the Process Refunds Screen (MREF) with the Generate credit card credits field selected.

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

The system prints a "dummy" credit card credit acknowledgment before the first actual acknowledgment to help you align credit card credit forms in the printer.

With the exception of the Total Amount Returned, fields are unlabeled.

Contents:

• order number and ship-to number: The order number and ship-to number associated with the credit card credit.
• refund date: The date the refund was generated.
• item: The code identifying the items on the order that were returned or exchanged, resulting in the credit card credit. Only the base item is included even if the item has SKUs.
• item description: The description of the item. This is the description of the base item even if the item has SKUs.
• item refund amount: The amount refunded for the item.
• Total Amount Returned: The total amount refunded for the credit card on the order, across all items. The tax amount included in the refund amount is based on the tax rate that was effective when the item was shipped.
• sold-to name and address: The name and address of the sold-to customer on the order, including the name of the country.

Credit Card Credit Register

Complete the Process Refunds Screen (MREF) with the Generate credit card credits field selected.

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

Contents:

• Order Number: The order number and order ship-to number.
• Customer Number: The sold-to customer number, unless there is a bill-to customer associated with the order; in this case, this is the bill-to customer number.
• Name: The sold-to or bill-to customer name.
• Refund Amount: The refund amount in the local currency (the currency defined in the Local Currency Code (A55) system control value). The tax amount included in the refund amount is based on the tax rate that was effective when the item was shipped. An asterisk after the refund amount indicates that the refund is flagged for Credit Card Net Exchange Billing.
• Final Totals: The total amount for the refunds, across all credits, in the local currency.

Note:

This report includes credit card credits regardless of whether the acknowledgements are printed or emailed.

Credit Card Order Cancellation List

This report sorts by the hold reason code associated with the vendor response code that caused the order to be flagged for cancellation. If the order was flagged for cancellation because the total number of declines reached the number defined in the Maximum Number of Retries on Credit Card Orders (E74) system control value, the order is listed under a hold reason code of AT. You can create a unique hold reason code for each vendor response for descriptive and sorting purposes.

Complete the Cancel Credit Card Order Cancellation Screen.

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

Contents:

• hold reason code associated with the vendor response, description
• cancel date
• order number
• customer name
• total merchandise dollars canceled on the order
• total number of orders canceled for the hold reason code
• total merchandise dollars canceled for the hold reason code

Customer Detail Exposure Report by Reason Code

Complete the Print Customer Detail Exposure Report Screen.

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

Contents:

• the customer action reason code selected for the customer action note
• the description of the customer action reason code
• the date range you entered at the Print Customer Detail Exposure Report Screen
• the sold-to customer number
• the bill-to customer number
• the street address for the customer
• the city, state, zip and country for the customer
• the day phone number and extension for the customer
• the evening phone number and extension for the customer
• the fax or mobile number and extension for the customer

  Note: the Third Phone Number Type (L53) system control value determines whether the third phone number is labeled the Fax or Mobile number.

• the action note

  Note: If there are multiple customer action notes for a customer, the report lists just the first note.

• the reason code totals

Customer Exposure Report by Reason Code

Complete the Customer Exposure Report Selection Screen.

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

Contents:

• the date range you entered at the Customer Exposure Report Selection Screen
• the customer action reason code selected for the customer action note. Notes not associated with a reason code are included in the first reason line (notice that the code and description, described below, are blank).
• the description of the customer action reason code
• the number of open action notes entered within the date range for each reason code
• the number of work-in-process customer action notes entered within the date range for each reason code
• the number of resolved action notes entered within the date range for each reason code
• the number of customer action notes entered outside of the date range for each reason code
• total numbers of open, resolved, and remaining action notes (final totals)

Customer Exposure Report by User

Complete the Customer Exposure Report Selection Screen.

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

Contents:

1. the date range you entered at the Customer Exposure Report Selection Screen
2. the name of the user who entered the note (not the user assigned to resolve the note).
3. the customer action reason code selected for the customer action note. Notes not associated with a reason code are included in the first reason line (notice that the code and description, described below, are blank).
4. the description of the customer action reason code
5. the number of open action notes entered within the date range for each reason code for the user
6. the number of work-in-process action notes entered within the date range for each reason code for the user
7. the number of resolved action notes entered within the date range for each reason code for the user
8. the number of customer action notes entered outside of the date range for each reason code (number remaining) for the user
9. subtotals in each category for the user
10. total numbers of open, work in process, resolved, and remaining action notes (final totals)

Daily Business Status Report

Enter DBST in the Fast path field at the top of a menu, select Printing the Daily Business Status Report (DBST) from a menu, or run the Daily Business Status Report periodic function (program name ACR0178).

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

Contents: Each field below indicates if the value is based on the Processing date you defined at the Daily Business Status Screen or the date you generated the report (job date). If the field indicates the value can be from either: the value is based on the Processing date if one exists; otherwise the job date is used to determine the value.

• Sales today: The merchandise dollar amount of sales today, based on the processing date or job date. This dollar amount includes shipments confirmed. This is the $ orders shipped from the Order Control Summary table.
• Sales MTD: The merchandise dollar amount of sales month to date, based on the processing date or job date. This is the $ orders shipped from the Order Control Summary table, based on the accounting period start and stop date.
• Cash today: The dollar amount of cash, based on the processing date or job date. This amount is from the Deposit amount field in the Cash Receipts Header table.
• Cash MTD: The dollar amount of cash month to date, based on the processing date or job date. This dollar amount comes from the Deposit amount field in the Cash Receipts Header table based on the accounting period start and stop date defined in Working with Accounting Periods (WACP).
• Inventory primary warehouse: The system uses this calculation, based on the job date, to determine the inventory for the Default Warehouse (A04): on hand quantity for primary warehouse x item cost = inventory for primary warehouse.
• Inventory all others: The system uses this calculation, based on the job date, to determine the inventory for all other warehouses besides the default warehouse: on hand quantity for all non-primary warehouses x item cost = inventory for all other warehouses.
• Orders entered today #: The number of orders entered, based on the processing date or job date. This includes the total number of ship-to addresses, orders which include only sold out items or non-inventory items, returns processed by negative quantities in order entry. This total does not include batch orders that have not yet been accepted. This total is not based on the date, but from the last time you cleared the daily totals (Daily Clear Process periodic function, program name MSR0574). This is the Orders entered number in the Order Control Summary table.
• Orders entered today $: The merchandise dollar total of orders entered, based on the processing date or job date. This includes merchandise dollar total of sold out items and non-inventory items. This total does not include merchandise dollars for items returned during order entry or merchandise dollars for batch orders that have not yet been accepted. This total is not based on the date, but from the last time you cleared the daily totals (Daily Clear Process periodic function, program name MSR0574). This is the Orders entered dollars in the Order Control Summary table.
• Orders entered month to date #: The number of orders entered for the month, based on the processing date or job date. This total is not based on the date, but from the last time you cleared the monthly totals (Monthly Clear Process periodic function, program name MSR0576). The system totals the Orders entered number value in the Order Control Summary table for each transaction date in the accounting period to determine the number of orders entered for the accounting period.
• Orders entered month to date $: The merchandise dollar total of orders entered for the month, based on the processing date or job date. This total is not based on the date, but from the last time you cleared the monthly totals (Monthly Clear Process periodic function, program name MSR0576). The system totals the Orders entered dollars value in the Order Control Summary table for each transaction date in the accounting period to determine the merchandise dollar total of orders entered for the accounting period.
• Average per order entered today $: The average merchandise dollar amount for the orders entered, based on the processing date or job date. The system uses this calculation to determine the average per order: orders entered today dollars / order entered today number = average per order entered today dollars
• Average per order entered month to date $: The average merchandise dollar amount for the orders entered for the month, based on the processing date or job date. The system uses this calculation to determine the average per order: orders entered month to date dollars / order entered month to date number = average per order entered month to date dollars
• Number of units entered today: The number of units ordered for the day, based on the processing date or job date. This includes the main set item as well as each component item, units of sold out items or non-inventory items. This does not include units returned in order entry, units on batch orders that have not yet been accepted. This is the Quantity ordered in the Order Control Summary table.
• Number of units entered month to date: The number of units ordered for the month to date, based on the processing date or job date. The system totals the Quantity ordered value in the Order Control Summary table for each transaction date in the accounting period to determine the number of units ordered for the accounting period.
• Packages shipped today #: The total number of shipped orders, based on the processing date or job date. This is the Orders shipped number in the Order Control Summary table. The setting of the Order Control Summary Shipment Update Method (I55) system control value determines how the system updates the # Orders shipped field in the Order Control Summary table.
• Packages shipped today $: The merchandise dollar total of shipped items, based on the processing date or job date. This includes shipments confirmed. This total does not include dollars for returns processed in order entry. This is the Orders shipped dollars in the Order Control Summary table.
• Packages shipped month to date #: The total number of shipped orders for the month to date, based on processing date or job date. The system adds the Orders shipped number in the Order Control Summary table for each transaction date in the accounting period to determine the total number of shipped orders for the accounting period.
• Packages shipped month to date $: The merchandise dollar total of shipped items for the month to date, based on processing date or job date. The system totals the Orders shipped dollars value in the Order Control Summary table for each transaction date in the accounting period to determine the merchandise dollar total of shipped items for the accounting period.
• Average per package shipped today $: The average merchandise dollar amount for the orders shipped, based on processing date or job date. The system uses this calculation to determine the average per package shipped: packages shipped today dollars / packages shipped today number = average per package shipped today dollars
• Average per package shipped month to date $: The average merchandise dollar amount for the orders shipped for the month, based on processing date or job date. The system uses this calculation to determine the average per package shipped: packages shipped month to date dollars / packages shipped month to date number = average per package shipped month to date dollars
• Number of units shipped today: The total number of shipped units, based on processing date or job date. This includes shipped units confirmed. This total does not include units for returns processed in order entry. This is Quantity shipped in the Order Control Summary table.
• Number of units shipped month to date: The total number of shipped units for the month to date, based on processing date or job date. The system totals the Quantity shipped value in the Order Control Summary table for each transaction date in the accounting period to determine the total number of shipped units for the accounting period.
• Warehouse value: The merchandise dollar amount of the inventory located in the specified warehouse, based on job date. The system uses this calculation to determine the dollar amount: units x item cost = item inventory value.
• Warehouse units: The number of units of the inventory located in the specified warehouse, based on job date. PRIMARY displays to the right of the primary warehouse (from the Default Warehouse (A04).

Drop Ship Batch Confirmation Report

Purpose: Use this report to review the total cost of items on drop ship pick slips when you confirm by billing batch number.

Confirm drop ship pick slips by billing batch number at the Batch Confirmation Pop-up Window.

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

Contents:

• current system date (not the date you entered at the Interactive Confirmation Screen)
• billing batch number for the group of drop ship pick slips
• vendor number for the item(s). The vendor number must be assigned to the item in the Vendor field on the Create and Change Item screens. Also, there must be a vendor/item record for this item and vendor, with a price defined, for the item to be included in this vendor's drop ship confirmation totals.
• name of the vendor
• number of drop ship pick slips confirmed in the billing batch
• total cost for drop shipments from this vendor, calculated by multiplying the unit vendor/item price for each item by the number of units confirmed in the billing batch
• total special handling cost for this vendor, calculated by multiplying the default special handling cost defined for the custom special handling format by the number of units. Special handling costs defined as a percentage rather than a unit amount are not included in this calculation.

For more information:

• Printing drop ship pick slips (fast path = MDSP): Selecting Vendors for Drop Ship Processing (MDSP)
• Assigning vendors to drop ship items (fast path = MITM: Working with Existing Items (MITM)
• Setting up vendor/items (fast path = WVNI): Working with Vendor Items (WVNI)
• Setting up custom special handling formats (fast path = WSHF): Establishing Custom Special Handling Formats (WSHF)

Email Errors Report

Click Accept at the Email Errors Report Screen.

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

Contents: This report has page breaks between each table that contains an email address field. The report lists each email address in error. based on the criteria described under When is an Email Address in Error? The information provided to identify the records in each table is:

• Customer Sold To: customer number
• Customer Sold To Email:
• customer number
• sequence number
• Customer Ship To:
• customer number
• ship to number
• Vendor (both vendor email and remittance email addresses): vendor number
• Vendor Contact:
• vendor number
• type
• sequence number
• Order Ship To Address
• order number
• ship to number
• OM Batch Header
• order number
• ship to number
• sequence number
• Soldout Notification
• order number
• ship to number
• sequence number
• Threshold Value: threshold code

Exchange Reason Report

Complete the Print Exchange Reason Report Screen.

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.

Different report options: Depending on your selections at the Print Exchange Reason Report Screen:

Selections:		Report Generated
Exchange reason code	Include item	Exchange Reason Report by:
yes	yes	Code and Item
yes	no	Code
no	yes	Item
no	no	N/A (produces the Exchange Reason Report)

Contents:

• Date range. The Start date and End date entered at the Print Exchange Reason Report Screen. The report includes exchanges processed on that date or later, regardless of when the order was originally created. Based on the Date from the exchange transaction in the Order Line History table; see the Display Order Line History Screen for more information.

NOTE: If you use Working with Return Authorizations (WRTA), this is the date you receive the exchange, which might differ from the date you create or credit the return authorization, or ship the replacement item.

• Exchange reason code. From Establishing Exchange Reason Codes (WEXR).
• Exchange reason description. From Establishing Exchange Reason Codes (WEXR).

The following three fields are included only if you selected the Include item flag at the Print Exchange Reason Report Screen:

• Item.
• SKU. Included only if the item has SKUs.
• Description. The item description rather than the SKU description, even if the item has SKUs.

Calculated fields: The following fields are calculated for:

• detail entries: by item/SKU or exchange reason code, depending on your selections at the Print Exchange Reason Report Screen
• subtotals: by exchange reason code, if you selected the Include item flag at the Print Exchange Reason Report Screen
• grand totals
• Units exchanged: The total number of units exchanged using the exchange reason code. If you use Working with Return Authorizations (WRTA), this total includes units that you have received, even if you have not yet credited the return and even if the return did not affect inventory. Returns you process by entering a negative quantity on an order are included in and increase this total.
• Amount exchanged: The total value of the exchanges, based on the actual selling prices. The selling price of an item might be zero if it was a free gift or a component on a set. The report does not indicate or factor in the prices of the replacement items.

Expected Membership Orders Report

Complete the Print Expected Membership Orders Screen.

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

Contents:

• range of dates you selected at the Print Expected Membership Orders Screen
• each date within the range when membership orders are next scheduled to be available for generation
• the total number of orders that will next be available for release on each date
• total number of orders scheduled for release for the date range

Held Order by Pay Type Report

Use the Print Held Orders by Pay Type Prompt Screen.

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

Contents:

• Selected Pay type: The code and name of the pay type for which the report was run.
• Order #: The order number using the pay type.
• Name: The name and address of the bill-to customer (who will be invoiced for the order, if different from the person who placed the order); otherwise, the name and address of the sold-to customer (the person who placed the order).
• Credit Card Last 4: The last four digits of the credit card number that was used as payment on the order.
• Amount: Ordinarily the order total, regardless of pay type. However, if the customer used two different credit cards that belong to the same payment type (such as two different Visa cards), only the first credit card used on the order prints on this report. In this case, the Amount field indicates the amount to charge for that payment method only, and does not include the amount for the catch-all.

Example: If the order total is $150.00 and there are two payment methods with the same pay type on the order, with one for $50.00 and the other as the catch-all, the Amount indicated is $50.00.

• Final Totals:The total dollar amount of charges for this payment type that are associated with held orders.

Held Order by Reason Code Report

Purpose: This report list held orders in your company.

Complete the Print Held Orders Report Screen. You can also generate this report by selecting Print Held Orders at the Manage Held Orders page in Modern View.

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: This report page breaks on currency code. Within currency code, the system sorts held orders in ascending order by ship via priority, user hold, pay type hold, SH hold, and order number sequence.

• Selection Criteria: The selection criteria you selected at the Print Held Orders Report Screen, if any.

  • Reason Code: The reason code you selected. ALL displays if you did not select a reason code.

  • Pay Type: The pay type you selected. ALL displays if you did not select a pay type.

  • Via Priority: The ship via priority you selected. ALL displays if you did not select a ship via priority.

• Currency: The report is broken out by currency. Both the currency code and the description are listed.
• For each hold reason code and ship via priority for the same currency:

  • Reason: The system hold reason on the order. From OHD OHR Sys hold reason in the Order Header table. Blank for user hold reasons, which are grouped together and listed first, with the user hold reason code indicated in the left-most column for each order on user hold.

Note:

The Awaiting Credit Card Auth (CW) hold reason is not included on the report.

• Ship Via Priority: The ship via priority for the ship via on the Order Header. From VIA Priority in the Ship Via table.

  The following column headings apply to the data below the Reason and Ship Via Priority

  • User Hold: The user hold, if any. From OHD OHR Usr hold reason in the Order Header table.

  • Payment Type Hold: The pay type hold, if any. From OHR Hold Reason in the Order Payment Method table.

  • Ship To Hold: The ship to hold, if any. From OST OHR Hold Reason in the Order Ship To table.

  • Order Number: The order number. From the Order # in the Order Header table.

  • Payment Type Code: The pay type code; MLT displays if more than one pay type was used on the order. From PAY Pay type in the Order Payment Method table.

  • Ship Via Code: The ship via code for the Order Ship To. From Ship via in the Order Ship To table.

  • Customer Number: The sold-to customer number. From Customer # in the Order Header table.

  • Name: The company name for the sold to customer. If a company name is not defined, this is the last name and first name of the sold-to customer. From NAM Company name in the Customer Sold To table or from NAM Last Name and NAM First Name in the Customer Sold To table.

  • Telephone/Email: The sold-to customer’s day time phone number, followed by the first 29 positions of the sold to customer’s primary email address. From CS# Phone in the Customer Sold To Phone # table and CEM Email Address in the Customer Sold To Email table.

  • Order Total: The total order value. From OST Add’l charges + OST Freight + OST Handling + OST Add’l freight + OST Tax + OST GST + OST PST + OST Merch in the Order Ship To table. Note: This total displays in the order currency, regardless of the setting of the Multi Currency by Offer (E03) system control value.

  • Order Date: The date the order was placed. From the OHD Order Date in the Order Header table.

  • Authorization Date: The most recent date when the credit card on the order was authorized. From the Auth Date in the Authorization History table.

• Total dollars on hold: The total order value for the system hold reason, or for all orders on user holds with the same currency. From OST Add’l charges + OST Freight + OST Handling + OST Add’l freight + OST Tax + OST GST + OST PST + OST Merch in the Order Ship To table for all orders with the specified system hold reason.
• Grand total [Currency code]: The total order value for the currency code. From OST Add’l charges + OST Freight + OST Handling + OST Add’l freight + OST Tax + OST GST + OST PST + OST Merch in the Order Ship To table for all orders on the report that use the same currency.

Item Purchase and Sales Aging Report

Use the Item Purchase and Sales Aging Report (LIPS) menu option.

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:

• Warehouse
• Vendor number and description
• Item/SKU
• On hand quantity
• Month to date
• Year to date
• Reserved quantity
• Open purchase order quantity
• Weekly receipts aging buckets (updates when you receive the item)

  • 0-7 days

  • 8-14 days

  • 15-21 days

  • 22-28 days

  • 28 and over days

• Last purchase order number
• Weekly sales aging buckets (updates when you confirm the item)

  • 0-7 days

  • 8-14 days

  • 15-21 days

  • 22-28 days

  • 28 and over days

• Last receipt date

Labels Printed by Item Report

This report identifies the number of labels printed for each item. A blank line at the top of the report indicates the number of labels that do not contain an item.

Complete the Process Catalog Requests Screen (PCAT) with the Sort labels field set to Item.

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

Labels Printed by Source Report

This report identifies the number of labels printed for each source code.

Complete the Process Catalog Requests Screen (PCAT) with the Sort labels field set to Source.

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

Labels Printed by Zip Report

This report identifies the number of labels printed for each zip code.

Complete the Process Catalog Requests Screen (PCAT) with the Sort labels field set to Zip.

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

Memberships in Error Report

Purpose: The GEN_ORDERS job generates this report if there are any standard customer memberships in error due to:

• pay type information that is missing or incomplete
• there are no items for the current rotation

Any discount-only standard memberships always appear on this report unless you specify membership types at the Generate Membership Orders Screen and exclude discount-only types. However, loyalty memberships are not included. See Loyalty Memberships for an overview.

Any customer memberships in active status, but which have only canceled detail lines, are listed on the report.

The GEN_ORDERS job does this level of checking before creating an order for the customer membership. There is an additional level of editing that takes place after order creation, which is documented in the Print Remote Order Errors Report.

Complete the Generate Membership Orders Screen.

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

Contents:

• release date used to select the memberships for generation
• selected membership types, if any
• for each membership in error:
• status of the membership (Note: This will always be A, or active)
• sold-to customer number
• sold-to customer name
• membership ID
• sequence number of the customer membership (a membership has a sequence number greater than 1 if the same customer has more than one membership with the same membership ID)
• next release date

Open Prepaid Order List

Use the Printing the Open Prepaid Order List (POPP) menu option.

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:

• order number
• order status (whether the order is held)
• number of order recipients
• order date
• customer number
• customer name
• order balance
• prepaid balance: The amount of prepayment received from the customer.
• refund due, if any: If the prepaid balance is greater than the order balance, and if no refunds have been paid yet, this equals the prepaid balance minus the order balance. The amount of the refund also depends, however, on how you have defined the pay type; if the refund check minimum for the pay type is $2.00, then refunds of less than $2.00 will appear as zero.
• refund paid, if any: The calculation is similar to refunds due, except that this amount includes refunds that have already been processed.
• open prepaid balance: This is the amount of the customer's prepayment that is applied to the order balance.
• balance due, if any: If the order balance is greater than the prepaid balance, this equals the order balance minus the prepaid balance
• order type
• user ID of the person who entered the order

When the report runs as part of your daily process, it includes all add reason codes for that day.

Operations Control Report

Purpose: Use this report to review the flow of orders from entry through shipment for a period of time. This report provides a high-level overview of the fulfillment process, identifies potential bottlenecks or problem areas, and delivers an audit trail of order activity.

This report is broken into separate areas of information:

• order control: beginning order totals and ending order totals
• shipment summary: shipped totals, exchanged totals, and credited/returned totals
• open order summary: open/held order totals, open/held backordered totals, open/held printed totals, and open/held reserved/unprinted totals
• general operational summaries: suspended batches totals, pending picks totals, pending RA receipts totals, pending RA credits totals, and pending refunds totals
• general merchandising summaries: backordered items totals, open PO totals, held PO totals, docked PO totals, open past due PO totals, held past due PO totals, docked past due PO totals, suspense receipt totals, pending putaway totals, and staging warehouse totals
• If the held and open totals are blank: You need to follow the process described under Print Order Control Report (POCT) to make sure the system records the total order activity.
• Drop ship items update the totals on this report as well as items that you ship from your warehouse.
• Non-inventory items: The setting of the Demand Update for Non-Inventoried Items (E59) system control value does not affect how the system calculates these totals; non-inventory items update each total regardless of this setting.
• Update demand for order maintenance: The setting of the Update Demand for Order Maintenance Transactions (C72) system control value does not affect how the system calculates these totals.

You can also review these totals in the Operations Control Summary menu option; see Reviewing Operations Control Summary (FLSH).

How to Print

• complete the Order Control Report Screen.
• submit the order summary periodic function (PFR0062).
• select Update current totals at the First Operations Control Summary Screen, Second Operations Control Summary Screen, or Display Operations Control Summary Screen in the Operations Control Summary (FLSH) menu option.

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:

• Date range: Dates included in the report. If you generated the report at the Order Control Report screen, these are the dates you entered; if you generated the report through the periodic function, both dates should represent the generation date; if you generated the report at one of the Operations Control Summary screens, both dates are the current date.

Order control: The number of orders, number of units, and total merchandise dollar value for open orders. The system breaks down these totals by gross demand, add on demand, cancelled orders, closed/soldout orders, and shipped orders.

• Beginning open order balance: The number of orders, number of units, and merchandise dollars for the beginning transaction date of this report.

  • number of orders: The total number of open and held orders as of the beginning transaction date. The system uses the following calculation to determine the beginning number of orders; these fields are from the Order Control Summary table: open orders number + held orders number + orders cancelled number + orders soldout/closed number + orders shipped number - orders entered number = beginning number of orders

  • number of units: The total number of units on open and held orders as of the beginning transaction date. The system uses this calculation to determine the beginning number of units; these fields are from the Order Control Summary table: open backordered quantity + open printed quantity + open unprinted quantity + held backordered quantity + held printed quantity + held unprinted quantity + add on demand + quantity cancelled + quantity soldout + quantity shipped - quantity ordered = beginning number of units

  • merchandise dollars: The merchandise dollar total of open and held orders as of the beginning transaction date. The system uses this calculation to determine the beginning merchandise dollars; these fields are from the Order Control Summary table: open backordered dollars + open printed dollars + open unprinted dollars + held backordered dollars + held printed dollars + held unprinted dollars + add on demand dollars + orders cancelled dollars + orders soldout dollars + orders shipped dollars - orders entered dollars = beginning merchandise dollars

  • This is the Orders entered dollars from the Order Control Summary table for the beginning transaction date.

The beginning open order balance is then broken out by:

• Gross demand: The number of orders, number of units, and merchandise dollars for orders entered for the selected date range. These order totals reflect initial order entry only.

  • number of orders: The total number of orders entered for the selected date range, from the Orders entered number in the Order Control Summary table.

  • number of units: The total number of units on new orders, from the Quantity ordered in the Order Control Summary table.

  • merchandise dollars: The merchandise dollar total on new orders, from the Orders entered dollars in the Order Control Summary table.

• Add on demand: Actual add-on demand; increased each time you add any items in order maintenance, including the replacement items in exchanges. However, these totals are decreased by orders or items canceled with a cancel reason whose Reduce demand flag is selected.

  • number of orders: The total number of orders; increased each time you reopen a closed order by adding item(s) in order maintenance, including exchange (replacement) items and mis-ships; decreased each time you cancel an order using a cancel reason whose Reduce demand? flag is selected. This is the Orders reopened number from the Order Control Summary table.

  • number of units: The total number of units; increased each time you add an item in order maintenance, including a mis-ship or exchange (replacement) item; decreased each time you cancel an item using a cancel reason whose Reduce demand? flag is selected. This is the Quantity increased from the Order Control Summary table.

  • merchandise dollars: The merchandise dollar total; increased each time you add item(s) in order maintenance by the extended price of the added item(s), or enter exchange item(s) in order maintenance by the extended price of the replacement item(s); decreased each time you cancel an item using a cancel reason whose Reduce demand? flag is selected. This is the Orders increased dollars from the Order Control Summary table.

• Cancelled: The number of orders, number of units, and merchandise dollars for orders cancelled for the selected date range. These totals include orders, items, or merchandise dollars only if the Reduce demand? flag for the cancel reason is unselected.

  • number of orders: The number of orders cancelled (orders in Cancelled status; all order lines have been cancelled). This is the Orders cancelled number from the Order Control Summary table.

  • number of units: The number of units cancelled, from the Quantity cancelled in the Order Control Summary table.

  • merchandise dollars: The merchandise dollar total of cancelled items, from the Orders cancelled dollars in the Order Control Summary table.

• Closed/soldout: The number of orders, number of units, and merchandise dollars for orders soldout for the selected date range. The system considers an order line sold out if you process soldout order lines in order entry, order maintenance, or the Processing Auto Soldout Cancellations (MASO) menu option, or you cancel order lines with a cancel reason whose Reduce demand? flag is selected. However, the system updates only soldout orders and does not update soldout units, soldout dollars, cancelled orders, cancelled units, or cancelled dollars for these order lines.

  • number of orders: The total number of soldout orders, including orders for which all order lines are sold out, or at least one order line is sold out and all other order lines have been cancelled using any cancel reason code. This does not include order lines that are sold out if other order lines exist on the order that are not sold out or cancelled. This is the Orders soldout/closed number from the Order Control Summary table.

  • number of units: The total number of sold out units, from the Quantity soldout in the Order Control Summary table.

  • merchandise dollars: The merchandise dollar total of sold out items, from the Orders soldout dollars in the Order Control Summary table.

• Shipped: The number of orders, number of units, and merchandise dollars for orders shipped for the selected date and accounting period as of the time you refreshed the screen. These totals are not decreased by returns or exchanges.

  • number of orders: The total number of shipped orders, from the Orders shipped number in the Order Control Summary table. The setting of the Order Control Summary Shipment Update Method (I55) system control value determines how the system updates the # Orders shipped field in the Order Control Summary table; if this system control value is not set to ORDERS, the will not provide an accurate day by day audit of order shipment activity.

  • number of units: The total number of shipped units, including shipped units confirmed. Does not include units for returns processed in order entry. This is the Quantity shipped from the Order Control Summary table.

  • merchandise dollars: The merchandise dollar total of shipped items, including shipments confirmed. Does not include dollars for returns processed in order entry. This is the Orders shipped dollars from the Order Control Summary table.

• Ending open order balance: The number of orders, units, and total merchandise dollar value for the ending transaction date of the date range you selected.

  • number of orders: The number of open and held orders as of the ending transaction date. The system uses this calculation to determine the ending number of orders; these fields are from the Order Control Summary table: open orders number + held orders number = ending number of orders.

  • number of units: The number of units on open and held orders as of the ending transaction date. The system uses this calculation to determine the ending number of units; these fields are from the Order Control Summary table: Open backordered quantity + Open printed quantity + Open unprinted quantity + Held backordered quantity + Held printed quantity + Held unprinted quantity = ending number of units.

  • merchandise dollars: The merchandise dollar total on open and held orders as of the ending transaction date. The system uses this calculation to determine the ending merchandise dollars; these field are from the Order Control Summary table: open backordered dollars + open printed dollars + open unprinted dollars + held backordered dollars + held printed dollars + held unprinted dollars = ending merchandise dollars.

Shipment summary: The number of orders, number of units, and total merchandise dollar value for shipments. The system provides totals by shipped orders, exchanged orders, and credited/returned orders.

• Shipped: The number of orders, number of units, and merchandise dollars for orders shipped for the selected date range. These totals are not decreased by returns or exchanges.

  • number of orders: The total number of shipped orders, including returns processed by negative quantities in order entry (these returns update the number of shipped orders and the Returns fields, but does not update shipped units or shipped dollars) and shipped orders confirmed. A single order with multiple pick slips (for example, for ship alone items) updates the total by 1. An order with multiple ship-tos updates the total by the number of ship-tos. For example, an order with 2 ship-to addresses updates the total by 2. This is the Orders shipped number from the Order Control Summary table.

  • number of units: The total number of shipped units, including shipped units confirmed. This does not include units for returns processed in order entry. This is the Quantity shipped from the Order Control Summary table.

  • merchandise dollars: The merchandise dollar total of shipped items, including shipments confirmed. Does not include dollars for returns processed in order entry. This is the Orders shipped dollars from the Order Control Summary table

• Exchanged: The number of orders, number of units, and merchandise dollars for items returned in exchange transactions for the selected date range. These totals include quantities and merchandise dollar value of the items returned in exchange transactions, not units and merchandise dollar value of items ordered in exchange. You can enter an exchange in order maintenance or Work with Return Authorizations (these totals increase only when you process the credit).

  • number of orders: The total number of exchange transactions processed, regardless of whether the exchanges are on the same order. For example, an order with 2 exchanged order lines processed separately updates this total by 2; however, if the same 2 exchanged order lines on a single order are processed in the same transaction, the total updates by 1. This is the Exchanges number from the Order Control Summary table.

  • number of units: The total number of units returned in exchange transactions, from the Quantity exchanged in the Order Control Summary table.

  • merchandise dollars: The merchandise dollar total of returned items in exchange transactions, from the Exchanged dollars in the Order Control Summary table.

• Credited/returned: The number of orders, number of units, and merchandise dollars for orders returned for the selected date range. You can enter a return in order entry (via negative quantity ordered), order maintenance, or Work with Return Authorizations (these totals increase only when you process the credit). These totals include simple returns only, as opposed to exchanges.

  • number of orders: The total number of return transactions processed and credited, regardless of whether the returns are on the same order. For example, an order with 2 returned order lines processed separately updates this total by 2; however, if the same 2 returned order lines on a single order are processed in the same transaction, the total updates by 1. This is the Invoices credited number from the Order Control Summary table.

  • number of units: The total number of returned units, from the Quantity credited in the Order Control Summary table.

  • merchandise dollars: The merchandise dollar total of returned items, from the Invoices credited dollars in the Order Control Summary table.

Open order summary: The number of orders, number of units, and total merchandise dollar value for backordered orders, printed orders, and reserved/unprinted orders as of the ending date on the report. The system provides totals by open orders, held orders, and open and held orders.

• Open: Open order totals as of the ending date on the report, broken out by:

  • open number of orders: The total number of open orders; this is the number of orders in an open status. From the Open orders number in the Order Control Summary table for the ending transaction date.

  • open backordered number of units: The total number of units on backorder that are located on open orders. This is the Quantity backordered from the Order Control Summary table for the ending transaction date.

  • open backordered merchandise dollars: The total merchandise dollars of units on backorder that are located on open orders. This is the Open backordered dollars the Order Control Summary table for the ending transaction date.

  • open printed on pick slips number of units: The total number of printed units on open orders. The total number of open printed units is the Open printed quantity in the Order Control Summary table for the ending transaction date.

  • open printed on pick slips merchandise dollar total: The total merchandise dollars of printed units on open orders, from the Open printed dollars in the Order Control Summary table for the ending transaction date.

  • open reserved/unprinted number of units: The total number of reserved units on open orders, from the Open unprinted quantity in the Order Control Summary table for the ending transaction date.

  Held: Held order totals as of the ending date on the report, broken out by:

  • held number of orders: The total number of held orders; this is the number of orders in a held status, from the Held orders number in the Order Control Summary table for the ending transaction date.

  • held backordered number of units: The total number of units on backorder that are located on held orders, from the Quantity held backordered in the Order Control Summary table for the ending transaction date.

  • held backordered merchandise dollar total: the total merchandise dollars of units on backorder that are located on held orders, from the Held backordered dollars in the Order Control Summary table for the most recent transaction date.

  • held printed on pick slips number of units: The total number of printed units on held orders. This is the Held printed quantity in the Order Control Summary table for the ending transaction date.

  • held printed on pick slips merchandise dollar total: The total merchandise dollars of printed units on held orders. This is the Held printed dollars in the Order Control Summary table for the ending transaction date.

  • held reserved/unprinted number of units: The total number of reserved units on held orders. This is the Held unprinted quantity in the Order Control Summary table for the ending transaction date.

  • held reserved/unprinted merchandise dollar total: The total merchandise dollars of reserved units on held orders. This is the Held unprinted dollars in the Order Control Summary table for the ending transaction date.

General operational summaries: The number of orders, number of units, and total merchandise dollar value for suspended orders, pending pick slips, pending RA receipts, pending RA credits, and pending refunds. The total number of suspended batches also displays.

• Suspended batches number: The total number of order batches that are in a suspended status. This is the Batches suspended number in the Order Control Summary table.
• Suspended orders: Total number of suspended orders, suspended units, and total dollar value of suspended orders, regardless if the order is batched.

  • number: The total number of suspended orders; this is the number of orders in a suspended status. This is the Orders suspended number in the Order Control Summary table for the ending transaction date.

  • number of units: The total number of suspended units, including units on backorder or on a held order lines. This does not include soldout units. This is the Orders suspended quantity in the Order Control Summary table for the ending transaction date.

  • merchandise dollars: The merchandise dollar total of suspended orders, including units on backorder or on held order lines. This does not include merchandise dollars for soldout units. This is the Orders suspended dollars in the Order Control Summary table for the ending transaction date.

• Pending picks: The number of pending pick slips, number of units on pending pick slips, and merchandise dollars for pending pick slips. Pending pick slips are pick slips that have not yet been billed or voided. The system increases the pending pick slip number, units, and dollars for drop ship orders if the drop ship output defined for the vendor is drop ship pick slip; if the drop ship output defined for the vendor is drop ship purchase order or collaborative shipping, the system only increases the total units and total dollars pending and does not increase the total number pending.

  • number: The total number of pick slips pending. This is the Pending picks number in the Order Control Summary table for the ending transaction date.

  • number of units: The total number of units on pending pick slips. This is the total of the Open printed quantity and the Held printed quantity in the Order Control Summary table for the ending transaction date

  • merchandise dollars: The merchandise dollar total of items on pending pick slips. This is the total of the Open printed dollars and the Held printed dollars in the Order Control Summary table for the ending transaction date.

• Pending RA receipts: The number of pending return authorization receipts, number of units on pending return authorization receipts, and merchandise dollars for pending return authorization receipts. Pending return authorization receipts are return authorizations that have been entered, but not yet received. You can only enter a pending RA receipt using non-streamlined return authorizations (the Use Streamlined Return Authorizations (F44) system control value is selected). These totals include quantities and merchandise dollar value of the items returned in return transactions and items returned in exchange transactions, not units and merchandise dollar value of items ordered in exchange.

  • number: The total number of pending return authorization receipts, regardless of whether the returns are on the same order. For example, an order with 2 pending RA receipt order lines processed separately updates this total by 2; however, if the same 2 pending RA receipt order lines on a single order are processed in the same transaction, the total updates by 1. This is the Pending RA receipt number in the Order Control Summary table for the ending transaction date.

  • number of units: The total number of units on pending return authorization receipts. This is the Pending RA receipt quantity in the Order Control Summary table for the ending transaction date.

  • merchandise dollars: The merchandise dollar total of items on pending return authorization receipts. This is the Pending RA receipt dollars in the Order Control Summary table for the ending transaction date.

• Pending RA credits: The number of pending return authorization credits, number of units on pending return authorization credits, and merchandise dollars for pending return authorization credits. Pending return authorization credits are return authorizations that have been received, but not yet credited. You can only enter a pending RA credit using non-streamlined return authorizations (the Use Streamlined Return Authorizations (F44) system control value is selected). These totals include quantities and merchandise dollar value of the items returned in return transactions and items returned in exchange transactions, not units and merchandise dollar value of items ordered in exchange.

  • number: The total number of pending return authorization credits, regardless of whether the returns are on the same order. For example, an order with 2 pending RA credit order lines processed separately updates this total by 2; however, if the same 2 pending RA credit order lines on a single order are processed in the same transaction, the total increases by 1. This is the Pending RA credit number in the Order Control Summary table for the ending transaction date.

  • number of units: The total number of units on pending return authorization credits. This is the Pending RA credit quantity in the Order Control Summary table for the ending transaction date.

  • merchandise dollars: The merchandise dollar total of items on pending return authorization credits. This is the Pending RA credit dollars in the Order Control Summary table for the ending transaction date.

• Pending refunds: The number of pending refunds, number of units on pending refunds, and merchandise dollars for pending refunds. Pending refunds are refunds in an open or held status that have not yet been processed; these totals do not include refunds that are in a pending cancelled, cancelled, pending write off, write off, or processed status

  • number: The total number of unprocessed refunds. This is the Refunds pending number in the Order Control Summary table for the ending transaction date.

  • merchandise dollars: The merchandise dollar total of items on unprocessed refunds. This is the Refunds pending dollars in the Order Control Summary table for the ending transaction date.

  .

General merchandising summaries: The number of orders, number of units, and total merchandise dollar value for backordered items, open POs, held POs, docked POs, open past due POs, held past due POs, docked past due POs, suspense receipts, pending putaway inventory, and staged warehouse inventory.

• Backordered items: The number of items on backorder, number of units on backorder, and merchandise dollars of backordered items.

  • number: The total number of items on backorder. This is the Backorder items number in the Order Control Summary table for the ending transaction date.

  • number of units: The total number of units on backorder, across items. The system adds the Open backordered quantity and the Held backordered quantity in the Order Control Summary table for the ending transaction date to determine the total number of units on backorder.

  • merchandise dollars: The merchandise dollar total for items on backorder. The system adds the Open backordered dollars and the Held backordered dollars in the Order Control Summary table for the ending transaction date to determine the merchandise dollar total of backordered items.

• Open PO: The number of open purchase orders, number of units on open purchase orders, and merchandise dollars of items on open purchase orders. Open purchase orders are POs that are in an open (O) status; this does not include drop ship POs.

  • number: The total number of open purchase orders from the PO Header table. This is the Open PO number in the Order Control Summary table for the ending transaction date.

  • number of units: The total number of units on open purchase orders from the PO Detail table. This is the Open PO quantity in the Order Control Summary table for the ending transaction date.

  • merchandise dollars: The merchandise dollar total for open purchase orders from the PO Detail table. This is the Open PO dollars in the Order Control Summary table for the ending transaction date.

• Held PO: The number of held purchase orders, number of units on held purchase orders, and merchandise dollars of items on held purchase orders. Held purchase orders are POs that are in a held (H) status; this does not include drop ship POs.

  • number: The total number of held purchase orders from the PO Header table. This is the Held PO number in the Order Control Summary table for the ending transaction date.

  • number of units: The total number of units on held purchase orders from the PO Detail table. This is the Held PO quantity in the Order Control Summary table for the ending transaction date.

  • merchandise dollars: The merchandise dollar total for held purchase orders from the PO Detail table. This is the Held PO dollars in the Order Control Summary table for the ending transaction date.

• Docked PO: The number of docked purchase orders, number of units on docked purchase orders, and merchandise dollars of items on docked purchase orders. Docked purchase orders are POs that are in a docked (D) status. The PO line status can be open (O) or held (H) to be included in these totals. If you partially receive a docked PO, the system updates the PO status from docked (D) to open (O).

  • number: The total number of docked purchase orders from the PO Header table. This is the Docked PO number in the Order Control Summary table for the ending transaction date.

  • number of units: The total number of units on docked purchase orders, from the PO Detail table. This is the Docked PO quantity in the Order Control Summary table for the ending transaction date.

  • merchandise dollars: The merchandise dollar total for docked purchase orders from the PO Detail table. This is the Docked PO dollars in the Order Control Summary table for the ending transaction date.

• Open past due PO: The number of open purchase orders that contain purchase order lines that are past due, number of units on open purchase orders that are past due, and merchandise dollars of items on open purchase orders that are past due. This does not include drop ship purchase orders. Open past due purchase order lines are PO lines that have not yet been received and are past the expected due date (the Due date defined for the PO line is less than the current date) and the PO header status is open (O). The PO line status can be open (O) or held (H) to be included in these totals.

  • number: The total number of open POs that contain PO lines that are past due from the PO Header table. This is the Open past due PO number in the Order Control Summary table for the ending transaction date.

  • number of units: The total number of units on open POs that are past due from the PO Detail table. This is the Open past due PO liens in the Order Control Summary table for the ending transaction date.

  • merchandise dollars: The merchandise dollar total for items on open POs that are past due from the PO Detail table. This is the Open past due PO dollars in the Order Control Summary table for the ending transaction date.

  Held past due PO: The number of held purchase orders that contain purchase order lines that are past due, number of units on held purchase orders that are past due, and merchandise dollars of items on held purchase orders that are past due. This does not include drop ship purchase orders. Held past due purchase order lines are PO lines that have not yet been received and are past the expected due date (the Due date defined for the PO line is less than the current date) and the PO header status is held (H). The PO line status can be open (O) or held (H) to be included in these totals.

  • number: The total number of held POs that contain PO lines that are past due from the PO Header table. This is the Held past due PO number in the Order Control Summary table for the ending transaction date.

  • number of units: The total number of units on held POs that are past due from the PO Detail table. This is the Held past due PO lines in the Order Control Summary table for the ending transaction date.

  • merchandise dollars: The merchandise dollar total for items on held POs that are past due from the PO Detail table. This is the Held past due PO dollars in the Order Control Summary table for the ending transaction date.

• Docked past due PO: The number of docked purchase orders that contain purchase order lines that are past due, number of units on docked purchase orders that are past due, and merchandise dollars of items on docked purchase orders that are past due. This does not include drop ship purchase orders. Docked past due purchase order lines are PO lines that have not yet been received and are past the expected due date (the Due date defined for the PO line is less than the current date) and the PO header status is docked (D). The PO line status can be open (O) or held (H) to be included in these totals.

  • number: The total number of docked POs that contain PO lines that are past due from the PO Header table. This is the Docked past due PO number in the Order Control Summary table for the ending transaction date.

  • number of units: The total number of units on docked POs that are past due from the PO Detail table. This is the Docked past due PO lines in the Order Control Summary table for the ending transaction date.

  • merchandise dollars: The merchandise dollar total for items on docked POs that are past due from the PO Detail table. This is the Docked past due PO dollars in the Order Control Summary table for the ending transaction date.

• Suspense receipt: The number of PO lines received into suspense, number of units received into suspense, and merchandise dollars of items received into suspense.

  • number: The total number of PO lines received into suspense from the PO Suspense table, including PO lines that only have a partial quantity received into suspense. This is the Suspense receipts number in the Order Control Summary table for the ending transaction date.

  • number of units: The total number of units on PO lines received into suspense from the PO Suspense table. This is the Suspense receipts quantity in the Order Control Summary table for the ending transaction date.

  • merchandise dollars: The merchandise dollar total for items received into suspense from the PO Suspense table. This is the Suspense receipts dollars in the Order Control Summary table for the ending transaction date.

• Pending putaway: The number of PO lines received into a pending putaway warehouse, number of units received into a pending putaway warehouse, and merchandise dollars of items received into a pending putaway warehouse. A pending putaway warehouse is a warehouse where you place inventory that is on its way to its final destination. You can define a warehouse as a pending putaway warehouse by assigning a warehouse location type of PP (pending putaway warehouse) to the warehouse in Working with Default Warehouse Locations (WWDL). The system increases these totals when you receive a PO line or a partial quantity on a PO line into a pending putaway warehouse.

  • number: The total number of PO lines received into a pending putaway warehouse from the Pending Putaway Detail table, including PO lines that only have a partial quantity received into a pending putaway warehouse. This is the Pending putaway lines in the Order Control Summary table for the ending transaction date.

  • number of units: The total number of units received into a pending putaway warehouse from the Pending Putaway Detail table. This is the Pending putaway quantity in the Order Control Summary table for the ending transaction date.

  • merchandise dollars: The merchandise dollar total of items received into a pending putaway warehouse from the Pending Putaway Detail table. This is the Pending putaway dollars in the Order Control Summary table for the ending transaction date.

• Staging warehouse: The number of PO lines received into a staging warehouse, number of units received into a staging warehouse, and merchandise dollars of items received into a staging warehouse. A staging warehouse is a warehouse that designates an area within your actual warehouse where you keep stock that needs to be put away. You can define a warehouse as a staging warehouse by entering the warehouse code in the Default Staging Warehouse (E15) system control value. The system increases these totals when you receive a PO line or a partial quantity on a PO line into a staging warehouse.

  • number: The total number of PO lines received into a staging warehouse, including PO lines that only have a partial quantity received into a staging warehouse. This is the Staging inventory number in the Order Control Summary table for the ending transaction date.

  • number of units: The total number of units received into a staging warehouse. This is the Staging inventory quantity in the Order Control Summary table for the ending transaction date.

  • merchandise dollars: The merchandise dollar total of items received into a staging warehouse. This is the Staging inventory dollars in the Order Control Summary table for the ending transaction date.

Order Addition Audit Report

Use the Print the Order Addition Report (PAAR) menu option. You can also add this report to your periodic processing.

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

Contents:

• date range (from and to dates for the period)
• add reason code
• operator (Rep) who added the item
• order number
• add reason code
• item or alias code
• SKU codes, if any
• description of the item
• unit price
• total number of order lines added by the operator for this add reason
• total number of order lines added by all operators for this add reason
• grand total number of order lines added for the period

Order Cancellation List by Item

This report lists each order flagged for backorder cancellation that is associated with the vendor, buyer, or item you select at the Select Items for Backorder Cancellation Report screen. If you left these fields blank at the prompt screen, each item flagged for cancellation due to backorder will appear on this report.

Select Accept at the Select Items for B/O Cancellation Report Screen, or select Print Report at the Work with Backorders Pending Cancellation Screen.

Note:

Like Working with Backorders Pending Cancellation (WBPC), this report does not include orders that would be eligible for cancellation due to backorder, but are flagged for cancellation due to credit card decline. See Working with Credit Card Cancellations (WCCC), for more information.

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

The contents on this report are broken out by backordered item.

Contents:

• Vendor: The number identifying the vendor for the item. Below the Buyer column heading.
• Buyer: The three-position code identifying the buyer for the item. Below the Item column heading.
• Item: The code identifying the item.
• SKU: The code identifying the unique SKU, if any.
• Description: The description of the item.
• Backorder Quantity: The total quantity of the order line that is backordered.
• Total Amount: The extended price (unit price * quantity) of the order line that is backordered.
• Cancel Date: The date when the order line is eligible for cancellation.
• Order Number
• Customer Number: The number identifying the sold-to customer on the order.

Totals:

• Item Total: The total Backorder Quantity and amount for the item.
• Grand Total: The total Backorder Quantity and amount for all items on the report.

Orders Canceled After Second Notice Report

The system produces this report when you process a cancel request by completing the Cancel Backordered Lines Window.

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

Contents:

• order number and ship-to number
• sold-to customer
• order line number
• item code
• SKU code, if applicable
• quantity
• cancel date

Order Hold Detail Report

Complete the Process Auto Sold Outs Screen. The system generates this report only if the Update orders and Hold related coordinate group lines fields are selected.

This report lists any order lines that were held because there was a soldout item that was coordinate grouped with one or more other items on the order.

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

Contents:

• batch number
• date you process auto soldouts
• item code
• SKU code, if any
• order number
• order line number
• status (S = soldout item; H = held item)
• coordinate group code
• item description
• quantity ordered
• unit price
• customer sold to first and last name
• customer sold to city and state or province
• home phone number of customer sold to

Order Receipt

Purpose: The order receipt provides a single view of the shipments that have taken place for an order ship-to. The receipt does not list any activities that have reduced order totals, such as a return, an item entered with a negative quantity, or a credit applied after shipment; however, the current order totals listed on the receipt reflect these activities if they have occurred.

1. Select Order Receipt at the Display Invoices Screen in standard order inquiry or,
2. Click the order receipt icon at the Invoices section of the Third Streamlined Order Inquiry Screen (Order Summary):

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

The contents described below are based on the Order Receipt Print Program (L46) system control value being set to the base graphical print program of ORDERRECG. If you use a different program, your receipt will differ.

Contents: The order receipt includes the following areas:

1. logo (if any), title, order information, and current sold-to and ship-to name and address
2. shipped items, ship via, and tracking number for each shipment
3. shipment totals to date for the order
4. payment methods that have been billed

Each of these components is described below. Also, see the Things to Note about the Order Receipt for additional details.

A. The information at the top of the page is:

1. Logo: You can include a company logo or an entity logo. The receipt uses the same logo as the pick slip. See Setting Up Company Logos for Forms and the Print Entity Image (K35) system control value for background and setup information.
2. Order #: The order number is separated from the ship-to number by a hyphen.
3. Order date: The Order date entered for the order header. Defaults to the current date when you create an order.
4. Sold To: The current name and address of the customer who placed the order, consisting of:
5. Company name
6. First name, Middle initial, and Last name
7. First address line
8. Apartment or Suite
9. Second address line

Note:

Lines 3 and 4 are not included.

1. City
2. State
3. Postal code
4. Country code
5. Ship To: The current name and address of the customer receiving the order. If the shipping address changes between shipments, the current shipping address is at the top of the page. This address is in the same format as the Sold To name and address, as well as the Attention line, if any, and can be:
6. the sold-to customer
7. a recipient customer
8. a permanent shipping address from the Address Book
9. a one-time ship-to address

Note:

This section of the receipt (logo, sold to, and ship to) is included at the top of each page if the receipt is more than one page. If individual shipments were mailed to a different ship-to address, those addresses are listed below.

B. Below is a summary of the Items that have been shipped for this order. This section consists of items shipped and related information, including the ship via and tracking number, and may also include the shipping address for the shipment, if it differs from the current address at the top of the page. The items, shipping information, and shipping address are listed separately for each invoice:

1. For each date when a shipment occurred, starting with the most recent shipment:
2. Items shipped on: Indicates the date shipped.
3. For each order line shipped on that date and billing on the same invoice, in alphanumeric order by item and SKU codes:
4. Item/SKU: the item code; separated by the SKU code, if any, by a slash (/)
5. Quantity: the quantity of the item that shipped on the date indicated
6. Price: the actual selling price per unit that billed

   Note: The price is .00 if, for example, the item was a free gift or a component of a set.

7. Extended price: The unit price * the quantity
8. Description (unlabeled field): the item description, followed by the SKU description
9. Ship To Address: The shipping address from the Invoice Address table. This name and address is in the same format as the Sold To and Ship To addresses above, and is included only if the Capture Addresses for Invoice (J24) system control value is selected, and if the name and address for the invoice differs from the Ship To address at the top of the page
10. For each shipment:
11. Shipping information: the description of the ship via who made the shipment
12. Tracking number (unlabeled field): included if it is available from the Manifest Upload Audit table. If there are multiple tracking numbers in the table for the same invoice, each tracking number is included

Note:

The ship via and tracking number may not be included if you confirmed confirmation manually, for brokered backorders fulfilling through integration with Order Orchestration, or for store pickup orders.

C. Current totals for the order ship-to, consisting of:

1. Merchandise: The current merchandise total for the order ship-to. This can differ from the sum of the item extended prices due to subsequent activity, such as returns or discounts applied after shipment. These activities can also affect the shipping, handling, and tax totals.
2. Shipping and Handling: The current freight and handling total for the order ship-to, including any special handling, gift wrap, and additional charges
3. Tax: The current total tax on the order, excluding any VAT
4. Total: The current total merchandise, shipping and handling, and tax

D. Payment methods billed for the order ship-to, consisting of:

1. Pay Method: The description of the payment method from the Pay Type table
2. Last 4 of Credit Card: The last 4 positions of the credit card. Included only for credit card pay types
3. Amount: The amount billed to the payment method. This amount might be zero for a shipment restricted to “no charge” items, such as free gifts or set components

Note:

The receipt does not indicate whether the deposit has been processed for the shipment, or whether a deferred or installment billing plan was used.

Things to Note about the Order Receipt

1. System control value: The Order Receipt Print Program (L46) system control value controls the format of the order receipt. The base print program is ORDERRECG (graphical form).
2. Credits not included: Only regular (debit) invoices are eligible for inclusion on the order receipt. The dollar amounts listed do not reflect any credits that might apply after billing.
3. Separate receipt for each order ship-to, but multiple invoices for an order ship-to on a single order receipt:
4. When you generate the order receipt for a multi-recipient order, the system generates a separate document for each separate ship-to;
5. However, if there were multiple shipments for a single order ship-to, all shipments are included on a single order receipt. The items, ship via, and tracking number (if available) for each shipment are listed separately, with shipped order totals and payment methods combined at the end of the order receipt.
6. When is the ship-to address listed below the shipped items? A ship-to name and address is listed below the items only if the Capture Addresses for Invoice (J24) system control value is selected, and if the name and address for the invoice differs from the Ship To address at the top of the page. The top of the page always indicates the current sold-to and ship-to name and address, even if the selected order did not ship to the customer’s current address(es).
7. Consolidate invoice? Your system control value settings control whether multiple shipments for an order on the same day are eligible for consolidation. See the Invoice Consolidation Method (E29) system control value for a discussion.

   Important: In Order Management System 21.0 or higher, you cannot select the Consolidated Invoice system control value if it is not already selected. If the system control value is currently selected (set to Y) and you deselect it (change it to N or blank), you cannot then change it back to selected. The option to consolidate invoices will be removed at a later date.

8. Setting up the logo to print on the order receipt: See Setting Up Company Logos for Forms for information on configuring the logo to print on the order receipt and other forms.
9. Invoices in reverse chronological order: If there have been multiple shipments for the order, they are listed in reverse chronological order (newest to oldest).
10. Items in alphanumeric order: All items shipped on the same invoice are listed in alphanumeric order by item and SKU code. As a result, a main set item and its components might not be listed together on the receipt.
11. When is the tracking number included? The tracking number is included if it is available from the Manifest Upload Audit table. The generic pick in API writes the tracking number to this table; however, manual confirmation and orders confirmed through integration with Order Orchestration do not write to the Manifest Upload Audit table, so the tracking number does not print for shipments using these methods.
12. Order receipts in Customer Invoices folder: Order receipts are included in the Customer Invoices folder. See Forms Management (My Forms)for background.
13. Currency is not indicated: The receipt does not indicate the currency used on the order.
14. No page numbering: If the receipt runs to multiple pages, the pages are not numbered.
15. Gift orders: Prices and totals are included for gift orders as well as non-gift orders.
16. “No charge” items: You can still generate an order receipt even if the invoice totals are zero. The zero prices and totals print on the receipt.

Order Reconciliation Report

Complete the Order Reconciliation Report Screen. For more information: See the sample report in PDF format.

Contents:

• dates included in the report. These are the dates you entered at the Order Reconciliation Report screen.
• gross demand (not including returns), broken out by:

  • total number of orders: includes the total number of orders, regardless of whether an order is a multiple or single ship-to order

  • total units of merchandise

  • total merchandise value; not including shipping, handling, or other additional order charges

• open, broken out by:

  • total number of open orders, regardless of whether an order is a multiple or single ship-to order

  • total units of merchandise on open orders

  • total merchandise value; not including shipping, handling, or other additional order charges

• held, broken out by:

  • total number of held orders

  • total units of merchandise on held orders; does not include units of merchandise held at the order line level

  • total value of merchandise on held orders; does not include merchandise held at the order line level.

• cancelled, broken out by:

  • total number of cancelled orders

  • total units of merchandise cancelled on all orders

  • total value of merchandise cancelled on all orders

• sold out, broken out by:

  • total units of merchandise sold out on all orders

  • total value of merchandise sold out on all orders

• closed/shipped, broken out by:

  • total number of closed orders, including quotes

  • total units of merchandise shipped

  • total value of merchandise shipped

• returned, broken out by:

  • total number of orders for which at least one item has been returned

  • total units of merchandise returned

  • total value of merchandise returned

Order Shipment Analysis Report

Use the Printing the Order Shipment Analysis (POSA) menu option.

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

Contents:

• Cmp: Company code.
• Ofr: Catalog (offer) code.
• Orders: Number of orders.
• Items ordered: Number of items ordered.
• Order value: Order value.
• Avg Ord Size: Average order size.
• Phone orders: Number of phone orders.
• Phone value: Value of phone orders.
• Avg Ord Size: Average size of phone orders.
• Mail orders: Number of mail orders.
• Mail value: Value of mail orders.
• Avg Ord Size: Average size of mail orders.
• Shpmnts: Number of shipments.
• Items Shipped: Number of items shipped.
• Shipment Value: Shipment value.
• Total
• Final Totals

Order Status and Activity Reports

Purpose: By using the reports listed below, you can research cancellation, backorder, shipment and sales activity.

• Submit Order Cancellation List Screen (POCL)

  • Order Cancellation List

• Printing Backorder Reports (PBOR)

  • Print Backorder Report Selection Prompt Screen

  • Backorder Report by Item

  • Backorder Report by Item with SKU Details

  • Backorder Report by Warehouse

  • Backorder Report by Warehouse with SKU Details

  • Backorder Report by Vendor

  • Backorder Report by Vendor with SKU Details

  • Backorder Report by Vendor w/PO

  • Backorder Report by Vendor/SKU/PO

• Printing the Sales Journal (PDSJ)

  • Out-of-Balance Invoices

  • Reporting by Division

  • Standard Sales Journal

  • Sales Journal by Division

• Printing the Sales Journal by Pay Type (PSJP)

  • Sales Journal by Pay Type

• Printing the Sales Journal Summary (PSJM)

  • Sales Journal Summary by Period

  • Sales Journal Summary by Offer

  • Sales Journal Summary by Descending Dollars

  • Sales Journal Summary by Invoice Date

  • Sales Journal Summary by Entity/Offer

• Sales Journal Summary by Order Type (Note: You generate this report through a periodic function)
• Printing Sales Journal Errors (PSJE)

  • Print Sales Journal Errors Screen

  • Sales Journal Errors Report

• Printing the Order Shipment Analysis (POSA)

  • Order Shipment Analysis Report

• Printing the Open Prepaid Order List (POPP)

  • Open Prepaid Order List

• Print the Order Addition Report (PAAR)

  • Order Addition Audit Report

• Printing the Sales Tax Report by State (PSTX)

  • State Tax Report

• Printing the State Tax Detail Report (PSTD)

  • State Tax Detail Report

• Printing the Order Demand/Sales Reports (PSSR)

  • Salesman Demand Report

  • Source Shipped Report

• Item Purchase and Sales Aging Report (LIPS)

  • Item Purchase and Sales Aging Report

• Print Order Control Report (POCT)

  • Order Control Report Screen

  • Operations Control Report

• Printing the Held Order Report (PHOR)

  • Held Order by Reason Code Report

• Printing the Daily Business Status Report (DBST)

  • Daily Business Status Report

• Printing the Order Reconciliation Report (PORS)

• Order Reconciliation Report

• Printing the Sales Journal by Currency Report (PSJC)

  • Sales Journal By Currency Report

• Printing the Held Orders by Pay Type Report (PHOP)
• Held Order by Pay Type Report
• Printing the Price Override Reason Report (PROR)

  • Identifying the User who Applied the Price Override

  • Print Price Override Reason Report Screen

  • Price Override Reason Report

• Printing the Return Reason Report (PRRR)

  • Return Reason Report

• Printing the Exchange Reason Report (PERR)

  • Exchange Reason Report

For information on how to research order activity through on-line inquiries, see Displaying Open Orders by Item (DOOI).

Order Status Reports and On-line Inquiries

In this part: This part presents the reports and on-line inquiries you use to monitor order activity for your company according to a variety of criteria.

• Order Status and Activity Reports provides examples of the reports related to researching an order through Order Inquiry, including order cancellation reports, backorder reports, sales journals, shipment analyses, and prepaid orders lists.
• Displaying Open Orders by Item (DOOI) describes several on-line inquiry functions that can help you evaluate your order activity.
• Ship Via/Item Inquiry (SVII) describes how to review the shippable orders for different shippers, broken out by item.
• Printing Backorder Reports by Descending Dollars (PBOD) describes how to generate the Backorder Report by Descending Dollars and provides a sample report
• Reviewing Operations Control Summary (FLSH) allows you to review operations and merchandising summary information.
• Reviewing Pending Orders (DOSS) describes how to review orders requiring further processing or action.
• Sales Summary (DSSS) describes a screen you can use to review sales numbers and amounts for the current date, week, and month, as well as sales for the current date broken out by order type and entity.
• Printing the Order Type Summary by Delivery Type Report (PDTS) describes how to generate the Order Type Summary by Delivery Type Report and provides a sample report.

Order Type Summary by Delivery Type Report

Purpose: This report displays order information summarized by order type and delivery type for orders that were entered within the date range you entered on the Order Delivery Type Summary Screen.

Which orders are included? The report includes order information only for orders whose Order status in the Order Header table is blank (Open), H (Held), X (Closed), or C (Cancelled). The date range you entered on the Order Type Summary screen determines which orders are selected for the report.

Enter a date range on the Order Delivery Type Summary Screen and select Submit.

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: A separate line prints on this report for each order type associated with orders entered within the date range you entered on the Order Delivery Type Summary screen. Within each order type, a separate line prints order information for each delivery type. Order information displays on this report in ascending order type, delivery type sequence.

• Start date: The date entered in the Start date field on the Order Delivery Type Summary screen. The report includes orders whose Order date in the Order Header table falls within the specified date range.
• End date: The date entered in the End date field on the Order Delivery Type Summary screen. The report includes orders whose Order date in the Order Header table falls within the specified date range.
• Order Type: The code and description of an order type associated with one or more orders that were entered within the specified date range. From Order type in the Order Header table and Description in Order Type table.
• Delivery Type: A description of the delivery type assigned to orders entered for the order type specified. From Delivery Type in the Order Ship To table.

  • No Broker Type = Delivery Type is blank (not defined for the order ship to).

  • Delivery = Delivery Type D.

  • Store Pickup = Delivery Type P.

  • Retail Pickup = Delivery Type R.

  • Ship for Pickup = Delivery Type S.

• Number of Orders: The number of orders entered within the specified date range for the order type and delivery type. This is the sum of the qualifying records in the Order Header and Order Ship To tables that are associated with the specified order type and delivery type for the selected date range. Note:

  • Multi-recipient orders count as a single order unless a different delivery type is defined for a ship to. For example, a multi-recipient order counts as a single order if the Delivery Type for each ship to is S. However, if the Delivery Type for one ship to is S and the Delivery Type for the other ship to is blank, the order counts as 2 orders.

  • This number includes cancelled orders, regardless of whether the cancel reason code used reduces demand.

• Number of Lines: The total number of order lines on the orders entered within the specified date range for the order type and delivery type. This is the sum of the qualifying records in the Order Detail table that are associated with the specified order type and delivery type for the selected date range. Note:

  • This number does not include orders cancelled using a cancel reason code that reduces demand.

  • This number includes main set items as well as each component item.

• Number of Units: The total number of units on the orders entered within the specified date range for the order type and delivery type. This is the sum of the Qty ordered in the Order Detail table for the selected orders. Note:

  • This total does not include orders cancelled using a cancel reason code that reduces demand.

  • This total includes main set items as well as each component item.

• Merchandise Amount: The total merchandise amount on the orders entered within the specified date range for the order type and delivery type. This is the sum of the Qty ordered x Price in the Order Detail table for the selected orders. Note: This total does not include orders cancelled using a cancel reason code that reduces demand.
• Average Amount The average merchandise amount on the orders entered within the specified date range for the order type and delivery type. The system uses the following calculation to determine the Average Amount: Merchandise Amount for the order type and delivery type / # Orders for the order type and delivery type = Average Amount for the order type and delivery type.
• Average Number of Lines: The average number of lines on the orders entered within the specified date range for the order type and delivery type. The system uses the following calculation to determine the Average Number of Lines: Lines for the order type and delivery type / # Orders for the order type and delivery type = Average Number of Lines for the order type and delivery type.
• Percentage of Orders: The percentage of all orders entered within the specified date range that are associated with this order type and delivery type. The system uses the following calculation to determine the Percentage of Orders Number of Orders for this order type and delivery type / Total Number of Orders for all order types x 100 = Percentage of Orders.
• Percentage of Amount: The percentage of the total merchandise amount entered within the specified date range that are associated with this order type and delivery type. The system uses the following calculation to determine the Percentage of Amount: Merchandise Amount for this order type and delivery type / Total Merchandise Amount for all order types x 100 = Percentage of Amount
• Totals: Totals across all order types:

  • Total Number Orders: The number of orders entered within the specified date range across all order types and delivery types. This is the sum of the Number of Orders across all order types and delivery types.

  • Total Number of Lines: The total number of order lines on the orders entered within the specified date range across all order types and delivery types. This is the sum of the Number Lines across all order types and delivery types.

  • Total Number of Units: The total number of units on the orders entered within the specified date range across all order types and delivery types. This is the sum of the Number of Units across all order types and delivery types.

  • Total Merchandise Amount: The total merchandise amount on the orders entered within the specified date range across all order types and delivery types. This is the sum of the Merchandise Amount across all order types and delivery types.

  • Total Average Amount: The average merchandise amount on the orders entered within the specified date range across all order types and delivery types. This is the sum of the Average Amount across all order types and delivery types.

  • Total Average Number of Lines: The average number of lines on the orders entered within the specified date range across all order types and delivery types. This is the sum of the Average Number of Lines across all order types and delivery types.

Order Cancellation List

Complete the Submit Order Cancellation List Screen (POCL).

Quotes: The system includes quotes on this report whose cancel date is earlier than the date you ran the report. See Entering Pre-Order Quotes for an overview.

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

Contents:

• Order #: A unique number the system assigns to identify an order. These are the orders that are due to be canceled.
• Total $: The total dollar value of the order or quote that is due to be canceled. (Note: This report does not support multi-currency conversion. The order total appears in the currency on the order, regardless of whether you process orders in multiple currencies.)
• Customer Name: The number, last name, first name and middle initial of the customer who placed the order.
• Daytime phone #: The customer's daytime phone number. You can define a phone number format for each country; the system uses this format whenever you enter or change a customer's phone number. See Setting Up the Country Table (WCTY).
• Ship to: The ship to customer number that has the items with an overdue cancellation date.
• Line #: The order line number for the item with an overdue cancellation date.
• Cancel date: The date the item is eligible for cancellation, in company date format.
• Quantity: The quantity of the item on the order line that is eligible for cancellation.
• Item: The item number.
• SKU: The SKU code, if the item has SKUs.
• Description: The item description.

Price Override Reason Report

Purpose: Use this report to review the price override reason codes used to discount items for a range of dates, and the total discount amounts and percentages applied.

Complete the Print Price Override Reason Report Screen.

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.

Different report options: Depending on your selections at the Print Price Override Reason Report Screen, the report can include items with price overrides or the users who overrode prices, or be restricted to a single price override reason code:

Selections:			Report Generated
Price override reason code	Include users	Include items	Price Override Reason Report by:
yes	yes	yes	User, Code and Item
yes	yes	no	User and Code
yes	no	yes	Code and Item
yes	no	no	Code
no	yes	yes	User and Item
no	no	yes	Item
no	yes	no	User
no	no	no	N/A (produces the Price Override Reason Report)

Contents:

• Date Range. The Start date and End date entered at the Print Price Override Reason Report Screen. These are the original order dates, not necessarily the dates when the price override was applied.
• User ID and Description. Included only if you selected the Include users flag at the Print Price Override Reason Report Screen. The description is from Working with User Records (WUSR). See the Include users field for a discussion on how the system determines the user ID who performed the price override.
• Price Override Code and Description. The price override reason assigned to the order line. The description is from Establishing Price Override Reason Codes (WPOR). The system excludes any price override reason codes whose Exclude from price override report field is selected; see Default Price Override Reasons for a list of system-assigned codes specified in system control values. You can also limit the report to a single code by completing the Price override reason field at the Print Price Override Reason Report Screen.

• Item/SKU and Item Description. Included only if you selected the Include items flag at the Print Price Override Reason Report Screen. The item description is displayed even if the item has SKU’s.

  Calculated fields: The following fields are calculated for:

  • detail entries: by item/SKU or price override reason code, depending on your selections at the Print Price Override Reason Report Screen

  • subtotals: by user, price override reason code, depending on your selections at the Print Price Override Reason Report Screen

  • grand totals

• Units with overrides: The total number of units ordered whose price was overridden using the specified code.

  Note:

  This total is not decreased by units that have been canceled if the cancel reason code is not flagged to reduce demand. Also, it is not decreased by units returned against the original order line. This total is increased by returned units if the return was created by entering a negative quantity.

Example: If there were 10 units ordered and 3 units returned by entering a negative quantity, the total number of units is 13.

• Total discount: The total discount applied, calculated by subtracting the total selling price of all included units from the total offer price, and multiplying the result by the unit quantity.

Note:

The total discount includes the price of any returned lines created by entering a negative quantity.

Example: If the total amount discounted on ordered lines was $20.00 and the total amount discounted on returned lines was $5.00, this total is $25.00. If the returned lines had their prices increased $5.00 instead of decreased, then the total discount would be $15.00.

• This is a negative number if the price override resulted in a price increase.
• When an item has an offer price that is greater than zero and the item is added to an order at no charge, the Total discount = the offer price, and the Discount % = 100.00.
• When the Override Item Offer Price flag for a price override reason is selected and the item is added to an order at no charge, the Total discount and Discount % are both = 0.00.
• Discount Percent: The discount percentage, calculated by dividing the sum of the offer prices by the sum of the selling prices on order lines using the price override reason code. This is a negative number if the price override resulted in a price increase. See the notes above under the Total discount for information on when the Discount % might be 100.00 or 0.00. Note: The Discount % is not included in the grand totals.

Order lines included in calculations:

• The report includes overridden order lines on orders originally created in the selected date range; however, the prices could have been overridden at a later date.
• Orders that are in error or suspended status are not included on the report.
• Order lines that originated on quotes are included in the totals for the Price Override Reason for Quotes (K75) even after you convert the quote to an order unless you apply another price override reason code.

Print Catalog Request Interface Errors Report

Select Submit at the Work with Catalog Request Interface Screen.

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

Contents:

• File type
• Entity
• Sequence number for the catalog request record
• Name and address
• Source code
• Offer

To review the errors for each request listed, use the Change Catalog Request Screen.

Print Request Interface Report

Select Submit at the Work with Catalog Request Interface Screen.

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

Contents:

• File type
• Entity
• Source
• For each type, entity, and source combination, the total number of catalog request interface records:

  • available to be processed by the CATALOGREQ job (error-free)

  • in error

  • total records in the file at the time the job was run

  • number of catalog requests created

  • number of records whose Create catalog request? flags were unselected

• Totals for the file type

Processed Refund Register

Complete the Processed Refund Register Screen.

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:

• range of dates entered at the Processed Refund Register screen
• the date the refund was processed, written off, or canceled
• the date that the refund was created through a return, overpayment, cancellation, or soldout cancellation
• bank code and description
• a code that identifies the status of the refund. Valid values are:
• P = Processed
• C = Canceled
• T = Written off
• the type of refund. Valid values are:
• Check
• Credit card credit
• Stored value card
• the current payment category of the refund. Valid values are:
• 1 = Cash/check
• 2 = Credit card
• the category of the payment type used on the order. May differ from the current category if there is an alternate refund type or alternate refund category for the pay type used on the order. Valid values are:
• 1 = Cash/check
• 2 = Credit card
• refund amount; a minus sign indicates a credit
• pay type (Represents the specific method of payment used on the order)
• order number
• customer name
• for each refund status by bank:
• subtotal by refund type
• subtotal by status
• subtotal by bank
• final total for selected date range

For more information: See Introducing the Refund Process for more information on creating refunds. See Working with Refunds, Writeoffs and Balances Due (WREF) for more information on payment categories.

Purge Customer Subscription List

Complete the Purge Customer Subscriptions Screen.

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

Contents:

• Customer number (Sold To or Ship To, if recipient)
• Customer name (Last, First)
• Subscription item number
• SKU code
• First issue number
• Date of first issue
• Last issue number
• Date of last issue
• Expiration issue number
• Number of intervals (between issues)
• Interval days (number of days between sending each issue)
• Order number (on which subscription item ordered)
• Ship to number (identifies shipping address on the order)
• Line number (the order detail line on which the subscription item was ordered)

Refund Check

Purpose: You might generate a refund check if a customer paid for an order by cash or check and if an item was sold out or backordered.

The Refund Check Print Program (D23) system control value identifies the refund check print program to use. The standard non-graphical print program for printing refund checks is REFCHECK. The standard graphical print program for printing refund checks is REFCHECKG.

Complete the Process Refunds Screen (MREF) with the Generate refund checks field selected.

Working with forms: See Forms Management (My Forms) for information on displaying or printing refund checks and other forms.

Sample refund checks: See the non-graphical sample refund check and the graphical sample refund check.

Contents:

Check stub: The top portion of the page represents the check stub.

• Order #: The order number and ship-to number.
• Order Message: Up to three lines of messages (flagged as Check Cust Msg at the Work with Order Messages screen; see Reviewing Order-Level Properties). If you reprint a check, the same messages will appear on the reprint unless you change them through order messages.
• Chk #: Refund check number.
• Amt: The amount of the refund. The tax amount included in the refund amount is based on the tax rate that was effective when the item was shipped.

Check: The bottom portion of the page represents the refund check itself. All fields on the check are unlabeled.

• Refund Date: The date the refund check was generated.
• Check Number: The check number on the check itself is followed by an asterisk (*) if this is a reprint. There is no asterisk next to the check number on the stub.

Note:

The refund amount is spelled out alphanumerically above the customer name and address if the Print Alpha $ Amount on Refund Check (E30) system control value is selected.

• Refund Amount: The amount of the refund. The tax amount included in the refund amount is based on the tax rate that was effective when the item was shipped.
• Customer Name and Address: The sold-to customer name and address appears here unless there is a bill-to customer associated with the order; in this case, the bill-to customer name and address is indicated. The name and address includes the:

  • prefix, first name, last name

  • company

  • address line 1

  • city, state, postal code

Note:

The country does not print on the refund check.

Refund Check Register

Complete the Process Refunds Screen (MREF) with the Generate refund checks field selected.

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

Contents:

• Original Check #: The original check number.
• Refund Amount: The refund amount in the local currency (the currency defined in the Local Currency Code (A55) system control value). The tax amount included in the refund amount is based on the tax rate that was effective when the item was shipped.
• Bonus Percent: Indicates the bonus discount, if any, you are awarding the customer for applying the refund check to another order.
• Order Number: The order number and ship-to number associated with the refund check.
• Customer Number: The sold-to customer number, unless there is a bill-to customer associated with the order; in this case, this is the bill-to customer number.
• Name: the sold-to or bill-to customer name, preceded by the company name, if any. The entry wraps to a second line if needed.
• Reprint: Set to Y if this is a reprinted check; otherwise set to N. See the Reprint Refunds Screen (MREP).
• Final Totals: The total amount for the refunds, across all refund checks, in the local currency.

Refund Due List

Complete the Print Refund Due List Screen.

The following reports are generated, based on the By refund type and By order # check boxes on the Print Refund Due List screen:

• Refund Due List by Type. This report sorts refunds by refund type.
• Refund Due List by Order #. This report sorts refunds by order number.

The Selection criteria drop down box on the Print Refund Due List Screen controls the type of refunds that display on the report.

• All = The report includes all refunds, including balance dues and writeoffs.
• Refunds Only = The report includes refunds, excluding balance dues and writeoffs. The text Refunds Only displays after the report title.
• Balance Dues Only = The report includes balance dues only. The text Balance Dues Only displays after the report title.
• Writeoffs Only = The report includes writeoffs only. The text Writeoffs Only displays after the report title.

Identifying a refund as balance due: The system considers a refund a balance due if the Refund reason field for the refund is set to B (Balance due).

Identifying a refund as a write off: The system considers a refund a write off if the Refund status field for the refund is set to W (Write off pending).

Note:

If a refund is flagged as both a balance due and a write off, the write off setting will take precedence over the balance due setting. In this situation, if you select to generate the report for Balance Dues Only, the system will not include the refund on the report. If you select to generate the report for Writeoffs Only, the system will include the refund on the report.

Note:

Important: If you generate the Refund Due List during a time when refunds are being processed, the totals and amounts on the report may not tie out correctly because the refunds that were being processed at the time the report was generated will not be reflected accurately on the report. You should generate the Refund Due List during a time when refunds are not being processed.

Refund Due List by Type

The Refund Due List by Type report sorts refunds by bank and within bank, by refund type, status, order number, and refund sequence number. The report page breaks by bank and refund type. The system generates this report if you select the By refund type check box on the Print Refund Due List Screen.

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:

• Bank: The Refund Due List by Type sorts refunds by bank. If you process orders in multiple currencies, the bank code indicates the currency used on the order and to use for the refund. The bank code is linked to the division of the source code on the order. The default check number for refund checks is also defined in the Bank table.

The report includes subtotals by refund type and report totals for each bank in use on your system. If you do not process orders in multiple currencies, the bank code indicates the division and next check number only.

The dollar amount of each refund is presented on the Refund Due List, and throughout all functions related to refunds, in the currency on the order. The totals for each currency also appear on the report if you process orders in multiple currencies.

The Multi Currency by Offer (E03) system control value must be selected for you to process orders in multiple currencies.

• Order #: The order number and ship to number associated with the refund.
• Typ (Refund type): The Refund Due List by Type sorts refunds by the following refund types:

Refund Type	Description
C	Credit card credit
K	Check
V	Stored value card

A page break separates each refund type on the report.

• Sts (Pending refund status): The report provides totals for each refund type broken out by the refund's pending status (the action to be taken on the order when you process refunds). Valid status types are:

Refund Status	Description
H	Held
N	Cancel pending
O	Open
W	Writeoff pending

• Amount (Refund amount): The dollar amount to be refunded. A negative sign indicates a balance due the customer. An asterisk after the amount indicates the refund has been flagged for Credit Card Net Exchange Billing.
• Ref date (Refund date): The date the transaction that resulted in a refund occurred.
• Man hld (Manual hold): Indicates whether the refund is on hold. A refund may be on hold because you placed it on hold through Work with Refunds (WREF), or the system placed the refund on hold because the refund amount exceeds the maximum amount defined for the pay type.

  • Y = The refund is on hold. Refunds on hold will not be processed when you process refunds (MREF).

  • N = The refund is not on hold. The refund will be processed when you process refunds (MREF).

• Hold until: The date when the system will release a refund from hold.
• PT (Pay type): The pay type on the order associated with the refund.
• DI (Deferred/Installment pay plan): The payment plan defined on the order. D indicates the order includes a deferred payment plan; I indicates the order includes an installment payment plan.
• Customer #: The number here refers to the sold-to customer unless there is a bill-to customer associated with the order producing the refund; in this case, this is the bill-to customer number.
• Sold to net W/O$ (Sold to net write off dollars): The net writeoff amount accumulated for the customer. A positive amount represents a balance you owe the customer; a negative amount represents a balance the customer owes you. This is the writeoff amount for the sold-to customer for the order.
• Phone #: The sold-to or bill-to customer's phone number.
• Current action: The action to be taken when the refund is processed. Possible actions are:

  • Refund will be processed.

  • Refund is on manual hold.

  • Refund will be cancelled.

  • Order Header is on hold.

• Totals for type: The total number and dollar amount of refunds for the refund type, broken out by:

  • Held: The number and dollar amount of refunds for the refund type that are held.

  • Open: The number and dollar amount of refunds for the refund type that are open and will be processed.

  • Cancel: The number and dollar amount of refunds for the refund type that will be cancelled.

  • Writeoff: The number and dollar amount of refunds for the refund type that will be written off.

• Final totals: Final totals by refund type (check, credit card, and stored value card) and status (held, open, cancel, and writeoff) appear for each bank. If you process orders in multiple currencies, the total by bank specifies the currency. The report provides final totals for each refund type and totals across all refund types. The system provides the number and dollar amount of refunds broken out by:

  • Held: The number and dollar amount of refunds for the refund type and across all refund types that are held.

  • Open: The number and dollar amount of refunds for the refund type and across all refund types that are open and will be processed.

  • Cancel: The number and dollar amount of refunds for the refund type and across all refund types that will be cancelled.

  • Writeoff: The number and dollar amount of refunds for the refund type and across all refund types that will be written off.

Refund Due List by Order #

The Refund Due List by Order # sorts refunds by bank and within bank, by order number and refund type. The report breaks by order, inserting an extra line after each order grouping. The report page breaks by bank.The system generates this report if you select the By order # check box on the Print Refund Due List Screen.

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:

• Bank: The Refund Due List by Order Number sorts refunds by bank only if you process orders in multiple currencies. If you process orders in multiple currencies, the bank code indicates the currency used on the order and to use for the refund. The bank code is linked to the division of the source code on the order. The default check number for refund checks is also defined in the Bank table.

The report includes subtotals by refund type and report totals for each bank in use on your system. If you do not process orders in multiple currencies, the bank code indicates the division and next check number only.

The dollar amount of each refund is presented on the Refund Due List, and throughout all functions related to refunds, in the currency on the order. The totals for each currency also appear on the report if you process orders in multiple currencies.

The Multi Currency by Offer (E03) system control value must be selected for you to process orders in multiple currencies.

• Order #: The order number and ship to number associated with the refund.
• Typ (Refund type): The Refund Due List by Type sorts refunds by the following refund types:

Refund Type	Description
C	Credit card credit
K	Check
V	Stored value card

A page break separates each refund type on the report.

• Sts (Refund status): The report provides totals for each refund type broken out by the refund's pending status (the action to be taken on the order when you process refunds). Valid status types are:

Refund Status	Description
H	Held
N	Cancel pending
O	Open
W	Writeoff pending

• Amount (Refund amount): The dollar amount to be refunded. A negative sign indicates a balance due the customer. An asterisk after the amount indicates the refund has been flagged for Credit Card Net Exchange Billing.
• Ref date (Refund date): The date the transaction that resulted in a refund occurred.
• Man hld (Manual hold): Indicates whether the refund is on hold. A refund may be on hold because you placed it on hold through Work with Refunds (WREF), or the system placed the refund on hold because the refund amount exceeds the maximum amount defined for the pay type.

  • Y = The refund is on hold. Refunds on hold will not be processed when you process refunds (MREF).

  • N = The refund is not on hold. The refund will be processed when you process refunds (MREF).

• Hold until: The date when the system will release a refund from hold.
• PT (Pay type): The pay type on the order associated with the refund.
• DI (Deferred/Installment pay plan): The payment plan defined on the order. D indicates the order includes a deferred payment plan; I indicates the order includes an installment payment plan.
• Customer #: The number here refers to the sold-to customer unless there is a bill-to customer associated with the order producing the refund; in this case, this is the bill-to customer number.
• Sold to net W/O $ (Sold to net write off dollars): The net writeoff amount accumulated for the customer. A positive amount represents a balance you owe the customer; a negative amount represents a balance the customer owes you. This is the writeoff amount for the sold-to customer for the order.
• Phone #: The sold-to or bill-to customer's phone number.
• Current action: The action to be taken when the refund is processed. Possible actions are:

  • Refund will be processed.

  • Refund is on manual hold.

  • Refund will be cancelled.

  • Order Header is on hold.

• Final totals: Final totals by refund type (check, credit card, and stored value card) and status (held, open, cancel, and writeoff) appear for each bank. If you process orders in multiple currencies, the total by bank specifies the currency. The report provides final totals for each refund type and totals across all refund types. The system provides the number and dollar amount of refunds broken out by:

  • Held: The number and dollar amount of refunds for the refund type and across all refund types that are held.

  • Open: The number and dollar amount of refunds for the refund type and across all refund types that are open and will be processed.

  • Cancel: The number and dollar amount of refunds for the refund type and across all refund types that will be cancelled.

  • Writeoff: The number and dollar amount of refunds for the refund type and across all refund types that will be written off.

Refund Check

Purpose: You might generate a refund check if a customer paid for an order by cash or check and if an item was sold out or backordered.

The Refund Check Print Program (D23) system control value identifies the refund check print program to use. The standard non-graphical print program for printing refund checks is REFCHECK. The standard graphical print program for printing refund checks is REFCHECKG.

Complete the Process Refunds Screen (MREF) with the Generate refund checks field selected.

Working with forms: See Forms Management (My Forms) for information on displaying or printing refund checks and other forms.

Sample refund checks: See the non-graphical sample refund check and the graphical sample refund check.

Contents:

Check stub: The top portion of the page represents the check stub.

• Order #: The order number and ship-to number.
• Order Message: Up to three lines of messages (flagged as Check Cust Msg at the Work with Order Messages screen; see Reviewing Order-Level Properties). If you reprint a check, the same messages will appear on the reprint unless you change them through order messages.
• Chk #: Refund check number.
• Amt: The amount of the refund. The tax amount included in the refund amount is based on the tax rate that was effective when the item was shipped.

Check: The bottom portion of the page represents the refund check itself. All fields on the check are unlabeled.

• Refund Date: The date the refund check was generated.
• Check Number: The check number on the check itself is followed by an asterisk (*) if this is a reprint. There is no asterisk next to the check number on the stub.

Note:

The refund amount is spelled out alphanumerically above the customer name and address if the Print Alpha $ Amount on Refund Check (E30) system control value is selected.

• Refund Amount: The amount of the refund. The tax amount included in the refund amount is based on the tax rate that was effective when the item was shipped.
• Customer Name and Address: The sold-to customer name and address appears here unless there is a bill-to customer associated with the order; in this case, the bill-to customer name and address is indicated. The name and address includes the:

  • prefix, first name, last name

  • company

  • address line 1

  • city, state, postal code

Note:

The country does not print on the refund check.

Refund Writeoff Register

Purpose: A writeoff can be a balance due that you are not collecting from the customer. For example, this may be a dollar amount that you will not try to collect because it is not worth the expense of contacting the customer, or a larger amount that you have tried but failed to collect. A writeoff can also be an amount that you owe the customer but are not refunding (for example, if the amount is too small for a refund check). Positive or negative writeoff balances accumulate for each customer, and you can apply this balance as a charge or credit on the customer's current order.

The report lists writeoffs in ascending sequence by order number.

Complete the Process Refunds Screen (MREF) with the Process writeoffs field selected.

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

Contents:

• Order Number: Indicates the order number and the number of the shipping address on the order.
• Customer Number: The sold-to customer number, unless there is a bill-to customer associated with the order; in this case, this is the bill-to customer number.
• Name: The sold-to or bill-to customer name.
• Amount: The writeoff amount in the local currency (the currency defined in the Local Currency Code (A55) system control value).
• Final Totals: The total amount for the writeoffs, across all writeoff records, in the local currency.

Return Reason Report

Complete the Print Return Reason Report Screen.

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.

Different report options: Depending on your selections at the Print Return Reason Report Screen:

Selections:		Report Generated
Return reason code	Include item	Return Reason Report by:
yes	yes	Code and Item
yes	no	Code
no	yes	Item
no	no	N/A (produces the Return Reason Report)

Contents:

• Date Range. The Start date and End date entered at the Print Return Reason Report Screen. The report includes returns processed on that date or later, regardless of when the order was originally created. Based on the Date from the return transaction in the Order Line History table; see the Display Order Line History Screen for more information.

Note:

If you use Establishing Return Reason Codes (WRTR), this is the date you receive the return, which might differ from the date you create or credit the return authorization.

• Return Reason Code. From Establishing Return Reason Codes (WRTR).
• Return Reason Description. From Establishing Return Reason Codes (WRTR).

The following three fields are included only if you selected the Include item flag at the Print Return Reason Report Screen:

• Item.
• SKU. Included only if the item has SKUs.

• Item Description. The item description rather than the SKU description, even if the item has SKUs.

  Calculated fields: The following fields are calculated for:

  • detail entries: by item/SKU or return reason code, depending on your selections at the Print Return Reason Report Screen

  • subtotals: by return reason code, if you selected the Include item flag at the Print Return Reason Report Screen

  • grand totals

• Units Returned: The total number of units returned using the return reason code. If you use Working with Return Authorizations (WRTA), this total includes units that you have received, even if you have not yet credited the return and even if the return did not affect inventory. Returns you process by entering a negative quantity on an order are included in and increase this total.
• Amount Returned: The total value of the returns, based on the actual selling prices. The selling price of an item might be zero if it was a free gift or a component on a set.

Sales Journal by Currency Report

This report displays invoices and credit invoices based on the invoice date range and optionally, currency, you defined. The amounts on this report display in the local currency and alternate (foreign) currency.

Select Submit at the Print Sales Journal by Currency Screen.

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

Contents:

• invoice dates: the invoice date range you selected at the Print Sales Journal by Currency Screen.
• currency: the currency associated with the invoices and credit invoices. The system looks at the currency code defined for the order in the Order Header Extended table to determine the currency associated with the invoices and credit invoices. If the invoices and credit invoices are for the local currency, this field is blank.
• invoice date: the date when you shipped and billed the merchandise.
• pay plan type: the payment plan type associated with the order. Valid values are regular (no payment plan), deferred, and installment.
• pay type: the payment type associated with the invoice or credit invoice.
• invoice: invoice number; this is an invoice that falls under the currency, invoice date, pay plan type, pay type combination.
• customer: the number of the customer associated with the invoice.
• order: the order number associated with the invoice.
• merchandise: the merchandise amount on the invoice in the alternate currency. The system multiplies the local merchandise amount by the conversion rate defined for the order in the Order Header Extended table to determine the alternate merchandise amount. If the invoice is for the local currency, the merchandise amount displays in the local currency.
• freight: the freight charges for the invoice in the alternate currency. The system multiplies the local freight amount by the conversion rate defined for the order in the Order Header Extended table to determine the alternate freight amount. If the invoice is for the local currency, the freight amount displays in the local currency.
• additional freight: the additional freight amount for the invoice in the alternate currency. The system multiplies the local additional freight amount by the conversion rate defined for the order in the Order Header Extended table to determine the alternate additional freight amount. If the invoice is for the local currency, the additional freight amount displays in the local currency.
• tax: the tax amount for the invoice in the alternate currency. The system multiplies the local tax amount by the conversion rate defined for the order in the Order Header Extended table to determine the alternate tax amount. If the invoice is for the local currency, the tax amount displays in the local currency.
• handling: the special handling amount for the invoice in the alternate currency. The system multiplies the local handling amount by the conversion rate defined for the order in the Order Header Extended table to determine the alternate handling amount. If the invoice is for the local currency, the handling amount displays in the local currency.
• additional charge: the additional charge amount for the invoice in the alternate currency. The system multiplies the local additional charge amount by the conversion rate defined for the order in the Order Header Extended table to determine the alternate additional charge amount. If the invoice is for the local currency, the additional charge amount displays in the local currency.
• total invoice: the amount billed for the invoice in the alternate currency. The system multiplies the local invoice total by the conversion rate defined for the order in the Order Header Extended table to determine the alternate invoice total. If the invoice is for the local currency, the total invoice amount displays in the local currency.
• amount collected: the amount you have received from the customer in the alternate currency. The system multiplies the local collected amount by the conversion rate defined for the order in the Order Header Extended table to determine the alternate collected amount. If the invoice is for the local currency, the amount collected displays in the local currency.
• total credits: the totals in the local currency for merchandise, freight, additional freight, tax, handling, additional charges, invoice total, and amount collected for the invoice credits grouped under the currency, invoice date, payment plan, pay type combination.
• XXX total credits (where XXX is the currency code): the totals in the alternate currency for merchandise, freight, additional freight, tax, handling, additional charges, invoice total, and amount collected for the invoice credits grouped under the currency, invoice date, payment plan, pay type combination. This field displays only for invoice credits associated with an alternate currency.
• total invoices: the totals in the local currency for merchandise, freight, additional freight, tax, handling, additional charges, invoice total, and amount collected for the invoices grouped under the currency, invoice date, payment plan, pay type combination.
• XXX total invoices (where XXX is the currency code): the totals in the alternate currency for merchandise, freight, additional freight, tax, handling, additional charges, invoice total, and amount collected for the invoices grouped under the currency, invoice date, payment plan, pay type combination. This field displays only for invoices associated with an alternate currency.
• totals for pay type: the totals in the local currency for merchandise, freight, additional freight, tax, handling, additional charges, invoice total, and amount collected for the invoices grouped under the currency, invoice date, pay type combination.
• XXX totals for pay type (where XXX is the currency code): the totals in the alternate currency for merchandise, freight, additional freight, tax, handling, additional charges, invoice total, and amount collected for the invoices grouped under the currency, invoice date, pay type combination. This field displays only for invoices associated with an alternate currency.
• totals for pay plan type: the totals in the local currency for merchandise, freight, additional freight, tax, handling, additional charges, invoice total, and amount collected for the invoices grouped under the currency, invoice date, payment plan combination.
• XXX total for pay plan type (where XXX is the currency code): the totals in the alternate currency for merchandise, freight, additional freight, tax, handling, additional charges, invoice total, and amount collected for the invoices grouped under the currency, invoice date, payment plan combination. This field displays only for invoices associated with an alternate currency.
• total for date: the totals in the local currency for merchandise, freight, additional freight, tax, handling, additional charges, invoice total, and amount collected for the invoices grouped under the currency, invoice date combination.
• XXX total for date (where XXX is the currency code): the totals in the alternate currency for merchandise, freight, additional freight, tax, handling, additional charges, invoice total, and amount collected for the invoices grouped under the currency, invoice date combination. This field displays only for invoices associated with an alternate currency.
• grand total: the totals in the local currency for merchandise, freight, additional freight, tax, handling, additional charges, invoice total, and amount collected for the invoices across all currencies, invoice dates, payment plans, and pay types. A grand total in the alternate currency does not display on this report.

Sales Journal by Division

This version of the Sales Journal prints if you select the Print by division setting through the Printing the Sales Journal (PDSJ) menu option. Sales transactions on this report are sorted and subtotaled by sales division. Each division starts on a new page. A grand total of all invoices for the company as a whole is presented at the end of the report.

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: See the Standard Sales Journal for a description of the contents of this report.

Sales Journal by Pay Type

Use the Printing the Sales Journal by Pay Type (PSJP) menu option.

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:

• Invoice date range
• Currency
• Invoice date (the date on which an invoice was created as a result of a shipment. This report shows all shipments for the specified report date range)
• Pay plan type
• Pay type code
• Invoice number
• Customer number
• Order number

Note:

The following totals are from the Invoice Payment Method record(s).

• Merchandise
• Freight
• Additional freight
• Tax (the amount of sales tax calculated on merchandise shipped. If this figure includes any VAT, the word VAT appears to the right.

  Note:

  This information appears only if the system control value is selected. On orders subject to VAT, tax does not accumulate in the Tax bucket; instead, a “hidden tax” is included in the order detail line and the customer pays a tax-inclusive price for each item. For such orders, the Merchandise total indicated is net of VAT. In other words, if the customer paid $10.00 for the merchandise, but a $1.50 hidden tax was included in the order detail line, the merchandise total would be $8.50 Tax Included in Price (E70))
• Handling
• Additional charge
• Total invoice
• Amount collected
• Total credits (the total dollar amount of credits (refunds) for this pay type for items returned today. Credits appear as negative dollar amounts.)
• Total invoices
• Totals for pay type
• Totals for pay plan type
• Totals for (date)
• Grand total

Note:

This report sorts by currency if the Multi Currency by Offer (E03) system control value is selected.

Sales Journal Summary by Offer

Select the By offer field on the Print Sales Journal Summary screen; see Printing the Sales Journal Summary (PSJM).

Information on this report sorts by offer (in alphanumeric offer code sequence). A grand total of sales for all offers is provided at the bottom of this report.

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

Contents:See the Sales Journal Summary by Entity/Offer.

Sales Journal Errors Report

Complete the Print Sales Journal Errors Screen through the Printing Sales Journal Errors (PSJE) menu option.

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

Contents:

• Date range: From and To dates selected at the Print Sales Journal Errors Screen
• Invoice date: the date the order shipment or credit billed
• Invoice: invoice number
• Customer: customer number
• Order: order number

Note:

The following totals are from the Invoice Ship To record.

• Merchandise: the total merchandise value billed on the invoice
• Freight: the total freight charges billed on the invoice
• Add’l freight
• Tax
• Handling
• Add’l charge
• Total cash
• Total C/C
• Out of balance amount: the total Merchandise, Freight, Additional freight, Tax, Handling, and Additional charge for all Invoice Pay Method records that do not equal the corresponding totals for the Invoice Ship To record. If the Invoice Pay Method total is higher than the Invoice Ship To total, the out-of-balance amount is negative; otherwise, if the Invoice Pay Method total is lower than the Invoice Ship To total, the out-of-balance amount is negative.

For more information: See Out-of-Balance Invoices for a discussion.

Sales Journal Summary by Descending Dollars

Select the By merch$ descending field on the Print Sales Journal Summary screen; see Printing the Sales Journal Summary (PSJM).

Information on this report is sorted by descending merchandise dollars (highest-to-lowest sales) for each offer during an accounting period. Sales totals are provided for each period. A grand total of sales for all periods is provided at the bottom of this report.

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

Contents: See the Sales Journal Summary by Entity/Offer.

Sales Journal Summary by Entity/Offer

Select the By entity/offer field on the Print Sales Journal Summary screen; see Printing the Sales Journal Summary (PSJM).

Information on this report is sorted by offer within each entity. Sales totals are provided for each entity. A grand total of sales for all entities is provided at the bottom of this report.

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 and End date: the dates between which sales information is reported
• Offer: the code for the catalog, television or space advertisement from which you accept orders

Note:

The following totals are from the Invoice Ship To record.

• Merchandise dollars: the sum of all merchandise amounts on the Invoice records for each offer. This is strictly the charge for the item and does not include charges for tax, freight, shipping, etc.
• Tax: the sum of the sales tax on the Invoice records for each offer.
• Freight: the sum of the freight on the Invoice records for each offer.
• Additional freight: the sum of the additional freight on the Invoice records for each offer.
• Charges: the sum of the extra charges on the Invoices for each offer. This may include service charges (for the source code or offer), additional shipper/item charges, guaranteed service charges, or additional charges/credits entered during Order Entry or Order Maintenance
• Handling: the sum of special handling charges on the Invoice for each offer. Special handling is some type of additional item handling, such as monogramming, hemming, altering, etc.
• Total: the sum of all Invoice Pay Method records for pay category Cash/Check for the offer
• Cost: the sum of the cost amounts in the Invoice records for each offer.
• Gross profit: the dollar amount of profit realized from the sales for each offer. This is calculated by:

Total Merchandise Amount - Total Cost for each offer

• Gross profit percent: the percentage of gross profit realized from the sales for each offer. This is calculated by:

(Total Gross Profit / Total Merchandise Amount) * 100

See Determining Gross Profit for a discussion.

• Deferred liability: total amount posted to deferred liability for this offer.
• Card Amount: the sum of all Invoice Pay Method records for  pay category Credit Card for the offer including gift cards.
• Invoice Date: The date that the invoice was created (This field only occurs when you print the Sales Journal Summary by Invoice Date)
• Division: This code represents the division of your business against which you are posting the transaction. (This field only occurs when you print the Sales Journal Summary by Invoice Date)

Sales Journal Summary by Invoice Date

Select the By invoice date field on the Print Sales Journal Summary screen; see Printing the Sales Journal Summary (PSJM).

Information on this report is sorted by date and division for each offer during an accounting period. Sales totals are provided for each period. A grand total of sales for all periods is provided at the bottom of this report.

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: See the Sales Journal Summary by Entity/Offer.

Sales Journal Summary by Offer

Select the By offer field on the Print Sales Journal Summary screen; see Printing the Sales Journal Summary (PSJM).

Information on this report sorts by offer (in alphanumeric offer code sequence). A grand total of sales for all offers is provided at the bottom of this report.

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

Contents: See the Sales Journal Summary by Entity/Offer.

Sales Journal Summary by Order Type

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.
• Total Value: the sum of all Invoice Pay Method records for the order type.

Sales Journal Summary by Period

Select the By period field at the Print Sales Journal Summary screen; see Printing the Sales Journal Summary (PSJM).

Information on this report is sorted by offer within accounting period. Sales totals are provided for each period. A grand total of sales for all periods is provided at the bottom of this report.

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: See the Sales Journal Summary by Entity/Offer.

Salesman Demand Report

Use the Printing the Order Demand/Sales Reports (PSSR) menu option.

Quotes: Quotes entered by the salesman number are included on this report. Q displays in the Order Status field for orders flagged as quotes. The Quantity Returned, Quantity Reserved, and Quantity Shipped totals are always 0 for quotes. See Entering Pre-Order Quotes for more information.

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

Contents:

• Orders from entered date range
• Salesman number
• Order number
• Order date
• Order status
• Merchandise total
• Tax total
• Freight total
• Gross margin
• Gross margin percent

The gross margin calculations on this report do include estimated freight for the item class. See Determining Gross Profit for a discussion.

• Quantity returned
• Quantity ordered
• Quantity reserved
• Quantity shipped
• Salesman totals
• Final totals

Ship Via/Item Detail Report

Use this report to review the total number of shippable orders and units for a particular ship via/item combination broken out by arrival date.

Select Print List at the Third Inquiry by Ship Via/Item Screen.

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

Contents:

• date and time the Ship Via/Item information was last updated, and the user ID of the person who processed the update
• code and description of the ship via
• item code and SKU, if any
• item description
• for each arrival date:
• total number of shippable orders
• total number of shippable units
• total number of shippable orders and units for the ship via/item combination

An order may be counted more than once in the Total orders column if there is an override arrival date for one or more of the same order lines for the selected item.

Ship Via/Item Header Report

Use this report to review the shippable orders for one or all ship vias broken out by item, including total orders, total units, and oldest arrival date.

Select Print List at the First Inquiry by Ship Via/Item Screen (includes all ship vias in your company) or the Second Inquiry by Ship Via/Item Screen (includes only the ship via you had selected at the first screen) These screens are available through the Ship Via/Item Inquiry menu option (SVII).

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

Contents:

• date and time the Ship Via/Item information was last updated, and the user ID of the person who processed the update
• code and description of each ship via, if you generated the report from the first screen, or of the ship via you selected, if you generated the report from the second screen
• for the ship via:
• item code and SKU, if any
• item description
• total number of shippable orders
• total number of shippable units
• earliest arrival date for all shippable units or orders
• total shippable orders and units for the ship via
• total shippable orders and units for all ship vias, if you generated the report by selecting Print List at the First Inquiry by Ship Via/Item Screen.

Note:

An order may be counted more than once in the Total orders column if there is an override ship via for one or more items on the order.

Soldout Notification Card

The system produces a soldout card for each order containing one or more soldout items unless the order is eligible for an email or XML notification instead. Up to four soldout notifications print on each 8 1/2 x 11" page.

Complete the Print Soldout Notification Screen.

Working with forms: See Forms Management (My Forms) for information on displaying or printing soldout notification cards and other forms.

Sample soldout notification cards: See the soldout notification card sample.

Note:

This sample represents the notification that prints when the Soldout Notification Print Program (E75) system control value is set to SOLDOUT. Depending on your setting, your soldout notifications may appear different.

File naming: If you use the standard soldout notification print program, the system creates a separate document for each country where you are mailing soldout notifications. The documents are named SOLDOUTUSA.EJOHNSON.20091015.123456.pdf, where:

• USA is the country code from the Country table
• EJOHNSON is the user ID who submitted the job
• October 15, 2009 is the date
• 12:45:56 is the time

For more information: See Forms Management (My Forms) for more information on working with forms and form-naming conventions.

Important:

Set the Page Scaling option to Reduce to printer margins when printing soldout notification cards to make sure that all customer address information prints correctly.

Contents:

• Order number
• Item quantity
• Item code
• SKU code (included if the item has SKUs)
• Item description
• Sold To customer name and address (name of person who placed order), including:

  • company name

  • customer prefix code, first name, middle initial, last name, and suffix

  • address line 1

  • apartment or suite

  • address lines 2-4

  • city, state, and postal code

  • country

Source Shipped Report

Use the Printing the Order Demand/Sales Reports (PSSR) menu option.

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:

• Orders from entered date range
• Source code
• Order number
• Order date
• Order status
• Merchandise total
• Tax total
• Freight total

Gross margin percent. The gross margin calculation on this report does include estimated freight for the item class. See Determining Gross Profit for a discussion.

• Quantity returned
• Quantity ordered
• Quantity reserved
• Quantity shipped
• Source totals
• Final totals

Standard Sales Journal

This report prints if you accept the default (unselected) setting of the Print by division field through the Printing the Sales Journal (PDSJ) menu option. Sales transactions are listed in ascending order (lowest-to-highest) by date and in ascending order by invoice number order within each 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.

Things to note about the spreadsheet version of the report:

• There may be a rounding discrepancy on the tax total for the last date included on the report, as well as the grand total of tax. This discrepancy should be no more than a few cents.
• Depending on the width of the data, there may be blank columns between some of the columns.

Sort order: The report sorts by:

1. currency, if the Multi Currency by Offer (E03) system control value is selected, with blank currency sorted first.
2. division, if you selected the Print by division flag when generating the report. See Sales Journal by Division.
3. invoice date. Within each date, the report lists invoices in ascending numeric order (lowest to highest).

Contents:

Page headings: Each page of the report includes the following headings:

• Invoice Dates: The range of dates you selected when generating the report.
• Currency: The currency code and description are included only if the Multi Currency by Offer (E03) system control value is selected. The currency indicated is blank if you run the report for shipments that occurred before you started using multi-currency by offer.
• Division: The division code and description are included only if you selected the Print by division flag when generating the report. See Sales Journal by Division for a discussion and report sample.
• Invoice Date: Totals are included for each invoice date.

There is a page break for each new currency, division, or invoice date.

For each invoice: The report lists:

• Invoice: The number identifying the invoice.
• Customer: The sold-to customer number.
• Order: The number identifying the order. The ship-to number is not listed.

Note:

The following fields are from the Invoice Ship To records. If there is more than one Invoice Ship To, these fields represent the sums across all ship-tos. The amounts listed for credit invoices are followed by a minus sign.

• Merchandise
• Freight
• Additional Freight
• Tax: The amount of sales tax calculated on merchandise shipped. If the Tax Included in Price (E70) system control value is selected, this figure includes any value-added tax, and the word VAT is to the right.

About VAT: On orders subject to VAT, tax on merchandise does not accumulate in the Tax bucket; instead, a “hidden tax” is included in the order detail line and the customer pays a tax-inclusive price for each item. For such orders, the Merchandise total indicated is net of VAT. In other words, if the customer paid $10.00 for the merchandise, but a $1.50 hidden tax was included in the order detail line, the merchandise total would be $8.50.

The unit VAT charge is stored in the Second choice SKU item field in the Order Detail table, and the total VAT amount for an invoice is the total of the extended VAT amounts for each order detail line billed for that invoice.

• Handling
• Additional Charge

Note:

The following fields indicate how the invoice was paid, and are from the Invoice Payment Method records. If there are multiple Invoice Payment Method records for the same pay category (for example, two credit cards), the field indicates the sum for that pay category.

• Total Cash
• Card Amount: The amount is the sum of all Invoice Pay Method records for pay category Credit Card for the offer including gift cards.

Calculated fields:

• Gross Profit: Calculated as Merchandise amount - cost from invoice ship-to / merchandise amount * 100. Rounded up or down to the nearest hundredth or cent, so that the report lists a gross profit with two decimal positions.

  Note:

  • If the Multi Currency by Offer (E03) system control value is selected, the cost is converted to the local currency before calculating the gross profit, using the conversion rate from the Invoice Currency record. For example, if the cost in the order currency is 10.00 and the currency conversion rate is 1.50, then the system uses a cost of 15.00 (10.00 * 1.5) to calculate gross profit. However, if the Multi Currency by Offer (E03) system control value is selected but the report includes shipments billed before you selected the system control value, the Gross profit listed for the invoices is 100.00%.

  • An invoice might have a Gross profit of 0.00 if it is for the shipment of a no-charge item, or if the cost and the merchandise total were equal.

See Determining Gross Profit for a discussion.

• Out-of-balance: the out-of-balance amount is included in a separate line immediately below the out-of-balance invoice. See Out-of-Balance Invoices for a discussion.

Totals: The report includes a total of each of the above-listed dollar values for:

• each date in the selected date range
• the division, if you selected the Print by division flag when generating the report. See Sales Journal by Division for a discussion and report sample.
• the currency, if the Multi Currency by Offer (E03) system control value is selected
• the entire selected date range

An out-of-balance total line is included for each of the above totals if any invoices in the selected date range were out-of-balance; see Out-of-Balance Invoices for a discussion.

• Gross profit totals: The Totals field for Gross profit represents the average gross profit percentage for all shipments on the specified invoice date, calculated by totaling the gross profit percentage for all shipments and dividing the result by the number of shipments, where:

  • the shipment amounts include positive invoices only, not credits

  • the number of shipments includes positive invoices only, not credits, and does not include invoices with a Gross profit of $0.00. An invoice might have a Gross profit of $0.00 if it is for the shipment of a no-charge item, or if the cost and the merchandise dollar total were equal.

See Determining Gross Profit for a discussion.

• VAT Total: the total amount of value-added tax, which is also included in the Tax total. This information appears only if the Tax Included in Price (E70) system control value is selected.

State Tax Detail Report

Use the Printing the State Tax Detail Report (PSTD) menu option.

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:

Report selections:

• State and description
• date range selected
• currency selected and description (if you use Multi Currency by Offer (E03))

Invoice and credit information: (this information is presented first for all invoices, both taxable and tax-exempt, then for all credits, which may also include both taxable and tax-exempt)

• invoice number
• invoice date
• customer number of the person who placed the order

State Tax Report

Purpose: This report displays tax, GST, and PST totals by state for all debit invoices and credit invoices within a given date range.

Use the Printing the Sales Tax Report by State (PSTX) menu option.

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

Note:

eport 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:

• From: The first date for invoices included on the report.
• To: The last date for invoices included on the report.
• State: A code for the state associated with the tax.
• Tax debit: The total tax associated with sales for the state. The system totals the Tax amount in the Invoice Ship To table for each debit invoice that falls within the specified date range and whose ship to customer resides in the specified state.
• Tax credit: The total tax associated with returns for the state. The system totals the Tax amount in the Invoice Ship To table for each credit invoice that falls within the specified date range and whose ship to customer resides in the specified state.
• GST debit: The total GST amount associated with sales for the state. The system totals the GST amount in the Invoice Ship To table for each debit invoice that falls within the specified date range and whose ship to customer resides in the specified state.
• GST credit: The total GST amount associated with returns for the state. The system totals the GST amount in the Invoice Ship To table for each credit invoice that falls within the specified date range and whose ship to customer resides in the specified state.
• PST credit: The total PST amount associated with returns for the state. The system totals the PST amount in the Invoice Ship To table for each credit invoice that falls within the specified date range and whose ship to customer resides in the specified state.
• PST debit: The total PST amount associated with sales for the state. The system totals the PST amount in the Invoice Ship To table for each debit invoice that falls within the specified date range and whose ship to customer resides in the specified state.

Stored Value Card Credit Register

Purpose: This report lists the order number, sold to customer, and refund amount associated with each stored value card credit processed. See Generating Stored Value Card Refunds for an overview. The report is sorted by order number.

Alternate currency and stored value card refunds: While the system allows you to generate a stored value card refund for an order associated with an alternate currency, the system can process stored value cards in the US currency only. If the order is for a currency other than U.S., you should generate a refund type other than stored value card for the order.

• Complete the Process Refunds Screen (MREF) with the Generate SVC credits field selected.
• Run the REFSVCR Process SVC Credit Refunds periodic function.

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

Contents:

• Order Number: The order number and ship-to number associated with the stored value card refund. The system adds a stored value card item to this order at no charge; this item generates a new stored value card for the refund amount to send to the sold to customer.
• Status: The status of the order. Blank = the order is open. H = The order is held. If the order status was X (closed), the system updates the order status to open once the new stored value card item is added to the order.
• Customer Number: The bill-to customer number associated with the stored value card refund, if any. If there is no bill-to customer associated with the refund, this is the sold-to customer number. This is the customer that receives the new stored value card for the refund amount.
• Name: The name of the bill-to or sold-to customer, starting with the customer’s company name, if any.
• Refund Amount: The refund amount in the local currency (the currency defined in the Local Currency Code (A55) system control value). Note: Stored value cards are allowed only in US currency.
• Final Totals: The total amount for the stored value card refunds, across all credits, in the local currency.

Substitute Item Processing List

This report includes each order updated when you used the Process Item Substitutions menu option, and the settings applied to each order. This report provides information used in the item substitution, based on your entries at the Process Substitute Items Screen.

Select Accept at the Process Substitute Items Screen.

Note:

Orders which were not eligible for substitution, such as orders with ship to addresses restricted for the substitute item, are not included on this report.

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

Contents:

• Canceled item, SKU, and description
• Substitute item, SKU, and description
• Cancel reason code
• Maximum number of items to cancel
• Ship vias to cancel
• Price override reason code
• Substitute item price
• Recalculate freight (Selected or Unselected)
• Date you processed the substitution
• Order number
• Sold-to customer name
• Unit quantity substituted for the order
• Total number of items substituted by the batch job

Unchanged Customers Report

Purpose: Use this report to review the customer address updates you want to process or to verify address changes that you want to purge from the work file.

How to print: Select Print at the Work with Unchanged Customers Screen (MBSF).

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

Contents: See the Work with Unchanged Customers Screen (MBSF).

Unmatched Email Status Report

Note:

Important: This report is not currently implemented. When you generate this report, the system prints a generic document with the following information:

The requested document is not currently implemented: CUSTOMER_EMAIL_STATUS_REPORT

Purpose: Use this report to review the records in the Customer Email Updates Table that were not matched to a sold to customer.

Submit the Customer Email Status Updates Process.

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

Contents: Information on this report sorts alphabetically by email address.

• Submit Date: The date the Customer Email Updates record was added to the Customer Email Updates table from the external system. If the external system provided a date in an incorrect format, the date will not display correctly.
• Email Address: The email address of the sold to customer.
• Profile ID: A unique code to identify the sold to customer in an external system.
• First Name: The first name of the sold to customer.
• Last Name: The last name of the sold to customer.
• Email Status: Indicates the preferred method of correspondence for the sold to customer’s email address. Valid values are:
• O1 (Email) = Email is the preferred method of correspondence.
• O2 (Order-only email) = Use email for order-related correspondence only; generate a document for other correspondence.
• O3 (No email) = Do not use email for any correspondence; generate a document instead.
• O4 (Do not ask the customer) = Do not ask the customer for his/her email address; the customer has already been asked and has declined to provide it. The system does not generate any email correspondence to the customer, even if an email address is specified.