Hello, I need someones help. I am not sure what I am missing here.
I have been asked to create a BAQ containing the following:
- List of Part Numbers on Hold
- Type of Hold
- ECR Number
- Only the Latest Open Sales Order Number per part
- Latest Open Sales Order Date per part
Example: Order 1 for part A was placed 6/01/2020. Order 2 for part A was placed 6/20/2020. I only want the Sales Order that was entered first which would be Order 1.
I have attempted to use the calculation field and used Min(OrderDate), however I still return multiple Sales order for each part. I only want one, the oldest sales order date per part number.
Here is what I have tried.
I created a subquery shown below:
The fields I pulled for the Subquery:
Then I created an Top Level Query, per shown below:
The fields I pulled for the Top Level:
The Calculated fields I tried to make:
My failed results where the highlighted lines would be what I want displayed out of the group of results. Also not sure how to handle different orders for the same part that have the same date (Highlighted in Green):
Thank you ahead of time!