List of Contributions

I want to create a dashboard that will show what the Primary Bun number is for some parts, I can see from looking at the tech details for the field that the info is in the PartWhse table, and the field is PrimBinNum. But when I add it to a BAQ, that field is not visible at all. Not sure why, so wondering ...

I will give this a try and see if I can make this work.

Wondering if anyone has created a BAQ report or Dashboard that is utilizing a recursive BAQ to create COSTED indented BOM report. If so, would you be willing to share that BAQ with all of us? I have been told that using a CTE query that a recursive BAQ could create a better Costed BOM report that is ...

Okay I got this to work here is what I did: with [SubQuery1] as (select [PartTran].[PartNum] as [PartTran_PartNum], [PartTran].[TranType] as [PartTran_TranType], [PartTran].[TranDate] as [PartTran_TranDate], [Part].[TypeCode] as [Part_TypeCode], (case when Row_Number() OVER (Partition BY Part.PartNum ...

I like what you have there, but confused on how to apply it to what I need. So For all active parts in out PART table, we want to get the earliest date for either the STK-MTL or PUR-STK transaction ( in the PartTran table , where the TranType is either the STK-MTL or PUR-STK. I need to get that date ...