BAQ not working in Kinetic

Kinetic ERP
1

I have a BAQ that is working perfectly in classic and Kinetic. I created the dashboard in Classic first, just because I am still more accustomed to classic to ensure it could be done first, but when I create it in application studio, I do not get any data.

The purpose of this BAQ was to pull into a report showing the tooling we need to order. BUT we are trying to pull anything we can into a dashboard instead of a report. On the Classic Dashboard, I had filtered it to only show if Calculated_POCal is > 0, displaying all tooling that was below the threshold between on hand and on order.

Hoping someone can see an issue with my BAQ and let me know where I went wrong?

/*  
 * Disclaimer!!! 
 * This is not a real query being executed, but a simplified version for general vision. 
 * Executing it with any other tool may produce a different result. 
 */

select distinct  
	[Part].[PartNum] as [Part_PartNum], 
	[Part].[PartDescription] as [Part_PartDescription], 
	[PartWhse].[MinimumQty] as [PartWhse_MinimumQty], 
	[PartWhse].[MaximumQty] as [PartWhse_MaximumQty], 
	[PartWhse].[WarehouseCode] as [PartWhse_WarehouseCode], 
	[PartWhse].[OnHandQty] as [PartWhse_OnHandQty], 
	[PODetail].[OpenLine] as [PODetail_OpenLine], 
	((case when PODetail.OpenLine = 1 then sum(PODetail.OrderQty) else 0 end)) as [Calculated_SumOrders], 
	(ISNULL(sum(RcvDtl.OurQty), 0)) as [Calculated_SumRec], 
	((case 
      when (PartWhse.MaximumQty >= 1) and (PartWhse.OnHandQty = 0) OR (PartWhse.OnHandQty + SumRec <= PartWhse.MinimumQty) and (PODetail.OpenLine  = 0) then 1
      
      when (PartWhse.MinimumQty > '0') and PartWhse.OnHandQty <= PartWhse.MinimumQty  then 1 
      
      when (PartWhse.MaximumQty > '0') and PartWhse.OnHandQty <= PartWhse.MinimumQty  then 1 
      
      else 0

 end)) as [Calculated_IdentOrder], 
	[PORel].[WarehouseCode] as [PORel_WarehouseCode], 
	((case 
     when identOrder = 1 and PartWhse.warehouseCode = PORel.WarehouseCode then 1 
     else 0 
end)) as [Calculated_POCal], 
	(case  
    
    when (IdentOrder = 1 and POCal = 1 and SumRec >= '1') then (PartWhse.MaximumQty - (PartWhse.OnHandQty + SumOrders - SumRec))
    
    when (IdentOrder = 1 and POCal = 1 and SumRec = 0) then (PartWhse.MaximumQty - (PartWhse.OnHandQty + SumOrders))
    
    when (IdentOrder = 1 and POCal = 0 and PODetail.OpenLine = 1) then (PartWhse.MaximumQty - (PartWhse.OnHandQty + SumOrders - SumRec ))
       
    when (IdentOrder = 1 and POCal = 0) then (PartWhse.MaximumQty - PartWhse.OnHandQty)
    
      
end) as [Calculated_CalRep], 
	((case when CalRep > 1 then 1 else 0 end)) as [Calculated_CalRep2] 

from Erp.Part as [Part]
inner join Erp.PartWhse as [PartWhse] on 
	  Part.Company = PartWhse.Company
	and  Part.PartNum = PartWhse.PartNum
	and ( (PartWhse.WarehouseCode = 'P1Tool'  
or PartWhse.WarehouseCode = 'P3Tool'  
or PartWhse.WarehouseCode = 'P5Tool'  
or PartWhse.WarehouseCode = 'EM2' ) )
left outer join Erp.PODetail as [PODetail] on 
	  Part.Company = PODetail.Company
	and  Part.PartNum = PODetail.PartNum
	and ( (PODetail.OpenLine = 1 ) )
left outer join Erp.PORel as [PORel] on 
	  PODetail.Company = PORel.Company
	and  PODetail.PONUM = PORel.PONum
	and  PODetail.POLine = PORel.POLine
	and ( PORel.OpenRelease = True  )
left outer join Erp.RcvDtl as [RcvDtl] on 
	  PORel.Company = RcvDtl.Company
	and  PORel.PONum = RcvDtl.PONum
	and  PORel.POLine = RcvDtl.POLine
	and  PORel.PORelNum = RcvDtl.PORelNum
	and  PORel.WarehouseCode = RcvDtl.WareHouseCode
	and ( (RcvDtl.ReceivedComplete = 0 ) )
left outer join Erp.PartPlant as [PartPlant] on 
	  Part.Company = PartPlant.Company
	and  Part.PartNum = PartPlant.PartNum
left outer join Erp.Vendor as [Vendor] on 
	  PartPlant.Company = Vendor.Company
	and  PartPlant.VendorNum = Vendor.VendorNum
where (Part.TypeCode = 'p')
group by 
	[Part].[PartNum], 
	[Part].[PartDescription], 
	[PartWhse].[MinimumQty], 
	[PartWhse].[MaximumQty], 
	[PartWhse].[WarehouseCode], 
	[PartWhse].[OnHandQty], 
	[PODetail].[OpenLine], 
	[PORel].[WarehouseCode]
order by PartWhse.WarehouseCode, Part.PartNum
1 Like
2

Hi Lisa,

Is your BAQ returning data in the BAQ editor? If so, check the network tab in the developer tools to make sure it’s actually being called from your application.

I had the same problem this morning. My issue was down to the wizard guided setup missed setting the BAQ ID for the grid under ‘Grid Model’ → ‘Provider Model’. Without this, it wasn’t ever actually calling the BAQ.

Hope this helps,

Nathan

1 Like
3

HAHAHA, the wizard isn’t even there today!

4

The New Application Wizard or the Grid Wizard? Last week, I noticed that the New Application Wizard doesn’t come up if you’ve opened Application Studio in a new tab - reported to Epicor under problem PRB0305471

1 Like
5

If your Classic dashboard works then I doubt the issue is with your BAQ. How did you create the Kinetic dashboard? By hand or having it generate automatically in Classic Deploy:

image
image444×434 37.5 KB

6

@brendanphilbin, Application Wizzard is not showing. I do open in its own window. I will check that, thank you.

@Randy, I have tried both ways, deploying from classic and manual creation (created different application names to compare) and cannot find a difference, but it works in classic.

7

Have you tried the template method mentioned in the link below? We use this method now and I prefer it over the wizards except for super easy dashboards (1 grid no filters).

1 Like