Creating and Maintaining Warehouses (WWHS)

Purpose: You can use the Work with Warehouses function to create, change, delete, or display warehouse information. A warehouse is required for each physical and logical warehouse in which you track inventory.

A logical warehouse can be:

• a section of a physical warehouse that is treated as if it were a separate warehouse. For example, if you have inventory in one building that is both a retail store and a mail order fulfillment center, you can establish this building as two separate warehouses to track retail and mail order inventory separately. Or, you might have areas in the warehouse where defective merchandise and merchandise that will be returned to the vendor is stored.

• a means to track inventory that is not kept in a warehouse; for example, you can map a logical warehouse to a retail outlet, or to represent stock that is in transit between warehouses.

Note: Inventory reservation takes place at the warehouse level. Maintain separate warehouses for defective merchandise and merchandise that you are returning to the vendor, so that these quantities are not included in inventory reservation.

Additionally, you can use this function to:

• create and maintain retail store information for a warehouse that represents a retail store.

• use Working with Warehouse Lists (WWHL) to create, change, delete, or display the sequence in which warehouses will be selected to fulfill orders if you ship merchandise from more than one warehouse.

• use the Work with Item Warehouse Screen to create, change, delete, or display item warehouse assignments.

In this topic:

Work with Warehouses Screen

Create Warehouse Screen

Create Store Screen

Change Warehouse Screen

Display Warehouse Screen

Work with Warehouse/Entity Screen

Create Warehouse/Entity Screen

Change Warehouse/Entity Screen

Display Warehouse/Entity Screen

Work with Warehouse Devices Screen

Create Warehouse Device Window

Change Warehouse Device Window

Work with Warehouses Screen

How to display this screen: Enter WWHS in the Fast Path field at the top of any menu, or select Work with Warehouses from a menu.

INR0286 DISPLAY Work with Warehouses 9/16/03 11:33:10

EZK Mail Order

Opt Whs Name Str Alloc O/E Telephone #

Type options, press Enter.

2=Change 4=Delete 5=Display 18=Whs/Ent 19=Devices 23=Items 98=User Field

2 MAIN WAREHOUSE N Y Y (617) 551-0650

3 DEFECTIVE WAREHOUSE N N Y

4 RETURN TO VENDOR N N N

5 OUTLET STORE WAREHOUSE Y N N

6 STAGING WAREHOUSE N N N

7 PISCATAWAY WAREHOUSE N N N

8 NATICK WAREHOUSE Y N Y

10 TORONTO WAREHOUSE N N N

F3=Exit F6=Create F12=Cancel F15=W/W Warehouse List F21=Print List

F24=Select company

Field

Description

Whs (Warehouse)

A number that identifies the warehouse.

Numeric, 3 positions; optional.

Name

The name of the warehouse.

Alphanumeric, 30 positions; optional.

Str (Retail outlet)

This field indicates whether the warehouse represents a retail store rather than a true warehouse.

Valid values are:

Y = The warehouse represents a retail store.

N = The warehouse does not represent a retail store.

Alphanumeric, 1 position; optional.

Alloc (Allocatable)

This field indicates whether you can reserve inventory from the warehouse.

Valid values:

Y = the warehouse is allocatable.

N = the warehouse is not allocatable.

If a warehouse is not flagged as allocatable, its on-hand quantity is not included in the availability calculation for items.

Alphanumeric, 1 position; optional.

O/E (Order entry)

This field indicates whether inventory availability can be viewed in Order Entry.

Y = inventory availability displays in Order Entry.

N = inventory availability does not display in Order Entry.

Alphanumeric, 1 position; optional.

Telephone #

The telephone number at the warehouse.

Numeric, 14 positions; display-only.

Screen Option

Procedure

Create a new warehouse

Press F6 to advance to the Create Warehouse Screen.

Change warehouse information

Enter 2 next to a warehouse to advance to the Change Warehouse Screen.

Delete a warehouse

Enter 4 next to a warehouse to delete it.

Display warehouse information

Enter 5 next to a warehouse to advance to the Display Warehouse Screen.

Work with warehouse/entity

Enter 18 next to a warehouse to advance to the Work with Warehouse/Entity Screen.

Work with warehouse device

Enter 19 next to a warehouse to advance to the Work with Warehouse Devices Screen.

Work with item warehouse

Enter 23 next to a warehouse to advance to the Work with Item Warehouse Screen.

Work with user defined fields

Enter 98 next to a warehouse to advance to the Work with User Fields Screen.

Work with warehouse lists

Press F15 to a warehouse to advance to the Work with Warehouse Lists Screen.

Create Warehouse Screen

To create: At the Work with Warehouses Screen, press F6.

INR0284 ENTER Create Warehouse 8/03/04 13:25:31

EZK Mail Order

Warehouse . . . . . . . . .

Name . . . . . . . . . . .

Address . . . . . . . . . .

City . . . . . . . . . . .

State/Zip/Country . . . . .

Drop point . . . . . . . .

Manager . . . . . . . . . .

Telephone#/Fax# . . . . . . /

Allocatable flag . . . . . (Y,N) Viewable in O/E . . . . (Y,N)

Receive restock transfers . (Y,N) Auto restock location .

Inventory Value G/L # . . . Retail outlet . . . . . N (Y,N)

Value Inv At Retail . . . . (Y,N) Retail type . . . . . .

Sharing warehouse . . . . . (Y,N) Shared cmp/whs . . . .

Division . . . . . . . . .

F3=Exit F12=Cancel

Field

Description

Warehouse

A code to identify the warehouse.

Numeric, 3 positions.

Create screen: required.

Change screen: display-only.

Name

The name of the warehouse.

Alphanumeric, 30 positions; required.

Address

The address of the warehouse.

Alphanumeric; three lines, 31 positions each; optional.

City

The city where the warehouse is located.

Alphanumeric, 25 positions; required.

State

The code representing the state or province where the warehouse is located. See Customer Service Setting Up the Country File (WCTY).

The system validates that the state you enter is assigned to the SCF in the first three positions of the postal code.

Alphanumeric, 2 positions; optional.

Zip code

The zip code or postal code where the warehouse is located. See Customer Service Setting Up the Postal Code File (WZIP).

Alphanumeric, 25 positions; optional.

Country

The country where the warehouse is located. Country codes are validated against the Country Code file. See Customer Service Setting Up the Country File (WCTY).

Alphanumeric, 3 positions; optional.

Drop point

The shipping point associated with the warehouse, or carrier pick-up point. The drop point is used in determining the correct destination UPS zone for a shipment in relation to the warehouse or carrier pick-up point from which it is shipped, and ultimately the shipping charge for the order. The code is validated against the Drop Point file.

Example: If you have a warehouse in Boston and a warehouse in Chicago, the UPS zone assignments will be different for each warehouse. If you ship an order from Boston to Los Angeles, Los Angeles is zone 8 in relation to Boston. If you ship an order from Chicago to Los Angeles, Los Angeles is Zone 4 in relation to Chicago. By assigning different drop points to each warehouse, you can establish the correct UPS zones for each warehouse and have the correct meter charges calculated.

The drop point also represents a carrier pick-up point when zone skipping is used. In zone skipping, orders are shipped from your warehouse to a UPS pick-up point by another carrier. The UPS zone to which the orders are shipped and the meter charges are determined in relation to the carrier pick-up point, and not your warehouse.

 

Example: If your warehouse is located in Boston, you may ship your west coast orders via common carrier to a UPS pick-up point in Chicago, and then ship the orders via UPS from Chicago to their final destination. The UPS zone and the meter charges must be based upon the zone assignments for Chicago even though your warehouse is actually located in Boston.

Note: If you are using the Freight by order weight freight method, the drop point defined for the warehouse must match the drop point defined for the SCF/Ship Via on the order. See Fulfillment Working with Weight Tables for Order Weight (WFTB).

The drop point field is required even if you have only one warehouse and are not using zone skipping.

Numeric, 3 positions; required.

Manager

The name of the warehouse manager.

Alphanumeric, 30 positions; optional.

Telephone #

The telephone number of the warehouse. You can define a telephone number format to map to the phone numbers you enter into the system. The system defaults the telephone number formats for the country defined in the Default Country for Customer Address (B17) system control value for any phone number entered on this screen. See Customer Service Setting Up the Country File (WCTY).

Numeric, 11 positions; optional.

Fax #

The fax number of the warehouse. See the Telephone number field description above for information on telephone number formats.

Numeric, 11 positions; optional.

Allocatable flag

The allocatable flag indicates whether merchandise in the warehouse can be reserved to fulfill consumer orders.

Valid values are:

Y = merchandise in this warehouse can be reserved to fulfill orders. The inventory reservation program considers inventory quantities in the warehouse when evaluating whether merchandise is available for shipment.

N = merchandise in the warehouse will not be used to fulfill orders. Examples of non-allocatable warehouses include non-saleable and defective item warehouses. If a warehouse is not flagged as allocatable, its on-hand quantity is not included in the availability calculation for items.

This field also controls whether the system displays item availability for the warehouse on the Display Item Availability Screen (Reviewing Item Availability).

Alphanumeric, 1 position; required.

Viewable in O/E (Viewable in Order Entry)

This flag indicates whether inventory availability for the warehouse can be viewed in Order Entry. When you view item availability in Order Entry, a list of all viewable warehouses and the item quantity available in each warehouse displays.

Valid values are:

Y = inventory quantities in this warehouse can be viewed in Order Entry.

N = inventory quantities in this warehouse cannot be viewed in Order Entry.

Alphanumeric, 1 position; required.

Receive restock transfers

A flag indicating whether the warehouse replenishment request will remain on the system after the transfer has been confirmed when using Replenish Warehouses. You use this function to create a request containing the items and quantities that should be replenished to the store or warehouse. When the shipment is confirmed, you must transfer the merchandise to the Auto restock location in the 'To' warehouse.

Note: The system uses this field to determine whether to retain replenishment requests you create using the standard process, where the system evaluates the 'To' warehouse's replenishment needs and the 'From' warehouse's available stock. The same is not true of outlet transfers, in which the system creates the request based on a work file containing purchase orders from outlet warehouses.

Valid values are:

Y = the replenishment request remains on the system when the restock shipment is confirmed. This allows the receiving warehouse to use the replenishment request to process inventory transactions transferring merchandise from the Auto restock location to the warehouse locations where the items are stored. The request is deleted from the system when the merchandise is moved from the Auto restock location.

Note: For outlet transfers, the system puts each item within the request in a C status if this field is set to Y.

 

N = the replenishment request is deleted from the system as soon as the restock shipment is confirmed (when the merchandise has been shipped to the receiving warehouse). The receiving warehouse must use the Inventory Transactions module to transfer the merchandise from the Auto restock location to the warehouse locations where the items are stored.

Note: For outlet transfers, the system puts each item within the request in a X status if this field is set to N.

Alphanumeric, 1 position; required.

Auto restock location

A location in the receiving warehouse where transferred stock is placed when it is transferred using the standard replenish warehouses process or the retail store restock process.

Replenishing Warehouses

The system does not use this location when you replenish warehouses using the outlet transfer process; instead, it uses the default outlet transfer (OT) location you define using Working with Default Warehouse Locations (WWDL).

See Replenish Warehouses for more information on working with warehouse replenishment, and see Retail Stores for more information on working with retail store restock.

Retail Store Restock

The system uses this location as the destination for a retail store restock transfer as long as there is no In-transit warehouse and In-transit location specified at the Create Store Screen screen. If both this field and the in-transit fields are blank, the system does not perform a transfer transaction; instead, it performs an issue (I), as it does for a standard order shipment. See Understanding Store Restock for an overview.

Alphanumeric, 7 positions; optional.

Inventory value G/L #

The general ledger account number for posting changes to inventory valuation resulting from purchase order receipts and order shipments. The system uses this value if there is no Inv G/L # (Inventory general ledger account number) defined in the Item file.

If you do not have authority to the Secure G/L Number Field Access (A84) secured feature, the system displays this field as display-only.

Numeric, 8 positions; optional.

Retail outlet

This field indicates whether the warehouse represents a retail store rather than a true warehouse.

Valid values are:

Y = The warehouse represents a retail store.

N = The warehouse does not represent a retail store.

When creating a warehouse, you advance to the Create Store Screen if you set this field to Y and the Use Retail Store File (G15) system control value is set to Y.

Alphanumeric, 1 position; required.

Value inv at retail (value inventory at current retail price)

This field indicates whether the system includes the inventory allocated to this warehouse in retail price change processing.

Valid values are:

Y = The inventory allocated to this warehouse is included in retail price change processing. The system includes the inventory for this warehouse in the on hand quantity defined for a retail price change history detail record.

N = The inventory allocated to this warehouse is not included in retail price change processing. The system does not include the inventory for this warehouse in the on hand quantity defined for a retail price change history detail record.

Retail price change processing allows you to track retail prices at your retail store and keep a history of the price changes in CWDirect. The price defined for an item/SKU in CWDirect matches the most recent price of the item/SKU in your retail store; if the prices do not match, the system tracks the difference in price in Reviewing Retail Price Change History. You can also apply retail price changes to open order lines that contain items associated with a price change. To use retail price change processing, enter Y in the Use Retail Price Change Processing (H29) system control value.

 

An error message displays if you enter N or leave this field blank, the Allocatable field for the warehouse is set to Y and the Use Retail Price Change Processing (H29) system control value is set to Y: Value Inv at Retail must be ’Y’ when SCV H29 (Use Retail Price Change Processing) is ’Y’.

An error message displays when you try to submit the Retail Price Change Update Process and an allocatable warehouse has this field set to N or blank: All allocatable warehouses must be set to ’Value Inv at Retail-’Y’’.

This field only displays if the Use Retail Price Change Processing (H29) system control value is set to Y.

Alphanumeric, 1 position; optional.

Retail type

This field indicates whether the warehouse represents a retail outlet or home delivery service.

Valid values:

H = HDL Home Delivery service; this warehouse represents a delivery service provider that provides "white glove" home delivery service. Instead of shipping products directly to the customer, the system sends the products to the HDL, who in turn, delivers the products to the customer. For example, you may wish to use a home delivery service for large items, such as furniture or appliances, that require someone to carry and set up the item in the customer’s home or business. See HDL (Home Delivery Service) Processing.

M = Main retail outlet; this warehouse represents a main retail outlet that is available to fulfill backorders through the Retail Fulfillment process.

S = Satellite retail outlet; this warehouse represents a satellite retail outlet that is available to fulfill backorders through the Retail Fulfillment process.

Set this field to S if the warehouse represents a retail outlet for retail fulfillment.The Retail Fulfillment process allows you to place a backordered item on hold while you are determining whether it is available for shipment from a retail outlet. Once you are notified that the retail outlet has shipped the item, you cancel the order line. See Fulfillment Retail Fulfillment Overview for more information on the retail fulfillment process, including setup options.

Alphanumeric, 1 position; optional.

The Sharing warehouse and Shared company/warehouse fields appear only if the Inventory Sharing (A69) system control value is set to Y.

Sharing warehouse

This field indicates whether the warehouse serves as a sharing warehouse for orders you take in another company. Valid values are:

Y = This warehouse provides inventory to fulfill orders you take in another company.

N or blank (default) = This is not a sharing warehouse.

Alphanumeric, 1 position; optional.

Shared cmp/whs (Shared company and warehouse)

These fields indicate whether to reserve and fulfill orders from a different warehouse in a different company.

Company

The company where the sharing warehouse (the warehouse that provides the inventory) is located. Company codes are defined in and validated against the Company file; see Installation Setting Up Companies (WCMP).

Numeric, 3 positions; optional.

Warehouse

The warehouse in the company, specified in the Company field, that is providing the inventory to fulfill orders against the current company and warehouse.

Numeric, 3 positions; optional.

Division

The division to use for posting changes to inventory valuation and accounts payable activity to the General Ledger Interface file, overriding the division that you specify at other fields and screens. The division is displayed as the Div (Division) at the Work with General Ledger Interface Screen.

 

Applies to What Postings?

If you specify a division here, the system always uses this division for general ledger postings:

• for any inventory transaction that affects this warehouse. This division overrides the Default Division for Inventory Transactions (C17) system control value.

• for A/P purchases that affect this warehouse. The warehouse division overrides the division you enter at the Enter A/P Invoices Screen (When Using Batching) or Enter A/P Invoices Screen (When Not Using Batching).

• for A/P disbursements that affect this warehouse. The warehouse division overrides the division specified at the Enter Bank/Division window in Work with A/P Checks (WCHK) or at the Enter Division and Bank Screen in Print A/P Checks (PCHK).

• for any of the general ledger postings listed above when you run the Resetting the General Ledger Interface File (RGLI) menu option. The warehouse division overrides the division you enter at the Reset General Ledger Interface Screen.

 

A/P Postings Use the A/P Transaction File

The division used for A/P postings is derived from the A/P Transaction file (APTRAN). The system creates an A/P Transaction record when you receive a purchase order if the Use Purchase Order/Drop Ship Matching (D21) system control value is set to Y.

 

Division not Used for A/P Postings When

The system does not use the warehouse division for A/P postings if:

• you assign it to the warehouse after receiving a purchase order (when the A/P Transaction record has already been created).

• you enter an unmatched invoice

• you enter an invoice for a drop shipment

 

If the Division for a Warehouse is Blank

If you leave the division blank for a warehouse, the system continues to use the division from the Default Division for Inventory Transactions (C17) system control value or that you enter at any of the screens listed above.

The division code is defined in and validated against the Division file; see Working with Divisions (WDIV).

Numeric, 3 positions; optional.

Note: If the Retail outlet field is set to Y and the Use Retail Store File (G15) system control value is set to Y, you advance to the Create Store Screen automatically when you create a warehouse.

Create Store Screen

Purpose: Use this screen or the Change Store screen to enter additional information for a warehouse that represents a retail store. The system uses the retail store information to create promotions for the retail store and create orders to restock the retail store. See Retail Stores.

How to display this screen: You advance to this screen automatically after completing the Create Warehouse Screen if:

• the Retail outlet field on the Create Warehouse Screen is set to Y, and

• the Use Retail Store File (G15) system control value is set to Y.

INR1427 ENTER Create Store 8/06/04 12:51:45

EZK Mail Order

Store ID : 14 RETAIL OUTLET

Region . . Rank . . . Std Commission N

District . Truck route Wty Commission N

Telephone #2 Rtl Group . Date Opened .

Modem #1 . Payroll Grp Date Closed .

Modem #2 . Fax Reports N Date Relocated

Speed Dial Rpt Activity Reloc From .

Status . . Sequence # Reloc To . .

Replenishment

Customer # Ship Via . Source . . .

Pay Type . From Whse . Replen Day .

Pick Day . Del Day . . Frequency . .

Type . . . Active . : N Store Distb .

In-Trans Whs In-Trans Loc

Store Sales

Customer # Ship Via . Source . . .

User fields

F3=Exit F12=Cancel

Field

Description

Store ID

The code and name of the retail store. This is the code and description of the warehouse that represents the retail store.

Store code: Numeric, 3 positions; display-only.

Store description: Alphanumeric, 30 positions; display-only.

Region

The region where the retail store is located, such as New England.

Store regions are defined in and validated against the Store Region file. See Working with Store Regions (WSRG).

Alphanumeric, 5 positions; optional.

Rank

The rank of the retail store, such as outlet.

Store ranks are defined in and validated against the Store Rank file. See Working with Store Ranks (WSTR).

Alphanumeric, 1 position; optional.

Std commission

An informational field that defines whether the retail store uses standard commission.

Valid values are:

Y = This retail store uses standard commission.

N (Default) = This retail store does not use standard commission.

Alphanumeric, 1 position; required.

District

An informational field that represents the district where the store is located.

Alphanumeric, 5 positions; optional.

Truck route

An informational field that represents the truck route defined for the store.

Numeric, 3 positions; optional.

Wty commission (Warranty commission)

An informational field that defines whether the retail store uses warranty commission.

Valid values are:

Y = This retail store uses warranty commission.

N (Default) = This retail store does not use warranty commission.

Alphanumeric, 1 position; required.

Telephone #2

A second telephone number defined for the retail store. The first telephone number for the store is located on the Create Warehouse Screen.

You can define a telephone number format to map to the phone numbers you enter into the system. See Customer Service Setting Up the Country File (WCTY).

Alphanumeric, 14 positions; optional.

Rtl group (Retail group)

An informational field that represents the retail group defined for the store. You can use the retail group to group similar stores together for custom reporting.

Numeric, 3 positions; optional.

Date opened

An informational field that represents the date the retail store was opened.

Numeric, 6 positions (MMDDYY format); optional.

Modem #1

A modem telephone number for the retail store.

You can define a telephone number format to map to the phone numbers you enter into the system. See Customer Service Setting Up the Country File (WCTY).

Alphanumeric, 14 positions; optional.

Payroll grp (Payroll group)

An informational field that represents the payroll group defined for the retail store. You can use the payroll group to generate payroll listings.

If you upload retail orders using the RA DOS interface, the system uses the payroll group to represent the salesman number for the order.

Numeric, 3 positions; optional.

Date closed

An informational field that represents the date the store was closed.

Numeric, 6 positions (MMDDYY format); optional.

Modem #2

A second modem telephone number for the retail store.

You can define a telephone number format to map to the phone numbers you enter into the system. See Customer Service Setting Up the Country File (WCTY).

Alphanumeric, 14 positions; optional.

Fax reports

This field indicates whether you wish to use the Fastfax interface to send faxes to the retail store.

Valid values are:

Y = Use the Fastfax interface to send faxes to the retail store.

N (default) = Do not use the Fastfax interface to send faxes to the retail store.

See Installation Setting Up FAX Interface Values.

Alphanumeric, 1 position; required.

Date relocated

An informational field that defines the date the store moved to a new location.

Numeric, 6 positions (MMDDYY format); optional.

Speed dial

An informational field that represents the speed dial number for the retail store.

Numeric, 5 positions; optional.

Rpt activity (Report activity code)

An informational code that identifies whether the retail store is included in retail store restock. You can use this information to produce custom reports.

Valid values are:

I = Include this store in retail store restock.

E = Exclude this store from retail store restock.

See Working with Retail Store Restock (WRSR).

Alphanumeric, 1 position; optional.

Reloc from (Store relocated from)

An informational field that defines the location of the store before the store relocated.

Alphanumeric, 10 positions; optional.

Status

This field indicates whether the store is active, for example the store is open for business, or inactive.

Valid values are:

A = The store is active. The store is included when you press F7 at the Select Stores Screen in Working with Retail Store Restock (WRSR).

I or blank = The store is inactive. The store is not included when you press F7 at the Select Stores Screen in Working with Retail Store Restock (WRSR), but you can select it individually.

Alphanumeric, 1 position; optional.

Sequence # (Store sort sequence number)

An informational field that is used to sort records on user-defined reports.

Numeric, 3 positions; optional.

Reloc to (Store relocated to)

An informational field that defines the location where the store relocated.

Alphanumeric, 10 positions; optional.

The following fields are used in retail store restock. See Understanding Store Restock for an overview, and Working with Retail Store Restock (WRSR) for instructions on generating store restock orders.

Customer # (Store restock customer number)

The sold-to customer that represents a retail store.

The system uses this customer number as the sold-to customer for retail store restock orders.

The system displays an error message such as the following if you enter a customer number that does not have this warehouse/store number defined in the Warehouse field for the customer:

Warehouse/Store not assigned for Customer 26.

For this reason, you need to:

1. create the warehouse that represents the retail store

2. create or modify the customer to use on store restock orders, assigning this warehouse number

3. use the Change Store screen to specify the customer number

Sold to customer numbers are defined in and validated against the Customer file. See Creating and Updating Sold-to Customers (WCST).

Numeric, 9 positions; optional.

Ship via

The ship via code for the system to use on retail store restock orders.

The system assigns this ship via code to the order header on a store restock order.

Ship via codes are defined in and validated against the Ship Via file. See Fulfillment Working with Ship Via Codes (WVIA).

Numeric, 2 positions; optional.

Source

The source code for the system to use on retail store restock orders. Typically, you create a separate source code for these orders, using a different pricing method than on source codes you use for customer orders.

Source codes are defined in and validated against the Source Code file. See Marketing Working with Source Codes (WSRC).

Alphanumeric, 9 positions; optional.

Pay type

The pay type code for the system to use on retail store restock orders. Typically, you create a new cash pay type that has a very high Order $limit in order to prevent retail store restock orders from going on hold, and to create separate postings to the General Ledger Interface file.

Pay type codes are defined in and validated against the Pay Type file. See Accounts Payable Working with Pay Types (WPAY).

Numeric, 2 positions; optional.

From whse (Restock from warehouse)

The warehouse where the system reserves inventory to restock this retail store.

The system displays an error message if you enter the warehouse code that is the same as the retail store: Store Restock From Warehouse can not be same as Store #.

Numeric, 3 positions; required.

Replen day (Restock day)

An informational field that represents the day this retail store should be restocked.

Valid values are 1-14.

Numeric, 2 positions; optional.

Pick day

An informational field that represents the day inventory used to restock this store should be picked.

Valid values are 1-14.

Numeric, 2 positions; optional.

Del day (Delivery day)

An informational field that represents the day the inventory used to restock this retail store is expected to be delivered.

Valid values are 1-14.

Numeric, 2 positions; optional.

Frequency (Restock frequency)

An informational field that represents how often this store is restocked.

Valid values are:

B = This retail store is restocked biweekly.

W = This retail store is restocked weekly.

Alphanumeric, 1 position; optional.

Type (Restock type)

This value determines which items in the store are in need of restock when you perform a store restock.

Valid values are:

A = Out of stock items only. The system restocks items whose on hand quantity equals zero only.

F = Full restock to highest maximum quantity. The system restocks items whose on hand quantity is less than or equal to the highest minimum defined.

L = Loose pick. The system restocks items that are set up with the location class defined in the Location Class for Loose Pick Store Restock (G22) system control value and the item's on hand quantity is equal to zero. For any items that are not defined with a location class, the system uses the full restock logic to restock the item.

Note: If you leave this field blank, the system does not automatically generate retail store restock orders for the warehouse when you use the Working with Retail Store Restock (WRSR) menu option.

Alphanumeric, 1 position; optional.

Active

This value indicates whether an active, unconfirmed restock order exists for this store.

Valid values are:

Y = An active, unconfirmed restock order exists for this store. You cannot create another restock order until the existing restock order is confirmed or canceled.

N (default) = There are currently no active, unconfirmed restock orders for this store; it is eligible for a new retail store restock order.

The system identifies an order as a restock order if:

• The sold to customer on the order matches the store restock customer number defined for the retail store warehouse.

• The order type on the order matches the order type defined in the Default Order Type for Store Restock Orders (G23) system control value.

Alphanumeric, 1 position; display-only.

Store distb (Store distribution)

An informational field that indicates whether the store is included in distribution.

Valid values are:

Y = The store is included in distribution.

N = The store is not included in distribution.

Alphanumeric, 1 position; optional.

In-trans whs (In-transit warehouse)

Optionally, enter the in-transit warehouse to enable you to track inventory on a store restock order when it is in-transit between your main warehouse and the retail store. If you specify an in-transit warehouse, you must also specify an In-trans loc (In-transit location).

Use in Retail Store Restock Process

When you confirm shipment of a retail store restock order for this store, the system transfers the inventory from the From whse (Restock from warehouse) to this warehouse. When the store receives the shipment, you can transfer the inventory from the in-transit warehouse to the warehouse representing the retail store, either through a menu option such as Working with Inventory Transactions in Batch Mode (WITB) or through the Generic Inventory Transaction Upload.

 

In-Transit Warehouse/Location Setup Options

When setting up your in-transit warehouse and location, you can:

• create a special -in-transit location in the retail store warehouse itself, so you can use the same warehouse code to track in-transit inventory en route to this store

• create a single in-transit warehouse and location to use for all retail stores

• create a single in-transit warehouse to use for all retail stores, but a separate in-transit location in this warehouse to use for each retail store

• create a separate in-transit warehouse and location to use for each retail store

See In-Transit Warehouse/Location Setup Options for more information on how to set up an in-transit warehouse and location.

Typically, you use a non-allocatable warehouse as the in-transit warehouse; also, the warehouse should not be viewable in order entry, and it should not be set up to receive restock transfers. See the Create Warehouse Screen for related fields.

Numeric, 3 positions; required if you specify an In-trans loc (In-transit location).

In-trans loc (In-transit location)

Optionally, enter the in-transit location to enable you to track inventory on a store restock order when it is in-transit between your main warehouse and the retail store. Your entry must be an existing location in the in-transit warehouse.

Note: If you specify an in-transit location, you must also specify an In-trans whs (In-transit warehouse).

For more information: See the description of the in-transit warehouse, above.

Alphanumeric, 7 positions; required if you specify an In-trans whs (In-transit warehouse).

The following fields are used in retail store sales.

Customer # (Sales customer number)

The sold to customer that represents a retail store.

The system uses this customer number as the sold to and ship to customer when you upload retail orders into CWDirect from the RA DOS system if the RA DOS order does not contain a customer number.

Sold to customer numbers are defined in and validated against the Customer file. See Creating and Updating Sold-to Customers (WCST).

Numeric, 9 positions; optional.

Ship via

The ship via code the system uses when you upload retail orders into CWDirect from the RA DOS system.

Ship via codes are defined in and validated against the Ship Via file. See Fulfillment Working with Ship Via Codes (WVIA).

Numeric, 2 positions; optional.

Source

The source code the system uses when you upload retail orders into CWDirect from the RA DOS system.

Source codes are defined in and validated against the Source Code file. See Marketing Working with Source Codes (WSRC).

Alphanumeric, 9 positions; optional.

User fields

Three informational fields for you to enter additional store information.

Alphanumeric, three 10-position fields; optional.

Note: An error message displays if you press F3 or F12 on the Create Store Screen and the Retail outlet field on the Create Warehouse Screen is set to Y: Retail store details must be defined. You must enter the required retail store information or change the Retail outlet field to N.

Change Warehouse Screen

To change: Enter 2 next to the warehouse at the Work with Warehouses Screen to advance to the Change Warehouse screen. At this screen you can change any information except the warehouse code. See the Create Warehouse Screen for field descriptions.

If the Retail outlet field for the warehouse is set to Y and the Use Retail Store File (G15) system control value is set to Y, you advance to the Change Store screen after you complete this screen. At this screen you can change any information except the store ID, store description, and active status. See Create Store Screen for field descriptions.

Display Warehouse Screen

To display: Enter 5 next to a warehouse at the Work with Warehouses Screen to advance to the Display Warehouse screen. You cannot change any information on this screen. See Create Warehouse Screen for field descriptions.

If the Retail outlet field for the warehouse is set to Y and the Use Retail Store File (G15) system control value is set to Y, you advance to the Display Store screen, where you can review store information. You cannot change any information on this screen. See Create Store Screen for field descriptions.

Work with Warehouse/Entity Screen

Purpose: Use this screen to work with warehouse/entity locations. These locations are used as the mailer ID for the SmartLabel on the pick slip if you use SmartLabel returns processing. The mailer ID is a three-position value, supplied by Newgistics, which indicates how to palletize returns in the Newgistics facility based on the originating warehouse and entity for the order. The system prints the complete Mailer ID in large type on the label, and also uses the second and third positions of the Mailer ID in the barcode. It is important to enter only the three positions for each warehouse/entity to prevent the SmartLabel from printing incorrectly. See Using SmartLabel Returns Processing for an overview and complete setup instructions.

How to display this screen: Enter 18 next to at the Work with Warehouses Screen.

INR1700 DISPLAY Work with Warehouse/Entity 1/15/04 17:02:35

EZK Mail Order

Warehouse: 2 MAIN WAREHOUSE

Opt Entity Description Location Id

Type options, press Enter.

2=Change 4=Delete 5=Display

1 AVIAN CREATIONS A12 23

2 PARROT LIFE A12 45

F3=Exit F6=Create F12=Cancel F21=Print list

F24=Select Company

Field

Description

Entity

An entity for which you have set up a warehouse/entity location as part of SmartLabel returns processing. An entity is a business unit within a company, defined in and validated against the Entity file. An order is associated with an entity based on the source code on the order header. See Using SmartLabel Returns Processing for an overview and complete setup instructions.

Numeric, 3 positions; optional.

Description

The description of the entity.

Alphanumeric, 25 positions; display-only.

Location

The code, or mailer ID, which indicates how to palletize returns based on the order’s shipping warehouse and entity. The code, which is supplied by Newgistics, is three positions in length.

Alphanumeric, 32 positions; display-only.

ID

The client ID (DUNS extension number) information to include in the USPS barcode on the SmartLabel. See Using SmartLabel Returns Processing for an overview and complete setup instructions.

Numeric, 2 positions; display-only.

Option

Procedure

Create a new warehouse/entity location

Press F6 to advance to the Create Warehouse/Entity Screen,

Change the location for an existing warehouse/entity

Enter 2 next to a warehouse/entity to advance to the Change Warehouse/Entity Screen.

Delete a warehouse/entity location

Enter 4 next to a warehouse/entity to delete it.

Display a warehouse/entity location

Enter 5 next to a warehouse/entity to advance to the Display Warehouse/Entity Screen.

Create Warehouse/Entity Screen

Purpose: Use this screen to create a location code by warehouse/entity, This location is used as the mailer ID for the SmartLabel on the pick slip if you use SmartLabel returns processing. The mailer ID is a three-position value, supplied by Newgistics, which indicates how to palletize returns in the Newgistics facility based on the originating warehouse and entity for the order. The system prints the complete Mailer ID in large type on the label, and also uses the second and third positions of the Mailer ID in the barcode. It is important to enter only the three positions for each warehouse/entity to prevent the SmartLabel from printing incorrectly. See Using SmartLabel Returns Processing for an overview and complete setup instructions.

How to display this screen: Press F6 at the Work with Warehouse/Entity Screen.

INR1696 ENTER Create Warehouse/Entity 1/15/04 17:04:57

EZK Mail Order

Warehouse . . . : 2 MAIN WAREHOUSE

Entity . . . . .

Location . . . .

Client Id . . . .

F3=Exit F12=Cancel

Field

Description

Warehouse

The warehouse selected at the Work with Warehouses Screen. The description displays to the right.

Warehouse code: numeric, 2 positions; display-only.

Warehouse description: alphanumeric, 30 positions; display-only.

Entity

An entity used to identify how to palletize returns in the Newgistics facility when you use SmartLabel returns processing. An order is associated with an entity based on the source code on the order header. An entity is a business unit within a company, defined in and validated against the Entity file; see Working with Entities (WENT) for more information.

Numeric, 3 positions; required.

Location

The mailer ID code which indicates how to palletize returns based on the order’s shipping warehouse and entity. The code, which is supplied by Newgistics, is three positions, of which the second and third are used in the barcode. If your entry in this field is longer than three positions, the SmartLabel on the pick slip will not print correctly.

Alphanumeric, 32 position; required.

Client ID

The client ID information (DUNS extension number) to include in the USPS barcode on the SmartLabel. This ID is appended to the SmartLabel D-U-N-S Number (I47). See Using SmartLabel Returns Processing for an overview and complete setup instructions.

Numeric, 2 positions; optional.

Change Warehouse/Entity Screen

To change: Enter 2 next to a warehouse/entity location at the Work with Warehouse/Entity Screen to advance to the Change Warehouse/Entity screen. At this screen you can change only the location. See the Create Warehouse/Entity Screen for field descriptions.

Display Warehouse/Entity Screen

To display: Enter 8 next to a warehouse/entity at the Create Warehouse/Entity Screen to advance to the Display Warehouse/Entity screen. You cannot change any information on this screen. See the Create Warehouse/Entity Screen for field descriptions.

Work with Warehouse Devices Screen

Purpose: Use this screen to define the default PC manifest, pick slip, and report output devices for a warehouse.

Note: It is not necessary to define PC manifest server devices if you use the PC Manifest Socket Interface.

How to display this screen: Enter 19 next to a warehouse on the Work with Warehouses Screen.

INR0750 DISPLAY Work With Warehouse Devices 6/18/97 14:38:41

The Mail Order Company

Opt Type Device

Select items, then select an action.

2=Change 4=Delete

M PC Manifest Server ID MANIFEST01

P Pick Output Queue P5

R Report Output Queue P3

F3=Exit F6=Create F12=Cancel

Field

Description

Type

The type of output device. Valid values are:

M - PC Manifest Server ID. You must define this device if you are using batch PC manifesting.

Note: It is not necessary to define PC manifest server devices if you use the PC Manifest Socket Interface.

P - Pick Output Queue.

R - Report Output Queue.

The description of each device type appears to the right of the type. Types and descriptions are system-defined.

Alphanumeric, 1 position; optional.

Device

The name of the output device.

Alphanumeric, 10 positions; optional.

Screen Option

Procedure

Create a new warehouse device

Press F6 to advance to the Create Warehouse Device Window.

Change warehouse device information

Enter 2 next to a warehouse device to advance to the Change Warehouse Device Window.

Delete a warehouse device

Enter 4 next to a warehouse device to delete it.

Create Warehouse Device Window

To create: Press F6 at the Work with Warehouse Devices Screen.

Create Warehouse Device

Device Type . (M, P, R)

Device . . . .

F3=Exit F12=Cancel

Change Warehouse Device Window

To change: Enter 2 next to the warehouse device at the Work with Warehouse Devices Screen.

Change Warehouse Device

Device Type : R

Device . . . . P3

F3=Exit F12=Cancel

WH07_01 CWDirect 18.0.x 2018 OTN