Presales Warehouse Receiving
Release Date: 3/1/24
Revised: 10/16/24
Version: 8.6 and Above
PO Warehouse Receiving Add Mode
If running the Presales Interface, the application will show the first vessel number attached to a purchase order when searching for a purchase order.
The validation
between receiving and presales is done on a batch basis, instead of an interactive basis. If a vendor EDI profile has 856 enabled, warehouse receiving will do the
following:
- Warehouse Receiving Edit List will match receiving transactions against Presales pending. The warning will be printed immediately after each receiving transaction if necessary. In addition, the application prints the total number of warnings at the grand total area.
- The checking logic for Warehouse Receiving Posting Journal is same as Edit List.
If the number of items received does not match the quantity from the Presales pending transaction, the vessel must be updated to allow partial receiving. When posting a full receiving or a partial receiving, the serial numbers entered in PO Warehouse Receiving must also match the serial numbers in the Presales Pending Serial Number file. Error messages will print on both the Warehouse Receiving Edit List and the Warehouse Receiving Posting Journal if there is a mismatch.
This situation will also trigger a new event:
PROGRAM: POWHRLST or POWHRPST
Type: PSMISMAT (i.e. Presales Mismatch)
File Name: IMITMFIL
Description: Presales Mismatch
Var 1: Item Number
Var 2: Item Description 1
Var 3: Item Description 2
Var 4: Qty Received
Var 5: Presales Qty
Var 6: Location: This refers to the regular warehouse location
Var 7: Presales Vessel ID
Var 8: PO Number
Var 9: Estimated Arrival Date
Var 10: Mismatch Message – the message can be “Over Receive”, “Under Receive”, “No Presales Found”, “Serial Number Mismatch” or "Realignment Error Encountered"
Var 1: Item Number
Var 2: Item Description 1
Var 3: Item Description 2
Var 4: Qty Received
Var 5: Presales Qty
Var 6: Location: This refers to the regular warehouse location
Var 7: Presales Vessel ID
Var 8: PO Number
Var 9: Estimated Arrival Date
Var 10: Mismatch Message – the message can be “Over Receive”, “Under Receive”, “No Presales Found”, “Serial Number Mismatch” or "Realignment Error Encountered"
This issue must be resolved before the transaction will post. If processing a partial receiving, the vessel must be updated to allow partial receiving posting. Otherwise, Pending Presales transactions can be adjusted by processing a Presales transaction against the vessel. Process either a negative transaction to reduce the quantity in the pending vessel or a positive amount to increase the amount in the pending vessel.
See Presales Negative Transactions for more information on processing a transaction against a pending Presales transaction.
Once the issue is resolved, post the warehouse receiving transaction. Posting the transaction will move the quantity from the Presales warehouse location to the regular inventory location. Customer Order Processing orders that are on file at the Presales location for the items received will be added to Fill Presales table. If an incomplete Presales Order Entry order is found and cannot be filled, an event is triggered.
Program: POWHRPST
Type: WRFILPSI
File: IMITMFIL
Description: WH Recv Fill Presales By Item
Var 1: Item Number
Var 2: Item Description 1 + Item Description 2
Var 3: Order No.
Var 4: New Order No. (always zeroes)
Var 5: Salesman No.
Var 6: Presales Order Date
Var 7: Qty Filled (always zeroes)
Var 8: Presales Location
Var 9: Customer No.
Var 10: Presales Cust PO#
Type: WRFILPSI
File: IMITMFIL
Description: WH Recv Fill Presales By Item
Var 1: Item Number
Var 2: Item Description 1 + Item Description 2
Var 3: Order No.
Var 4: New Order No. (always zeroes)
Var 5: Salesman No.
Var 6: Presales Order Date
Var 7: Qty Filled (always zeroes)
Var 8: Presales Location
Var 9: Customer No.
Var 10: Presales Cust PO#
An event is also triggered when the Presales pending quantities are updated. This happens during Presales Transaction Posting and Warehouse Receiving Posting.
Program: POPTXQTY
Type: PENDITEM
File: IMITMFIL
Description: Pending Item
Var 1: Item Number
Var 2: Item Description 1
Var 3: Item Description 2
Var 4: PO No.
Var 5: Qty Received
Var 6: Location
Type: PENDITEM
File: IMITMFIL
Description: Pending Item
Var 1: Item Number
Var 2: Item Description 1
Var 3: Item Description 2
Var 4: PO No.
Var 5: Qty Received
Var 6: Location
Filling the order requires a second step. See Fill Presales Orders for more information.
CLS
Related Articles
Presales Interface Setup
Release Date: 3/1/24 Revised: 3/21/24 Version: 8.6 and Above Alpha Document Number Support If using alpha document numbers, set up alpha document number support for the Presales Generated Order. This option is available from System Utilities-> Global ...Feature - Warehouse Receiving Mass Receiving
Release date: 11/18/2017 The following changes were made to PO --> Processing --> Warehouse Receiving process A new option has been added: Mass Receiving. Warehouse receiving records (POWHRECI) are created using passed values from the screen program, ...Feature - Default Receiving Description in Warehouse Receiving Import
Release Date - 2/11/19 This feature gives the user the ability to specify a default Receiving Description when importing PO Warehouse Receiving transactions from an CSV file. This option is available with the Invoice/Document Number field. When ...Feature - Warehouse Receiving Missing Item Attribute Event
Release date: 12/31/2019 Updated: 2/10/2020 - Event will only trigger in Add mode Version 8.5 and up A new PO Warehouse receiving event has been added. This event is triggered in Add mode of the PO Warehouse Receiving application. The event is ...Feature - Move Successful Warehouse Receiving Files to Separate Directory
Release date: 3/5/2019 Version: 8.2 and up Added the ability to move successful Warehouse Receiving import files to a separate directory. This feature is useful to create "Auditing" of the interfaced files if issues should arise later. First go to ...