R02 PO Reconciliation Summary

Filters

The filter pane for this report includes the following filters.

Last Updated Date: specify a range of dates to see information for that period. This dashboard's data is limited to the last 90 days.
Seller Name
Facility Name
PO Status
PO Number
Channel (B2B or EB2C)
Open to Receive Flag (N or Y)
Open to Putaway Flag (N or Y)

Data Elements

The PO Reconciliation Summary report provides a purchase order-level summary view of unit data as being interfaced to Radial or actively worked on by Radial Ops.

Column	Description
Seller Name	The name of the seller or sub-client, as set up in the order management system.
Seller ID	A unique identifier for the seller or sub-client, as set up in the order management system. Usually a seller corresponds to one sales channel, for example, a webstore serving a particular geographic region operating under a particular name.
Facility Name	Name of the warehouse or distribution center.
Facility ID	Unique identifier for the warehouse or distribution center.
PO Number	Client purchase order (PO) number.
PO Created Date	Date when the purchase order was created.
Last Updated Date	Date of the most recent chance to the purchase order.
PO Status	The current status value of the purchase order, for example: Canceled, Closed, Created, Partially Shipped, Receiving Started, Shipped.
Units Expected	Number of units expected for the purchase order. You can click the value in this column to jump to the PO Reconciliation Details second-level dashboard for a more detailed view of this purchase order.
Units Shipped	Number of units shipped for the purchase order. You can click the value in this column to jump to the PO Reconciliation Details second-level dashboard for a more detailed view of this purchase order.
Units Received	Number of units actually received for the purchase order. You can click the value in this column to jump to the PO Reconciliation Details second-level dashboard for a more detailed view of this purchase order.
Units Putaway	Number of units put away for the purchase order. You can click the value in this column to jump to the PO Reconciliation Details second-level dashboard for a more detailed view of this purchase order.
Remain to Receive	Number of units not yet received for the purchase order. You can click the value in this column to jump to the PO Reconciliation Details second-level dashboard for a more detailed view of this purchase order.
Remain To Putaway	Number of units left to be put away. This value is calculated as (Received Units - Putaway Units). You can click the value in this column to jump to the PO Reconciliation Details second-level dashboard for a more detailed view of this purchase order.

PO Reconciliation Details

PO Reconciliation Details is a second-level dashboard. You can reach it by clicking numeric values in any of several columns in the main PO Reconciliation Summary report. The details dashboard opens in a new browser tab. To return to the main report, close the tab for the second-level dashboard.

The filters panel for the details dashboard are preset for the specific Seller, Facility, and PO Number from the table row that you clicked. You can make additional filter selections, for example, to find information related to a specific Item Number, Client Item Number, or UPC Number.

PO Reconciliation by Item

This table provides the PO Line level view of the data as being interfaced to Radial or actively worked on by Radial Operations.

Column	Description
Seller Name	The name of the seller or sub-client, as set up in the order management system.
Seller ID	A unique identifier for the seller or sub-client, as set up in the order management system. Usually a seller corresponds to one sales channel, for example, a webstore serving a particular geographic region operating under a particular name.
Facility Name	Name of the warehouse or distribution center.
Facility ID	Unique identifier for the warehouse or distribution center.
PO Number	Client purchase order (PO) number.
PO Created Date	Date when the purchase order was created.
Last Updated Date	Date of the most recent chance to the purchase order.
PO Status	The current status value of the purchase order, for example: Canceled, Closed, Created, Partially Shipped, Receiving Started, Shipped.
Item Number	A unique identifier for the item. Typically, Radial-assigned catalog ID followed by client-assigned SKU number for the item.
Client Item Number	The client's unique identifier for the item.
UPC Number	Universal Product Code, a manufacturer-assigned number that corresponds to a barcode for the item.
Item Description	A text description of the item or SKU.
Product Status	A status code for the product corresponding to this Item Number and UPC.
Units Expected	Number of units expected for the purchase order.
Units Shipped	Number of units shipped for the purchase order.
Units Received	Number of units actually received for the purchase order.
Units Putaway	Number of units put away for the purchase order.
Remain to Receive	Number of units not yet received for the purchase order.
Remain To Putaway	Number of units left to be put away. This value is calculated as (Received Units - Putaway Units).

PO Inbound Transaction Details

This table provides all the transactions that occurred in the warehouse management system against the selected PO.

Column	Description
Seller Name	The name of the seller or sub-client, as set up in the order management system.
Seller ID	A unique identifier for the seller or sub-client, as set up in the order management system. Usually a seller corresponds to one sales channel, for example, a webstore serving a particular geographic region operating under a particular name.
Facility Name	Name of the warehouse or distribution center.
Facility ID	Unique identifier for the warehouse or distribution center.
PO Number	Client purchase order (PO) number.
ASN Number	The number of the advanced shipping notice related to the purchase order.
PO ASN Type	The type of source for the ASN. Values are based on how the ASN was created. X = ASN was created for a PO YES = ASN was created, not against a PO NO = Unknown how ASN was created
Item Number	A unique identifier for the item. Typically, Radial-assigned catalog ID followed by client-assigned SKU number for the item.
Client Item Number	The client's unique identifier for the item.
UPC Number	Universal Product Code, a manufacturer-assigned number that corresponds to a barcode for the item.
Item Description	A text description of the item or SKU.
Unit Price	Unit cost of the SKU. If this information is not provided by the seller, the value is set to $0.
Retail Price	Unit selling price of the SKU. If this information is not provided by the seller, the value is set to $0.
LPN Number	An identifier for a pallet or grouping of containers in shipping.
Received Date	Date when the items in the PO were received.
Received Units	Number of units actually received for the purchase order.
Putaway Date	Date when the items in the PO were put away.
Putaway Units	Number of units put away for the purchase order.