Processing Drop Ship Orders by Batch (MDSB)

Overview: Use Process Drop Ship Orders by Batch to review the number of drop ship orders available for processing for each vendor and to limit the number of drop ship orders that are processed for each vendor. Process Drop Ship Orders by Batch provides an alternative method for generating drop ship picks in addition to the Selecting Vendors for Drop Ship Processing (MDSP) menu option.

Note: You can use Process Drop Ship Orders by Batch to generate drop ship pick slips only; this menu option does not generate drop ship purchase orders. See Selecting Vendors for Drop Ship Processing (MDSP) for information on generating drop ship purchase orders.

The Process Drop Ship Orders by Batch screen displays vendors and the number of drop ship picks that are available to generate for each vendor. At this screen, you can define how many picks you wish to print for a vendor and the batch size for the picks that you print.

To review the number of drop ship orders available for processing for each vendor, you must run the Update Available Picks Batch Program.

In this chapter:

• Update Available Picks Batch Program

• Generate Drop Ship Picks by Batch Program

• Process Drop Ship Orders by Batch Screen

Update Available Picks Batch Program

Select Update Avail Picks at the Process Drop Ship Orders by Batch Screen to submit a batch program that updates the number of available picks for drop ship pick generation.

The Update Available Picks batch program evaluates the number of open drop ship orders and updates the Avail picks field and the Last update field for the vendor.

Note: An open drop ship order is an order that is in open status and includes a drop ship order detail line in open status. An order that is on hold, or an order that is open but includes a drop ship order detail line that is on hold, is not included by the Update Available Picks batch program.

The Update Available Picks batch program:

• reviews each open order detail line to determine if the item on the line is a drop ship item.

• if the item is a drop ship item, identifies the vendor associated with the item.

• uses the Allow Only Single Line on Drop Ship Picks (C82) system control value to determine the number of picks eligible for generation for the vendor.

• updates the Avail picks field and the Last update field for the vendor, and displays the values on the Process Drop Ship Orders by Batch Screen.

• updates the # picks to release field with the value in the Avail picks field.

The Process Drop Ship Orders by Batch Screen continues to display the calculated number of available picks until you run the Update Available Picks batch program again, or you run the Generate Drop Ship Picks by Batch Program.

Example: The Allow Only Single Line on Drop Ship Pick (C82) system control value controls whether drop ship pick slips are limited to printing one detail line (item) per pick slip. The program uses this system control value to determine the number of picks that are available to generate for the vendor.

Allow Only Single Line on Drop Ship Pick (C82) system control value is unselected
More than 1 drop ship item on the order?	Each drop ship item on an order that is associated with the same vendor represents 1 pick for that vendor. Example: You order 3 drop ship items and they are all associated with vendor 2398. Results: 1 drop ship pick prints.
Different vendors for the drop ship items on the order?	Each drop ship item on an order that is associated with a different vendor represents 1 pick for each vendor. Example: You order 6 drop ship items: 3 of drop ship item 1 (vendor 2398), 2 of drop ship item 2 (vendor 2499), and 1 of drop ship item 3 (vendor 2501). Results: 1 pick prints for vendor 2398, 1 pick prints for vendor 2499, and 1 pick prints for vendor 2501.
Different ship to customers for the drop ship items on the order?	Each drop ship item on the order that is shipping to a different ship-to customer represents a separate pick for each vendor. Example: You order 6 drop ship items for ship-to customer 1: 3 of drop ship item 1 (vendor 2398), 2 of drop ship item 2 (vendor 2499), and 1 of drop ship item 3 (vendor 2501) and you also order 3 drop ship items for ship-to customer 2: 2 of drop ship item 1 (vendor 2398) and 1 of drop ship item 2 (vendor 2499). Results: 2 picks print for vendor 2398, 2 picks print for vendor 2499, and 1 pick prints for vendor 2501.

Allow Only Single Line on Drop Ship Picks (C82) system control value is selected
More than 1 drop ship item on the order?	Each drop ship item on an order that is associated with the same vendor represents a separate pick for that vendor. Example: You order 3 drop ship items and they are all associated with vendor 2398. Results: 3 drop ship picks print.
Different vendors for the drop ship items on the order?	Each drop ship item on an order that is associated with a different vendor represents 1 pick for each vendor. Example: You order 6 drop ship items: 3 of drop ship item 1 (vendor 2398), 2 of drop ship item 2 (vendor 2499), and 1 of drop ship item 3 (vendor 2501). Results: 3 picks print for vendor 2398, 2 picks print for vendor 2499, and 1 pick prints for vendor 2501.
Different ship to customers for the drop ship items on the order?	Each drop ship item on the order that is shipping to a different ship to customer represents a separate pick for each vendor. Example: You order 6 drop ship items for ship to customer 1: 3 of drop ship item 1 (vendor 2398), 2 of drop ship item 2 (vendor 2499), and 1 of drop ship item 3 (vendor 2501) and you also order 3 drop ship items for ship to customer 2: 2 of drop ship item 1 (vendor 2398) and 1 of drop ship item 2 (vendor 2499). Results: 5 picks print for vendor 2398, 3 picks print for vendor 2499, and 1 pick prints for vendor 2501.

Generate Drop Ship Picks by Batch Program

Select Submit at the Process Drop Ship Orders by Batch Screen to submit a batch program that generates drop ship picks based on the number of picks to release and the batch size you defined for each vendor.

The Generate Drop Ship Picks by Batch program:

• reviews each open order detail line to determine if the item on the order line is a drop ship item.

• if the item is a drop ship item, identifies the vendor associated with the item.

• uses the # picks to release field for each vendor to determine how many picks to generate.

• processes credit card authorizations on the drop ship orders, if needed. Any orders that are declined for authorization are not used in the batch size calculation, and picks are not generated for the orders; see Using the Credit Card Authorization Interface.

• creates a batch of picks based on the Batch size and the # picks to release fields defined for the vendor. If the # picks to release is greater than the Avail picks, the program uses the Avail picks to determine the total number of picks to generate.

• runs the Update Available Picks Batch Program to refresh the Process Drop Ship Orders by Batch Screen with updated available drop ship pick information. If all picks are generated, the screen will be blank.

Print program: The system uses the Drop Ship Pick Print Program (E92). If this system control value is blank, the system uses the Pick Printing Program (C37). If the Create Generic Pick Download Triggers (I31) system control value is selected, the system also generates the Pick Message from Order Management System (CWPickOut).

Example:

Vendor	Available Picks	# Picks to Release	Batch Size	Drop Ship Batches Generated
2398	98	20	5	4 drop ship batches are generated containing 5 picks each.
2499	24	28	5	5 drop ship batches are generated: 4 batches containing 5 picks each, and 1 batch containing 4 picks.
2501	9	blank	5	No picks are generated since the # of picks to release is 0.
2603	25	10	15	1 drop ship batch is generated containing 10 picks.

Reports generated:

• Vendor Drop Ship Worksheet (Produced whenever you run drop ship processing.)

• Drop Ship Pick Slip/Invoice (Always produced for drop ship pick slips.)

• Declined Drop Ships (Produced whenever you run drop ship processing.)

• Credit Card Authorization Listing (Produced for drop ship orders requiring credit card authorization.)

• Address Verification Response List (Produced for drop ship orders requiring credit card authorization and AVS verification.)

Bypassing printable pick slips not available: Even if the Bypass Creation of Pick Forms during WSPS Pick Generation (K55) system control value is selected, the Process Drop Ship Orders by Batch option still creates printable pick slips for eligible vendors. This system control value controls the generation of printable pick slips only when you use the Streamlined Pick Slip Generation (WSPS) option.

Process Drop Ship Orders by Batch Screen

Purpose: This screen displays vendors that have open, unshipped drop ship orders available for processing. At this screen, you can define the batch size of the picks processed for each vendor and the number of drop ship orders you would like to release for processing.

Note: No information displays when you first advance to the Process Drop Ship Orders by Batch screen. To display vendors that have drop ship orders that are available for processing, you must select Update Avail Picks to run the Update Available Picks Batch Program.

How to display this screen: Enter MDSB in the Fast path field at the top of any menu or select Drop Ship Orders by Batch from a menu.

Field	Description
Fax picks to vendors	Indicates whether to fax the drop ship pick slips. This option is not currently implemented.
Last update	The last date when you submitted the Update Available Picks Batch Program. Numeric, 6 positions (in user date format); display-only.
Vendor #	A unique number to identify a vendor that has drop ship orders available for processing. The system displays vendors on this screen only if they have open drop ship orders and have the Drop ship pick field selected. Vendor codes are defined in and validated against the Vendor table; see Working with Vendors (WVEN). Numeric, 7 positions; optional.
Name	The name of the vendor that has open drop ship orders. Alphanumeric, 30 positions; optional.
Avail picks	The number of available drop ship picks that can be generated for the vendor. Calculated when you submit the Update Available Picks Batch Program. The system clears this field when you submit the Generate Drop Ship Picks by Batch Program. Numeric, 9 positions; display-only.
# picks to release	The number of available picks to release for drop ship pick batch generation. Leave this field blank if you do not wish to generate drop ship picks for the vendor. Numeric, 9 positions; optional.
Batch size	The number of picks to include in a drop ship batch for a specified vendor before creating a new batch. Example: Batch size = 2 # of picks to release = 5 In this situation, the system generates 3 batches: Batch 1 has 2 picks Batch 2 has 2 picks Batch 3 has 1 pick
	The vendor’s Drop ship batch size defaults, but you can override it. If you override the batch size on this screen, the system does not update the Drop ship batch size field for the vendor. Numeric, 7 positions; required.

Screen Option	Procedure
Submit a batch program to update the number of available picks	Select Update Avail Picks to submit the Update Available Picks Batch Program. A message indicates that the batch program has been submitted: Job 431745/UPD_#PCK submitted.
Submit a batch program to generate the drop ship picks	Select Submit to submit the Generate Drop Ship Picks by Batch Program. A message indicates that the batch program has been submitted: Job 431746/DROP_SHIP submitted.