Hello
Use Case :
AR Team would like a report that displays fulfillable items for open sales orders that reflects the Quantity Fulfilled, which is easy enough, but they'd like to see the total quantity fulfilled by Period if possible.
Example Scenario :
Sales Order ABC has a fulfillable item with a quantity sold of 36. There are three Item Fulfillment transactions against SO-ABC , two in February, fulfilling a quantity 8 on one entry and 2 on another, and one in March fulfilling a quantity of 12.
In the output, the AR team would like to see something on the order of :
SOA-BC Quantity Sold Quantity Fulfilled Fulfilled in Period
36 10 Jan 2026
36 12 Feb 2026
Ideally they'd like to have the actual fulfillment date and if possible the item fulfillment transaction included in the output as well. I have been running through different ways to land the results, ways of summarizing or not, etc, and its so close but its not quite landing exactly as they'd like. For sure if I include the actual fulfillment date and/or the item fulfillment transaction, the quantity column results go sideways.
Does anybody have any tips or tricks I'm missing or forgetting?
Thanks!