Hi All
Â
I am trying to use the following BAQ to show all order lines and the demand/available stock.
Â
That part works.
Â
But then I want to only display the closest requestdate for the part.
Â
So if there are several orders with the same part on, one tomorrow, one in 2 week and one in a month, I only want the BAQ to display the 'FIRST' time it occurs and ignore the other times it appears.
Â
However, FIRST seems to be pulling on the order in which the order was added.
Â
For example, it the order for two weeks time was added before the order where the part is due tomorrow, it will show the order for two weeks time instead - which I dont want.
Â
Here is the BAQ ...
Â
for first OrderDtl no-lock where OrderDtl.OpenLine = TRUE , each Part no-lock where (Part.Company = OrderDtl.Company and Part.PartNum = OrderDtl.PartNum ) , each PartWhse no-lock outer-join where (Part.Company = PartWhse.Company and Part.PartNum = PartWhse.PartNum ) by OrderDtl.PartNum by OrderDtl.RequestDate .
Â
Any help would be appreciated.
Â
Thanks.
[Non-text portions of this message have been removed]
Â
I am trying to use the following BAQ to show all order lines and the demand/available stock.
Â
That part works.
Â
But then I want to only display the closest requestdate for the part.
Â
So if there are several orders with the same part on, one tomorrow, one in 2 week and one in a month, I only want the BAQ to display the 'FIRST' time it occurs and ignore the other times it appears.
Â
However, FIRST seems to be pulling on the order in which the order was added.
Â
For example, it the order for two weeks time was added before the order where the part is due tomorrow, it will show the order for two weeks time instead - which I dont want.
Â
Here is the BAQ ...
Â
for first OrderDtl no-lock where OrderDtl.OpenLine = TRUE , each Part no-lock where (Part.Company = OrderDtl.Company and Part.PartNum = OrderDtl.PartNum ) , each PartWhse no-lock outer-join where (Part.Company = PartWhse.Company and Part.PartNum = PartWhse.PartNum ) by OrderDtl.PartNum by OrderDtl.RequestDate .
Â
Any help would be appreciated.
Â
Thanks.
[Non-text portions of this message have been removed]