Order Entry dashboards and reports

Cancelled Customer Orders

The Cancelled Customer Orders dashboard contains these reports:

The Orders Placed vs Orders Canceled by Sales Representative report shows orders canceled by sales representative.
The Canceled Order QTY vs Customer Orders QTY by Month report shows the canceled order quantities by order over time.
The Canceled Orders by Location report displays the number of canceled orders based on location.
The Canceled Orders by Reason report displays the number of canceled orders by reason.
The Canceled Orders by Month report shows cancelled order trend month over month.

The filters used for slicing data are:

Company
Customer
Customer name
Customer order inventory location
Customer order source description
Order type
Year
Year/month

Cancelled Customer Order Detail

The Cancelled Customer Order Detail dashboard has a report by the same name. The report includes customer status, order source, order type, tax details, inventory location, hold code, goods amount, total AOC amount, freight charge amount, open order amount, customs total, inventory goods amount, sales tax, tax total, and order totals.

By clicking the Customer Order number in the report, you are redirected to the Customer Order Lines dashboard which shows supporting detail of the order clicked based on the filters selected.

The filters used for slicing data are:

Company
Customer
Customer name
Customer Order
Customer Order Cancel Credit Reason Code
Customer order inventory location
Customer order source description
Order type
Year
Year/month

Customer Orders

The Customer Orders dashboard has these reports showing summarized information about orders based on order source, description, aging bucket and order type:

The Orders by Source report displays number of orders based on order source description.
The Orders vs Returns by Month Compares report number of orders with number of returns based on year/month.
The Orders by Type report displays number of orders based on order type.
The Order Aging report displays number of orders based on aging bucket.

The filters used for slicing data are:

Backorder
Bill Postal Country
Company
Customer
Customer name
Customer Order inventory location
Customer Order Return Status
Customer Order Ship To Country
Customer Order source description
Customer Order Status
Customer Order Tax Status
Order Type
Year
Year/month

Customer Order Detail

The Customer Order Details report displays the detailed report of customer order details which includes customer status, order source, order type, tax details, inventory location, hold code, goods amount, total addon charge amount, freight charge amount, entered discount, gross amount, net amount, open order amount, customs total, inventory, and non inventory goods amount

By clicking Customer Order number, you are redirected to Customer Order Lines dashboard which shows the detail report of customer order lines based on the filters selected.

The filters used for slicing data are:

Backorder
Company
Customer
Customer name
Customer Order
Customer Order inventory location
Customer Order source description
Customer Order Status
Order type
Year
Year/month

Customer Order Lines

The Customer Order Lines report displays the detailed report of Customer Order Lines which includes customer item, item type, line number, sales class type, tax details, gross amount, sell unit price, unit cost, unit price, shipped quantity, and order quantity.

The filters used for slicing data are:

Backorder
Company
Customer
Customer name
Customer Order
Customer Order inventory location
Customer Order Line Type
Customer Order source description
Customer Order Status
Item Description
Item Number
Order type
Year
Year/month

Customer Order Return Details

The Customer Order Return Detail report displays the customer order return detail such as invoice number, reason code, status, freight charge, number of returns, and undecided count.

By clicking on the Customer Order Return number in the report, you are redirected to the Customer Order Return Line Details dashboard which shows the detail of return lines based on the filters selected.

The filters used for slicing data are:

Company
Customer
Customer name
Customer Order Return
Customer Order Return location
Customer Return Reason
Customer Order Return Status
Order Entry Currency
Year
Year/month

Customer Order Return Line Detail

The Customer Order Return Line Detail report shows detailed information about customer order return lines. The report includes customer order, return, item, line type, reason code, customs total, detail quantity, entered price, entered unit cost, quantity, unit price, and unit cost

The filters used for slicing data are:

Company
Customer
Customer name
Customer Order Return
Customer Order Return location
Customer Order Return Reason
Customer Order Return Status
Item Description
Item Number
Line Return Reason
Line Type
Order Entry Currency
Year
Year/month

Item Analysis

The Item Analysis dashboard has these reports showing summarized information of item quantity, top returned quantity, and sales quantities:

The Item Quantity By Month report displays order quantity based on year/month.
The Canceled Orders by Month report compares number of orders canceled against canceled quantity based on month.
The Top Returned Items by Quantity report shows top returned item quantity per item.
The Item Sales Quantity report displays sales quantity per item.

The filters used for slicing data are:

Company
Customer
Customer name
Customer Order inventory location
Customer Order source description
Customer Order Status
Customer Order Tax Status
Item Description
Item Number
Order type
Year
Year/month

Order Analysis

The Order Analysis dashboard has these reports showing the summary of goods amounts based on month, items ordered and compares the values:

The Order Breakdown by Month report compares entered payments, freight totals, insurance totals, customs totals, goods amounts, and order discounts.
The Goods Amount by Month report shows the goods amount summarized by month.
The Items by Order report is a detailed report of items ordered with the order number, quantity, unit price, customs total, freight total, insurance total, and discounts taken.

The filters used for slicing data are:

Backorder
Bill Postal Country
Company
Customer
Customer name
Customer Order inventory location
Customer Order Ship To Country
Customer Order source description
Customer Order Status
Customer Order Tax Status
Order type
Year
Year/month

Orders By Location

The Orders By location dashboard has these reports showing summarized information of goods amount, entered discount, delivered tax total amount, and total add on charge amount based on inventory locations:

The Total Amount by Location report displays goods amount based on inventory location.
The Discounts by Location report displays entered discount based on inventory location.
The Total Tax by Location report displays delivered tax total amount based on inventory location.
The Total Add On Charges by Location report displays total add on charge amount based on inventory location.

The filters used for slicing data are:

Backorder
Bill Postal Country
Company
Customer
Customer name
Customer Order inventory location
Customer Order Ship To Country
Customer Order source description
Customer Order Status
Customer Order Tax Status
Order type
Year
Year/month

Orders By Sales Representative Detail

The Orders By Sales Representative Detail report contains details about the volume of orders placed, order dates, inventory locations, quantity, order net, commission rates, and territories by sales representative.

The filters used for slicing data are:

Company
Customer
Customer name
Customer Order inventory location
Customer Order Ship To Country
Customer Order source description
Customer Order Status
OE Sales Representative
Order type
Year
Year/month