search-icon

Add fields to Fulfillment Details Report

started a topic about 2 years ago

We need a single report which shows the following fields:

 

Location of each shipment/fulfilment (not the location selected in the Sales Order header, as we often have Sales Orders which are shipped from multiple locations and need to see the location each item was shipped from in order to calculate taxes and levies correctly).

Product

SKU

SO#

Qty shipped (from individual fulfilments, not a whole order)

Carrier (from Ship tab, not Sales Order header)

Tracking #

Unit

Customer Name

Customer Additional Attributes

Product Additional Attributes

Order Additional Attributes

Order Date

Shipment Date (from individual fulfilments, not just the last shipment date present in the Sales Order, which I think is how some reports show this)

Customer Reference

Bin

Category (of products)

 

The closest report available at the moment is the Fulfillment Details Report, which is good because it splits rows into individual fulfilments as we need, however this is currently missing the fields "Unit", and "Bin", and the Location shown in the rows of the report is currently pulled from the Sales Order header, not the individual fulfillments, which is what we need. Could this report be updated to include these three additional pieces of information, or a new report created which covers everything we need?

 

Thank you.


1 person likes this idea
  • Yes I would also include 'Pick Location' so we can see where it finally dispatched from instead of the Location at the header level.


    This would help us troubleshoot which orders from our ecommerce site had been accidently fulfilled from a different location at the line level due to issues with the Cin7-Shopify integration


    Thanks


    Rohit

Login or Signup to post a comment

1 person likes this idea
Log in or Sign up to post a comment