How can I get the CostPer of PODetail with BAQ

how to get RptCalcField: CostPer of PODetail in Report Data Definition: POForm
with BAQ


I don’t know how to calculate the formula of this file or where the data is stored so I can write BAQ to get CostPer

select 
	[PODetail].[Company] as [PODetail_Company],
	[PODetail].[PONUM] as [PODetail_PONUM],
	[PODetail].[POLine] as [PODetail_POLine],
	[PODetail].[LineDesc] as [PODetail_LineDesc],
	[PODetail].[IUM] as [PODetail_IUM],
	[PODetail].[OrderQty] as [PODetail_OrderQty],
	[PODetail].[XOrderQty] as [PODetail_XOrderQty],
	[PODetail].[UnitCost] as [PODetail_UnitCost],
	[PODetail].[DocUnitCost] as [PODetail_DocUnitCost],
	[PODetail].[PUM] as [PODetail_PUM],
	[PORel].[PORelNum] as [PORel_PORelNum],
	[PORel].[DueDate] as [PORel_DueDate],
	[PORel].[XRelQty] as [PORel_XRelQty],
	[PORel].[RelQty] as [PORel_RelQty],
	[PORel].[Plant] as [PORel_Plant],
	[PORel].[OrderRelNum] as [PORel_OrderRelNum],
	[Company].[Name] as [Company_Name],
	[Company].[Address1] as [Company_Address1],
	[Company].[Address2] as [Company_Address2],
	[Company].[Address3] as [Company_Address3],
	[Company].[City] as [Company_City],
	[Company].[Company] as [Company_Company],
	[Company].[Country] as [Company_Country],
	[Company].[PhoneNum] as [Company_PhoneNum],
	[Company].[FaxNum] as [Company_FaxNum],
	[Company].[StateTaxID] as [Company_StateTaxID],
	[Company].[TaxRegionCode] as [Company_TaxRegionCode],
	[Company].[TaxRegReason] as [Company_TaxRegReason],
	[Company].[Character03] as [Company_Character03]
from Erp.PODetail as PODetail
inner join Erp.POHeader as POHeader on 
	PODetail.Company = POHeader.Company
	and PODetail.PONUM = POHeader.PONum
inner join Erp.PORel as PORel on 
	PODetail.Company = PORel.Company
	and PODetail.PONUM = PORel.PONum
	and PODetail.POLine = PORel.POLine
inner join Erp.Company as Company on 
	Company.Company = PODetail.Company
where (PODetail.PONUM = @PONum)
select distinct CostPerCode from PODetail

image
how do i determine these parameters to divide by 1 or 10 or 100 or 1000?

:thinking: :thinking: :thinking:
Thank you so much have a nice day! :smiling_face_with_three_hearts:

I’m not sure if tis answers your question, but in BAQs our formula typically looks like this

(case
when PODetail.CostPerCode = ‘E’ then (OpenQtyPODetail.UnitCost)
when PODetail.CostPerCode = ‘C’ then (OpenQty
PODetail.UnitCost)/100
when PODetail.CostPerCode = ‘M’ then (OpenQtyPODetail.UnitCost)/1000
else (OpenQty
PODetail.UnitCost)

** OpenQty is (PORel.RelQty - PORel.ReceivedQty)

2 Likes

yes but here I see in the PO report there are /10 people so I want to ask to confirm if there is 10% because I checked the data also only E, C, M corresponds to /1 /100 and / 1000
Thank you have a good day!

Not that I’m aware of there isn’t… It’s only 1, 100 or 1000

1 Like