Hello, I have one BAQ below that pulls in values which exports into an excel automatically for our stock feed website, however I have a secondary BAQ which has pulled in the “Finished Stock Qty” for some PartMtl Raw table lamp bases we have so for example 10 in stock against raw code 823347-TL it pulls through against the finish sku ANTONIA-TL I want to add the values from the calculated column to the column untested in my main BAQ
Is there any common PartNum between both queries? Just sounds two sub-queries.
I would probably create a UD Field in Part Master Part_UD.Untested and then I would be able to join like below. One query pointing to the Finished Stock and then other query pointing to my UD field in part master. 
1 Like
Hello Miguel,
So for example the main stock file is 3820 sku’s but these raw bases that I have got against the finished sku is only about 42 so I made the connector just do all part’s from the Part table but yes the sku’s will match
Also the only issue is that the raw bases will drop in quantity when used in MRP’s etc