Chapter 9: 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, instead of using the Selecting Vendors for Drop Ship Processing (MDSP) menu option.

Note: You can use Process Drop Ship Orders by Batch to generate only drop ship pick slips; this menu option does not generate drop ship purchase orders. See Chapter 6: 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

Press F7 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 an open status and the order detail line that contains the drop ship item is in an open status. An order that is on hold or an order that is open but the order detail line that contains the drop ship item is on hold, will not be considered in the Update Available Picks batch program.

The Update Available Picks batch program:

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

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

• looks at the value defined in the Allow Only Single Line on Drop Ship Picks (C82) system control value to determine the number of picks that will generate 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 calculated number of available picks continues to display on the Process Drop Ship Orders by Batch Screen 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 Picks (C82) system control value controls whether drop ship picks are limited to printing one detail line (item) per pick slip. Based on the setting of this system control value, the program determines the number of picks that are available to generate for the vendor differently.

Allow Only Single Line on Drop Ship Picks (C82) system control value is set to N
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 set to Y
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

Press F9 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 all open order detail lines to determine if the item on the order line is a drop ship item.

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

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

• If the # of picks to release is 0 or blank, the program does not process drop ship picks for that vendor.

• If the # of picks to release is greater than 0, the program generates picks for that vendor, based on the Avail picks field for that vendor.

• 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 Authorization/Deposit Setup.

• 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 field is greater than the Avail picks field, the program uses the Avail picks to determine the total number of picks to generate.

• faxes the drop ship picks to the vendors if the Fax picks to vendors field is set to Y.

• 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 program name defined in the Drop Ship Pick Print Program (E92) system control value to print drop ship pick slips. If a program name has not been defined, the system uses the program name defined in the Pick Printing Program (C37) system control value. The standard pick printing program name is FLR0439.

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: The system produces the following reports during drop ship batch processing:

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

• Drop Ship Invoice/Pick Slip (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.)

Process Drop Ship Orders by Batch Screen

Purpose: This screen displays vendors that have open drop ship orders available for processing that have not yet shipped. 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 press F7 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.

FLR0960 DISPLAY Process Drop Ship Orders by Batch 1/18/00 13:51:08 PAT Company Fax Picks to Vendors . . . . . Y (Y/N) Last Update : 1/18/00 Vendor# Name Avail # Picks Batch Picks to Release Size 50010 ATLANTA DROP SHIP VENDOR 10 1 1 10 50012 BOSTON DROP SHIP VENDOR 12 1 1 12 50013 CHICAGO DROP SHIP VENDOR 13 1 1 13 50014 DENVER DROP SHIP VENDOR 14 1 1 14 50015 FORTKNOX DROP SHIP VENDOR 15 1 1 15 50016 HOUSTON DROP SHIP VENDOR 16 2 2 16 50018 MONTREAL DROP SHIP VENDOR 18 1 1 18 50019 PETERSBURG DROP SHIP VENDOR 19 1 1 19 50020 ROCHESTER DROP SHIP VENDOR 20 1 1 20 50022 SACRAMENTO DROP SHIP VENDOR 22 1 1 22 F3=Exit F7=Update Avail Picks F9=Submit F12=Cancel F24=Select Company

Field	Description
Fax picks to vendors	Indicates whether you wish to fax the drop ship pick slips you generate to the vendor using the Fast Fax interface. To fax a drop ship pick slip, you must have purchased the FAX Interface, and set up the FAX Interface System Control file values. See Installation Chapter 20: Setting Up FAX Interface Values. Additionally, you must enter the vendor's fax number in the Vendor file. Valid values: Y = Fax the drop ship picks to the vendor using the Fast Fax interface. The drop ship picks are faxed to the vendor when you submit the Generate Drop Ship Picks by Batch Program. N = Do not fax the drop ship picks to the vendor using the Fast Fax interface, however drop ship picks should be printed. The value defined in the FAX Available (B53) system control value defaults to this field. Alphanumeric, 1 position; required.
Last update	The date when the number of drop ship orders that are available for processing was last updated. This date represents the last time you submitted the Update Available Picks Batch Program. Numeric, 6 positions (MMDDYY format); display-only.
Vendor #	A unique number to identify a vendor that has drop ship orders available for processing. The system only displays vendors on this screen that have open drop ship orders and have the Drop ship pick field set to Y. Vendor codes are defined in and validated against the Vendor file; see Merchandising Chapter 19: 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. This field is 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 that you wish 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. The drop ship batch size determines the number of picks that print in one batch before the system creates a new batch. Example: Batch size = 2 # of picks to release = 5 In this situation, the system generates 3 batches: Batch 1 contains 2 picks Batch 2 contains 2 picks Batch 3 contains 1 pick An error message displays if you define a # of picks to generate and the batch size is blank:   Batch size is required.
	The batch size defined in the Drop ship batch size field for the vendor 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	Press F7 to submit the Update Available Picks Batch Program. A message displays indicating the batch program has been submitted:   Job 431745/UPD_#PCK submitted.
Submit a batch program to generate the drop ship picks, and optionally, fax the picks to the vendor	Press F9 to submit the Generate Drop Ship Picks by Batch Program. A message displays indicating the batch program has been submitted:   Job 431746/DROP_SHIP submitted.