Jira code: CORP:13
There is no standard way to include the sales order number in this report because the transaction record available here shows the details from item fulfilment and the item receipt. This report shows the systematic flow of items like what is the beginning inventory and how the stock is changed. Also, the current quantity on hand is also shown in this report. This report as such cannot be replicated to a new report, if we do like this, then we will not get this inventory change over time. The solution is to add a hidden field called ‘created by’ in the item fulfilment page and source the standard ‘Created By’ field in that item fulfilment to this newly created custom field so that even if the field is hidden we can get this in the report. After creating this field, create a workflow in the item fulfilment page to source this value. Then we can add this new custom field in the inventory activity report. In the report, the sales order number will be sourced here but when we click the sales order number the item fulfilment will be opened as it is fetched from the item fulfilment itself.