The Picking Slip Confirmation process is the next step once goods have been physically picked with picked quantities marked on the paperwork. These quantities now need to be entered onto the system to reduce the stock availability and produce a transaction ready for invoicing the customer. Dispatch information may also be captured at this point depending on the warehouse procedures in place. In some instances, the recording of dispatch information could be a separate operation in which case other transactions may be more suitable.
Consignments can be consolidated for the same Carrier and for the same Delivery Address where previous orders have not yet been manifested.
Consignments can also be consolidated for orders with the same Customer reference. This process accumulates the total weight, number of cartons and number of pallets.
The order consolidation field in the Customer Masterfile is setup with X = Allow merge by Billing number. Order consolidation flag (OCON) is soft coded in control file TMSDS/CM-OCON to define how to merge picking slip/invoice and how to trigger invoice merge process, either automatically by system or manually released for invoice (1=Automatic, 2=Manual). For merging for ASN orders or diverted orders, OCON will set up as ‘Automatic’ invoicing and change to call DSO135 with Online mode and will not write pick plan file. For printing invoice at status A, OCON will set up as ‘Manual’ invoicing that will call DSR131 to print dispatch docket.
For a consolidated Carrier con-note label to be printed a document print control entry for EDR610A must be made.
Diverted orders can be merged into one invoice if:
- All diverted orders are at status ‘A’, if all ‘A’ generate a Pick Plan record for each process number.
- This displays a message on the screen that the picking slip is waiting on another to be confirmed before the invoice is generated.
- When two picking slips are linked to the same order and are diverted due to availability in the warehouse, a message displays upon confirmation of one picking slip, to inform the users that the picking slip is being actioned in another part of the warehouse. This allows the user to action based on customer instructions determining whether to send goods out individually or together.
- The Total weight, number of cartons and number of pallets are accumulated for consolidated orders with the same customer reference.
Merged Picking slips but produce separate invoices.
- Process numbers can be consolidated onto the one picking slip but produce separate invoices. This will use TMSDS/TR-DMRG to determine whether consolidation should be at the order time as per TMSDS/CM-OCON or whether to merge across all picking slips to produce one invoice or whether merge orders into one picking slip but produce separate invoices. Consolidating picking slips will reduce actioning time of the orders but still ensure customers receive multiple invoices.
Customer classification type can be setup in control file TMSDS/INVLL-CT to limit the number of orders per invoice and number of lines on an invoice.
Allows for an already existing invoice number when determining the common invoice number for a consolidated group.
If an order has an Order Type that requires compulsory payment, as defined in TMSDS/OM-PAYR and the payment amount in the debtor’s transactions is less than the order amount, the order will be placed on HOLD.
The Discrepancy Flag is used if the system indicates that a sufficient stock level exists to fill an order, but the physical stock quantity is not sufficient, that is if there is a discrepancy between system stock and physical stock. By setting the discrepancy flag to Y, the system will mark the total stock quantity for a Title, in a warehouse, as being ‘in discrepancy’ and no stock will be available for transactions.
TMSWH/DSC-PLCY defines the location discrepancy policy based on a discrepancy reason code. A discrepancy transaction will be written for the item/location when a discrepancy is found.
The Invoice can be printed without sales revenue and only take up sales revenue at dispatch customer pick up. TMSDS/PRT-INV determines at what stage an invoice will print. It includes a print stage for status A to print a dummy invoice at pick confirm before completion of the order.
The system checks for status A after pick confirm and recalculates total in the case of a short pick and triggers the invoice print if defined in TMSDS/PRT-INV.
After the actual delivery, Warehouse will input the ‘acknowledge date / delivery date’ in the system. The system will generate ‘firm’ invoice from the ‘delivery date’ and trigger sales entry, stock adjustment, and update Accounts Receivable.
The results of the confirmation process are:
- A document number is generated before the Invoice generation process which facilitates printing document numbers on labels. TMSDS/TR-DOCN must be set to 1
- Backorders will be created where applicable
- Invoices may print depending on TMSDS/PRT-INV
- Labels may print depending on TMSDS/PRT-LAB
- Consignment Notes may print depending on TMSDS/PRT-CON
- Consolidated carrier connote labels may print depending on TMSDS/EDI-CONP
- Stock Discrepancies will be recorded
- Consignment/Manifest files will be updated
- An invoice number which differs from the Pick slip number will be allocated
- Invoices will consolidate by billing number/customer reference
The results of a rejection are:
- The order is given a status R
- Backorders will not be created
- The order cannot be reopened
- The order can be copied into a new order if required
- The status R order will remain on the system until purged
- Container status changes to C for Complete for the order. If the number of pallets is entered the system will not delete the container even though there is not stock on it. This is to generate the manifest for pallets
The following control files that need to be established specifically for use by the Pick Confirm process are:
TMSDS/ASRL-CLS Serial Number Item classification
TMSDS/DS-DOCN Document number selection list
TMSDS/DSE100-1 Program switches
TMSDS/EDI-CONN Consignment details for EDI
TMSDS/PK-APGO Allow pick quantity greater than order quantity
TMSDS/PRT-CON When to print con-notes?
TMSDS/PRT-DLYP Does DSO136 print document (by DSO137) when PCKM=p
TMSDS/PRT-SMRY Print picking summary control
TMSDS/TR-DCHGR Dispatch charges no charge reversal Title number
TMSDS/TR-PCKM Picking method
TMSDS/WH-PCK Pick confirmation update via queue or interactive
TMSWH/ENT-SRL When to enter serial number?
When a component of a system is short picked, the whole system is invoiced to the customer, and a credit and backorder is created to cover only the item which has been short picked.
Invoice, labels and connote printing is done via WHO660 Pick confirmation . Invoice printing will be done based on TMSDS/CM-OCON and labels and connote printing will be based on TMSDS/PRT-LAB and TMSDS/PRT-CON control file settings.
Confirm pick slip quantities
The Pick Confirm program is used to enter the picked quantities of orders to reduce the stock available and produce a transaction ready for invoicing the customer. This process can display in RF format or full screen format.
Access to the picking entry function is obtained by selecting the picking date (defaulted to the current system date) and the picking slip number.
A Picking Slip must have one of the following statuses for confirmation to be allowed:
- DW (in picking and available to warehouse)
- DA (in picking and available to pick)
- DP (in picking and picker assigned)
This example describes how to confirm pick slip quantities.
- In the menu, expand Base Modules > Distribution > Inventory Management > Warehouse Management > Warehouse Control > Pick/Pack/Dispatch Confirm> Pick Confirm and double-click WH Pick Confirm. DSE100 Picking Confirmation selection panel appears.
- Enter valid picking date, picking slip number and click OK. Even if a replenishment run has not been completed, for the warehouse run on which this pick slip resides, the pick slip can be confirmed provided that all Titles on the pick slip have been replenished. (Pick Key is pick slip # prefixed with P). DSE100 Picking Confirmation panel appears.
| Field | Description |
| Immediate document print | The Immediate document print flag is defaulted from control file TMSDS/TR-IDOC, which determines not only the default but whether or not it can be overridden. If the sales order was maintained, this will carry forward to the Picking Slip for confirmation (depending on the control file setup). Y means yes the invoice will print immediately the confirmation of the picking slip is completed. TMSDS/WH-PCK determines whether 'immediate document prints' are submitted to the background processor or printed interactively from the picking confirmation. |
| Carrier | The Carrier code defaults from the Customer masterfile and can be overridden. A Carrier code identifies the freight carrier responsible for shipping/delivering the goods to the customer. In DSE100 Pick Confirm, the Carrier code is defaulted from the sales order and can be overridden at this point. TMSDS/CAR-SEL has a selection list from where the system selects the cheapest carrier meeting the warehouse, postcode and weight criteria. If the selection list is not available then the carrier is selected using TMSDS/AUTO-CAR. A default of ** indicates the system will select the Carrier based on TMSDS/AUTO-CAR. |
| Forwarding agent code | Forwarding agents are used by freight companies to continue the transport of the goods if the freight company itself is unable to complete the delivery. For example: to isolated country areas or overseas destinations. This field contains the code that identifies the agent responsible for forwarding the goods. In DSE100 Pick Confirm , the Forwarding Agent code is defaulted from the sales order and can be overridden. The Forwarding Agent address is used in freight calculations. |
| Delivery run no | A Delivery run number can be allocated to a customer on the Customer masterfile. This code assigns a sales order to a specific delivery run. Normally used when a company controls their own delivery vehicles or has contractors assigned to delivery runs. The Invoice print can be requested by Delivery Run number, thus grouping all customers with the same run number together for picking and dispatch purposes. For example, deliver in overseas or local courier run. |
| Delivery stop no | This is the customer sequence on a particular delivery run. It enables the warehouse personnel to load the truck according to the sequence in which the goods are going to be delivered. This is usually used in conjunction with Delivery run numbers. |
| Truck number | This identifies the truck to be used for the specified Delivery run. |
| Number of pallets | If applicable, the number of pallets on which the order has been packed is entered here. This is used by the label printing programs to determine how many labels to print. The Total weight, number of cartons and number of pallets are accumulated for consolidated orders with the same customer reference. |
| Number of cartons | The number of cartons into which the order has been packed for dispatch is specified in this field. This number defaults from TMSDS/DSE100-1 and can be overridden if necessary. This number is also used by the label print programs to determine how many labels are to be printed. The Total weight, number of cartons and number of pallets are accumulated for consolidated orders with the same customer reference. |
| Enter weight by carton | Optionally, the entered invoice weight can be validated against the calculated order weight. Validation depends on TMSWH/ENT-WGHT which has a weight tolerance and TMSDS/DSE100-1 which can force a weight entry by carton. |
| Total weight | This field indicates the total weight of the titles on this particular order, be it system calculated or manually entered. There is a flag in TMSDS/DSE100-1 that determines whether to allow total weight to be entered OR to be protected so the system will recalculate the total weight. This weight is used to determine the freight charges for delivery on the order. The Total weight, number of cartons and number of pallets are accumulated for consolidated orders with the same customer reference. |
| Volume | This defaults as the physical volume of goods to be shipped which is calculated according to the weights given on the Title masterfile. If weights have not been setup on the Title masterfile this field will be blank. The default can be amended if required or if there is no default the volume can be entered. |
| Volumetric weight | The Volume and weight of the goods to be shipped can be calculated by the system if the Title masterfile has been setup with the information. The default, if applicable, can be overridden or an entry made if required. |
| Picking reference | The name or user ID of the picker can be entered for inquiry purposes. This field can also be used to record the Consignment Note number or any other useful reference. The length of this field can be increased to 15 characters by setting a Control File accordingly. |
| Tracking reference |
The name or user ID of the packer can be entered for inquiry purposes or any other useful reference can be entered. A tracking reference can be the proof of delivery number, in most cases the consignment note number, for a customer order. A Control File determines what this field is to be used for. A Consignment number per Carrier is recorded when the consignment number becomes known and the customer has received the goods. It can be viewed on the Transaction Header Inquiry screen. This is a 12 character field which determines whether to calculate a consignment note number automatically via TMSDS/EDI-CONN. |
- Enter the required fields and click OK. DSE100 Picking Confirmation panel appears.
| Option | Description |
| Pick slip trans | Access DSI050 Transactions by Picking Slip Number to view the transactions. |
| Multi-location |
The Multi-Location Stock Allocation is used for those instances where a product is stored in multiple warehouse locations and it is being picked from one or more of these locations, or where the location from which this product is picked is different from that allocated by the system. It is also possible to indicate whether stock is picked from Bulk instead of Open. If this is the case the Bulk to Open Replenishment function is overridden. The affected stock levels for these locations will be immediately updated. This option is selected if an asterisk (*) displays in the location field indicating that the Title can be found in multiple locations and therefore the operator must confirm out of which location quantities were physically picked. |
| Function | Description |
| Reject | This function allows for picking slips to be rejected. This will create an invoice with a status R. The debtor’s transactions will not be updated however the document can be viewed through customer transaction inquiries. |
| Header | Display header details for maintenance |
| Charges | Freight charges can still be added to an order at this stage. This function key displays an additional entry screen to allow the specification of the freight charge basis. These instructions are used by the freight calculation routine to calculate the appropriate delivery charge.
|
| Cfrm & skip | Finalises the picking confirmation and skip the process. |
- If all picking slip details are correct then click Cfrm & Skip.
- Split lines if required and specify the carton number if required. Click OK. Pick Confirmation is completed.
