How to easily locate an order and associated purchased items by the ship to address information.
Locating an order can be challenging. First, locate the address customer id and sequence number in PS. Then use this query to access order line details (orders within the last 3 years): K_JAC_SHIPTO_LINES_BY_LOC. Prompts for customer id and loc (ship to).
Use query :
|
K_JAC_SHIPTO_LINES_BY_LOC
|
|||||||
This query will quickly identify order lines for the associated customer and location (regardless of bill to account). Excellent to use for locating a ship to on a multiple ship to order.
If the purchase was more than 3 years ago, try K_K_OP_DB_ORD_SHIPTO_ARCHIVE.
This archive query only needs the customer id.