Add fields to Fulfillment Details Report
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.