I have an AOT query that gives me the quantity of items on sales lines by item Id and inventory dimension. It is a simple query that just returns the ItemId, InventDimId and SalesQty for open sales The query is incorporated into a view in order to populate a grid in D365FSC. The query looks like the screen shot below:
In the view, I have the SalesQty field set with an Aggregation of Sum. This gives me each item/inventory dimension combination with the quantity of the item being sold.
My problem is I need to be able to filter the query by date. If I add the ShippingDateRequested field to the view, my sum then becomes item id/inventory dim/ShippingDateRequested, which I don’t want. If I don’t have the ShippingDateRequested field, I don’t have a way of setting a date range.
I added a ShippingDateRequested range to the AOT query and left the ShippingDateRequested off the view, but when I try to set the value of the query range, I get an error that the field doesn’t exist in the view.
Is there a way I can set a date range for these sales orders lines and not have them show up on the view?