Spotlight On...
Order Management Reports
By
Dec 8, 2005, 09:20

Here are the standard reports available through our on-line order management system.

Products (what's in the warehouse)

• Product Backordered – shows only products are on backorder, how many pieces are backordered, reserved, or expected. Also shows reorder points

• Product Detail – shows all products with balances, plus version, expiration date, sort groups & status

• Product Summary – shows all products, with balances, reorder points, number backordered, expected, and average monthly usage.

• Product Transaction Summary – material movement over a defined period, including what’s been received, shipped, returned, disposed, adjusted, and on hand.

• 12 Month Component Usage – product usage over the past 12 months

• Understock – balances under predefined reorder points and target balances

• Inactive Products – products with no activity over a defined time period

Shipping

• Package Shipments – ship to addresses, tracking numbers, method of delivery, weight and cost of package

• Products Shipped – by product, the ship to address, e-mail, phone, fax, date and time of shipment

Orders

• Daily Orders – list of all orders for a certain day, and the status of each, including source

• Orders Backordered – cumulative backorders by date. Includes bill to and ship to addresses and product and quantity backordered

• Orders Backordered (by product) – grouped by product, with ship to address, phone number, and quantity backordered. Totals are summarized at end of each product.

Offers (what can be ordered)

• Offers Ordered – grouped by offer, includes ship to addresses, with on hand balances and backorders

• Offer Component – includes info on clusters and start and stop dates of offers (if applicable), as well as balances

• Offer Categorization – groups the above information in user-defined categories (ie: catalogs, premiums, audio, video, hard cover, soft cover, etc.)

• Offer Sales Analysis – grouped by categories, it computes quantities sold by price of product

Notifications/Confirmations
• Reorder Notification - e-mail automtically sent when a product reaches a predetermined amount
• Material Receipt Notification - an autommatic e-mail is sent when material has been received into the warehouse
• Order Confirmation - once an order is placed, an e-mail is sent to the orderer with an order number and a link into the system. Any backordered products will be noted.
• Shipping Confirmation - once an order has been shipped, an e-mail will be sent to the orderer with a link into our system (to check status) and a tracking number and a link into the express carrier's site (if applicable).


© Copyright 2003 by YourSITE.com