The report shows fulfillment details for authorised 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 authorised users using the Report Scheduling feature available to DEAR customers with the Automation module subscription. See Report Scheduling for more information.

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


Table of Contents

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


Reporting PeriodAllows 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.
LayoutSet to the Default layout. Allows selection of saved layouts, if any. 
Save Layout AsAllows saving a layout for potential future use.
Reset LayoutResets 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 DEAR Reports - Filtering Reports for more detailed information about using filters. 


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.  

SKUSKU of the product
ProductName of the product
Order #Order number
Order DateDate the order was authorised
CustomerCustomer name
Fulfillment StatusStatus of the fulfillment (Packed, Partially Fulfilled, Shipped, etc.)
Fulfillment #Fulfillment number of the sale
CarrierCarrier name, for shipped orders
Tracking #Carrier tracking number for shipped orders
Quantity OrderedOrder quantity of the product
Customer ReferenceCustomer reference from the sale document header
Sales RepresentativeName of the sales representative who handled the order
YearYear the order was authorised
QuarterQuarter of the calendar the order was authorised
MonthMonth the order was authorised
Shipment DateDate on which ship was authorised
Required by dateRequired 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 NoteShows the information saved in the Shipment Note field under the Ship tab in Advanced Sale
LocationSale header location
BrandProduct Brand
CategoryProduct Category
FamilyProduct Family name
Product TagsComma-separated product tags
UnitProduct unit of measure
Batch/lotBatch/lot number of the product
Shipping AddressLine 1 of the shipping address
CityShipping address city
StateShipping address state
CountryShipping address country
TaxTax associated with the order
TotalTotal value of the order = Amount + Tax
Customer Additional Attribute 1-10Values of customer additional attributes
Product Additional Attribute 1-10Values of product additional attributes
Data Headers
Quantity PickedQuantity picked of SKU
Quantity PackedQuantity packed of SKU
Quantity ShippedQuantity shipped of SKU

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


[back to top]

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 authorised. In the case of Advanced Sale, this could refer to partial pick.
  • PACKED - the Pack tab of the order has been authorised. In the case of Advanced Sale, this could refer to partial pick.
  • SHIPPED - the Ship tab of the order has been authorised. 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 DEAR support.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.