Purpose: Through the Customer Maintenance option, you can review a customer's mail, item, item class, and order history, which the system collects automatically as updates occur. History for both the sold-to and ship-to customers is available.
In this topic:
• Related System Control Values
• Displaying Customer History Screens
• Display Customer Mail History Screen
• Item, Item Class, and Order History Screen Flow
• Ship-to Customer History Screen Flow
• Customer Sold To Item History Screen
• Order Billing History Detail Screen
• About Entry/Maintenance Codes
• Sample Order/Billing History for an Order
• Display Customer Order History Screen
• Display Customer Item Class Screen
• Display Customer Item Class History Screen (Reviewing Detail)
• Customer Sold To Order History Screen (Reviewing Detail)
• Display Customer Order/Entity History Screen
• Display Customer Entity History Screen (Reviewing Order Detail)
• Display Customer Item Class Entity Screen (Reviewing History)
• Display Customer Item Class Entity Details Screen (Reviewing History)
• Display Ship To Item History Screen
• Display Ship To Order History Screen
• Display Ship To Order History Details Screen
• Display Ship To Order/Entity History Screen
• Display Ship To Entity History Screen (Order History Details by Entity)
For more information: See Creating and Updating Individuals for information on the Work with Sold To Individuals screen, including mail and order history options at the individual customer level.
Overview: The following system control values affect how the system updates demand for orders.
If using multiple currencies: If you process orders in multiple currencies based on the offer (the Multi Currency by Offer (E03) field in the System Control file is set to Y), each of the dollar values that display on these screens will be converted into your local currency.
If using VAT and tax-inclusive pricing: If the Tax Included in Price (E70) field in the System Control file is set to Y, certain orders may be subject to tax-inclusive pricing and VAT. In this case, you charge the customer the tax-inclusive price for items on an order, and include a hidden tax amount on the order detail line for the item rather than including tax in the Tax bucket on the order. The hidden tax may be calculated as a percentage of the item price, or may be a fixed amount.
If you use VAT and tax-inclusive pricing, the dollar value that appears on most fields described in this chapter will be net of any hidden tax for the item. In other words:
Total = (Tax-inclusive price - Hidden tax) * Quantity
In cases where you have defined the hidden tax to charge for an item as a fixed amount, it is possible for the order total to represent a credit if the hidden tax amount exceeds the item price -- for example, if you offer the item as an incentive or free gift.
Demand for order maintenance: Update Demand for Order Maintenance Transactions (C72): Possible settings are:
• Y: The system increases the customer's demand history (in the Orders buckets) for items you add or quantities you increase in order maintenance.
• N or is blank: Demand does not update for additions in order maintenance; however, all other order history updates, such as for shipments (in the Sales buckets), returns, exchanges, cancellations, and soldouts, will still take place. In this situation, the customer's life-to-date sales (or other activity) may be greater than the customer's order (demand) history.
Demand for non-inventory items: Possible settings are:
• ALL: All updates take place for non-inventory items in the same way as for inventory items.
• ITEM: The Order/Billing History record updates. Also, you will be able to review order records for non-inventory items at the Customer Sold To Item History Screen, Display Customer Item Class Screen, Display Customer Item Class History Screen (Reviewing Detail), and Customer Sold To Order History Screen (Reviewing Detail) in the same way as you review records for inventory items. However, the Customer Sold To Order History screen will not reflect orders for non-inventory items in the Life-to-date order total fields or the Last order amount.
• NONE: There are no demand updates for non-inventory items.
Track at entity level: The Track Customer History at Entity Level (F89) system control value controls whether a customer's order, item, and item class history is broken out based on the entity associated with each order. The system determines the entity associated with an order based on the source code on the order header.
If this system control value is set to Y, you can advance to additional screens to review entity-level history. If this system control value is set to N or is blank, these screens are not available, and all customer history is consolidated at the customer level.
Track individual customer order history: If the Update Customer Individual Order History File (H79) is set to Y, the system tracks order history at both the individual customer level and the sold-to customer level. You can review individual customer history at the Display Individual Order History Screen. If this system control value is set to N or is blank, this screen is not available, and individual order history is not tracked separately.
Displaying Customer History Screens
Access: You can display the history screens from any Work with Customers screen, such as from the Work with Customers by Last Name screen. See Selecting Customers.
Type of History |
Option |
Mail History |
15 |
Item History |
18 |
Order History |
19 |
You can also display these screens by pressing the following function keys at any Create, Change, or Display Customer screen in customer maintenance. See Creating and Updating Sold-to Customers (WCST).
Type of History |
Option |
Mail History |
F15 |
Item History |
F18 |
Order History |
F19 |
Note: Additional history options include:
• Display Individual Order History Screen: if the Update Customer Individual Order History File (H79) is set to Y
• Display Customer Order/Entity History Screen: if the Track Customer History at Entity Level (F89) system control value is set to Y
• Display Individual Mail History Screen: if the Enable Catalog Request at Individual Level (H81) system control value is set to Y
Display Customer Mail History Screen
Purpose: Use this screen to review the offers sent to the customer. This screen lists the source codes associated with each offer mailed to that customer. The source codes are listed in reverse chronological order (most recent to oldest).
You generate customer mail history in two ways:
• House list: If you indicated to update Mail History when you generated the customer list for the offer mailing, the information from the house list segment appears here. See Marketing Working with Drops (WHLS).
• Catalog request: Mail history is updated when you process a catalog request for a customer. See Processing Catalog Requests (PCAT).
Note: You can also use the Display Individual Mail History Screen to review mail history at the individual level if the Enable Catalog Request at Individual Level (H81) system control value is set to Y. When you process a catalog request that includes an individual, only the individual customer mail history is updated; the customer-level mail history is not updated.
Related system control values:
• If the Load Source from Mailing History (D20) system control value is set to Y, and the offer on an order line is found in the sold to customer’s mail history, the system defaults the source code associated with the offer to the order line.
• If the Update Source Code from Mail History (J94) system control value is set to Y, the system updates the source code and offer on an order line based on the most recent customer mail history associated with the item on the order line.
Note: If both of these system control values are set to Y, the system uses Update Source Code from Mail History Logic When Using Item.
How to display this screen: At a Work with Customers scan screen, enter 15 next to a customer; see Selecting Customers. You can also display this screen by pressing F15 at a Create, Change, or Display Customer Sold To screen; see Creating and Updating Sold-to Customers (WCST).
CSR0274 DISPLAY Display Customer Mail History 2/15/99 8:53:02 KAL Co.
Customer # 12544 SANDER HOSPITAL ATTN: AUCLAIR, KIMBERLY R
Source Description Mail Date Ofr
SOURCEB SOURCE CODE B 2/15/99 B01 A123 FIRST SOURCE CODE 12/09/97 EAT
F3=Exit F12=Cancel |
Field |
Description |
Customer # |
A unique number to identify a customer. Numeric, 9 positions; display-only, assigned by the system. |
Customer name (Unlabeled field to the right of the customer number) |
The name of a customer and/or the business associated with the customer. Alphanumeric, 41 positions; display-only. |
Source |
A code used to identify the segment of your customer base for a particular offer. Alphanumeric, 7 positions; optional. |
Description |
The description of the mailing. Alphanumeric, 30 positions; display-only. |
Mail date |
The date you mailed the offer (catalog) to the customer. Numeric, 6 positions (MMDDYY format); display-only. |
Item, Item Class, and Order History Screen Flow
Purpose: This chart presents the order of the screens you use to review item, item class, and order history for a sold-to customer.
Note: You can also review individual customer order history at the Display Individual Order History Screen if the Update Customer Individual Order History File (H79) is set to Y. Similarly, you can review individual customer mail history at the Display Individual Mail History Screen if the Enable Catalog Request at Individual Level (H81) system control value is set to Y.
Ship-to Customer History Screen Flow
Purpose: The chart below presents the order of the screens you use to review item and order history for a ship-to customer.
Customer Sold To Item History Screen
Purpose: Use this screen to review the items ordered by the customer. This screen contains a record for each type of transaction involving the item, such as a shipment, return, or exchange.
You can advance to this screen only if the Track item history field for the sold-to customer is set to 2 (track sold-to item history) or 3 (track sold-to and ship-to item history); however, the system continues to track item history regardless of this setting.
How to display this screen: At a Work with Customer screen, enter 18 next to a customer (see Selecting Customers) or press F18 at a Create, Change, or Display Customer Sold To screen (see Creating and Updating Sold-to Customers (WCST)).
CSR0277 DISPLAY Customer Sold To Item History 5/11/99 15:09:55 EZK Mail Order
Customer : 317 COMMERCIALWARE ATTN: MUNDI, GLORIA
Opt Item COL SIZE WDTH Date Qty Ord Order Total Ind# Con BALL Type options, press Enter. 5=Display
BALL LRGE 12/09/98 MERMAID BEACH BALL 15-INCH BALL BALL LRGE 12/08/98 10 10.00 MERMAID BEACH BALL 15-INCH BALL BALL LRGE 12/08/98 10 5.00 MERMAID BEACH BALL 15-INCH BALL BALL LRGE 12/08/98 20 20.00 MERMAID BEACH BALL 15-INCH BALL BALL LRGE 12/08/98 MERMAID BEACH BALL 15-INCH BALL +
F3=Exit F10=Individuals F12=Cancel F21=Print List |
Field |
Description |
Customer # |
A unique number to identify a customer. Numeric, 9 positions; display-only, assigned by the system. |
Customer name (Unlabeled field to the right of the customer number) |
The name of the customer and/or the company associated with the customer. Alphanumeric, 41 positions; display-only. |
Item |
The item involved in the transaction. There are separate records for each transaction. Transactions listed on this screen include entering, canceling, selling out, shipping, returning, exchanging, or changing item quantity or price. The system lists items in alphanumeric order, and transactions for each item in reverse chronological order. The item description appears below the item code. Alphanumeric, 12 positions; optional. |
SKU (Stock keeping unit) |
The item's unique characteristics, such as its color or size. The SKU description appears below the Quantity ordered. Alphanumeric, one 14-position field (full SKU) or three 4-position fields (split SKU); optional. |
Date |
The date of the transaction. Numeric, 6 positions (MMDDYY format); optional. |
Qty ord (Quantity ordered) |
The quantity of the item ordered by the customer. If the transaction does not represent an order (for example, a return or shipment), no quantity displays. Numeric, 5 positions; optional. |
Order total |
The total merchandise dollar amount of the item ordered by the customer on this date. This total does not include freight, tax, handling, or other additional charges, and displays only if the transaction represents an order (as opposed to a return or a shipment, for example). If the Update Demand for Order Maintenance Transactions (C72) is not set to Y, an order total appears only next to items entered through order entry. Numeric, 11 positions with a 2-place decimal; optional. |
Ind# (Individual number) |
A number to identify the individual within an organization who placed the order. See Creating and Updating Individuals. Numeric, 3 positions; display-only. |
Con (Consolidated?) |
This flag indicates if the order billing history record for the item has been consolidated. Valid values are: Y = This item's history has been consolidated blank = This item's history has not been consolidated. You can consolidate order billing history records to save space on your system and improve performance. When you consolidate order billing history, you select one or more fields to retain; for example, if you retain customer sold-to number only, all activity for all items for the customer is consolidated into one record, and the amounts are added or netted together. Consolidated records appear on this screen only if you selected to retain the item information. See System Operations Consolidating Order Billing History (MOBH). Alphanumeric, 1 position; display-only. |
Screen Option |
Procedure |
Review detail information about the item transaction |
Enter 5 next to a record to advance to the Order Billing History Detail Screen. |
Work with individual customers |
Press F10. See Creating and Updating Individuals. |
Order Billing History Detail Screen
Purpose: Use this screen to review detailed history for each transaction against an item on an order. The system creates order/billing history records through transactions you enter in order entry, order maintenance, billing, processing auto soldouts, processing item substitutions, or any other transaction against an item on an order. The order and billing asynchronous jobs process most of these updates; see System Operations Working with the ORDR_ASYNC Job.
How to display this screen: At the Customer Sold To Item History Screen, enter 5 next to the item you want to review, or enter 5 next to a record at the Customer Sold To Order History Screen (Reviewing Detail).
CSR0287 ENTER Order/Billing History Detail 5/11/99 15:48:15 EZK Mail Order Customer # . . . : 291 BROWN, SARAH RAE R Ship to # . . . . : 0 Salesman # . . . : Offer number . . : OFR ALL-PURPOSE OFFER Source code . . . : SOURCE ALL-PURPOSE SOURCE Item number . . . : TOASTER DELUXE CLASSIC TOASTER SKU Code . . . . : DELUXE CLASSIC TOASTER Item class . . . : Ship via code . . : 2 East Coast Shippers, Inc. Long SKU Dpt/Cls : Order Number . . : 5154 Entry/Maint. Code : E Entity : 1 Placer/Originator : 4 4 SARAH BROWN SARAH BROWN Transaction Date : 3/18/99 Consolidated from: 12/01/95 to: 6/01/98 Quantity ordered . . : 1 $ Ordered 16.74 Quantity cancelled . : $ Cancelled Quantity sold out . : $ Sold out Quantity sold . . . : $ Shipped # Sales Quantity returned . : $ Returned # Ret Quantity exchanged . : $ Exchanged
F3=Exit F12=Cancel |
Field |
Description |
Customer number |
A unique number to identify a customer. Numeric, 9 positions; display-only. |
Customer name (Unlabeled field to the right of the customer number) |
The customer's name and/or the company associated with the customer. Alphanumeric, 41 positions; display-only. |
Ship to # |
The number assigned to each shipping address on the order. Numeric, 3 positions; display-only. |
Salesman # |
A number that identifies the sales representative credited for the order. See Accounts Payable Working with Sales Representatives (WSLS). Numeric, 7 positions; display-only. |
Offer number |
The code for the catalog, space, or television advertisement from which the customer ordered the item. See Marketing Working with Offers (WOFR). Alphanumeric, 3 positions; display-only. |
Description (Unlabeled field to the right of the Offer number field) |
The description associated with the offer. Alphanumeric, 30 positions; display-only. |
Source code |
A code that identifies a segment of your customer base. The source code from the order header appears here, unless you overrode the source code at the order entry detail line. See Marketing Working with Source Codes (WSRC). Alphanumeric, 7 positions; display-only. |
Description (Unlabeled field to the right of the Source code field) |
The description associated with the source code. Alphanumeric, 30 positions; display-only. |
Item number |
A code representing a unit of inventory. Alphanumeric, 12 positions; display-only. |
Description (Unlabeled field to the right of the Item number field) |
The description associated with the item. Alphanumeric, 40 positions; display-only. |
SKU code (Stock keeping unit) |
The item's unique characteristics, such as its size or color. Alphanumeric, one 14- position field (full SKU) or three 4-position fields (split SKU); display-only. |
Description (Unlabeled field to the right of the SKU code field) |
The description associated with the SKU. The item description appears here for nonSKU’ed items. Alphanumeric, 40 positions; display-only. |
Item class |
The item class assigned to the item. See Merchandising Working with Item Classes (WICL). Numeric, 3 positions; display-only. |
Description (Unlabeled field to the right of the Item class field) |
The description associated with the item class. Alphanumeric, 40 positions; display-only. |
Ship via code |
A code for the carrier to deliver the item to the customer. See Fulfillment Working with Ship Via Codes (WVIA). Numeric, 2 positions; display-only. |
Description (Unlabeled field to the right of the Ship via code field) |
The description associated with the ship via code. Alphanumeric, 40 positions; display-only. |
Long SKU dpt/cls |
Two fields used to group items for reporting purposes. Long SKU Department A code, typically used in a retail environment, which represents a department code for this SKU. You can assign this code at both the item and the SKU level; the code assigned to the SKU overrides the item-level code. Department codes are defined in and validated against the Long SKU Department file; see Merchandising Working with Long SKU Departments (WLSD). Numeric, 4 positions; display-only. Long SKU Class A code, typically used in a retail environment, that represents a class code for this SKU. You can assign this code at both the item and the SKU level; the code assigned to the SKU overrides the item-level code. Long SKU class codes are defined in and validated against the Long SKU Class file; see Merchandising Working with Long SKU Classes (WLSC). Numeric, 4 positions; display-only. |
Descriptions (Long SKU department description/Long SKU class description) |
The first 20 positions of the descriptions associated with the long SKU department and long SKU class codes assigned to the SKU. Alphanumeric, 20 positions; display-only. |
Order number |
The number of the order on which the customer ordered the item. Numeric, 8 positions; display-only. |
Entry/Maintenance code |
A code indicating the type of transaction performed on this item. Valid values are: B = Billing (can include sales, exchanges, and returns, including returns you enter through order entry) M = Maintenance (can include orders, changes, cancellations, and sellouts) E = Entry (can include orders and sellouts) See About Entry/Maintenance Codes. Alphanumeric, 1 positions; display-only. |
Entity |
The code representing the entity associated with the source code on order header. Each source code is associated with an entity through its division. Entities are defined in and validated against the Entity file. See Accounts Payable Working with Entities (WENT). Numeric, 3 positions; display-only. |
Placer |
The identifying number and name of the individual within an organization who placed the order. See Creating and Updating Individuals. Placer number: numeric, 3 positions; display-only. Placer name: alphanumeric, 15 positions (the first 15 characters of the title, first name, middle initial, last name, and suffix); display-only. |
Originator |
The identifying number and name of the individual within an organization who originated or approved the order. If you have deleted the individual record, the originator number only will display. See Creating and Updating Individuals. Originator number: numeric, 3 positions; display only. Originator name: alphanumeric, 15 positions (the first 15 characters of the title, first name, middle initial, last name, and suffix); display only. |
Note: The placer and originator appear on this screen only if the Individuals required in order entry System Control value is set to Y. |
|
Transaction date |
The date when the transaction occurred. Note: Transactions that take place on the same day may be consolidated into the same Order/Billing History record if the key fields to the transactions are the same. For example, if a customer adds an item to the order and then cancels it the same day, both transactions will appear on the same Order/Billing History record. Numeric, 6 positions (MMDDYY format); display-only. |
Consolidated from... |
The date of the earliest record that was used to derive the totals for the consolidated record. If a record has been consolidated, any fields not retained in the consolidation appear blank. This information appears only for consolidated records; see System Operations Consolidating Order Billing History (MOBH). Numeric, 6 positions (MM/DD/YY format); display-only. |
Consolidated to... |
The date of the latest record that was used to derive the totals for the consolidated record. Numeric, 6 positions (MM/DD/YY format); display-only. |
Note: Each of the Total amount fields below represents the merchandise amount net of hidden tax if you use VAT and tax-inclusive pricing. In addition, if you process orders in multiple currencies based on offer, each amount has been converted into your local currency. See the beginning of this chapter for more information. If the record has been consolidated, the totals represent the net for all records used to derive the consolidated record. |
|
Total quantity of the item added to the order on the date shown. Note: If this field is blank, but there is an order amount, the transaction represents changing the price of an item. Numeric, 5 positions; display-only. |
|
The merchandise dollar amount ordered for this item on the date shown. This does not include tax, freight, or additional charges. When does this field update? The orders amount and quantity fields update for transactions that represent adding an item to the order for any reason, including free gifts, incentive or promotional items, or replacement items when you process an exchange. If this field is blank: This field will be blank if: • the Update Demand for Order Maintenance Transactions (C72) system control value is set to N or blank and the transaction represents adding an item in order maintenance • the items is free of charge • for items that you return through order entry (using a negative quantity); there will be both an entry and a billing transaction for such an item • the transaction does not represent adding an item to an order |
|
|
Cancels: If the cancel reason used to cancel the item is set to update demand (Reduce demand? = Y), the cancellation total for the item appears here as a credit (CR), and the number of units canceled appears in the Quantity ordered field. Additionally, the Canceled fields will not be updated for the item. If you use a cancel reason that is not set to update demand, the totals appear in the Canceled fields rather than the Orders fields, and the dollar total will be a positive number. See Establishing Cancel Reason Codes (WCNR). Numeric, 11 positions with a 2-place decimal; display-only. |
Total quantity of the item canceled. A quantity in this field indicates that the cancel reason used on the order did not update demand. See Establishing Return Reason Codes (WRTR). Methods for canceling items include order maintenance, Processing Item Substitutions (PSUB), and Working with Backorders Pending Cancellation (WBPC). Numeric, 5 positions; display-only. |
|
The total merchandise value of canceled units, not including tax, freight, or additional charges. An amount in this field indicates that the cancel reason used on the order did not update demand. Numeric, 11 positions with a 2-place decimal; display-only. |
|
Quantity sold out |
Total quantity of the item sold out on the date shown. Numeric, 5 positions; display-only. |
$ sold out |
The total merchandise value of soldout units, not including tax, freight, or additional charges. These fields are updated on the transaction that represents: • adding a soldout item in order entry or order maintenance. In this situation, the order total amount and dollars update as well as the soldout amount and dollars. However, if the Update Demand for Order Maintenance Transactions (C72) system control value is not set to Y, only the soldout fields will update for items you add in order maintenance. • processing auto soldouts. See Processing Auto Soldout Cancellations (MASO). Numeric, 11 positions with a 2-place decimal; display-only. |
Quantity sold |
Total quantity of this item shipped on the date shown. Numeric, 5 positions; display-only. |
$ shipped |
Total merchandise dollar amount of the item you are reviewing shipped to the customer on the date shown. Numeric, 11 positions with a 2-place decimal; display-only. |
The total number of shipments to this customer for this date and item. Numeric, 5 positions; display-only. |
|
Quantity returned |
Total quantity of this item returned on the date and for the order shown. Numeric, 5 positions; display-only. |
$ returned |
The total merchandise value of returned units, not including tax, freight, or additional charges. Numeric, 11 positions with a 2-place decimal; display-only. |
# ret (Number of returns) |
Total number of orders related to the return transaction. This number will never be more than one. Numeric, 5 positions; display-only. |
Quantity exchanged (Exchanges total quantity) |
Total quantity of this item exchanged on the date shown. This field is updated for the billing transaction that represents returning the original item for exchange. Numeric, 5 positions; display-only. |
$ exchanged |
The total merchandise value of exchanged units, not including tax, freight, or additional charges, based on the price of the original item. This field is updated on the billing transaction that represents returning the original item for exchange. There will also be a maintenance transaction for both the original and the replacement item of the exchange; however, these maintenance transactions will not have any total quantities or dollar amounts. Numeric, 11 positions with a 2-place decimal; display-only. |
For more information: See Sample Order/Billing History for an Order for samples of the order/billing history records produced by a typical order.
The Entry/Maintenance code indicates the type of transaction performed on an item. The codes are:
• B = Billing
• M= Maintenance
• E = Entry
Examples: Examples of each type of transaction code are described in the table below.
Transaction Example |
Order/Billing History Update |
You enter an order for an item in order entry. |
The ORDER_ASYNC job creates an entry (E) transaction with the merchandise totals reflected in the Orders fields ($ ordered and Quantity ordered). |
You cancel an item and add another item. |
The ORDER_ASYNC job creates a maintenance (M) transaction with the merchandise total for the cancel reflected in the Cancels fields ($ canceled and Cancels total #, and another M transaction for the new item with the merchandise total reflected in the Orders fields ($ ordered and Quantity ordered. Note: The Quantity ordered and $ ordered fields update for units added in order maintenance only if the Update Demand for Order Maintenance Transactions (C72) system control value is set to Y; otherwise, the M transaction will appear with these fields blank. However, the total amount and quantity billed still increase when you ship and bill these items. |
You then ship that item to the customer. |
The BILL_ASYNC job creates a billing (B) transaction with the merchandise total for the shipment reflected in the Sales fields (# sales, Quantity ordered and $ ordered). |
See System Operations Using the ASYNC Jobs (MBJC) for more information on the asynchronous (ASYNC) jobs.
Sample Order/Billing History for an Order
Entry screen sample: The following screen sample represents the order/billing history transaction for entering an order for the item BE12345:
CSR0287 ENTER Order/Billing History Detail 5/11/99 16:27:48 EZK Mail Order Customer # . . . : 317 COMMERCIALWARE ATTN: MUNDI, GLORIA Ship to # . . . . : 0 Salesman # . . . : Offer number . . : OFR ALL-PURPOSE OFFER Source code . . . : SOURCE ALL-PURPOSE SOURCE CODE Item number . . . : BE12345 COLORFUL BEACH BALL SKU Code . . . . : COLORFUL BEACH BALL Item class . . . : TST TEST CLASS Ship via code . . : 1 Large Thumb Inc. Long SKU Dpt/Cls : 1234 19 TEST FORECAST ITEM Order Number . . : 5364 Entry/Maint. Code : E Entity : 1 Placer/Originator : Transaction Date : 4/29/99 Quantity ordered . . : 1 $ Ordered 10.00 Quantity cancelled . : $ Cancelled Quantity sold out . : $ Sold out Quantity sold . . . : $ Shipped # Sales Quantity returned . : $ Returned # Ret Quantity exchanged . : $ Exchanged
F3=Exit F12=Cancel |
Shipment screen sample:
CSR0287 ENTER Order/Billing History Detail 5/11/99 16:29:49 EZK Mail Order Customer # . . . : 317 COMMERCIALWARE ATTN: MUNDI, GLORIA Ship to # . . . . : 0 Salesman # . . . : Offer number . . : OFR ALL-PURPOSE OFFER Source code . . . : SOURCE ALL-PURPOSE SOURCE CODE Item number . . . : BE12345 COLORFUL BEACH BALL SKU Code . . . . : COLORFUL BEACH BALL Item class . . . : TST TEST CLASS Ship via code . . : 1 Large Thumb Inc. Long SKU Dpt/Cls : 1234 19 TEST FORECAST ITEM Order Number . . : 5364 Entry/Maint. Code : B Entity : 1 Placer/Originator : Transaction Date : 5/11/99 Quantity ordered . . : $ Ordered Quantity cancelled . : $ Cancelled Quantity sold out . : $ Sold out Quantity sold . . . : 1 $ Shipped 10.00 # Sales 1 Quantity returned . : $ Returned # Ret Quantity exchanged . : $ Exchanged
F3=Exit F12=Cancel |
Return screen samples:
CSR0287 ENTER Order/Billing History Detail 5/11/99 16:33:11 EZK Mail Order Customer # . . . : 317 COMMERCIALWARE ATTN: MUNDI, GLORIA Ship to # . . . . : 0 Salesman # . . . : Offer number . . : OFR ALL-PURPOSE OFFER Source code . . . : SOURCE ALL-PURPOSE SOURCE CODE Item number . . . : BE12345 COLORFUL BEACH BALL SKU Code . . . . : COLORFUL BEACH BALL Item class . . . : TST TEST CLASS Ship via code . . : 1 Large Thumb Inc. Long SKU Dpt/Cls : 1234 19 TEST FORECAST ITEM Order Number . . : 5364 Entry/Maint. Code : M Entity : 1
Transaction Date : 5/11/99 Quantity ordered . . : $ Ordered Quantity cancelled . : $ Cancelled Quantity sold out . : $ Sold out Quantity sold . . . : $ Shipped # Sales Quantity returned . : $ Returned # Ret Quantity exchanged . : $ Exchanged
F3=Exit F12=Cancel |
CSR0287 ENTER Order/Billing History Detail 5/11/99 16:35:25 EZK Mail Order Customer # . . . : 317 COMMERCIALWARE ATTN: MUNDI, GLORIA Ship to # . . . . : 0 Salesman # . . . : Offer number . . : OFR ALL-PURPOSE OFFER Source code . . . : SOURCE ALL-PURPOSE SOURCE CODE Item number . . . : BE12345 COLORFUL BEACH BALL SKU Code . . . . : COLORFUL BEACH BALL Item class . . . : TST TEST CLASS Ship via code . . : 1 Large Thumb Inc. Long SKU Dpt/Cls : 1234 19 TEST FORECAST ITEM Order Number . . : 5364 Entry/Maint. Code : B Entity : 1
Transaction Date : 5/11/99 Quantity ordered . . : $ Ordered Quantity cancelled . : $ Cancelled Quantity sold out . : $ Sold out Quantity sold . . . : $ Shipped # Sales Quantity returned . : 1 $ Returned 10.00 # Ret Quantity exchanged . : $ Exchanged
F3=Exit F12=Cancel |
There are two transactions for the return:
• a maintenance transaction for entering the return in order maintenance
• a billing transaction for crediting the return.
Regarding order/billing transactions:
• Transactions on the same day: Transactions for the same order, item, and of the same type (i.e., entry, maintenance, or billing) that take place on the same day are consolidated into one record.
• Adding items in order maintenance: If the Update Demand for Order Maintenance Transactions (C72) system control value is set to N or is blank, the order totals fields will not increase for any items you add in order maintenance. The maintenance transactions created in this situation will have no order quantities or amounts.
• Changing an item price: If you change the price of an item in order maintenance, you create a maintenance transaction with an order amount equal to the price change but no order quantity if the Update Demand for Order Maintenance Transactions (C72) system control value is set to Y; however, if this system control value is set to N, you create a maintenance transaction with no order quantity or amount.
• Exchanges: Entering an exchange in order maintenance produces three order/billing transactions:
• a maintenance transaction to reflect the change to the original item (with no quantity or dollar total);
• a maintenance transaction to add the replacement item (with order quantity and dollar total if you update demand for order maintenance);
• a billing transaction to credit the return of the original item (with exchange quantity and total).
• Item substitution: Processing a substitution through Processing Item Substitutions (PSUB) produces two maintenance transactions: a cancel for the original item, and an order for the replacement item.
Display Customer Order History Screen
Purpose: Use this screen below to review cumulative and current ordering information for a sold-to customer.
Note: Depending on the user’s authority to credit card information, the system writes a record to the Credit Card Audit file when this screen is displayed. See Logging Credit Card Data Access for more information.
How to display this screen: At a Work with Customers screen, enter 19 next to a customer; see Selecting Customers. Or press F19 at a Create, Change or Display Customer Sold To screen (see Creating and Updating Sold-to Customers (WCST)).
Note: You can also review individual customer order history at the Display Individual Order History Screen if the Update Customer Individual Order History File (H79) is set to Y.
CSR0129 DISPLAY Display Customer Order History 4/17/05 8:50:55 EZK Mail Order
Customer : 299 JACKMAN, OPHELIA
On order : 82,425.53 Active since . : 6/20/95 LIFE TO DATE QUANTITY AMOUNT Orders . . . . . . . : 713 44,712.35 Sales . . . . . . . . : 282 13,747.70 Returns . . . . . . . : 51 1,733.50 Cancels . . . . . . . : 24 2,017.88 Exchanges . . . . . . : 7 108.00 Sold outs . . . . . . : 62 827.46 Warranty Shipped . . .: .0000 Warranty Returned . . : .0000 Last credit card . . : 4788********1443**** Exp 905 Last order type . . . : P Last order date : 8/10/04 Last pay type . . . . : 9 Last order amt : 4.50 Last source . . . . . : SOURCE Last mail date : 2/11/02 Ref/Bal Due Write Off : .00 Ext Sales Date : 4/09/05 BML Account# 4444 Ext Sales Amt . : 800.00 F3=Exit F12=Cancel F17=Item classes F18=History details F19=Entity details F21=Detail report |
Field |
Description |
Customer # |
A unique number used to identify the customer you are reviewing. Numeric, 9 positions; display-only. |
Customer name (Unlabeled field to the right of the customer number) |
The name of the sold-to customer you are reviewing. Alphanumeric, 41 positions; display-only. |
The total dollar value of all open, unshipped orders for this customer, including charges for merchandise, freight, tax, special handling, and shipping. Cancels: This field subtracts the value of a canceled order/item. Soldouts: This field does not include the amount of soldout items on an order. Note: The On Order amount is not net of hidden tax; see Related System Control Values for more information on VAT. You can reset the On order $ for a sold to customer based on the open balance in the Order Ship To file using the Reset Customer Sold To $ On Order (RONO) menu option. Numeric, 11 positions with a 2-place decimal; display-only. |
|
The date of the customer's first order. The system uses the value in the Order date field in Order Entry. Numeric, 6 positions (MMDDYY format); display-only, updated by the system. |
|
Note: Each of the Amount fields described below represents the actual purchase price of merchandise only after applying any discounts, price overrides, or other repricing. However, if you use tax-inclusive pricing and VAT, amounts described below are net of hidden tax. In addition, if you process orders by multiple currencies based on offer, each amount has been converted into your local currency. See the beginning of this chapter for more information. The BILL_ASYNC and ORDR_ASYNC background jobs update order history; see Operating the Background Jobs for more information. Non-inventory items: The Demand Update for Non-Inventoried Items (E59) system control value controls whether the following totals are updated for non-inventory items. |
|
The gross number of orders placed by this customer. Updates: If the Update Demand for Order Maintenance Transactions (C72) system control value is set to Y, this field increases when you add a detail line(s) to an order in Order Maintenance. If the Update Demand for Order Maintenance Transactions (C72) system control value is set to N or is blank, this field does not update when you add a detail line(s) to an order in Order Maintenance. Cancellations: This total reduces when you cancel an order only if you enter a cancel reason set to update demand; otherwise, the orders quantity remains the same and the Cancels quantity total increases. The total does not increase when you enter a return through order entry, enter an exchange item on an order that is already open or held, or enter an order to purchase a gift certificate only. Numeric, 5 positions; display-only. |
|
The total merchandise value of the orders placed by the customer, including any backordered or soldout items and the purchase of any gift certificates. This total does not reflect returns created through order entry. Updates: If the Update Demand for Order Maintenance Transactions (C72) system control value is set to Y, this field updates when you add a detail line(s) to an order in Order Maintenance. When you enter an exchange, the price of the exchange (replacement) item is added. If the Update Demand for Order Maintenance Transactions (C72) system control value is N or is blank, this field does not update when you add a detail line(s) to an order in Order Maintenance, including an exchange item. Cancellations: This total reduces when you cancel an order only if you enter a cancel reason set to update demand; otherwise, the orders amount remains the same and the Cancels amount increases. Numeric, 11 positions with a 2-place decimal; display-only. |
|
The number of shipments to the customer, including generation of a gift certificate. This total may be larger than the orders quantity if the Update Demand for Order Maintenance Transactions (C72) system control value is set to N or is blank, and you have added any items to this customer's orders in order maintenance. If an order has partial shipments on different days, each shipment updates the sales quantity; however, if two shipments occur on the same day, the sales quantity is increased just by 1. Numeric, 5 positions; display-only. |
|
The total merchandise dollar value of orders shipped to the customer, including generation of a gift certificate. This total may be larger than the orders amount if the Update Demand for Order Maintenance Transactions (C72) system control value is set to N or is blank, and you have added any items to this customer's orders in order maintenance. Also, it may be larger due to purchase of gift certificates. Numeric, 11 positions with a 2-place decimal; display-only. |
|
The number of returns processed for the customer, including returns you process by entering a negative quantity in order entry or crediting a return through the return authorizations suite of functions (see Managing Returns). If you enter multiple returns during a single order entry, order maintenance, or return authorizations session, the quantity is increased just 1. Note: If you use the return authorizations suite, this total is updated when you credit the return. Numeric, 5 positions; display-only. |
|
The total merchandise dollar value of items returned by the customer, including returns you process by entering a negative quantity in order entry or through the return authorizations suite of functions (see Managing Returns). Note: If you use the return authorizations suite, this total is updated when you credit the return. Numeric, 11 positions with a 2-place decimal; display-only. |
|
The number of orders or order lines canceled by the customer. If you cancel multiple items on an order in a single session or cancel the whole order, this total is increased just 1. This total does not include cancellations using a cancel reason whose Update demand field is set to N. Methods for canceling items include order maintenance, Processing Item Substitutions (PSUB), and Working with Backorders Pending Cancellation (WBPC). Numeric, 5 positions; display-only. |
|
The total merchandise dollar value of items canceled by the customer. This total does not include cancellations using a cancel reason whose Update demand field is set to N. Numeric, 11 positions with a 2-place decimal; display-only. |
|
The number of exchanges processed for the customer. If you exchange multiple items on an order in a single session, this total is increased just 1. Numeric, 5 positions; display-only. |
|
The total merchandise dollar amount of items exchanged by the customer. This amount represents the returned items, not the replacement items. Numeric, 11 positions with a 2-place decimal; display-only. |
|
The number of soldout items ordered by the customer. This includes items sold out automatically during order entry, backordered items sold out through option 13, and items sold out automatically through Processing Auto Soldout Cancellations (MASO). Numeric, 5 positions; display-only. |
|
Total merchandise dollar amount of soldout items ordered by the customer. Numeric, 11 positions with a 2-place decimal; display-only. |
|
The total cost of warranty items shipped to the customer. Since warranty items are added to an order at no charge, the system uses the cost defined in the Costing Method (A25) system control value to determine the warranty shipped amount. If you are using FIFO costing, the system uses the weighted average FIFO cost. If the cost was overridden on the order detail line, the system uses the cost override. Numeric, 11 positions with a 2-place decimal; display-only. |
|
The total cost of warranty items returned or exchanged by the customer. Since warranty items are added to an order at no charge, the system uses the cost defined in the Costing Method (A25) system control value to determine the warranty returned amount. If you are using FIFO costing, the system uses the weighted average FIFO cost. If the cost was overridden on the order detail line, the system uses the cost override. Numeric, 11 positions with a 2-place decimal; display-only. |
|
The number of the credit card the customer most recently used on an order. The system stores this credit card number in the Customer Sold To Order History file only if the Prevent Storing the Customer’s Last CC# and Exp Date (J86) system control value is set to N or blank. If you use Credit Card Tokenization, this number may be a token rather than the actual credit card number. If you do not have authority to the Display Full Credit Card Number (B14) secured feature, the credit card number displays in the format specified at the Credit Card Number Layout Screen for the associated pay type. For example, ************1443 may display instead of the entire credit card number. See Credit Card Number Format for an overview. If the operator does not have authority to the Restrict Access to Credit Card Numbers in OI and OM (A88) secured feature, this field is blank. If the last credit card payment method used was Bill Me Later, the description of the Bill Me Later pay type displays. See Bill Me Later Processing for an overview. If the last credit card payment method used as a Direct Bank Disbursement, the description of the Direct Bank Disbursement pay type displays. See Processing Direct Bank Disbursements/Electronic Checks for an overview. Alphanumeric, 20 positions; display-only. |
|
The expiration date of the credit card above. The system stores the credit card’s expiration date in the Customer Sold To Order History file only if the Prevent Storing the Customer’s Last CC# and Exp Date (J86) system control value is set to N or blank. May be blank if the credit card pay type does not require an expiration date, based on the Require expiration date setting. If the operator does not have authority to the Restrict Access to Credit Card Numbers in OI and OM (A88) secured feature, this field is blank. Numeric, 4 positions (MMYY format); display-only. |
|
A code that identifies how the order was received, such as a telephone, mail, fax, etc. Order types are defined in and validated against the Order Type file. See Establishing Order Types (WOTY). Alphanumeric, 1 position; display-only. |
|
The date of the most recent order for the customer. The system uses the value in the Order date field in order entry. Numeric, 6 positions (MMDDYY format); display-only. |
|
The payment method used by the customer on the most recent order. If there was more than one pay type on the order, the last payment method entered appears. Pay type codes are defined in and validated against the Pay Type file. See Accounts Payable Working with Pay Types (WPAY). Numeric, 2 positions; display-only. |
|
The original dollar value of merchandise on the customer's most recent order. This field does not update to reflect subsequent transactions against the order that changed the order total, such as cancellations, soldouts, or adding items. This value will be zero if the most recent order for the customer was a return through order entry. Numeric, 11 positions with a 2-place decimal; display-only. |
|
The source code used on the header of the customer's most recent order (even if the order was a return through order entry) or catalog request; however, if there is an individual on the catalog request, this field is not updated for the sold-to customer, only for the individual. The source code identifies a segment of your customer base. You can analyze sales by source code. Additionally, the source code determines the method to calculate freight and pricing on an order. See Working with Source Codes (WSRC). Alphanumeric, 7 positions; display-only. |
|
The most recent date when you mailed an offer (catalog) to the customer. The system updates this field when you print catalog mailing labels through Processing Catalog Requests (PCAT) or generate a house list; however, if there is an individual on the catalog request, this field is not updated for the sold-to customer, only for the individual. Numeric, 6 positions (MMDDYY format); display-only. |
|
The total amount eligible to be written off (or applied as an additional charge/credit) for the customer from short-paying (balance dues) or over-paying (refunds) orders. Numeric, 7 positions with a 2-place decimal; display-only. |
|
The last date when the Ext sales amt was updated. The system uses this date to calculate the customer’s total dollar value in order to determine if the customer qualifies for a loyalty program with a calculation method of E (external) or O (order). The total merchandise dollar value of any orders entered since the last Ext sales date are added to the Ext sales amount, and this total is compared with the LTD dollars required for the loyalty program. For example, a loyalty program requires at least $500.00 in ordered merchandise. The Ext sales amount total is $400.00, and the Ext sales date is two weeks ago. In the two weeks since the Ext sales date, the customer has placed an order for $50.00, and is currently placing an order for $60.00. In this situation, the total dollar value ordered since the Ext sales date is $110.00, so the customer qualifies for the loyalty program. The Generic Customer API updates this field whenever you add or change a customer and specify an External sales amount. If the external sales date is not specified in the CWCustomerIn message, but the message does specify an external sales amount, the system uses the current date to update this field. The system does not consider this date when calculating a customer’s total dollar value for a loyalty program with a calculation method of S (sales). |
|
|
Merge/purge: The customer merge/purge process updates the target customer’s external sales date using different logic than it uses when updating the External sales dollars. As a result, it is possible to have an amount of zero with an update date, or a date that does not reflect the actual date when the amount was updated. See Working with Merge/Purge Sold-to Names (MMCS) for more information on merge/purge. For more information: See Loyalty Memberships for a discussion. Numeric, 6 positions (MM/DD/YY format); display-only. |
BML account # |
The account number assigned if the customer has established a Bill Me Later account. This account number is used for authorization of subsequent orders that have a Bill Me Later payment method once the account is established; however, the actual account number is not required when entering an order. Instead, you enter the customer’s date of birth and last four digits of the social security number. See Bill Me Later Processing for an overview. Numeric, 20 positions; display-only. |
The total dollar value of external sales, if any, to include when calculating the customer’s eligibility for a loyalty membership program: • Loyalty programs with a type of S (sales): the system adds this dollar value to the total merchandise dollar value of sales within the effective period of the loyalty program. • Loyalty programs with a type of E (external) or O (orders), the Ext sales date (External sales date) and the loyalty program start date, if any, indicate whether to add recent order dollars to the external sales amounts when calculating the qualifying dollar total for loyalty membership evaluation. For more information: See Loyalty Memberships for a discussion. Numeric, 9 positions with a two-place decimal; display-only. |
|
Screen Option |
Procedure |
Review customer item class history |
Press F17 to advance to the Display Customer Item Class Screen. |
Review customer order history detail |
Press F18. See Customer Sold To Order History Screen (Reviewing Detail). |
Review order history by entity |
Press F19 to advance to the Display Customer Order/Entity History Screen. Note: This option is available only if the Track Customer History at Entity Level (F89) system control value is set to Y. |
Display Customer Item Class Screen
Purpose: Use this screen to review item classes assigned to an item the customer ordered.
Important: Detailed customer item class history has been kept only since version 3.0 of Mozart (CWDirect), so totals may not be complete for longer-standing customers.
How to display this screen: Press F17 at the Display Customer Order History Screen.
CSR0747 DISPLAY Display Customer Item Class 2/24/99 11:30:34 EZK Mail Order
Customer# . : 317 COMMERCIALWARE ATTN: MUNDI, GLORIA
# of # of Date of Opt Cls Description Orders Units LTD Total Last Order
Type options, press Enter. 5=Display 7=Entity history
CRT CREATIVITY TOYS 7 8 211.90 1/28/99 KIT KITCHEN GOODS 22 69 2,079.98 2/15/99 PTY PARTY GOODS 2 75 75.00 11/25/98 123 SOFT TOYS 72 193 1,727.70 2/23/99 4 ACCESSORIES 1 1 5.00 1/28/99
F3=Exit |
Field |
Description |
Customer # |
A unique number to identify a customer. Numeric, 9 positions; display-only. |
Customer name (Unlabeled field to the right of the customer number) |
The name of the customer placing the order and/or the company associated with that customer. Alphanumeric, 41 positions; display-only. |
Class (Item class) |
A code used to group similar items for reporting, merchandising, customer service information, and demand tracking. Item class codes are defined in and validated against the Item Class file. You assign an item class to an item at the first Create or Change Item screen. See Merchandising Working with Item Classes (WICL) for more information on working with item class; see Merchandising Working with Existing Items (MITM) for more information on assigning an item to an item class. Alphanumeric, 40 positions; display-only. |
Description (Item class description) |
The description of the item class. Alphanumeric, 40 positions; display-only. |
# of orders |
The total number of orders the customer has placed for items in this item class. Numeric, 5 positions; display-only. |
# of units |
The total number of units the customer has ordered for items in this item class. Numeric, 5 positions; display-only. |
LTD total (Life-to-date total) |
The dollar total of all merchandise the customer has ordered from this item class to date. Numeric, 13 positions with a 2-place decimal; display-only. |
Date of last order |
The date when the customer last placed an order for an item from this class, or added an item from this class in order maintenance. Numeric, 6 positions (MMDDYY format); display-only. |
Screen Option |
Procedure |
Review item class history detail |
Enter 5 next to an item class to advance to the Display Customer Item Class History Screen (Reviewing Detail). |
Review item class history by entity |
Enter 7 next to an item class to advance to the Display Customer Item Class Entity Screen (Reviewing History). Note: This option is available only if the Track Customer History at Entity Level (F89) system control value is set to Y. |
Display Customer Item Class History Screen (Reviewing Detail)
Purpose: Use this screen to review the sold-to customer's order and sales history for a particular item class.
Note: See Display Customer Order History Screen for more information on how the system calculates order activity totals.
How to display this screen: Enter 5 next to an item class at the Display Customer Item Class Entity Screen (Reviewing History).
CSR0873 DISPLAY Display Customer Item Class History 4/13/98 11:10:13 EZK Mail Order
Customer# . : 576 BIRD, TONY
# of # of Date of Cls Description Orders Units LTD Total Last Order 123 SOFT TOYS 2 7 70.00 4/13/98
LIFE TO DATE QUANTITY AMOUNT Sales . . . . . . . . : 3 30.00 Returns . . . . . . . : 0 .00 Cancels . . . . . . . : 1 10.00 Exchanges . . . . . . : 0 .00 Sold Outs . . . . . . : 0 .00
F3=Exit F12=Cancel |
Field |
Description |
Customer # |
A unique number to identify a customer. Numeric, 9 positions; display-only. |
Customer name (Unlabeled field to the right of the customer number) |
The name of the customer placing the order and/or the company associated with that customer. Alphanumeric, 41 positions; display-only. |
Cls (Item class) |
A code used to group similar items for reporting, merchandising, customer service information, and demand tracking. Item class codes are defined in and validated against the Item Class file. You assign an item class to an item at the first Create or Change Item screen. See Merchandising Working with Item Classes (WICL) for more information on working with item class; see Merchandising Working with Existing Items (MITM) for more information on assigning an item to an item class. Alphanumeric, 40 positions; display-only. |
Description (Item class description) |
The description of the item class. Alphanumeric, 40 positions; display-only. |
# of orders |
The total number of orders the customer has placed for items in this item class. Numeric, 5 positions; display-only. |
# of units |
The total number of units the customer has ordered for items in this item class. Numeric, 5 positions; display-only. |
LTD total (Life-to-date total) |
The dollar total of all merchandise the customer has ordered from this item class to date. Numeric, 13 positions with a 2-place decimal; display-only. |
Date of last order |
The date when the customer last placed an order for an item from this class, or added an item from this class in order maintenance. Numeric, 6 positions (MMDDYY format); display-only. |
Life-to-date totals: |
|
Sales |
The total units and merchandise total shipped to the sold-to customer for this item class. Quantity: numeric, 5 positions; display-only. Amount: numeric, 13 positions with a 2-place decimal; display-only. |
Returns |
The total units and merchandise total returned by the sold-to customer for this item class. Quantity: numeric, 5 positions; display-only. Amount: numeric, 13 positions with a 2-place decimal; display-only. |
Cancels |
The total units and merchandise total canceled by the sold-to customer for this item class. Quantity: numeric, 5 positions; display-only. Amount: numeric, 13 positions with a 2-place decimal; display-only. |
Exchanges |
The total units and merchandise total exchanged by (that is, returned for exchange by) the sold-to customer for this item class. Quantity: numeric, 5 positions; display-only. Amount: numeric, 13 positions with a 2-place decimal; display-only. |
Sold outs |
The total units and merchandise total sold out, either in order entry/maintenance or through process auto soldouts, the sold-to customer for this item class. Quantity: numeric, 5 positions; display-only. Amount: numeric, 13 positions with a 2-place decimal; display-only. |
Customer Sold To Order History Screen (Reviewing Detail)
Purpose: This screen displays sales history associated with each order placed by the customer. Each entry on this screen represents an order/billing history transaction; see Order Billing History Detail Screen.
How to display this screen: Press F18 at the Display Customer Order History Screen.
CSR0281 DISPLAY Customer Sold To Order History 5/11/99 16:40:24 EZK Mail Order
Customer : 317 COMMERCIALWARE ATTN: MUNDI, GLORIA
Tran -- Consolidated -- ----- Order ----- ----- Sales ------ Opt Date From To Qty Amount Qty Amount Ent
Type options, press Enter. 5=Display
6/02/98 1 6.99 1 6/02/98 1 6.99 1 6/02/98 1 6.99 1 6/02/98 1 6.99 1 6/02/98 1 6.99 1 6/02/98 1 6.99 1 6/02/98 1 6.99 1 6/02/98 1 6.99 1 8/28/95 6/01/98 1 30.00 1 30.00 1 +
F3=Exit F12=Cancel F21=Print list |
Field |
Description |
Tran date (Transaction date) |
The date when order or sales activity occurred for the customer. The system lists order or sales activity by date starting with the most recent date. Each entry on this screen represents an order/billing history transaction for an item on an order. The transaction date does not appear for consolidated records. See the following fields. Numeric, 6 positions (MMDDYY format); optional. |
Consolidated from |
The date of the earliest record that was used to derive the totals for the consolidated record. If a record has been consolidated, any fields not retained in the consolidation appear blank. This information appears only for consolidated records; see System Operations Consolidating Order Billing History (MOBH). Numeric, 6 positions (MM/DD/YY format); display-only. |
Consolidated to |
The date of the latest record that was used to derive the totals for the consolidated record. See above for more information. Numeric, 6 positions (MM/DD/YY format); display-only. |
The total unit quantity of the item ordered. If blank: If the Update Demand for Order Maintenance Transactions (C72) system control value is set to Y, transactions you enter in order maintenance will appear on this screen. This field and the Amount field are blank for cancellations, returns, exchanges, and sellouts. However, if a cancel reason code whose Update demand field is set to Y was used, the amount for this field will display. Numeric, 5 positions; optional. |
|
Amount |
The total merchandise dollar amount ordered on the date shown. This total does not include freight, handling, or other charges. If blank: If the Update Demand for Order Maintenance Transactions (C72) system control value is set to Y, transactions you enter in order maintenance will appear on this screen. This field and the Qty (Order quantity) field are blank for cancellations, returns, exchanges, and sellouts. However, if a cancel reason code whose Update demand field is set to Y was used, the amount for this field will display. Numeric, 11 positions with a 2-place decimal; optional. |
Sales |
|
Qty (Quantity) |
The total number of units shipped on the date shown. Numeric, 5 positions; optional. |
Amount |
Total merchandise dollar value of shipments for the date shown. Numeric, 11 positions with a 2-place decimal; optional. |
Entity |
The code representing the entity associated with the source code on order header. Each source code is associated with an entity through its division. Entities are defined in and validated against the Entity file. See Accounts Payable Working with Entities (WENT). Numeric, 3 positions; display-only. |
Screen Option |
Procedure |
Display order history detail |
Enter 5 next to a record to advance to the Order Billing History Detail Screen. |
Display Customer Order/Entity History Screen
Purpose: Use this screen to review the entities in which the customer has placed orders, and to select an entity for further inquiry.
The system tracks entity history for a customer even if there has not been any order activity (for example, if the customer has requested a catalog); however, the order totals and date of last order will be blank.
How to display this screen: Press F19 at the Display Customer Order History Screen.
Note: This screen is available only if the Track Customer History at Entity Level (F89) system control value is set to Y.
OER1084 DISPLAY Display Customer Order/Entity History 2/15/99 9:01:15 EZK Mail Order
Customer# . . : 317 COMMERCIALWARE ATTN: MUNDI, GLORIA
------- LTD Order -------- Date of Opt Ent # of Amount Last Order
Type options, press Enter. 5=Display
1 ROBOTS ALIVE 1 50.00 2/10/99 2 A DOG'S LIFE 5 180.00 2/12/99
F3=Exit F12=Cancel F21=Detail report |
See Order Billing History Detail Screen for remaining fields.
Field |
Description |
Ent (Entity) |
A code representing the entity for which the order activity took place. An order is associated with an entity through the source code on the order header; each source code is assigned to a division, and each division points to an entity. Entities are defined in and validated against the Entity file. See Accounts Payable Working with Entities (WENT). Numeric, 3 positions; optional. |
Entity description (Unlabeled field to the right of the entity code) |
The description of the entity. Alphanumeric, 25 positions; display-only. |
LTD order...# of |
The gross number of orders placed by this customer in this entity. Updates: If the Update Demand for Order Maintenance Transactions (C72) system control value is set to Y, this field increases when you add a detail line(s) to an order in Order Maintenance. If the Update Demand for Order Maintenance Transactions (C72) system control value is set to N or is blank, this field does not update when you add a detail line(s) to an order in Order Maintenance. Cancellations: This total reduces when you cancel an order only if you enter a cancel reason set to update demand; otherwise, the orders quantity remains the same and the Cancels total increases. Preexisting orders: Orders you entered before the Track Customer History at Entity Level (F89) Level system control value was set to Y are not included in this total; however, items you added in order maintenance are included if the Update Demand for Order Maintenance Transactions (C72) system control value is set to Y. Numeric, 5 positions; display-only. |
LTD order...amount (Life-to-date order amount) |
The merchandise dollar total of orders placed by this customer in this entity. Updates: If the Update Demand for Order Maintenance Transactions (C72) system control value is set to Y, this field increases when you add a detail line(s) to an order in Order Maintenance. If the Update Demand for Order Maintenance Transactions (C72) system control value is set to N or is blank, this field does not update when you add a detail line(s) to an order in Order Maintenance. Cancellations: This total reduces when you cancel an order only if you enter a cancel reason set to update demand; otherwise, the orders quantity remains the same and the Cancels total increases. Preexisting orders: Orders you entered before the Track Customer History at Entity Level (F89) Level system control value was set to Y are not included in this total; however, items you added in order maintenance are included if the Update Demand for Order Maintenance Transactions (C72) system control value is set to Y. Numeric, 11 positions with a 2-place decimal; display-only. |
Date of last order |
The most recent date when you entered an order for this customer in this entity. Numeric, 6 positions (MMDDYY format); display-only. |
Screen Option |
Procedure |
Review customer entity history details |
Enter 5 next to an entity to advance to the Display Customer Entity History Screen (Reviewing Order Detail). |
Display Customer Entity History Screen (Reviewing Order Detail)
Purpose: Use this screen to review details about a customer's order history for a particular entity.
The system tracks entity history for a customer even if there has not been any order activity (for example, if the customer has requested a catalog); however, the order totals and date of last order will be blank.
How to display this screen: Enter 5 next to an entity at the Display Ship To Order/Entity History Screen.
Note: This screen is available only if the Track Customer History at Entity Level (F89) system control value is set to Y.
OER1081 DISPLAY Display Customer Entity History 2/15/99 10:38:02 EZK Mail Order
Customer : 317 COMMERCIALWARE ATTN: MUNDI, GLORIA Entity : 1 ROBOTS ALIVE On order : 151.75
Entered date . : 2/10/99 Original source . : SOURCE1 Active since . : 2/10/99 Last source . . . : SOURCE7 Last order date : 2/15/99
LIFE TO DATE QUANTITY AMOUNT Orders . . . . . . . . . : 6 235.00 Sales . . . . . . . . . . : 1 50.00 Returns . . . . . . . . . : 2 55.00 Cancels . . . . . . . . . : 2 20.00 Exchanges . . . . . . . . : 0 .00 Sold outs . . . . . . . . : 1 30.00
F3=Exit F12=Cancel |
See Display Customer Order History Screen and Display Customer Order/Entity History Screen for additional field descriptions.
Note: Each field on this screen represents history for this customer within this entity only.
Field |
Description |
Entered date |
The date that the first activity for this customer within the entity took place. This activity might be something other than entering an order, such as a return or exchange. Numeric, 6 positions (MM/DD/YY format); display-only. |
Display Customer Item Class Entity Screen (Reviewing History)
Purpose: Use this screen to review customer item class history broken out by entity, or to select an entity for further inquiry.
How to display this screen: Enter 7 next to an item class at the Display Customer Item Class Screen.
Note: This screen is available only if the Track Customer History at Entity Level (F89) system control value is set to Y.
CSR0956 DISPLAY Display Customer Item Class Entity 2/15/99 12:13:45 EZK Mail Order
Customer# . . . : 317 COMMERCIALWARE ATTN: MUNDI, GLORIA Item Class . . : 123 SOFT TOYS # of # of Date of Opt Ent Description Orders Units LTD Total Last Order
Type options, press Enter. 5=Display
1 ROBOTS ALIVE 7 9 90.00 2/15/99 2 A DOG'S LIFE 5 18 180.00 2/15/99
F3=Exit F12=Cancel |
See Display Customer Item Class Screen and Display Customer Order/Entity History Screen for field descriptions.
Note: Each field on this screen represents history for this customer within this entity and item class only.
Screen Option |
Procedure |
Display details about the customer's order history for this item class and entity |
Enter 5 next to an entity to advance to the Display Customer Item Class Entity Details Screen (Reviewing History). |
Display Customer Item Class Entity Details Screen (Reviewing History)
Purpose: Use this screen to review detailed information about a customer's order history for a particular item class and entity.
How to display this screen: Enter 5 next to an entity at the Display Customer Item Class Entity Screen (Reviewing History).
Note: This screen is available only if the Track Customer History at Entity Level (F89) system control value is set to Y.
CSR0957 DISPLAY Display Customer Item Cls Entity Details 2/15/99 12:21:55 EZK Mail Order
Customer# . : 317 COMMERCIALWARE ATTN: MUNDI, GLORIA Entity . . . : 2 A DOG'S LIFE
# of # of Date of Cls Description Orders Units LTD Total Last Order 123 SOFT TOYS 5 18 180.00 2/15/99
LIFE TO DATE QUANTITY AMOUNT Sales . . . . . . . . . . . . : 1 10.00 Returns . . . . . . . . . . . : 0 .00 Cancels . . . . . . . . . . . : 1 10.00 Exchanges . . . . . . . . . . : 0 .00 Soldouts . . . . . . . . . . : 0 .00
F3=Exit F12=Cancel |
See Display Customer Item Class History Screen (Reviewing Detail) and Display Customer Order/Entity History Screen for field descriptions.
Note: Each field on this screen represents history for this customer within this entity and item class only.
Display Ship To Item History Screen
Purpose: Use this screen, to review item history for a ship-to customer associated with a sold-to customer.
You can advance to this screen and subsequent screens only if the Track item history field for the sold-to customer is set to 3 (track sold-to and ship-to item history); however, the system continues to track item history regardless of this setting.
How to display this screen: Enter 18 next to a ship to customer at the Work with Customer Ship Tos Screen, which is available by pressing F7 at any Create/Change/Display Customer screen in customer maintenance, or by entering 7 next to a sold to customer at a customer maintenance scan screen.
CSR0290 DISPLAY Display Ship To Item History 5/11/99 16:51:30 EZK Mail Order
Customer : 291 BROWN, SARAH RAE R Ship to # : 1 PETS 'R' US ATTN: KAPLAN, ELISE Z
Opt Item COL SIZE WDTH Date Qty Ord Order Total Con
Type options, press Enter. 5=Display
B5000 BLK 10 11/11/98 1 50.00 BLACK SIZE 10 B5000 BLK 10 11/11/98 0 .00 BLACK SIZE 10 B5000 BLK 12 11/11/98 1 50.00 BLACK SIZE 12 B5000 BLK 4 11/11/98 1 50.00 BLACK SIZE 4 +
F3=Exit F12=Cancel F21=Print List |
Although it includes ship-to item history only, the Display Ship To Item History screen resembles the Customer Sold To Item History Screen; see this screen for remaining field descriptions.
Field |
Description |
Ship to # |
A unique number to identify the ship-to customer for the sold-to customer. There can be up to 999 ship-to customers for a sold-to customer. The customer's name appears to the right of the ship-to number. If there is a company name, this information is included before the name, followed by the word ATTN. Ship-to number: numeric, 3 positions; display-only. Name: alphanumeric, 41 positions; display-only. |
Screen Option |
Procedure |
Display order billing history detail |
Enter 5 next to an item to advance to the Order Billing History Detail Screen. Note: The same information is available by selecting the ship to customer's order billing history as by selecting the sold to customer's history. |
Display Ship To Order History Screen
Purpose: Use this screen to review order totals for a ship to customer.
Note: Depending on the user’s authority to credit card information, the system writes a record to the Credit Card Audit file when this screen is displayed. See Logging Credit Card Data Access for more information.
How to display this screen: Enter 19 next to a ship to customer at the Work with Customer Ship Tos Screen, which is available by pressing F7 at any Create/Change/Display Customer screen in customer maintenance, or by entering 7 next to a sold to customer at a customer maintenance scan screen. See Creating and Updating Sold-to Customers (WCST).
Note: You can advance to this screen only if the Track item history field for the sold-to customer is set to 3 (track sold-to and ship-to item history); however, the system continues to track item history regardless of this setting.
CSR0180 DISPLAY Display Ship To Order History 8/12/03 14:08:26 EZK Mail Order
Customer : 613 JACKRABBIT ENTERPRISES ATTN: JACKRABBIT, Ship to : 1 BUNNIES 'N' MORE ATTN: LEPUS, RUFUS
On order : 245.36- Active since . : 2/25/99
LIFE TO DATE QUANTITY AMOUNT Orders . . . . . . : 9 286.10 Sales . . . . . . . : 15 480.00 Returns . . . . . . : 9 265.00 Cancels . . . . . . : Exchanges . . . . . : Sold outs . . . . . : 1 20.00
Last credit card . : 12345678901234567890 Exp 1205 Last order type . . : P Last order date : 8/12/03 Last pay type . . . : 15 Last source . . . . : SOURCE Last mail date :
F3=Exit F12=Cancel F18=History details F21=Print list |
Although it includes ship-to customer history only, this screen resembles the Display Customer Order History Screen. See this screen and the Display Ship To Item History Screen for field descriptions.
Note: Each field on this screen represents history for this ship-to customer only.
Display Ship To Order History Details Screen
Purpose: Use this screen to review order detail for a ship to customer, or to select an order detail line for further inquiry. Each entry on this screen represents an order/billing history transaction; see Order Billing History Detail Screen.
How to display this screen: Press F18 at the Display Ship To Order History Screen.
Note: You can advance to this screen only if the Track item history field for the sold-to customer is set to 3 (track sold-to and ship-to item history); however, the system continues to track item history regardless of this setting.
CSR0291 DISPLAY Display Ship To Order History Details 5/11/99 16:56:21 EZK Mail Order
Customer : 291 BROWN, SARAH RAE R Ship to # : 2 BROWN, HANNAH E
Tran -- Consolidated -- ----- Order ----- ----- Sales ------ Opt Date From To Qty Amount Qty Amount Ent
Type options, press Enter. 5=Display
6/10/98 0 .00 0 .00 1 6/10/98 0 .00 0 .00 1 11/03/95 6/01/98 1 20.96 0 .00 1 11/03/95 6/01/98 1 20.96 0 .00 1 3/23/98 6/01/98 4 40.00 0 .00 1 4/13/98 6/01/98 0 .00 1 20.96 1 4/13/98 6/01/98 0 .00 1 10.00 1
F3=Exit F12=Cancel F21=Print list |
Although it includes ship-to customer order history details only, this screen resembles the Customer Sold To Order History Screen (Reviewing Detail); see this screen for field descriptions.
Note: Each field on this screen represents history for this ship-to customer only.
Display Ship To Order/Entity History Screen
Purpose: Use this screen to review the entities in which a ship to customer has had order activity, and to select an entity for further inquiry.
How to display this screen: Press F19 at the Display Ship To Order History Screen.
Note: This screen is available only if the Track Customer History at Entity Level (F89) system control value is set to Y. Also, you can advance to this screen only if the Track item history field for the sold-to customer is set to 3 (track sold-to and ship-to item history); however, the system continues to track item history regardless of this setting.
CSR0946 DISPLAY Display Ship To Order/Entity History 2/15/99 14:21:38 EZK Mail Order
Customer # : 317 COMMERCIALWARE ATTN: MUNDI, GLORIA Ship To . . : 1 JACKRABBIT, OPHELIA
------- LTD Order -------- Date of Opt Ent # of Amount Last Order
Type options, press Enter. 5=Display
1 ROBOTS ALIVE 1 50.00 2/15/99 2 A DOG'S LIFE 1 10.00 2/12/99
F3=Exit F12=Cancel F21=Print List |
Although it includes ship-to customer order/entity history only, this screen resembles the Display Customer Order/Entity History Screen; see this screen for field descriptions.
Note: Each field on this screen represents history for this ship-to customer only.
Display Ship To Entity History Screen (Order History Details by Entity)
Purpose: Use this screen to review order history for a particular ship to customer within a particular entity.
How to display this screen: Enter 5 next to an entity at the Display Ship To Order/Entity History Screen.
Note: You can advance to this screen only if the Track item history field for the sold-to customer is set to 3 (track sold-to and ship-to item history); however, the system continues to track item history regardless of this setting.
CSR0949 DISPLAY Display Ship To Entity History 2/15/99 15:05:02 EZK Mail Order
Customer# . . . : 317 COMMERCIALWARE ATTN: MUNDI, GLORIA Ship to . . . . : 1 JACKRABBIT, OPHELIA Entity . . . . : 1 ROBOTS ALIVE On order . . . : 57.50
Entered date . . : 2/15/99 Active since . . : 2/15/99 Last order date : 2/15/99
LIFE TO DATE QUANTITY AMOUNT Orders . . . . . . . . . . : 1 50.00 Sales . . . . . . . . . . . : 0 .00 Returns . . . . . . . . . . : 0 .00 Cancels . . . . . . . . . . : 0 .00 Exchanges . . . . . . . . . : 0 .00 Sold outs . . . . . . . . . : 0 .00
F3=Exit F12=Cancel |
Although it includes ship-to customer entity history only, this screen resembles the Display Customer Entity History Screen (Reviewing Order Detail); see this screen for field descriptions.
Note: Each field on this screen represents history for this ship-to customer only.
| Working with Pay Type Exclusions | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Work with User Fields Screen |
CS03_09 CWDirect 18.0.x 2018 OTN