Order Status

This report provides the status of orders and returns in our order management system along with extensive data for each.  

Order Date: The date the order was placed by the customer.

Status: Status of the order. These include: 

• "Sales" - Shipped order
• "Returns" - Returned order
• "Cancelled" - Cancelled order
• "Open Backorder" - Open order waiting for inventory to be delivered to the IPS warehouse  
• "Committed Backorder" - Open order with committed inventory not yet in process
• "In Process" - Order being processed in the Ingram warehouse
• "Awaiting Shipment" - Completed order ready for shipment

Status Date: The date a status is assigned or changed by Ingram for an item.
PO or Credit Memo: An identifying sequence generated by Ingram when an order is placed (PO) or a return (Credit Memo) is processed.

Future Processing Date: A designated future date for product to be shipped.
HQ Account Number: Headquarter account number linked to the headquarter name.
Headquarter: The headquarter name.
Bill To: Billing account number.
Billing Location: Billing location where product is billed.
Ship To: Shipping account number assigned to a shipping location.
Shipping Location: Shipping location where product is shipped.
SL Country: Shipping location country.
SL Region: The contractual sales region assignment for international, domestic and Canada customers Shipping Location.
Destination Country: This region is based on the destination country (regions are: USD, Canada, or International).
IPS Sales Region: The contractual sales region assignment for international, domestic and Canada customers.
Territory – Examples:
Canada
Field Sales
Gift
International
Library
Mass Merch
National
Publisher Account
EAN: 13-digit code used to identify the product (ISBN).
Title: Title
Format: – Examples:
Big Book
Board Book
Paperback / Softback
Hardback
Multiple Copy Pack
Spiral Bound
Brand Category: Publisher defined category set up through the client manager and maintained in TMS (title management system).
Imprint: Imprint
Release Date: The date initial new title backorders are released to the warehouse for fulfillment.
Pub Date: From CoreSource, publisher defined expected date for product to be available.
Qty: The number of items ordered or returned.
Value: The value of the items ordered or returned.
Invoice #: An Ingram generated invoice number is created when product is processed and shipped.
Direct Fulfillment: This is a Yes / No flag if the order includes or excludes Direct Fulfillment.
DF Type of Order: Direct Fulfillment Type of Order. This is from the iPage entered Direct Fulfillment order information.
Ship Date: The date the order is shipped to the customer.
Carrier: The shipping company transporting product.
Tracking Number: The carrier’s shipment tracking number.
Bill of Lading: The receipt verification of shipped items.
Pro Number: A tracking number used by carriers to track the progress of the shipment.
Credit Hold Status: This is a Yes / No flag to indicate if the account is on Credit Hold.

Credit Code Description – Examples:
Author Signing
Catalog Sales
Hassle Free Returns
IPS Affidavit Adjustment
IPS Sales Adjustment
Overstock
Non-return Credit
Cancel Date: The date a product is cancelled.
Expected Due Date: The date the publisher expects Ingram to receive the product in a DC location and is defined via the shipment notification process. Once shipment is received, the Due Date field is cleared since this is no longer relevant data.
Expected Units: Units provided via the shipment notification process where a Publisher PO exists.