Working with Order Line History Errors (WOHE)

Working with Order Line History Errors (WOHE)

Overview: Use this menu option to correct and reprocess an Order Line History In Message (CWORDLNHSTIN) that is in error.

CWDirect receives the Order Line History In Message (CWORDLNHSTIN) through the Order Line History (ORDLNHSTIN) job in Working with Integration Layer Processes (IJCT). See Order Line History In API for an overview.

In this topic:

• Order Line History Interface Errors

• Work with Order Line History Errors Screen

• Change Order Line History Errors Screen

• Display Order Line History Errors Screen

Order Line History Interface Errors

A list of errors that may occur when processing the Order Line History In Message (CWORDLNHSTIN) from an external system is displayed below.

Error Description	Reason
Company number is blank	The company_code in the Order Line History In Message (CWORDLNHSTIN) does not contain a value.
Company number (999) is invalid	The company_code in the Order Line History In Message (CWORDLNHSTIN) does not contain a valid CWDirect company code.
Order number is blank	The order_number in the Order Line History In Message (CWORDLNHSTIN) does not contain a value.
Order number (99999999) is invalid	The order_number in the Order Line History In Message (CWORDLNHSTIN) does not contain a valid CWDirect order number.
Order Ship To is blank	The ship_to_number in the Order Line History In Message (CWORDLNHSTIN) does not contain a value.
Order Ship To (999) is invalid	The ship_to_number in the Order Line History In Message (CWORDLNHSTIN) is not a valid ship to number for the specified order number.
Order Detail Seq is blank	The olh_odt_seq in the Order Line History In Message (CWORDLNHSTIN) does not contain a value.
Order Detail Seq (99999) is invalid	The olh_odt_seq in the Order Line History In Message (CWORDLNHSTIN) is not a valid order detail sequence number on an order line for the specified order number.
Activity is blank	The activity_code in the Order Line History In Message (CWORDLNHSTIN) does not contain a value.
Activity (Z) does not exist in Order Lin	The activity_code in the Order Line History In Message (CWORDLNHSTIN) does not exist as a valid activity code in the Order Line Activity Code file.
Activity (A) is reserved for system use	The activity_code in the Order Line History In Message (CWORDLNHSTIN) is a system-delivered code other than I (In Transit) or V (Delivered). You can pass any user-defined activity code in the CWORDLNHSTIN message. The only system-delivered activity codes CWDirect can receive in the message are I and V.
Quantity exceeds qty on line	The quantity in the Order Line History In Message (CWORDLNHSTIN) is greater than the quantity on the order line.
Quantity is not populated	The quantity in the Order Line History In Message (CWORDLNHSTIN) does not contain a value.
Item does not match item on line	The item_id in the Order Line History In Message (CWORDLNHSTIN) does not match the item number on the order line.
SKU does not match item on line	The sku in the Order Line History In Message (CWORDLNHSTIN) does not match the SKU code defined for the item on the order line.
Contact Date in invalid	The contact_date in the Order Line History In Message (CWORDLNHSTIN) is an invalid date. The contact date must be in MMDDYYYY format. You can send a past or future date.
Contact Time is invalid	The contact_time in the Order Line History In Message (CWORDLNHSTIN) is an invalid time. The contact time must be in HHMMSS format.
External System is invalid	The ext_sys_date in the Order Line History In Message (CWORDLNHSTIN) is an invalid date. The external system date must be in MMDDYYYY format. You can send a past or future date.
User is invalid	The user in the Order Line History In Message (CWORDLNHSTIN) is not a valid CWDirect user ID.
Order is in use	The order_number in the Order Line History In Message (CWORDLNHSTIN) is currently in use by another user or system process.
In Transit not allowed - line not shipped	The entire quantity for the order line (olh_odt_seq) defined in the Order Line History In Message (CWORDLNHSTIN) for activity I (In Transit) has not yet been shipped. In order to flag an order line as In Transit, an order line history record must exist for the order line for activity code S (Shipment) or B (Express Billed). Note: The system validates that the order line has been shipped. However, if the order line has been partially shipped, the system does not validate that the In Transit quantity does not exceed the shipped quantity on the order line.
POD not allowed - line not shipped	The entire quantity for the order line (olh_odt_seq) defined in the Order Line History In Message (CWORDLNHSTIN) for activity V (Delivered) has not yet been shipped. In order to flag an order line as Delivered, an order line history record must exist for the order line for activity code S (Shipment) or B (Express Billed).
Qty exceeds amt remaining to be POD’d	The quantity in the Order Line History In Message (CWORDLNHSTIN) for activity V (Delivered) is greater than the quantity remaining on the order line that can be flagged as delivered. In order to flag an order line as Delivered, an order line history record must exist for the order line for activity code S (Shipment) or B (Express Billed). The quantity flagged as delivered cannot be greater than the quantity shipped. In addition, when you process a return or exhange, the system automatically flags the returned quantity as delivered. For example: • if 2 units have shipped on an order line for a quantity of 2, you cannot flag 3 units as delivered. • if 2 units have shipped on an order line for a quantity of 3, you cannot flag 3 additional units as delivered.

Work with Order Line History Errors Screen

This screen displays all records in the Order Line History Error file.

Order line history errors display on this screen in descending error date/time and company sequence.

Note: The Work with Order Line History Errors screen is not company-specific; order line history errors for all companies in an environment display. You can use the Company scan field to position to the order line history errors for your company. To display order line history errors that are associated with an invalid company code, leave the Company scan field blank. In addition, pressing F7, will reprocess all order line history errors, across all companies; pressing F11 will delete all order line history errors, across all companies.

To correct an error: Use the Change Order Line History Errors Screen to correct the error on an Order Line History In Message (CWORDLNHSTIN). Once you correct the error, you can:

• Enter 7 next to to reprocess a single Order Line History In Message (CWORDLNHSTIN) in error.

• If the Order Line History In Message (CWORDLNHSTIN) no longer contains errors, the system creates an order line history record and displays the record on the Display Order Line History Screen.

• If the Order Line History In Message (CWORDLNHSTIN) still contains errors, the system creates a new record in the Order Line History Error file with the new error reason. You will need to correct the new error and reprocess the message again.

• Press F7 to reprocess all of the Order Line History In Message (CWORDLNHSTIN) in error.

• For each Order Line History In Message (CWORDLNHSTIN) that no longer contains errors, the system creates an order line history record and displays the record on the Display Order Line History Screen.

• For each Order Line History In Message (CWORDLNHSTIN) that still contains errors, the system creates a new record in the Order Line History Error file with the new error reason. You will need to correct the new error and reprocess the message again.

Note: When you press F7, the system reprocesses all order line history errors, not just the errors for your company.

How to display this screen: Enter WOHE in the Fast path field or select Work with Order Line History Errors from a menu.

CSR1445 DISPLAY Work with Order Line History Errors 10/11/06 11:31:51

Op Error Cmp Ext Sys Order# Shp Line Act Error reason

Date Date To# Seq# Typ

Type options, press Enter.

2=Change 4=Delete 5=Display 7=Reprocess

10/03/06 25 44/44/06 12149 1 1 I External System is invalid

10/03/06 25 9/19/06 12149 1 1 I Contact Date is invalid

10/03/06 25 9/19/06 12161 1 1 I In Transit not allowed -line n

F3=Exit F7=Reprocess All F11=Delete All F12=Cancel F21=Print list

Field	Description
Error date	The date the system placed the Order Line History In Message (CWORDLNHSTIN) in error. Enter a valid date to display order line history errors that match the date you entered. Numeric, 6 positions (MM/DD/YY format); optional.
Cmp (Company)	A code for the company where the order associated with the order line history record exists. This is the company code from the company_code tag in the Order Line History In Message (CWORDLNHSTIN). Enter a company code to display order line history errors that match your entry. Numeric, 3 positions; optional.
Ext sys date (External system date)	The date the Order Line History In Message (CWORDLNHSTIN) was processed in the external system. This is the date from the ext_sys_date tag in the Order Line History In Message (CWORDLNHSTIN). Enter a date to display order line history errors that match your entry. Numeric, 6 positions (MM/DD/YY format); optional.
Order #	The order number that contains the order line whose order line history you wish to update. This is the order number from the order_number tag in the Order Line History In Message (CWORDLNHSTIN). Enter an order number to display order line history errors that match your entry. Numeric, 8 positions; optional.
Shp to # (Ship to number)	The order ship to that contains the order line whose order line history you wish to update. This is the ship to number from the ship_to_number tag in the Order Line History In Message (CWORDLNHSTIN). Numeric, 3 positions; display-only.
Line seq # (Line sequence number)	The order line sequence number defined for the order line whose order line history you wish to update; this is the order_detail_nbr tag in the Pick Message from CWDirect (CWPickOut). This is the sequence number from the olh_odt_seq tag in the Order Line History In Message (CWORDLNHSTIN). Numeric, 5 positions; display-only.
Act typ (Activity type)	Indicates the type of activity performed against the order line. Enter a valid activity code to display order line history errors that match your entry. Order line activity codes are defined in and validated against the Working with Order Line Activity Codes (WOLA)menu option. You can pass any user-defined activity code in the CWORDLNHSTIN message. The only system-delivered activity codes CWDirect can receive in the message are: V = Delivered; the item on the order line has been delivered to the customer. When the system receives an Order Line History In message with an activity code of V, the system posts the delivery confirmation to the general ledger; see Posting Delivery Confirmation. I = In Transit; the item on the order line is in the process of being delivered to the customer. TBD displays next to order lines on the Order Inquiry Detail Screen that are in an In Transit status. Alphanumeric, 2 positions; optional.
Error reason	A description of the reason for the error. See Order Line History Interface Errors for a list of possible errors. Alphanumeric, 40 positions; display-only.

Field

Description

Error date

The date the system placed the Order Line History In Message (CWORDLNHSTIN) in error.

Enter a valid date to display order line history errors that match the date you entered.

Numeric, 6 positions (MM/DD/YY format); optional.

Cmp

(Company)

A code for the company where the order associated with the order line history record exists.

This is the company code from the company_code tag in the Order Line History In Message (CWORDLNHSTIN).

Enter a company code to display order line history errors that match your entry.

Numeric, 3 positions; optional.

Ext sys date

(External system date)

The date the Order Line History In Message (CWORDLNHSTIN) was processed in the external system.

This is the date from the ext_sys_date tag in the Order Line History In Message (CWORDLNHSTIN).

Enter a date to display order line history errors that match your entry.

Numeric, 6 positions (MM/DD/YY format); optional.

Order #

The order number that contains the order line whose order line history you wish to update.

This is the order number from the order_number tag in the Order Line History In Message (CWORDLNHSTIN).

Enter an order number to display order line history errors that match your entry.

Numeric, 8 positions; optional.

Shp to #

(Ship to number)

The order ship to that contains the order line whose order line history you wish to update.

This is the ship to number from the ship_to_number tag in the Order Line History In Message (CWORDLNHSTIN).

Numeric, 3 positions; display-only.

Line seq #

(Line sequence number)

The order line sequence number defined for the order line whose order line history you wish to update; this is the order_detail_nbr tag in the Pick Message from CWDirect (CWPickOut).

This is the sequence number from the olh_odt_seq tag in the Order Line History In Message (CWORDLNHSTIN).

Numeric, 5 positions; display-only.

Act typ

(Activity type)

Indicates the type of activity performed against the order line.

Enter a valid activity code to display order line history errors that match your entry.

Order line activity codes are defined in and validated against the Working with Order Line Activity Codes (WOLA)menu option.

You can pass any user-defined activity code in the CWORDLNHSTIN message. The only system-delivered activity codes CWDirect can receive in the message are:

V = Delivered; the item on the order line has been delivered to the customer. When the system receives an Order Line History In message with an activity code of V, the system posts the delivery confirmation to the general ledger; see Posting Delivery Confirmation.

I = In Transit; the item on the order line is in the process of being delivered to the customer. TBD displays next to order lines on the Order Inquiry Detail Screen that are in an In Transit status.

Alphanumeric, 2 positions; optional.

Error reason

A description of the reason for the error.

See Order Line History Interface Errors for a list of possible errors.

Alphanumeric, 40 positions; display-only.

Screen Option	Procedure
Correct an order line history error	Enter 2 next to an order line history error to advance to the Change Order Line History Errors Screen.
Delete an order line history error	Enter 4 next to an order line history error to delete it.
Review an order line history error	Enter 5 next to an order line history error to advance to the Display Order Line History Errors screen.
Reprocess an order line history error	Enter 7 next to an order line history error. • If the Order Line History In Message (CWORDLNHSTIN) no longer contains errors, the system creates an order line history record and displays the record on the Display Order Line History Screen. • If the Order Line History In Message (CWORDLNHSTIN) still contains errors, the system creates a new record in the Order Line History Error file with the new error reason. You will need to correct the new error and reprocess the message again.
Reprocess all order line history errors.	Press F7. • For each Order Line History In Message (CWORDLNHSTIN) that no longer contains errors, the system creates an order line history record and displays the record on the Display Order Line History Screen. • For each Order Line History In Message (CWORDLNHSTIN) that still contains errors, the system creates a new record in the Order Line History Error file with the new error reason. You will need to correct the new error and reprocess the message again. Note: The system reprocesses all order line history errors, not just the errors for your company.
Delete all order line history errors	Press F11. Note: The system deletes all order line history errors, not just the errors for your company.

Change Order Line History Errors Screen

Purpose: Use this screen to review and change the details of an order line history error.

Once you correct the error, you can enter 7 next to the order line history error to reprocess the record. If the record is no longer in error, the system removes the record from the Order Line History Error file and creates a record in the Order Line History file for the order line.

How to display this screen: Enter 2 next to an order line history error at the Work with Order Line History Errors Screen.

CSR1446 CHANGE Change Order Line History Errors 10/11/06 15:34:08

Error Date/Time . . : 10/11/06 14:57:41

Error Seq # . . . . : 1

Company . . . . . . . 25 EVOLUTIONARY NICHE CO

Order # . . . . . . . 12119

Ship To # . . . . . . 1

ODT Seq # . . . . . . 1

Item/Sku . . . . . . . FI2H FISH COOKIE JAR

Activity . . . . . . . V Delivered

Quantity . . . . . . . 1

Contact Date . . . . . 101206

Contact Time . . . . . 10:36:00

Delivery Provider . . HDL

External System Date . 100306

User . . . . . . . . . LWARREN

External Reference # . ABCDEFGHIJ0123456789

Error Reason . . . . : Order number (00012119) is invalid

F3=Exit F12=Cancel

Field	Description
Error date	The date the system placed the Order Line History In Message (CWORDLNHSTIN) in error. Numeric, 6 positions (MM/DD/YY format); display-only.
Error time	The time the system placed the Order Line History In Message (CWORDLNHSTIN) in error. Numeric, 6 positions (HH:MM:SS format); display-only.
Error seq #	A unique sequence number assigned to the order line history error record. Numeric, 9 positions; display-only.
Company	A code for the company where the order associated with the order line history record exists. This is the company code from the company_code tag in the Order Line History In Message (CWORDLNHSTIN). Numeric, 3 positions; required.
Order #	The order number that contains the order line whose order line history you wish to update. This is the order number from the order_number tag in the Order Line History In Message (CWORDLNHSTIN). Numeric, 8 positions; required.
Ship to #	The order ship to that contains the order line whose order line history you wish to update. This is the ship to number from the ship_to_number tag in the Order Line History In Message (CWORDLNHSTIN). Numeric, 3 positions; required.
ODT seq #	The order line sequence number defined for the order line whose order line history you wish to update; this is the order_detail_nbr tag in the Pick Message from CWDirect (CWPickOut). This is the sequence number from the olh_odt_seq tag in the Order Line History In Message (CWORDLNHSTIN). Numeric, 5 positions; required.
Item	A code for the item on the order line. This is the item number for the item_id tag in the Order Line History In Message (CWORDLNHSTIN). Alphanumeric, 12 positions; optional.
SKU	A code for the SKU of the item on the order line. This is the SKU code for the sku tag in the Order Line History In Message (CWORDLNHSTIN). Alphanumeric, 14 positions; optional.
Activity	Indicates the type of activity performed against the order line. This is the activity code for the activity_code tag in the Order Line History In Message (CWORDLNHSTIN). Order line activity codes are defined in and validated against the Working with Order Line Activity Codes (WOLA)menu option. You can pass any user-defined activity code in the CWORDLNHSTIN message. The only system-delivered activity codes CWDirect can receive in the message are: V = Delivered; the item on the order line has been delivered to the customer. When the system receives an Order Line History In message with an activity code of V, the system posts the delivery confirmation to the general ledger; see Posting Delivery Confirmation. I = In Transit; the item on the order line is in the process of being delivered to the customer. TBD displays next to order lines on the Order Inquiry Detail Screen that are in an In Transit status. Alphanumeric, 2 positions; required.
Quantity	The quantity of the item on the order line associated with the order line history record. This is the quantity for the quantity tag in the Order Line History In Message (CWORDLNHSTIN). Numeric, 5 positions; required.
Contact date	The date associated with the order line activity. This is the contact date for the contact_date tag in the Order Line History In Message (CWORDLNHSTIN). For example, if the activity_code is I (In Transit), the contact_date represents the date the item on the order line is scheduled to be delivered; if the activity_code is V (Delivered), the contact_date represents the date the item on the order line was delivered to the customer. Numeric, 6 positions (MMDDYY format); optional.
Contact time	The time the activity occurred, in HHMMSS format. This is the contact time for the contact_time tag in the Order Line History In Message (CWORDLNHSTIN). For example, if the activity_code is I (In Transit), the contact_time represents the time the item on the order line is scheduled to be delivered; if the activity_code is V (Delivered), the contact_time represents the time the item on the order line was delivered to the customer. Numeric, 6 positions (HHMMSS format); optional.
Delivery provider	Identifies the name of the delivery provider. For example, this represents the HDL (Home Delivery Service) provider. This is the delivery provider for the delivery_provider tag in the Order Line History In Message (CWORDLNHSTIN). Alphanumeric, 15 positions; optional.
External system date	The date the message was processed in the external system, in MMDDYYYY format. This is the date for the ext_sys_date tag in the Order Line History In Message (CWORDLNHSTIN). Numeric, 6 positions (MMDDYY format); optional.
User	Identifies the user who performed the activity against the item on the order line. User IDs are defined in and validated against the User file. If a user ID is not passed for the user tag in the Order Line History In Message (CWORDLNHSTIN), the system updates the user with the user ID who started the Order Line History (ORDLNHSTIN) job. Alphanumeric, 10 positions; optional.
External reference #	Represents an external reference number provided by the external system. This is the external reference number for the ext_ref_num tag in the Order Line History In Message (CWORDLNHSTIN). Alphanumeric, 20 positions; optional.
Error reason	A description of the reason for the error. Use this description to determine how to correct the error. See Order Line History Interface Errors for a list of possible errors. Alphanumeric, 40 positions; display-only.

Display Order Line History Errors Screen

To display: Enter 5 next to an order line history error at the Work with Order Line History Errors Screen to advance to the Display Order Line History Errors screen. You cannot change any fields on this screen; see Change Order Line History Errors Screen for field descriptions.

Working with Order Line Activity Codes (WOLA)

Contents

SCVs

Search

Glossary

Reports

Solutions

XML

Index

Order Transaction History In API

CS18_03 CWDirect 18.0.x 2018 OTN