1. Home
  2. /
  3. Panel Help
  4. /
  5. WMS Integration
  6. /
  7. Work with WMS transactions...

Work with WMS transactions (WMSD30001)

Related topics

This program displays the sent/received transactions from/to an external WMS system. All transactions sent/received are logged and the status denoting the stage of the transaction is displayed. Status 9 (completed) is automatically set when a transaction is sent/received and there are no errors. This transaction log holds timestamp information, and information about the keys to the related interface files as well as transaction specific keys which will aid in, e.g., further analysis to find errors. Detailed information about erroneous transactions can also be accessed.

Functionality is also available to re-process a transaction in error and also to cancel (close) a transaction in error, e.g. after manual update using the normal DC1 routines (Work with pickings, Work with pickings and Work with inventory).

Options

Timestamps Select this option to view the transaction log timestamp details.
Errors Only applicable for erroneous transactions (i.e. status = 7). Select this option to view the errors that have been created for the transaction.
Retry Only applicable for erroneous transactions (i.e. status = 7). Select this option to re-process a transaction in error. This option is not displayed in enquiry mode.
Cancel Only applicable for erroneous transactions (i.e. status = 7). Select this option to cancel (close) a transaction in error. This option is not displayed in enquiry mode.
Correct Only applicable for erroneous transactions (i.e. status = 7). Select this option to access Transaction in error mode in the Work with picking, Work with receptions or Work with inventory routine (depending on the transaction type) where you can manually correct the transaction, if applicable.

Function keys

Selection fields

Whs
This column lists the warehouse of the transaction.
Date
This column lists the date when the transaction was created.
Time
This column lists the time when the transaction was created.
D
This column lists the panel value code denoting the direction of the transaction (i.e. S for Send, R for Receive).
Type
This column lists the transaction type of the transaction.
Segment
This column lists the segment for the transaction type.
Main key
This column lists the segment/message type specific main key of the transaction.
S
This column lists the status of the transaction.

0 Created
7 Error
8 Cancelled (i.e. Manually close an erroneous transaction)
9 Completed
Transaction id
This column lists the transaction id of the transaction.
Seq
This column lists the sequence number of the transaction.
Main key
This column lists the segment/message type specific main key (full length) of the transaction.
External system name
This column lists the “name” of the external WMS system.
Message number
This column lists the message number of the transaction. Message number is a unique number attributed by the sending system.
Transaction number
This column lists the transaction number of the transaction. Transaction number is a unique number for the transaction segment attributed by the sending system.
External event
This column lists the external segment ID if this is a “Received” transaction.
Business partner
This column lists the business partner code on the transaction when relevant for the transaction type and segment.
Item
This column lists the item on the transaction when relevant for the transaction type and segment.
Pick list
This column lists the pick list number when relevant for the transaction type and segment.
Shipment
This column lists the shipment number when relevant for the transaction type and segment.
Pick consolidation
This column lists the pick consolidation number when relevant for the transaction type and segment.
Sales order
This column lists the sales order number when relevant for the transaction type and segment.
Sales order line
This column lists the sales order line number when relevant for the transaction type and segment.
Purchase order
This column lists the purchase order number when relevant for the transaction type and segment.
Purchase order line
This column lists the purchase order line number when relevant for the transaction type and segment.
Retry possible
This column is only applicable for erroneous transactions (status = 7) and denotes if you are allowed to re-process the transaction. If this column is set to YES for a transaction, click the Retry option.

Work with WMS transactions (WMSD30007)

Related topics

This panel displays the details of the selected transaction.

Warehouse
Displays the warehouse of the transaction.
Creation date
Displays the date when the transaction was created.
Creation time
Displays the time when the transaction was created.
Direction
Displays the panel value code denoting the direction of the transaction (i.e. S for Send, R for Receive).
Transaction id
Displays the transaction id of the transaction.
Sequence number
Displays the sequence number of the transaction.
Transaction type
Displays the transaction type and description of the transaction.
Segment
Displays the segment and description for the transaction type.
Main key
Displays the segment/message type specific main key of the transaction.
Key2
Only displayed if relevant for the transaction. Displays the segment/message type specific key2 of the transaction.
Key3
Only displayed if relevant for the transaction. Displays the segment/message type specific key3 of the transaction.
Trigger file
Only displayed for “Sent” transactions. Displays the trigger file that initiated the transaction.
Trigger event
Only displayed for “Sent” transactions. Displays the trigger event (operation) that initiated the transaction.

1 Insert
2 Delete
3 Update
Trigger date
Only displayed for “Sent” transactions. Displays the trigger date.
Trigger time
Only displayed for “Sent” transactions. Displays the trigger time.
Interface action
Displays *ADD, *CHANGE, or *DELETE for the sending transaction from DC1.

The following can also be displayed for a receiving transaction if the transaction is “IA” (Inventory adjustment): *ADJUST (Inventory adjustment +/-), *ADDSTS (Move stock to unusable, unsellable, or unavailable), *RMVSTS (Move from unusable, unsellable, unavailable to stock) *NORMTONCC (Move stock to NCC), *NCCTONORM (Move NCC qty to stock).

Status
Displays the status of the transaction.

0 Created
7 Error
8 Cancelled (i.e. Manually close an erroneous transaction)
9 Completed
Retry possibility
Denotes if a transaction in error is possible to re-process. If this field is set to YES you can click the Retry option from the initial panel.
Message number
Displays the message number of the transaction. Message number is a unique number attributed by the sending system.
Transaction number
Displays the transaction number of the transaction. Transaction number is a unique number for the transaction segment attributed by the sending system.

Work with WMS transactions, Timestamps (WMSD30008)

Related topics

This panel displays the timestamp information for the transaction.

Warehouse
Displays the warehouse of the transaction.
Transaction
Displays the transaction id of the transaction.
Direction
Displays the panel value code denoting the direction of the transaction (i.e. S for Send, R for Receive).
Sequence number
Displays the sequence number of the transaction.
Transaction type
Displays the DC1 transaction type and description.
Segment
Displays the DC1 segment ID for the transaction type.
Main key
Displays the segment/message type specific main key of the transaction.
E date
This column lists the date when the transaction was processed in DC1.
E time
This column lists the time when the transaction was processed in DC1.
WMS date
This column lists the date when the transaction was processed in the external WMS system.
WMS time
This column lists the time when the transaction was processed in the external WMS system.
Cnl date
If an erroneous transaction was cancelled (i.e. manually closed), this column lists the date when the erroneous transaction was cancelled.
Cnl time
If an erroneous transaction was cancelled (i.e. manually closed), this column lists the time when the erroneous transaction was cancelled.
Cnl user
If an erroneous transaction was cancelled, this column lists the user ID that cancelled the erroneous transaction.
S
Displays the status of the transaction.

0 Created
7 Error
8 Cancelled (i.e. Manually close an erroneous transaction)
9 Completed
Interface date
This column lists the date when the transaction was transferred to the interface files.
Interface time
This column lists the time when the transaction was transferred to the interface files
Confirm date
This column lists the date when the transaction was confirmed received in the external WMS system.
Confirm time
This column lists the time when the transaction was confirmed received in the external WMS system.

Work with WMS transactions, Retry (WMSD30011)

Related topics

This panel displays all erroneous transactions that you selected to re-process. Click OK to re-process.

Whs
This column lists the warehouse of the transaction.
Date
This column lists the date when the transaction was created.
Time
This column lists the time when the transaction was created.
D
This column lists the panel value code denoting the direction of the transaction (i.e. S for Send, R for Receive).
Trans id
This column lists the transaction id of the transaction.
Seq
This column lists the sequence number of the transaction.
Main key
This column lists the segment/message type specific main key of the transaction.

Work with WMS transactions, Cancel (WMSD30014)

Related topics

This panel displays all erroneous transactions that you selected to cancel (i.e. manually close). Click OK to cancel.

Whs
This column lists the warehouse of the transaction.
Date
This column lists the date when the transaction was created.
Time
This column lists the time when the transaction was created.
D
This column lists the panel value code denoting the direction of the transaction (i.e. S for Send, R for Receive).
Trans id
This column lists the transaction id of the transaction.
Seq
This column lists the sequence number of the transaction.
Main key
This column lists the segment/message type specific main key of the transaction.

Work with WMS transactions, More selections (WMSD30017)

Related topics

On this panel you can narrow down the transactions displayed on the initial Work with WMS transactions panel by making selections.

Function keys


Selection

  • Picking/Reception
  • Shipment
  • Pick consolidation
  • Sales order
  • Business partner
  • Item
  • Purchase order
  • External event