Hi Epicor Community,
I’m trying to add a field in SOPickL report but got an error, am I missing some steps?
Appreciate you guys help
Add the field in using the GUI - you’ll see then how it’s expecting it to look.
Go into the expression editor, in the bottom section look for Datasets, find your field in the relevant one and double click it.
1 Like
this field wasn’t in the default report, so i need to add in the field and I followed the steps that I have seen, could be I’m missing some steps?
1 Like
So you need to add it into the query string, and then also add it as a field.
Go to the properties of the dataset, then fields. Add in as a query field, using exactly the same name as what you put in the query string something like T1.MyField.
1 Like
Ok, that error is coming from upstream in the RDD.
Open the Report Data Definition that is used by your report style. Go to Report Tables, then find the Customer table. On the Excluded Columns tab, make sure the check box is clear next to Company (and any other key columns used in the Relationship such as CustNum).
1 Like
Hi @markdamen ok I got it working now, thanks for the help
1 Like
Hey @markdamen I’m trying to add tax in parttranrpt but got error
also do i need to do relationship with part trans and PO header?
=“SELECT T1.ActTranQty,T1.AsOfDate,T1.AssemblySeq,T1.AssetNum,T1.BurUnitCost,T1.Calc_DocNum,T1.Calc_InvoiceNum,T1.Calc_LineNum,T1.Calc_PrintedBy,T1.Calc_SNList,T1.Calc_VendorAddrList,
T1.Calc_VendorID,T1.Calc_WareHouseDesc,T1.Company,T1.EmpID,T1.ExtCost,T1.InvAdjReason,T1.JobNum2,T1.JobSeq2,T1.LotNum2,T1.OrderLine,T1.OrderNum,T1.PackLine,T1.PackNum,T1.PackSlip,
T1.PBInvNum,T1.PORelNum,T1.POUnitCost,T1.ProjProcessed,T1.SubUnitCost,T1.SysDate,T1.SysTime,T1.TranDocTypeID,T1.TranNum,T1.TranQty,T1.WareHouse2,T1.AdditionNum,T1.AsOfSeq,
T1.AssemblySeq2,T1.BinNum,T1.BinNum2,T1.BinType,T1.Calc_Bin2Description,T1.Calc_BinDescription,T1.Calc_EntryPerson,T1.Calc_InvoiceDate,T1.Calc_ReasonDescription,
T1.Calc_WareHouse2Desc,T1.Calc_Weight,T1.DisposalNum,T1.EntryPerson,T1.InvAdjSrc,T1.JobNum,T1.JobSeq,T1.LbrUnitCost,T1.LegalNumber,T1.LoanFlag,T1.LotNum,T1.MscNum,
T1.MtlUnitCost,T1.OrderRelNum,T1.PartDescription,T1.PartNum,T1.Plant,T1.Plant2,T1.POLine,T1.PONum,T1.POReceiptQty,T1.PurPoint,T1.TranDate,T1.TranReference,T1.TranType,
T1.UM,T1.WareHouseCode,T1.RptLanguageID,T1.MtlBurUnitCost,T1.PCID, T2.TotalOrder, T2.TotalTax, T2.DocTotalOrder, T2.DocTotalTax
FROM PartTran_” + Parameters!TableGuid.Value + " T1"
LEFT OUTER JOIN POHeader " + Parameters!TableGuid.Value + " T2"
ON T1.Company = T2.Company and T1.PONum = T2.PONum
Please start a new thread on this topic - this one is already marked resolved and the new request is more involved. Cheers.