Fulfillment Details Report

The report shows fulfillment details for authorized sales orders. Use this report to see the fulfillment status for each order, with quantity picked, packed and shipped. The output can be customised to show carrier, tracking info and more.

This report can be automatically generated and sent out to authorized users using the Report Scheduling feature available to Cin7 Core customers with the Automation module subscription. See Report Scheduling for more information.

Note: Non-inventory products are not shown in this report.

Prerequisites

Managing Cin7 Core Reports

Data from this report can be exported in Excel, PDF or RTF format.

Input:

Reporting Period	Allows the user to select the reporting period from a list of options or set a custom date range. This report is filtered by sale order date.
Layout	Set to the Default layout. Allows selection of saved layouts, if any.
Save Layout As	Allows saving a layout for potential future use.
Reset Layout	Resets the layout to the default layout or selected saved layout.

Select Apply Filter to set filter fields for the report and Update to refresh the output with any new changes. See Managing Cin7 Core Reports - Filtering Reports for more detailed information about using filters.

Output:

The following output fields are available for this report. You may have to open the Configure Layout menu to add some of them to your report.

Fields
SKU	SKU of the product
Product	Name of the product
Order #	Order number
Order Date	Date the order was authorized
Required By	Date the order is required by
Customer	Customer name
Fulfillment Status	Status of the fulfillment (Packed, Partially Fulfilled, Shipped, etc.)
Fulfillment #	Fulfillment number of the sale
Carrier	Carrier name, for shipped orders
Tracking #	Carrier tracking number for shipped orders
Quantity Ordered	Order quantity of the product
Customer Reference	Customer reference from the sale document header
Sales Representative	Name of the sales representative who handled the order
Year	Year the order was authorized
Quarter	Quarter of the calendar the order was authorized
Month	Month the order was authorized
Shipment Date	Date on which ship was authorized
Required by date	Required by date from sale document header
Invoice #	Invoice number. If there are multiple invoices for a fulfillment, these are displayed with comma-delimited tags.
Shipment Note	Shows the information saved in the Shipment Note field under the Ship tab in Advanced Sale
Location	Sale header location
Brand	Product Brand
Category	Product Category
Family	Product Family name
Product Tags	Comma-separated product tags
Unit	Product unit of measure
Batch/lot	Batch/lot number of the product
Shipping Address	Line 1 of the shipping address
City	Shipping address city
State	Shipping address state
Country	Shipping address country
Tax	Tax associated with the order
Total	Total value of the order = Amount + Tax
Customer Additional Attribute 1-10	Values of customer additional attributes
Product Additional Attribute 1-10	Values of product additional attributes
Data Headers
Quantity Picked	Quantity picked of SKU
Quantity Packed	Quantity packed of SKU
Quantity Shipped	Quantity shipped of SKU

Note: If you have added an Additional Attribute set to your sale process, the attributes will appear as additional report fields.

FAQs

What are the possible Fulfillment Statuses and their definitions?

NOT FULFILLED - nothing on the order has been picked, packed or shipped.
PICKED - the Pick tab of the order has been authorized. In the case of Advanced Sale, this could refer to partial pick.
PACKED - the Pack tab of the order has been authorized. In the case of Advanced Sale, this could refer to partial pick.
SHIPPED - the Ship tab of the order has been authorized. At least one line item of the order has shipped.
FULFILLED means every line item of a sale order has been shipped.

Still no answer to your question? Please do not hesitate to get in touch with Cin7 Core support.

Fulfillment Details Report

Prerequisites

Input:

Output:

FAQs

Was this article helpful?