Update Order Status and Shipping Data program

Need more info or you couldn't find what you were looking for, let us know by sending an email to: support@dancik.com.

The Update Order Status and Shipping Data program allows you to inquire and update the status and location of orders.

Note: If the F1=Cut Station Menu option does not appear, go into menu option WM2 8 - Cutting Station Defaults File and make sure the workstation is set-up as a cut station.

Enter or scan the order#, line#, and the new status. The item#, serial#, and/or user id may be required for verification and for security reasons. When scanning, the ord#, line, item#, ser# and User ID is automatically entered and verified. Enter line# 9999 to indicate you want to update the entire order, and not just a single line.

Note: You can press Help with cursor in the New Status field to see a list of valid status codes.

— If the item is a serialized item, then the user must scan or enter a serial number. Blanks are not allowed.

— If the serial number does not match the serial number on the order, an error message is displayed, indicating the user is scanning the wrong inventory.

— If the item is non-serialized, blanks are permitted and no checking is performed.

A cutting station is defined as a workstation located near a cutting machine used to perform status updates on cut orders. The Cutting Station Program is a special option within the Order/Shipping Status Update Program. Its purpose is to allow multiple cuts to be made while a roll is on the cutting machine that has more than one uncut order allocated to it.

The Cutting Station Program can be accessed from the Order/Shipping Status Update Program if the following conditions are true:

The cut station program is accessed via the F1 function at the bottom of Menu Option WAR 5 - Update Order Status.

Note: If the F1=Cut Station Menu does not appear, go into menu option WM2 8 - Cutting Station Defaults File and make sure the workstation is set-up as a cut station.

When the Cut Station Functions appear, select option 3 to take a roll measurement.

The status code of the serial number will be automatically changed to “m” (measured) unless the serial number is assigned to one of the status codes identified in the option Prevent status updates to serial # status codes below during Measurement Adjustments under the System Wide Settings - Options for Counter Interface.

Notice that the serial number that was measured and adjusted still retains it’s “D- Damaged” status.

The following Point Of Pick/Cut Inquiry Screen was automatically displayed when the cutting machine operator scanned the pick label for order number 406522, line 0010. It was displayed because the roll with serial number 39002953 in Location B23 had additional orders allocated to it, that were not yet cut.

The Cutting Station Screen displays the length physically on the roll, the length of the cut being made, and the length the remaining balance will be. The screen displays in the default rolled goods UM as specified in the Control Panel. The figures can be displayed in an alternate UM by entering in the Show In U/M field. The bottom half of the screen displays the other uncut orders allocated against this roll. The cutting station operator can see if labels have already been printed for the other uncut orders, and can request to print labels for those orders by entering a P next to the order numbers.

Depending on the system wide setting for Options for Must Ship Complete Orders, the listing of orders could vary. The order display options for “Must Ship Complete” orders are as follows:

Field Name	Description
Item#	The item number being cut.
Name	The description of the item being cut.
Serial#	The serial number being cut.
Loc	The bin location from which the roll was pulled.
Qty Now in Location	The quantity physically on the roll when it was pulled from the bin location, prior to this order being cut. The program calculates the quantity (length) that is still physically on the roll by taking the onhand quantity, and then subtracting the quantity of any orders that are at status X or further. Orders at status X, A, S,0,1,2,3,4,5,6,7,8 and 9 are considered already cut, and are subtracted from the onhand balance in order to calculate the Qty Now in Location.
Order	The order number and line number of the roll being cut, followed by the quantity or length to be cut for this order.
Qty After Order Is Filled	The quantity or length that will be left on the roll after this order has been cut or filled.
Other Unfilled Orders for___	The bottom half of the screen displays a list of other uncut (unfilled) orders for this roll. (serial number and location).
P	This column allows you to enter a P for print. A P code causes a pick label to print for the respective order or line.
Order	The order number of other uncut orders for this roll.
Line	The line number of other uncut orders for this roll.
Customer	The customer name of other uncut orders for this roll.
Qty	The quantity of other uncut orders for this roll.
UM	The UM related to the quantity.
Ship Date	The ship date of each other uncut order for this roll.
Via	The ship via code of each other uncut order for this roll.
RT	The ship truck route of each other uncut order for this roll.
S	The order status code of each other uncut order for this roll.
LBL	This field shows Y if a pick label has previously been printed for the order or line, or N if a pick label has not been printed. This field changes from N to Y if you request a label to print using the P option.
Pick List	This field shows Y if a pick list has previously been printed for the order or line, or an N if a pick list has not been printed.

Note: The Cutting Station Program can only calculate the quantity or length that is physically on each roll if you utilize the standard meaning of each order status code. Orders at X,A,S,0,1,2,3,4,5,6,7,8 and 9 are considered already cut, and therefore not part of the quantity physically left on the roll.

To print labels for other uncut orders allocated against a roll, enter P next to the orders. When a cutting machine operator enters P next to an order, the program checks to make sure the order is not on credit hold. If the order is not on credit hold, the label is printed. If you use the pick label pool, the label prints and the line is removed from the pick label pool. If the order is an credit hold, a message is displayed and the label is not printed. If a label has already been printed, the new label will be marked as a duplicate or reprint. After labels are printed, the screen is updated and redisplayed..

Enter the two-digit printer code if you want to override the default printer. This override feature allows the cutting operator to select additional orders to cut, and request bar code pick labels to print at a specific printer, rather than the normally assigned label printer, which might be far from the cutting station. This facilitates the use of label printers at the cut station.

The “limits” function enables you to prevent shipping errors. Use the “limits” function to make sure the right customer gets the right product every time. The Update Order Status Program (option 5 on the Warehouse Functions menu) enables users to tell the program what they are working on, via the use of the “F2=Limits” function. This function can limit the user’s session to a truck route, a ship via, a transfer warehouse, or a specific order number. Once the “limits” screen is set, the program only allows the scanning of orders that meet the “limits” criteria, and will reject orders that should not be processed.

If a user enters into any of these “limits” fields, then any labels/orders that are scanned must match the parameters. For example, if the “limit to” is set to a specific Truck Route, then only scans of orders assigned to that truck route are processed, and others will issue an error “Order Not On This Truck Route”

1. On the Order/Shipping Status Update screen that appears, press F2 to show the limiting parameters.

2. Place one or more limits on the order update process. Enter the order information and press Enter.

3. Only orders falling within the entered limits are updated. If the order(s) does not fall within the limits, an error message appears at the bottom of the screen.

Note: Although the screens work best with scanning barcoded pick labels, you may key the information too. Therefore, you do not require barcoding in order to benefit from these functions.

4. The Limit fields remain in effect until they are changed, or until the user exits the program with F7. You may use the other function keys shown on the screen, but you will be returned to this program with the limit fields still set. Only F7 exits this program.

As an example of how these documents are used, the pick/load sheet can be run when the customer pulls their car up to the dock. When all the material is loaded, you can run the packing list and get a signature.

The F11 function on the Update Order Status application (WAR 5) allows an operator to enter cross reference information such as fabrication numbers or operator names too help track inventory through production. These cross-referenced numbers appear as F6-Misc. lines on the order detail line.

The Allow Other Ref# setting on page 3 of the Workstation Control Panel activates this functionality and also allows you to enter a different cross reference label. The default label is FA TAG# but this can be changed as needed.

2. On the screen that appears, enter the Order/Line and the reference comment (in this example it is a FA number.

Product Data Sheets contain information that must be supplied with each order. This functionality allows for easy printing of the Product Data Sheets, in pdf format, when the order is packed for shipment.

Note: For this functionality to operate as designed, it is recommended you use the latest release of Adobe’s Acrobat reader. The download is free and can be performed off Adobe's website: http://www.adobe.com.

The Special Instructions Screen for these three files has to be configured so the system recognizes that the item has a Product Data Sheet. In this example, the Item File is used, but the functionality is the same for all three programs.

2. On the Item File Profile Screen press the F12=Spc/Instr function key. The Special Instructions Screen appears. Notice the circled entry.

3. The Main Type must be set to I and the Sub Type has to be U. The text must be the file name of the product data sheet PDF. For example, if the PDF file is TASTIERADATA.PDF, enter TASTIERADATA.

4. You may enter the pdf file name in the F12 screen of the Item File, Manufacturer File, or Product Line File. The program can display up to three PDF files per item.

These files can only be located in a PRDDTA folder on the IFS directory home/www. If the PRDDTA folder does not exist, it needs to be created.

Note: An example directory path: SAL/dancik.com/home/www/prddta (where SAL is the machine name, dancik.com is the domain, and prddta is the folder where the pdf files reside).

In order for the iSERIES to access PDFs stored on a PC, the internal IP address for the system must be defined in the WM000F (IWMS - Task Transaction file) on the iSERIES. The IP address can be found by PING(ing) the system from command line if its not known.

Note: See your network administrator regarding access to and adding PDF files to the PRDDTA file.

1. On the Warehouse Functions menu (WAR), select option 5 - Update Order Status.

2. Enter and the order and line number you want to update. A badge number/name and new status code may also need to be entered.

3. Press Enter. If the item/manufacturer/product line has a Product Data Sheet set up in the Special Instructions, the F15= Product Data Sheet function key appears.

Note: Only two PDFs will open at a time. If there is a third Product Data Sheet, it opens automatically after one or both of the other PDF's are closed.

The Number of Labels and Quantity per Label is automatically calculated from information in the Packaging File (FIL 11). For line number 0010, the Packaging File, based on the UM and quantity is informing us we need two UCC shipping labels with 30.3 SF in each carton.

Note: Each label is assigned a unique UCC-128 number if no UCC-128 number is entered.

In the order shown above, the order was for 77 SF of the item on line 0010, we know that we have to override the 2 labels to 3 (30.3 x 2 = 60.6 SF). This gives us two full cartons and a partially full carton.

Going back to the UCC-128 Label Maintenance Screen we can see that several labels, including the one shown above, are attached to line 0010 on order 419065.

To edit the UCC label data, select a line number. All of the label numbers for the selected line appear.

The WSI menu contains the set-up and user options that allow you to import and export shipping information from the Dancik system to third party shippers such as UPS and Fedex. This eliminates having to manually enter shipment information into the third party’s software application (i.e., Worldship for UPS and Fedex Ship Manager). This interface can also upload and assign tracking numbers into the orders on the core system.

The system automatically inserts the UPS tracking number into the UCC-128 Label Maintenance screen. Adding the UPS data to the UCC maintenance screen allows the CMS 856 work files (shipping notices) and 810 work files (invoices) extract to include the UPS tracking number, ship quantity and UM.

1. The process starts when order information is exported to UPS Worldship via menu option WSI 1 -Export Shipping Provider Data.

2. After the shipping information is sent to a shipping agency (UPS) the system calculates and adds the applicable shipping charges to the total cost of the order. Use menu option WSI 2 to register the charges to the customers.

3. When the shipping information is imported in from UPS the tracking number, Shipping Qty, and UM are automatically inserted into the UCC-128 Label Maintenance screen. The lines on the order display. Notice that “CT” is automatically inserted as the Lading UM. This UM is hard coded into the program. That means that the Lading UM of CT cannot be changed.

4. Enter an “X” by the order lines you want to inquire on. The UPS tracking number is automatically inserted and the Ship Qty and UM are default to “1” and “EA”.

Note: If a label format is not assigned to a customer, the default UCC label is used.

Function Key	Description
F4	Cancel this screen. Returns to the Status Update Screen without updating the status of this line to X. Press F4 if you will not be cutting this order.
F6	Return to Status Update Screen normally. The status of the order will be updated to status X.