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
how do i determine these parameters to divide by 1 or 10 or 100 or 1000?
Thank you so much have a nice day!