BAQ Error

Epicor ERP 9
1

I am trying to do a simple BAQ and just have crazy issues. I am sure I am missing something simple.

I have PartBin and WhseBin (only non-netteable)

I am trying to sum the Parts on hand. They are in multiple bin locations and i get the following error. i am using TOTAL to calculate total On hand Qty.

PartBin Company must be a quoted constant or an unabbreviated, unambiguous buffer/field reference for buffers known to query . (7328)

2

Is this total on hand per part per warehouse?
Or total pieces on hand per bin?
Or total pieces on hand per part per bin?

1 Like
3

Try first making the BAQ without summing up the QOH by Partnum.

The Query Phrase in E10 is

select 
	[PartBin].[PartNum] as [PartBin_PartNum],
	[PartBin].[BinNum] as [PartBin_BinNum],
	[PartBin].[OnhandQty] as [PartBin_OnhandQty],
	[WhseBin].[NonNettable] as [WhseBin_NonNettable]
from Erp.PartBin as PartBin
inner join Erp.WhseBin as WhseBin on 
	PartBin.Company = WhseBin.Company
And
	PartBin.WarehouseCode = WhseBin.WarehouseCode
And
	PartBin.BinNum = WhseBin.BinNum
 and ( WhseBin.NonNettable = FALSE  )

If you can’t get that to work, try it without having the table criteria that filters on non-netable

If the query works, go back and remove the PartBin and Non-Nettable from the displayed fields. Then apply grouping by partnumber and add the calculated field for TOTAL(OnHandQty).

I know E10 is different, but your query phrase should look something like:

select 
	[PartBin].[PartNum] as [PartBin_PartNum],
	(SUM(PartBin.OnhandQty)) as [Calculated_QOHinNonNetable]
from Erp.PartBin as PartBin
inner join Erp.WhseBin as WhseBin on 
	PartBin.Company = WhseBin.Company
And
	PartBin.WarehouseCode = WhseBin.WarehouseCode
And
	PartBin.BinNum = WhseBin.BinNum
 and ( WhseBin.NonNettable = TRUE)

group by [PartBin].[PartNum]
4

I ended doing a View in SQl and creating an External BAQ.

Thanks