@Bart_Elia Just curious what is the best way to get an issue over to Epicor. I guess it would be an enhancement. I feel the issues and working around the RDD and SSRS could be eliminated with some modifications on Epicor side. But I know when putting in a ticket it can be a battle especially when modifying it. Any suggestions how to suggest enhancements or to get to Epicor to review something.
1 Like
This is the Query from a SubReport on the AR Form. Why can anyone tell me why Epicor has added ALL these fields in a sub Report that requires so little…ONLY 5 fields needed on this report.
="SELECT T1.Company,T1.InvoiceNum,T1.PayDates,T1.DocPayAmount,T2.RptLiteralsLPaySch,T2.RptLiteralsLDuDate,T2.RptLiteralsLAmt,T2.RptLiteralsLTotal, T1.[CurrencyCode], T1.[InvcHeadSequence], T2.[DecimalsGeneral] as RptLabelsDecimalsGeneral, T2.[DecimalsPrice] as RptLabelsDecimalsPrice, T2.[DecimalsCost] as RptLabelsDecimalsCost, T2.[GlbDecimalsGeneral] as RptLabelsGlbDecimalsGeneral, T2.[GlbDecimalsPrice] as RptLabelsGlbDecimalsPrice, T2.[GlbDecimalsCost] as RptLabelsGlbDecimalsCost, T2.[RptLiteralsPage], T2.[RptLiteralsTime], T2.[RptLiteralsUser], T2.[RptLiteralsDate], T2.[RptLiteralsAUHdng], T2.[RptLiteralsGuiFormat], T2.[RptLiteralsLActQty], T2.[RptLiteralsLActQtyAmt], T2.[RptLiteralsLAGAFIPRespons], T2.[RptLiteralsLAGCAE], T2.[RptLiteralsLAGCAI], T2.[RptLiteralsLAGCUIT], T2.[RptLiteralsLAGDueDate], T2.[RptLiteralsLAGIIBB], T2.[RptLiteralsLAGIssueDate], T2.[RptLiteralsLAGRegTaxPayer], T2.[RptLiteralsLAllocDepAllocAmt], T2.[RptLiteralsLAllocDepAllocBal], T2.[RptLiteralsLAllocDepHdr], T2.[RptLiteralsLAllocDepInvDate], T2.[RptLiteralsLAllocDepInvNum], T2.[RptLiteralsLAllocDepTaxAmt], T2.[RptLiteralsLAUAccount], T2.[RptLiteralsLAUApply2Inv], T2.[RptLiteralsLAUAttAccRcv], T2.[RptLiteralsLAUBranch], T2.[RptLiteralsLAUBSB], T2.[RptLiteralsLAUCheque], T2.[RptLiteralsLAUCost], T2.[RptLiteralsLAUCreditNote], T2.[RptLiteralsLAUDirectDeposit], T2.[RptLiteralsLAUGST], T2.[RptLiteralsLAUHdng], T2.[RptLiteralsLAUHours], T2.[RptLiteralsLAULessDeposit], T2.[RptLiteralsLAULinear], T2.[RptLiteralsLAUMonetary], T2.[RptLiteralsLAUPercentage], T2.[RptLiteralsLAUPrice], T2.[RptLiteralsLAUSubTotal], T2.[RptLiteralsLAUTotal], T2.[RptLiteralsLAUTxID], T2.[RptLiteralsLBckOrd], T2.[RptLiteralsLBillablePcnt], T2.[RptLiteralsLBillTo], T2.[RptLiteralsLBurdenTotal], T2.[RptLiteralsLCodeDesc], T2.[RptLiteralsLComeFrom], T2.[RptLiteralsLComponents], T2.[RptLiteralsLContinueInNext], T2.[RptLiteralsLContractLbr], T2.[RptLiteralsLContractNo], T2.[RptLiteralsLCopy], T2.[RptLiteralsLCostMkpAmt], T2.[RptLiteralsLCPUActivityAmt], T2.[RptLiteralsLCurrentAmt], T2.[RptLiteralsLCusPart], T2.[RptLiteralsLDate], T2.[RptLiteralsLDescription], T2.[RptLiteralsLDirectLbrTotal], T2.[RptLiteralsLDiscountPercent], T2.[RptLiteralsLDraftCopy], T2.[RptLiteralsLEA], T2.[RptLiteralsLEMail], T2.[RptLiteralsLEMaila], T2.[RptLiteralsLExtAmt], T2.[RptLiteralsLExtPrice], T2.[RptLiteralsLFax], T2.[RptLiteralsLFaxa], T2.[RptLiteralsLFeeTotal], T2.[RptLiteralsLFFActQtyAmt], T2.[RptLiteralsLFinChargeAmt], T2.[RptLiteralsLFinCharges], T2.[RptLiteralsLFirstPrinted], T2.[RptLiteralsLFOB], T2.[RptLiteralsLFSAEquipmentPartNum], T2.[RptLiteralsLFSAServiceOrderNum], T2.[RptLiteralsLHComponents], T2.[RptLiteralsLHdng], T2.[RptLiteralsLImportedFrom], T2.[RptLiteralsLImportNum], T2.[RptLiteralsLINAmt], T2.[RptLiteralsLINBillTo], T2.[RptLiteralsLINCGST], T2.[RptLiteralsLINCommodityCode], T2.[RptLiteralsLINCustomerName], T2.[RptLiteralsLINDate], T2.[RptLiteralsLINDiscount], T2.[RptLiteralsLINElecrtonicRef], T2.[RptLiteralsLINGrandTotal], T2.[RptLiteralsLINIGST], T2.[RptLiteralsLINInvoiceNumber], T2.[RptLiteralsLINLessAdvBill], T2.[RptLiteralsLINLessPrepDeposit], T2.[RptLiteralsLINOrigInvc], T2.[RptLiteralsLINPrice], T2.[RptLiteralsLINQty], T2.[RptLiteralsLINRate], T2.[RptLiteralsLINSelfAssessment], T2.[RptLiteralsLINSGST], T2.[RptLiteralsLINShipTo], T2.[RptLiteralsLINSignature], T2.[RptLiteralsLINSrNo], T2.[RptLiteralsLINSubtitleCM], T2.[RptLiteralsLINSubtitleIGST], T2.[RptLiteralsLINSubtitleNonIGST], T2.[RptLiteralsLINSubTotal], T2.[RptLiteralsLINTaxValue], T2.[RptLiteralsLInternalUse], T2.[RptLiteralsLINTitle], T2.[RptLiteralsLINTotalTax], T2.[RptLiteralsLINUOM], T2.[RptLiteralsLInvoice], T2.[RptLiteralsLInvSubTotal], T2.[RptLiteralsLInvThrough], T2.[RptLiteralsLIssuerIDIssDate], T2.[RptLiteralsLIssuerIDType], T2.[RptLiteralsLIssuerName], T2.[RptLiteralsLIssuerPrsnIDCode], T2.[RptLiteralsLIssuerSerialNum], T2.[RptLiteralsLIssuerSurname], T2.[RptLiteralsLKit], T2.[RptLiteralsLKitComponents], T2.[RptLiteralsLKits], T2.[RptLiteralsLKitSeq], T2.[RptLiteralsLLaborFee], T2.[RptLiteralsLLegalText], T2.[RptLiteralsLLegNum], T2.[RptLiteralsLlessAdvBill], T2.[RptLiteralsLLessPrepDeposits], T2.[RptLiteralsLLine], T2.[RptLiteralsLLineRef], T2.[RptLiteralsLLinesSubtotal], T2.[RptLiteralsLMaterial], T2.[RptLiteralsLMaterialFee], T2.[RptLiteralsLMiscChgs], T2.[RptLiteralsLMsWrkActivity], T2.[RptLiteralsLMWActCPU], T2.[RptLiteralsLMWActivity], T2.[RptLiteralsLMXAdvBill], T2.[RptLiteralsLMXAmount], T2.[RptLiteralsLMXCertDateTime], T2.[RptLiteralsLMXCertificateNumber], T2.[RptLiteralsLMXCertificateSN], T2.[RptLiteralsLMXCM], T2.[RptLiteralsLMXCurrency], T2.[RptLiteralsLMXDeposit], T2.[RptLiteralsLMXDescription], T2.[RptLiteralsLMXDigitalSeal], T2.[RptLiteralsLMXDiscount], T2.[RptLiteralsLMXExchangeRate], T2.[RptLiteralsLMXFolioFiscal], T2.[RptLiteralsLMXFooter], T2.[RptLiteralsLMXFormOfPayment], T2.[RptLiteralsLMXImportDate], T2.[RptLiteralsLMXImportNum], T2.[RptLiteralsLMXInvoice], T2.[RptLiteralsLMXIssuedBy], T2.[RptLiteralsLMXIssuer], T2.[RptLiteralsLMXMiscCharges], T2.[RptLiteralsLMXOriginalString], T2.[RptLiteralsLMXPage], T2.[RptLiteralsLMXPaymentMethod], T2.[RptLiteralsLMXPlaceAndDate], T2.[RptLiteralsLMXProdServCode], T2.[RptLiteralsLMXPuchaseType], T2.[RptLiteralsLMXQuantity], T2.[RptLiteralsLMXReceiptor], T2.[RptLiteralsLMXReceptorTaxId], T2.[RptLiteralsLMXRelated], T2.[RptLiteralsLMXReportTitle], T2.[RptLiteralsLMXSATSeal], T2.[RptLiteralsLMXSubtotal], T2.[RptLiteralsLMXTaxId], T2.[RptLiteralsLMXTaxRegime], T2.[RptLiteralsLMXTotal], T2.[RptLiteralsLMXTotalAmount], T2.[RptLiteralsLMXTransfer], T2.[RptLiteralsLMXUM], T2.[RptLiteralsLMXUMCFDI], T2.[RptLiteralsLMXUnitPrice], T2.[RptLiteralsLMYCreditNote], T2.[RptLiteralsLMYGross], T2.[RptLiteralsLMYGST], T2.[RptLiteralsLMYRefInvoiceNo], T2.[RptLiteralsLMYSubTotal], T2.[RptLiteralsLMYTaxInvoice], T2.[RptLiteralsLNo], T2.[RptLiteralsLNOKID], T2.[RptLiteralsLODC], T2.[RptLiteralsLODCFee], T2.[RptLiteralsLODCTotal], T2.[RptLiteralsLof], T2.[RptLiteralsLOrdered], T2.[RptLiteralsLOrdrd], T2.[RptLiteralsLOurPart], T2.[RptLiteralsLPackSlp], T2.[RptLiteralsLPage], T2.[RptLiteralsLPartDesc], T2.[RptLiteralsLPartNo], T2.[RptLiteralsLPartNum], T2.[RptLiteralsLPartRev], T2.[RptLiteralsLPEAdvBilling], T2.[RptLiteralsLPEApproved], T2.[RptLiteralsLPECorrelative], T2.[RptLiteralsLPECreditMemoF], T2.[RptLiteralsLPECreditMemoT], T2.[RptLiteralsLPECurrency], T2.[RptLiteralsLPEDebitNoteF], T2.[RptLiteralsLPEDebitNoteT], T2.[RptLiteralsLPEDiscounts], T2.[RptLiteralsLPEDocumentType], T2.[RptLiteralsLPEExchangeRate], T2.[RptLiteralsLPEExSales], T2.[RptLiteralsLPEExtPrice], T2.[RptLiteralsLPEIGV], T2.[RptLiteralsLPEInvoiceF], T2.[RptLiteralsLPEInvoiceT], T2.[RptLiteralsLPEISC], T2.[RptLiteralsLPEIssueDate], T2.[RptLiteralsLPENonTaxOper], T2.[RptLiteralsLPENumberSign], T2.[RptLiteralsLPEOtherCharges], T2.[RptLiteralsLPEOtherTaxes], T2.[RptLiteralsLPEQty], T2.[RptLiteralsLPEReasonCode], T2.[RptLiteralsLPEReceiptorAddress], T2.[RptLiteralsLPEReceiptorName], T2.[RptLiteralsLPERefDoc], T2.[RptLiteralsLPERUC], T2.[RptLiteralsLPESalesNoteF], T2.[RptLiteralsLPESalesNoteT], T2.[RptLiteralsLPEServiceProvided], T2.[RptLiteralsLPETaxOper], T2.[RptLiteralsLPETotalAmt], T2.[RptLiteralsLPETotalAmtTxt], T2.[RptLiteralsLPEUntPrice], T2.[RptLiteralsLPEUOM], T2.[RptLiteralsLPhone], T2.[RptLiteralsLPONum], T2.[RptLiteralsLPricePerUnit], T2.[RptLiteralsLPrintedAt], T2.[RptLiteralsLProblem], T2.[RptLiteralsLProjectFee], T2.[RptLiteralsLQty], T2.[RptLiteralsLQtyOrd], T2.[RptLiteralsLQtyPerParent], T2.[RptLiteralsLRateLegalText], T2.[RptLiteralsLRetention], T2.[RptLiteralsLRetentionAmt], T2.[RptLiteralsLRev], T2.[RptLiteralsLRounding], T2.[RptLiteralsLRUABefore], T2.[RptLiteralsLRUAddress], T2.[RptLiteralsLRUBAfter], T2.[RptLiteralsLRUBuyer], T2.[RptLiteralsLRUBuyer_INN_KPP], T2.[RptLiteralsLRUChiefAccountant], T2.[RptLiteralsLRUChiefAccountant_2], T2.[RptLiteralsLRUCIncrease], T2.[RptLiteralsLRUConsignorNameAddr], T2.[RptLiteralsLRUCorrInvoiceNum], T2.[RptLiteralsLRUCorrInvoiceRevNum], T2.[RptLiteralsLRUCorrRevisionNum], T2.[RptLiteralsLRUCostAmendment], T2.[RptLiteralsLRUCountryCode_2], T2.[RptLiteralsLRUCountryName_2], T2.[RptLiteralsLRUCurrency], T2.[RptLiteralsLRUCurrency_2], T2.[RptLiteralsLRUCurrencyName], T2.[RptLiteralsLRUCustomsDeclNumber], T2.[RptLiteralsLRUDDerease], T2.[RptLiteralsLRUExciseTax], T2.[RptLiteralsLRUExciseTax_2], T2.[RptLiteralsLRUFIO], T2.[RptLiteralsLRUFrom], T2.[RptLiteralsLRUGeneralManager], T2.[RptLiteralsLRUGeneralManager_2], T2.[RptLiteralsLRUImportedFrom], T2.[RptLiteralsLRUImportedFrom_2], T2.[RptLiteralsLRUIndividualEntrepr], T2.[RptLiteralsLRUIndividualEntrReq], T2.[RptLiteralsLRUNA], T2.[RptLiteralsLRUNoExcise], T2.[RptLiteralsLRUNoVAT], T2.[RptLiteralsLRUPage], T2.[RptLiteralsLRUPageOf], T2.[RptLiteralsLRUQuantity], T2.[RptLiteralsLRUQuantity_2], T2.[RptLiteralsLRUReceiverNameAddr], T2.[RptLiteralsLRURemark], T2.[RptLiteralsLRURevisionNum_2], T2.[RptLiteralsLRUSeller], T2.[RptLiteralsLRUSeller_INN_KPP], T2.[RptLiteralsLRUSignature], T2.[RptLiteralsLRUStatutoryRef1], T2.[RptLiteralsLRUStatutoryRef1_2], T2.[RptLiteralsLRUStatutoryRef1_c], T2.[RptLiteralsLRUStatutoryRef2], T2.[RptLiteralsLRUStatutoryRef2_2], T2.[RptLiteralsLRUStatutoryRef3], T2.[RptLiteralsLRUStatutoryRef3_2], T2.[RptLiteralsLRUStatutoryRef4], T2.[RptLiteralsLRUStatutoryRef4_2], T2.[RptLiteralsLRUStockItemDescr], T2.[RptLiteralsLRUTheSameAsSeller], T2.[RptLiteralsLRUToPaymentDocNo], T2.[RptLiteralsLRUTotalC], T2.[RptLiteralsLRUTotalD], T2.[RptLiteralsLRUTotalToPay], T2.[RptLiteralsLRUTotalWithoutVAT], T2.[RptLiteralsLRUTotalWithoutVAT_2], T2.[RptLiteralsLRUTotalWithVATInc_2], T2.[RptLiteralsLRUTotalWithVATIncl], T2.[RptLiteralsLRUToVATInvoice], T2.[RptLiteralsLRUUnitOfMeasure], T2.[RptLiteralsLRUUnitPriceVATExcl], T2.[RptLiteralsLRUUOMCode_2], T2.[RptLiteralsLRUUOMName_2], T2.[RptLiteralsLRUVATAmount], T2.[RptLiteralsLRUVATAmount_2], T2.[RptLiteralsLRUVatInvoiceNo], T2.[RptLiteralsLRUVATRate], T2.[RptLiteralsLRUVendorVATAmount], T2.[RptLiteralsLSalesKit], T2.[RptLiteralsLSalsRep], T2.[RptLiteralsLSeeBelow], T2.[RptLiteralsLSEOCR], T2.[RptLiteralsLShipTo], T2.[RptLiteralsLShpDt], T2.[RptLiteralsLShpVia], T2.[RptLiteralsLSlsTxID], T2.[RptLiteralsLSoldTo], T2.[RptLiteralsLSoldToL], T2.[RptLiteralsLSourceInvoiceNum], T2.[RptLiteralsLSubcontract], T2.[RptLiteralsLSubcontractFee], T2.[RptLiteralsLTax], T2.[RptLiteralsLTHBranch], T2.[RptLiteralsLTHBranchID], T2.[RptLiteralsLTHCMRefInvoiceNo], T2.[RptLiteralsLTHCopy], T2.[RptLiteralsLTHCreditNote], T2.[RptLiteralsLTHHeadOffice], T2.[RptLiteralsLTHRevisionDate], T2.[RptLiteralsLTHRevisionNum], T2.[RptLiteralsLTHServiceTax], T2.[RptLiteralsLTHTaxPayerNo], T2.[RptLiteralsLTrms], T2.[RptLiteralsLTWAbsentKeyWarning], T2.[RptLiteralsLTWAddress], T2.[RptLiteralsLTWAmount], T2.[RptLiteralsLTWAmountInWords], T2.[RptLiteralsLTWAndFixedAssetBase], T2.[RptLiteralsLTWAndPutVSign], T2.[RptLiteralsLTWBasedOnApproval], T2.[RptLiteralsLTWBusinessPersonSho], T2.[RptLiteralsLTWBuyer], T2.[RptLiteralsLTWBuyerAddress], T2.[RptLiteralsLTWBuyerGuiCode], T2.[RptLiteralsLTWBuyerName], T2.[RptLiteralsLTWBuyersNote], T2.[RptLiteralsLTWBuyersNoteColon], T2.[RptLiteralsLTWCertifiedCopy], T2.[RptLiteralsLTWCheckNumber], T2.[RptLiteralsLTWCitizenID], T2.[RptLiteralsLTWCompInvoice], T2.[RptLiteralsLTWDay], T2.[RptLiteralsLTWDeductible], T2.[RptLiteralsLTWDifferentiation], T2.[RptLiteralsLTWExempt], T2.[RptLiteralsLTWFixedAsset], T2.[RptLiteralsLTWForReportingCorru], T2.[RptLiteralsLTWForTheLotteryDraw], T2.[RptLiteralsLTWGuiFormat], T2.[RptLiteralsLTWGuiNumber], T2.[RptLiteralsLTWIfItIsOneTheTop], T2.[RptLiteralsLTWIfItIsOtherPrize], T2.[RptLiteralsLTWIfYouWantToReport], T2.[RptLiteralsLTWInTheFirstArticle], T2.[RptLiteralsLTWInvoiceApproved], T2.[RptLiteralsLTWInvoiceNote], T2.[RptLiteralsLTWInvoiceYearAndPer], T2.[RptLiteralsLTWLotteryDrawingDat], T2.[RptLiteralsLTWLotteryWinnerShou], T2.[RptLiteralsLTWMonth], T2.[RptLiteralsLTWNonDeductible], T2.[RptLiteralsLTWNotesForPrize], T2.[RptLiteralsLTWPart1Footer], T2.[RptLiteralsLTWPart2Footer], T2.[RptLiteralsLTWPart3Footer], T2.[RptLiteralsLTWPeriod], T2.[RptLiteralsLTWPhone], T2.[RptLiteralsLTWPhoneNumber], T2.[RptLiteralsLTWPleaseDialDirect], T2.[RptLiteralsLTWPleaseIssueGuiInv], T2.[RptLiteralsLTWPrizeClaimingPeri], T2.[RptLiteralsLTWPrizeCollection], T2.[RptLiteralsLTWPrizeCollectorID], T2.[RptLiteralsLTWPrizeCollectorSgn], T2.[RptLiteralsLTWProcessPayingPriz], T2.[RptLiteralsLTWProductName], T2.[RptLiteralsLTWPurchaseAndFee], T2.[RptLiteralsLTWQuantity], T2.[RptLiteralsLTWRandomCode], T2.[RptLiteralsLTWReceiptOfPrizeCol], T2.[RptLiteralsLTWReprintCopy], T2.[RptLiteralsLTWResidencyAddress], T2.[RptLiteralsLTWRoc], T2.[RptLiteralsLTWSalesAmt], T2.[RptLiteralsLTWSeller], T2.[RptLiteralsLTWSellerStampArea], T2.[RptLiteralsLTWSignatureOrStamp], T2.[RptLiteralsLTWStickDutyStamp], T2.[RptLiteralsLTWTaxable], T2.[RptLiteralsLTWTheNameAndAddress], T2.[RptLiteralsLTWThePrizeAndItShou], T2.[RptLiteralsLTWTheResidentCard], T2.[RptLiteralsLTWTotalAmount], T2.[RptLiteralsLTWTotalAmountColon], T2.[RptLiteralsLTWTotalSales], T2.[RptLiteralsLTWTotalTax], T2.[RptLiteralsLTWToTheNextBusiness], T2.[RptLiteralsLTWUnifiedInvoiceNum], T2.[RptLiteralsLTWUnitPrice], T2.[RptLiteralsLTWWebSiteForCheckin], T2.[RptLiteralsLTWWebSiteURL], T2.[RptLiteralsLTWWinner], T2.[RptLiteralsLTWYear], T2.[RptLiteralsLTWYuanInteger], T2.[RptLiteralsLTWZeroRated], T2.[RptLiteralsLUntPrice], T2.[RptLiteralsLVatNr], T2.[RptLiteralsLWarehouse], T2.[RptLiteralsLWarranty], T2.[RptLiteralsLWarrantyA], T2.[RptLiteralsLWHCode], T2.[RptLiteralsLYes], T2.[RptLiteralsLYurPOLinNum], T2.[InvoiceNum] as RptLabelsInvoiceNum, T2.[MovementNum] as RptLabelsMovementNum, T2.[ACHTranCode] as RptLabelsACHTranCode, T2.[Adjustment] as RptLabelsAdjustment, T2.[AdjustmentReason] as RptLabelsAdjustmentReason, T2.[AdjustmentRef] as RptLabelsAdjustmentRef, T2.[BankAcctID] as RptLabelsBankAcctID, T2.[BankBatchExcluded] as RptLabelsBankBatchExcluded, T2.[BankBatchSysRowID] as RptLabelsBankBatchSysRowID, T2.[CCCity] as RptLabelsCCCity, T2.[CCState] as RptLabelsCCState, T2.[ccToken] as RptLabelsccToken, T2.[CustomerBankAcctNumber] as RptLabelsCustomerBankAcctNumber, T2.[CustomerBankAddress1] as RptLabelsCustomerBankAddress1, T2.[CustomerBankAddress2] as RptLabelsCustomerBankAddress2, T2.[CustomerBankAddress3] as RptLabelsCustomerBankAddress3, T2.[CustomerBankCity] as RptLabelsCustomerBankCity, T2.[CustomerBankCountryNum] as RptLabelsCustomerBankCountryNum, T2.[CustomerBankIBANCode] as RptLabelsCustomerBankIBANCode, T2.[CustomerBankID] as RptLabelsCustomerBankID, T2.[CustomerBankName] as RptLabelsCustomerBankName, T2.[CustomerBankNameOnAccount] as RptLabelsCustomerBankNameOnAccount, T2.[CustomerBankPostalCode] as RptLabelsCustomerBankPostalCode, T2.[CustomerBankState] as RptLabelsCustomerBankState, T2.[CustomerBankSwiftNum] as RptLabelsCustomerBankSwiftNum, T2.[DepositBalance] as RptLabelsDepositBalance, T2.[DocDepositBalance] as RptLabelsDocDepositBalance, T2.[DocWriteOffAmount] as RptLabelsDocWriteOffAmount, T2.[LockboxID] as RptLabelsLockboxID, T2.[PayMethodReference] as RptLabelsPayMethodReference, T2.[Reference] as RptLabelsReference, T2.[ReversedReason] as RptLabelsReversedReason, T2.[SEC] as RptLabelsSEC, T2.[SourceGroupID] as RptLabelsSourceGroupID, T2.[SourceHeadNum] as RptLabelsSourceHeadNum, T2.[Calc_InvoiceNum] as RptLabelsCalc_InvoiceNum, T2.[ActTypeCode] as RptLabelsActTypeCode, T2.[APBOECheck] as RptLabelsAPBOECheck, T2.[CalendarID] as RptLabelsCalendarID, T2.[ChiefAcctName] as RptLabelsChiefAcctName, T2.[COSequenceCert] as RptLabelsCOSequenceCert, T2.[CountryNum] as RptLabelsCountryNum, T2.[CurrentFiscalYear] as RptLabelsCurrentFiscalYear, T2.[DeepCopy] as RptLabelsDeepCopy, T2.[DeepCopyDupOrRevEst] as RptLabelsDeepCopyDupOrRevEst, T2.[EDICode] as RptLabelsEDICode, T2.[EmpPhotoPath] as RptLabelsEmpPhotoPath, T2.[EpicorAccountNum] as RptLabelsEpicorAccountNum, T2.[EschedFileSet] as RptLabelsEschedFileSet, T2.[ExternalID] as RptLabelsExternalID, T2.[FEIN] as RptLabelsFEIN, T2.[FiscalCalendarID] as RptLabelsFiscalCalendarID, T2.[FRxDSN] as RptLabelsFRxDSN, T2.[FRxPassWord] as RptLabelsFRxPassWord, T2.[FrxUserid] as RptLabelsFrxUserid, T2.[LegalName] as RptLabelsLegalName, T2.[LogoFile] as RptLabelsLogoFile, T2.[ManagerName] as RptLabelsManagerName, T2.[MapURL] as RptLabelsMapURL, T2.[Number] as RptLabelsNumber, T2.[OrgRegCode] as RptLabelsOrgRegCode, T2.[SendToFSA] as RptLabelsSendToFSA, T2.[StateTaxID] as RptLabelsStateTaxID, T2.[TaxRegionCode] as RptLabelsTaxRegionCode, T2.[TaxRegReason] as RptLabelsTaxRegReason, T2.[WIApplication] as RptLabelsWIApplication, T2.[WIAutoCreateJob] as RptLabelsWIAutoCreateJob, T2.[WIGetDetails] as RptLabelsWIGetDetails, T2.[WIRelease] as RptLabelsWIRelease, T2.[WISchedule] as RptLabelsWISchedule, T2.[WIShippingCosts] as RptLabelsWIShippingCosts, T2.[Calc_EmailFromAddr] as RptLabelsCalc_EmailFromAddr, T2.[Calc_ExecutionTime] as RptLabelsCalc_ExecutionTime, T2.[Calc_INAddressList] as RptLabelsCalc_INAddressList, T2.[Calc_IssuerIDIssDate] as RptLabelsCalc_IssuerIDIssDate, T2.[Calc_IssuerIDType] as RptLabelsCalc_IssuerIDType, T2.[Calc_IssuerName] as RptLabelsCalc_IssuerName, T2.[Calc_IssuerPrsnIDCode] as RptLabelsCalc_IssuerPrsnIDCode, T2.[Calc_IssuerSerialNum] as RptLabelsCalc_IssuerSerialNum, T2.[Calc_IssuerSurname] as RptLabelsCalc_IssuerSurname, T2.[Calc_Localization] as RptLabelsCalc_Localization, T2.[Calc_MXAddress] as RptLabelsCalc_MXAddress, T2.[Calc_MXUseExpedidoEn] as RptLabelsCalc_MXUseExpedidoEn, T2.[Calc_THBranchID] as RptLabelsCalc_THBranchID, T2.[Calc_THTaxPayerNo] as RptLabelsCalc_THTaxPayerNo, T2.[Calc_UseCopyNum] as RptLabelsCalc_UseCopyNum, T2.[Calc_usePreNumberFmt] as RptLabelsCalc_usePreNumberFmt, T2.[Description] as RptLabelsDescription, T2.[DepositCredit] as RptLabelsDepositCredit, T2.[OurSupplierCode] as RptLabelsOurSupplierCode, T2.[PEBOEIsMultiGen] as RptLabelsPEBOEIsMultiGen, T2.[PEBOEStatus] as RptLabelsPEBOEStatus, T2.[PONum] as RptLabelsPONum, T2.[ServiceInvoice] as RptLabelsServiceInvoice, T2.[ShipDate] as RptLabelsShipDate, T2.[Calc_BillToAddressList] as RptLabelsCalc_BillToAddressList, T2.[Calc_BottomAddress] as RptLabelsCalc_BottomAddress, T2.[Calc_BTAddressList] as RptLabelsCalc_BTAddressList, T2.[Calc_CHBankAcctIBANCode] as RptLabelsCalc_CHBankAcctIBANCode, T2.[Calc_CHBankAcctISRPartyID] as RptLabelsCalc_CHBankAcctISRPartyID, T2.[Calc_CompanyAddressList] as RptLabelsCalc_CompanyAddressList, T2.[Calc_ConReference] as RptLabelsCalc_ConReference, T2.[Calc_ConStartDate] as RptLabelsCalc_ConStartDate, T2.[Calc_CreditMemo] as RptLabelsCalc_CreditMemo, T2.[Calc_CurrDesc] as RptLabelsCalc_CurrDesc, T2.[Calc_CurrDocDecimalsGeneral] as RptLabelsCalc_CurrDocDecimalsGeneral, T2.[Calc_CurrDocDecimalsPrice] as RptLabelsCalc_CurrDocDecimalsPrice, T2.[Calc_CurrDocDesc] as RptLabelsCalc_CurrDocDesc, T2.[Calc_CurSymbol] as RptLabelsCalc_CurSymbol, T2.[Calc_CustContactName] as RptLabelsCalc_CustContactName, T2.[Calc_CustEMailAddress] as RptLabelsCalc_CustEMailAddress, T2.[Calc_CustFax] as RptLabelsCalc_CustFax, T2.[Calc_CustID] as RptLabelsCalc_CustID, T2.[Calc_CustPartOpts] as RptLabelsCalc_CustPartOpts, T2.[Calc_CustPhone] as RptLabelsCalc_CustPhone, T2.[Calc_CustResaleID] as RptLabelsCalc_CustResaleID, T2.[Calc_DiscountTotal] as RptLabelsCalc_DiscountTotal, T2.[Calc_DocDspTaxAmt] as RptLabelsCalc_DocDspTaxAmt, T2.[Calc_DocInvoiceAmt] as RptLabelsCalc_DocInvoiceAmt, T2.[Calc_DropShipPackSlip] as RptLabelsCalc_DropShipPackSlip, T2.[Calc_DteOrdrd] as RptLabelsCalc_DteOrdrd, T2.[Calc_ExtPriceTotal] as RptLabelsCalc_ExtPriceTotal, T2.[Calc_fFOB] as RptLabelsCalc_fFOB, T2.[Calc_GuiFormatCodeDesc] as RptLabelsCalc_GuiFormatCodeDesc, T2.[Calc_GuiTaxTypeCodeDesc] as RptLabelsCalc_GuiTaxTypeCodeDesc, T2.[Calc_INAdvBilled] as RptLabelsCalc_INAdvBilled, T2.[Calc_INBillToAddrList] as RptLabelsCalc_INBillToAddrList, T2.[Calc_INCGSTAmtTotal] as RptLabelsCalc_INCGSTAmtTotal, T2.[Calc_INDocAllocAmt] as RptLabelsCalc_INDocAllocAmt, T2.[Calc_INDocAllocTaxAmt] as RptLabelsCalc_INDocAllocTaxAmt, T2.[Calc_INIGSTAmtTotal] as RptLabelsCalc_INIGSTAmtTotal, T2.[Calc_INIsExport] as RptLabelsCalc_INIsExport, T2.[Calc_INIsIGST] as RptLabelsCalc_INIsIGST, T2.[Calc_INSATaxTotal] as RptLabelsCalc_INSATaxTotal, T2.[Calc_INSGSTAmtTotal] as RptLabelsCalc_INSGSTAmtTotal, T2.[Calc_INShipToAddrList] as RptLabelsCalc_INShipToAddrList, T2.[Calc_INTotalWords] as RptLabelsCalc_INTotalWords, T2.[Calc_InvoiceAmtInWords] as RptLabelsCalc_InvoiceAmtInWords, T2.[Calc_InvoiceRefDate] as RptLabelsCalc_InvoiceRefDate, T2.[Calc_InvoiceRefLegalNumber] as RptLabelsCalc_InvoiceRefLegalNumber, T2.[Calc_InvSubTotal] as RptLabelsCalc_InvSubTotal, T2.[Calc_InvSuffix] as RptLabelsCalc_InvSuffix, T2.[Calc_IsBaseCurr] as RptLabelsCalc_IsBaseCurr, T2.[Calc_IsDraftCopy] as RptLabelsCalc_IsDraftCopy, T2.[Calc_LessPrepaidDeposits] as RptLabelsCalc_LessPrepaidDeposits, T2.[Calc_MscTotal] as RptLabelsCalc_MscTotal, T2.[Calc_MtlTotal] as RptLabelsCalc_MtlTotal, T2.[Calc_MulPackNum] as RptLabelsCalc_MulPackNum, T2.[Calc_mulponum] as RptLabelsCalc_mulponum, T2.[Calc_MulShipDate] as RptLabelsCalc_MulShipDate, T2.[Calc_MulShipTo] as RptLabelsCalc_MulShipTo, T2.[Calc_MulShipVia] as RptLabelsCalc_MulShipVia, T2.[Calc_MulShpCon] as RptLabelsCalc_MulShpCon, T2.[Calc_MultSoldTo] as RptLabelsCalc_MultSoldTo, T2.[Calc_MultTaxID] as RptLabelsCalc_MultTaxID, T2.[Calc_MXAmountInWords] as RptLabelsCalc_MXAmountInWords, T2.[Calc_MXApprovalNumber] as RptLabelsCalc_MXApprovalNumber, T2.[Calc_MXApprovalYear] as RptLabelsCalc_MXApprovalYear, T2.[Calc_MXBarcode] as RptLabelsCalc_MXBarcode, T2.[Calc_MXCBB] as RptLabelsCalc_MXCBB, T2.[Calc_MXCertificateSN] as RptLabelsCalc_MXCertificateSN, T2.[Calc_MXCertifiedTimeStamp] as RptLabelsCalc_MXCertifiedTimeStamp, T2.[Calc_MXCurrencyId] as RptLabelsCalc_MXCurrencyId, T2.[Calc_MXDigitalSeal] as RptLabelsCalc_MXDigitalSeal, T2.[Calc_MXExpeditionAddress] as RptLabelsCalc_MXExpeditionAddress, T2.[Calc_MXFiscalFolio] as RptLabelsCalc_MXFiscalFolio, T2.[Calc_MXFolio] as RptLabelsCalc_MXFolio, T2.[Calc_MXFormOfPayment] as RptLabelsCalc_MXFormOfPayment, T2.[Calc_MXIsBaseCurr] as RptLabelsCalc_MXIsBaseCurr, T2.[Calc_MXOrigFiscalFolio] as RptLabelsCalc_MXOrigFiscalFolio, T2.[Calc_MXOrigFiscalFolioAmount] as RptLabelsCalc_MXOrigFiscalFolioAmount, T2.[Calc_MXOrigFiscalFolioDate] as RptLabelsCalc_MXOrigFiscalFolioDate, T2.[Calc_MXOrigFiscalFolioSeries] as RptLabelsCalc_MXOrigFiscalFolioSeries, T2.[Calc_MXOriginalString1] as RptLabelsCalc_MXOriginalString1, T2.[Calc_MXOriginalString10] as RptLabelsCalc_MXOriginalString10, T2.[Calc_MXOriginalString2] as RptLabelsCalc_MXOriginalString2, T2.[Calc_MXOriginalString3] as RptLabelsCalc_MXOriginalString3, T2.[Calc_MXOriginalString4] as RptLabelsCalc_MXOriginalString4, T2.[Calc_MXOriginalString5] as RptLabelsCalc_MXOriginalString5, T2.[Calc_MXOriginalString6] as RptLabelsCalc_MXOriginalString6, T2.[Calc_MXOriginalString7] as RptLabelsCalc_MXOriginalString7, T2.[Calc_MXOriginalString8] as RptLabelsCalc_MXOriginalString8, T2.[Calc_MXOriginalString9] as RptLabelsCalc_MXOriginalString9, T2.[Calc_MXOriginalStringTFD] as RptLabelsCalc_MXOriginalStringTFD, T2.[Calc_MXPaidAs] as RptLabelsCalc_MXPaidAs, T2.[Calc_MXPaymentAccountNum] as RptLabelsCalc_MXPaymentAccountNum, T2.[Calc_MXPaymentMethod] as RptLabelsCalc_MXPaymentMethod, T2.[Calc_MXPaymentNum] as RptLabelsCalc_MXPaymentNum, T2.[Calc_MXPMSATCodeDescr] as RptLabelsCalc_MXPMSATCodeDescr, T2.[Calc_MXPurchaseType] as RptLabelsCalc_MXPurchaseType, T2.[Calc_MXRelated] as RptLabelsCalc_MXRelated, T2.[Calc_MXSATCertificateSN] as RptLabelsCalc_MXSATCertificateSN, T2.[Calc_MXSATSeal] as RptLabelsCalc_MXSATSeal, T2.[Calc_MXSerie] as RptLabelsCalc_MXSerie, T2.[Calc_MXTaxRegime] as RptLabelsCalc_MXTaxRegime, T2.[Calc_MXTotalPayments] as RptLabelsCalc_MXTotalPayments, T2.[Calc_MYBaseCurrCode] as RptLabelsCalc_MYBaseCurrCode, T2.[Calc_MYBaseCurrSymbol] as RptLabelsCalc_MYBaseCurrSymbol, T2.[Calc_NumRecordPerPage] as RptLabelsCalc_NumRecordPerPage, T2.[Calc_NumTotalParts] as RptLabelsCalc_NumTotalParts, T2.[Calc_PackNum] as RptLabelsCalc_PackNum, T2.[Calc_PEAdvBilling] as RptLabelsCalc_PEAdvBilling, T2.[Calc_PEBTAddress] as RptLabelsCalc_PEBTAddress, T2.[Calc_PEBTName] as RptLabelsCalc_PEBTName, T2.[Calc_PECompanyAddressList] as RptLabelsCalc_PECompanyAddressList, T2.[Calc_PEDiscounts] as RptLabelsCalc_PEDiscounts, T2.[Calc_PEDocumentID] as RptLabelsCalc_PEDocumentID, T2.[Calc_PEExSales] as RptLabelsCalc_PEExSales, T2.[Calc_PEIdentityDocType] as RptLabelsCalc_PEIdentityDocType, T2.[Calc_PEIdentityDocTypeDesc] as RptLabelsCalc_PEIdentityDocTypeDesc, T2.[Calc_PEIGV] as RptLabelsCalc_PEIGV, T2.[Calc_PEISC] as RptLabelsCalc_PEISC, T2.[Calc_PELegalText] as RptLabelsCalc_PELegalText, T2.[Calc_PENonTaxOper] as RptLabelsCalc_PENonTaxOper, T2.[Calc_PEOtherCharges] as RptLabelsCalc_PEOtherCharges, T2.[Calc_PEOtherTaxes] as RptLabelsCalc_PEOtherTaxes, T2.[Calc_PERefDocType] as RptLabelsCalc_PERefDocType, T2.[Calc_PeriodEndDate] as RptLabelsCalc_PeriodEndDate, T2.[Calc_PETaxOper] as RptLabelsCalc_PETaxOper, T2.[Calc_PETotalAmt] as RptLabelsCalc_PETotalAmt, T2.[Calc_PETotalAmtTxt] as RptLabelsCalc_PETotalAmtTxt, T2.[Calc_PPAllowPcnt] as RptLabelsCalc_PPAllowPcnt, T2.[Calc_PrintBottomAddress] as RptLabelsCalc_PrintBottomAddress, T2.[Calc_RefInvAmt] as RptLabelsCalc_RefInvAmt, T2.[Calc_RefInvNum] as RptLabelsCalc_RefInvNum, T2.[Calc_SalesPerson] as RptLabelsCalc_SalesPerson, T2.[Calc_SalesTerms] as RptLabelsCalc_SalesTerms, T2.[Calc_SEBankRef] as RptLabelsCalc_SEBankRef, T2.[Calc_ShipDate] as RptLabelsCalc_ShipDate, T2.[Calc_ShipTo] as RptLabelsCalc_ShipTo, T2.[Calc_ShipToAddressList] as RptLabelsCalc_ShipToAddressList, T2.[Calc_ShipToContactName] as RptLabelsCalc_ShipToContactName, T2.[Calc_ShipVia] as RptLabelsCalc_ShipVia, T2.[Calc_ShpConNum] as RptLabelsCalc_ShpConNum, T2.[Calc_SoldToAddressList] as RptLabelsCalc_SoldToAddressList, T2.[Calc_SubTotal] as RptLabelsCalc_SubTotal, T2.[Calc_TaxMethod] as RptLabelsCalc_TaxMethod, T2.[Calc_TotalMiscChrg] as RptLabelsCalc_TotalMiscChrg, T2.[Calc_TransportationMode] as RptLabelsCalc_TransportationMode, T2.[Calc_TWAmountInWords] as RptLabelsCalc_TWAmountInWords, T2.[Calc_TWPart1QRBitmapBase64] as RptLabelsCalc_TWPart1QRBitmapBase64, T2.[Calc_TWPart1QRSource] as RptLabelsCalc_TWPart1QRSource, T2.[Calc_TWPart2QRBitmapBase64] as RptLabelsCalc_TWPart2QRBitmapBase64, T2.[Calc_TWPart2QRSource] as RptLabelsCalc_TWPart2QRSource, T2.[Calc_TWRandomCode] as RptLabelsCalc_TWRandomCode, T2.[Calc_vDocPayAmounts] as RptLabelsCalc_vDocPayAmounts, T2.[Calc_VoucherString] as RptLabelsCalc_VoucherString, T2.[Calc_Voucher-String] as RptLabelsCalc_Voucher_String, T2.[Calc_vPayAmounts] as RptLabelsCalc_vPayAmounts, T2.[Calc_vPayDates] as RptLabelsCalc_vPayDates, T2.[CurrDesc] as RptLabelsCurrDesc, T2.[CurrencyID] as RptLabelsCurrencyID, T2.[CurrName] as RptLabelsCurrName, T2.[CurrSymbol] as RptLabelsCurrSymbol, T2.[DocumentDesc] as RptLabelsDocumentDesc, T2.[BTName] as RptLabelsBTName, T2.[CustID] as RptLabelsCustID, T2.[Name] as RptLabelsName, T2.[TradingPartnerName] as RptLabelsTradingPartnerName, T2.[JrnlDescription] as RptLabelsJrnlDescription, T2.[CardMemberName] as RptLabelsCardMemberName, T2.[CurrencyCode] as RptLabelsCurrencyCode, T2.[OrderDate] as RptLabelsOrderDate, T2.[NumberOfPayments] as RptLabelsNumberOfPayments, T2.[TermsCode] as RptLabelsTermsCode, T2.[AllocDepECAcqSeq] as RptLabelsAllocDepECAcqSeq, T2.[AllocDepInvcLine] as RptLabelsAllocDepInvcLine, T2.[AllocDepInvcNum] as RptLabelsAllocDepInvcNum, T2.[AllocDepRateCode] as RptLabelsAllocDepRateCode, T2.[AllocDepTaxBal] as RptLabelsAllocDepTaxBal, T2.[ApplyConfirmationDate] as RptLabelsApplyConfirmationDate, T2.[ConfirmationDate] as RptLabelsConfirmationDate, T2.[DocAllocTaxBal] as RptLabelsDocAllocTaxBal, T2.[InvoiceLine] as RptLabelsInvoiceLine, T2.[LegalNumber] as RptLabelsLegalNumber, T2.[Percent] as RptLabelsPercent, T2.[ReverseByInvoiceNum] as RptLabelsReverseByInvoiceNum, T2.[TaxableAmt] as RptLabelsTaxableAmt, T2.[TaxConfirm] as RptLabelsTaxConfirm, T2.[TaxReverseDate] as RptLabelsTaxReverseDate, T2.[TranDocTypeID] as RptLabelsTranDocTypeID, T2.[Calc_BaseTaxableAmtTotal] as RptLabelsCalc_BaseTaxableAmtTotal, T2.[Calc_BaseTaxAmtTotal] as RptLabelsCalc_BaseTaxAmtTotal, T2.[Calc_LegalText] as RptLabelsCalc_LegalText, T2.[Calc_MXDocTaxAmt] as RptLabelsCalc_MXDocTaxAmt, T2.[Calc_RateLegalText] as RptLabelsCalc_RateLegalText, T2.[Calc_TaxableAmtTotal] as RptLabelsCalc_TaxableAmtTotal, T2.[Calc_TaxAmtTotal] as RptLabelsCalc_TaxAmtTotal, T2.[Calc_TaxDesc] as RptLabelsCalc_TaxDesc, T2.[ChangeDate] as RptLabelsChangeDate, T2.[ChangedBy] as RptLabelsChangedBy, T2.[Discount] as RptLabelsDiscount, T2.[EpicorFSA] as RptLabelsEpicorFSA, T2.[MXPaymentNum] as RptLabelsMXPaymentNum, T2.[WriteOffHeadNumRef] as RptLabelsWriteOffHeadNumRef, T2.[Calc_fTranAmt] as RptLabelsCalc_fTranAmt, T2.[Calc_fTranDate] as RptLabelsCalc_fTranDate, T2.[Calc_InvNum] as RptLabelsCalc_InvNum, T2.[PartNum] as RptLabelsPartNum, T2.[Calc_ContPrice] as RptLabelsCalc_ContPrice, T2.[Calc_fCallNum] as RptLabelsCalc_fCallNum, T2.[Calc_InvoiceLine] as RptLabelsCalc_InvoiceLine, T2.[Calc_RptUserID] as RptLabelsCalc_RptUserID, T2.[ContractDescription] as RptLabelsContractDescription, T2.[MfgComment] as RptLabelsMfgComment, T2.[PartDescription] as RptLabelsPartDescription, T2.[PurComment] as RptLabelsPurComment, T2.[TrackDimension] as RptLabelsTrackDimension, T2.[TrackLots] as RptLabelsTrackLots, T2.[TrackSerialNum] as RptLabelsTrackSerialNum, T2.[AnnualRevenue] as RptLabelsAnnualRevenue, T2.[ConsolidateLinesPerPart] as RptLabelsConsolidateLinesPerPart, T2.[ExternalCRMCustomerID] as RptLabelsExternalCRMCustomerID, T2.[ExternalCRMCustomerType] as RptLabelsExternalCRMCustomerType, T2.[ExternalCRMLastSync] as RptLabelsExternalCRMLastSync, T2.[ExternalCRMSyncRequired] as RptLabelsExternalCRMSyncRequired, T2.[Industry] as RptLabelsIndustry, T2.[NumberOfEmployees] as RptLabelsNumberOfEmployees, T2.[Ownership] as RptLabelsOwnership, T2.[Rating] as RptLabelsRating, T2.[SyncToExternalCRM] as RptLabelsSyncToExternalCRM, T2.[TickerLocation] as RptLabelsTickerLocation, T2.[TickerSymbol] as RptLabelsTickerSymbol, T2.[GroupDesc] as RptLabelsGroupDesc, T2.[WebDesc] as RptLabelsWebDesc, T2.[TaxAuthorityDescription] as RptLabelsTaxAuthorityDescription, T2.[TerritoryDesc] as RptLabelsTerritoryDesc, T2.[Company] as RptLabelsCompany, T2.[MXFiscalFolio] as RptLabelsMXFiscalFolio, T2.[ConsolidateLines] as RptLabelsConsolidateLines, T2.[DocInAdvanceBillCredit] as RptLabelsDocInAdvanceBillCredit, T2.[DockingStation] as RptLabelsDockingStation, T2.[DocUnitPrice] as RptLabelsDocUnitPrice, T2.[DropShipPONum] as RptLabelsDropShipPONum, T2.[ExtPrice] as RptLabelsExtPrice, T2.[InAdvanceBillCredit] as RptLabelsInAdvanceBillCredit, T2.[PricePerCode] as RptLabelsPricePerCode, T2.[UnitPrice] as RptLabelsUnitPrice, T2.[Calc_ActDate] as RptLabelsCalc_ActDate, T2.[Calc_ActivityAmount] as RptLabelsCalc_ActivityAmount, T2.[Calc_ActivityUnit] as RptLabelsCalc_ActivityUnit, T2.[Calc_BackOrdQty] as RptLabelsCalc_BackOrdQty, T2.[Calc_BaseExtPrice] as RptLabelsCalc_BaseExtPrice, T2.[Calc_BdnCd] as RptLabelsCalc_BdnCd, T2.[Calc_BdnPrc] as RptLabelsCalc_BdnPrc, T2.[Calc_BdnSetDesc] as RptLabelsCalc_BdnSetDesc, T2.[Calc_BdnSetID] as RptLabelsCalc_BdnSetID, T2.[Calc_BillSchedID] as RptLabelsCalc_BillSchedID, T2.[Calc_BillSchedIDDesc] as RptLabelsCalc_BillSchedIDDesc, T2.[Calc_CalcExtPrice] as RptLabelsCalc_CalcExtPrice, T2.[Calc_CalcUnitPrice] as RptLabelsCalc_CalcUnitPrice, T2.[Calc_ChargeRate] as RptLabelsCalc_ChargeRate, T2.[Calc_ContComment] as RptLabelsCalc_ContComment, T2.[Calc_CostPlusPrc] as RptLabelsCalc_CostPlusPrc, T2.[Calc_CurrentHours] as RptLabelsCalc_CurrentHours, T2.[Calc_DocActivityAmount] as RptLabelsCalc_DocActivityAmount, T2.[Calc_DocLineTotal] as RptLabelsCalc_DocLineTotal, T2.[Calc_DocLineTotalDisc] as RptLabelsCalc_DocLineTotalDisc, T2.[Calc_DocUnitPriceDisc] as RptLabelsCalc_DocUnitPriceDisc, T2.[Calc_DspDocLineTax] as RptLabelsCalc_DspDocLineTax, T2.[Calc_Duration] as RptLabelsCalc_Duration, T2.[Calc_ExtPrice] as RptLabelsCalc_ExtPrice, T2.[Calc_FeeCharge] as RptLabelsCalc_FeeCharge, T2.[Calc_GetNextLegalNum] as RptLabelsCalc_GetNextLegalNum, T2.[Calc_INCGSTAmt] as RptLabelsCalc_INCGSTAmt, T2.[Calc_INCGSTRate] as RptLabelsCalc_INCGSTRate, T2.[Calc_INDocLineTotal] as RptLabelsCalc_INDocLineTotal, T2.[Calc_INIGSTAmt] as RptLabelsCalc_INIGSTAmt, T2.[Calc_INIGSTRate] as RptLabelsCalc_INIGSTRate, T2.[Calc_INSGSTAmt] as RptLabelsCalc_INSGSTAmt, T2.[Calc_INSGSTRate] as RptLabelsCalc_INSGSTRate, T2.[Calc_INTaxLineTotal] as RptLabelsCalc_INTaxLineTotal, T2.[Calc_InvcComment] as RptLabelsCalc_InvcComment, T2.[Calc_InvoiceDisplayLine] as RptLabelsCalc_InvoiceDisplayLine, T2.[Calc_IsBlank] as RptLabelsCalc_IsBlank, T2.[Calc_IsKitParent] as RptLabelsCalc_IsKitParent, T2.[Calc_IstAmt] as RptLabelsCalc_IstAmt, T2.[Calc_IstBdrXng] as RptLabelsCalc_IstBdrXng, T2.[Calc_IstCmdCd] as RptLabelsCalc_IstCmdCd, T2.[Calc_IstCntCd] as RptLabelsCalc_IstCntCd, T2.[Calc_IstCur] as RptLabelsCalc_IstCur, T2.[Calc_IstDesc] as RptLabelsCalc_IstDesc, T2.[Calc_IstFlow] as RptLabelsCalc_IstFlow, T2.[Calc_IstFlowSp] as RptLabelsCalc_IstFlowSp, T2.[Calc_IstFOB] as RptLabelsCalc_IstFOB, T2.[Calc_IstInvcLn] as RptLabelsCalc_IstInvcLn, T2.[Calc_IstInvcNum] as RptLabelsCalc_IstInvcNum, T2.[Calc_IstISShpVia] as RptLabelsCalc_IstISShpVia, T2.[Calc_IstMemoFlg] as RptLabelsCalc_IstMemoFlg, T2.[Calc_IstPeriod] as RptLabelsCalc_IstPeriod, T2.[Calc_IstPosted] as RptLabelsCalc_IstPosted, T2.[Calc_IstShpVia] as RptLabelsCalc_IstShpVia, T2.[Calc_IstSrcMod] as RptLabelsCalc_IstSrcMod, T2.[Calc_IstSuppUnts] as RptLabelsCalc_IstSuppUnts, T2.[Calc_IstTrms] as RptLabelsCalc_IstTrms, T2.[Calc_IstTrnTyp] as RptLabelsCalc_IstTrnTyp, T2.[Calc_IstVndNum] as RptLabelsCalc_IstVndNum, T2.[Calc_IstWeight] as RptLabelsCalc_IstWeight, T2.[Calc_JobNumber] as RptLabelsCalc_JobNumber, T2.[Calc_KitParentLine] as RptLabelsCalc_KitParentLine, T2.[Calc_LabDur] as RptLabelsCalc_LabDur, T2.[Calc_LabMod] as RptLabelsCalc_LabMod, T2.[Calc_Labor] as RptLabelsCalc_Labor, T2.[Calc_LineDesc] as RptLabelsCalc_LineDesc, T2.[Calc_LineSoldToAddressList] as RptLabelsCalc_LineSoldToAddressList, T2.[Calc_LineTotal] as RptLabelsCalc_LineTotal, T2.[Calc_LotNumber] as RptLabelsCalc_LotNumber, T2.[Calc_MarkUpAmt] as RptLabelsCalc_MarkUpAmt, T2.[Calc_MatDur] as RptLabelsCalc_MatDur, T2.[Calc_Mate] as RptLabelsCalc_Mate, T2.[Calc_MatMod] as RptLabelsCalc_MatMod, T2.[Calc_MeasuredWorkID] as RptLabelsCalc_MeasuredWorkID, T2.[Calc_Misc] as RptLabelsCalc_Misc, T2.[Calc_MiscDur] as RptLabelsCalc_MiscDur, T2.[Calc_MiscMod] as RptLabelsCalc_MiscMod, T2.[Calc_Modifier] as RptLabelsCalc_Modifier, T2.[Calc_MsWrkIDDesc] as RptLabelsCalc_MsWrkIDDesc, T2.[Calc_MXUOMSATCode] as RptLabelsCalc_MXUOMSATCode, T2.[Calc_NextLegalNumID] as RptLabelsCalc_NextLegalNumID, T2.[Calc_NextLinePBType] as RptLabelsCalc_NextLinePBType, T2.[Calc_NumLineByInv] as RptLabelsCalc_NumLineByInv, T2.[Calc_OurJobQty] as RptLabelsCalc_OurJobQty, T2.[Calc_OurJobShippedQty] as RptLabelsCalc_OurJobShippedQty, T2.[Calc_OurReqQty] as RptLabelsCalc_OurReqQty, T2.[Calc_OurStockQty] as RptLabelsCalc_OurStockQty, T2.[Calc_OurStockShippedQty] as RptLabelsCalc_OurStockShippedQty, T2.[Calc_ParentWrkSchID] as RptLabelsCalc_ParentWrkSchID, T2.[Calc_PBFeeCharge] as RptLabelsCalc_PBFeeCharge, T2.[Calc_PBMarkUp] as RptLabelsCalc_PBMarkUp, T2.[Calc_POLine] as RptLabelsCalc_POLine, T2.[Calc_ponum] as RptLabelsCalc_ponum, T2.[Calc_PrevLinePBType] as RptLabelsCalc_PrevLinePBType, T2.[Calc_PricePerUnit] as RptLabelsCalc_PricePerUnit, T2.[Calc_PSLegalNum] as RptLabelsCalc_PSLegalNum, T2.[Calc_PtWrkSchIDDesc] as RptLabelsCalc_PtWrkSchIDDesc, T2.[Calc_QtyOrdrd] as RptLabelsCalc_QtyOrdrd, T2.[Calc_Reference] as RptLabelsCalc_Reference, T2.[Calc_RetentionAmt] as RptLabelsCalc_RetentionAmt, T2.[Calc_RetentionPcnt] as RptLabelsCalc_RetentionPcnt, T2.[Calc_RetentionPrcnt] as RptLabelsCalc_RetentionPrcnt, T2.[Calc_SellingJobQty] as RptLabelsCalc_SellingJobQty, T2.[Calc_SellingJobShippedQty] as RptLabelsCalc_SellingJobShippedQty, T2.[Calc_SellingStockQty] as RptLabelsCalc_SellingStockQty, T2.[Calc_SellingStockShipQty] as RptLabelsCalc_SellingStockShipQty, T2.[Calc_SerialNumber] as RptLabelsCalc_SerialNumber, T2.[Calc_ShipComment] as RptLabelsCalc_ShipComment, T2.[Calc_ShipLog] as RptLabelsCalc_ShipLog, T2.[Calc_ShipToShipToFax] as RptLabelsCalc_ShipToShipToFax, T2.[Calc_ShipToShipToNum] as RptLabelsCalc_ShipToShipToNum, T2.[Calc_ShipToShipVia] as RptLabelsCalc_ShipToShipVia, T2.[Calc_StateTaxID] as RptLabelsCalc_StateTaxID, T2.[Calc_UnitPrice] as RptLabelsCalc_UnitPrice, T2.[Calc_UOMDescription] as RptLabelsCalc_UOMDescription, T2.[Calc_WarrComment] as RptLabelsCalc_WarrComment, T2.[Calc_WarrDesc] as RptLabelsCalc_WarrDesc, T2.[Calc_WhseCode] as RptLabelsCalc_WhseCode, T2.[CallDescription] as RptLabelsCallDescription, T2.[CorpName] as RptLabelsCorpName, T2.[FaxNum] as RptLabelsFaxNum, T2.[FirstName] as RptLabelsFirstName, T2.[LastName] as RptLabelsLastName, T2.[MiddleName] as RptLabelsMiddleName, T2.[PhoneNum] as RptLabelsPhoneNum, T2.[OrderDtlCharacter01] as RptLabelsOrderDtlCharacter01, T2.[OrderDtlCharacter02] as RptLabelsOrderDtlCharacter02, T2.[DisplaySeq] as RptLabelsDisplaySeq, T2.[KitFlag] as RptLabelsKitFlag, T2.[KitParentLine] as RptLabelsKitParentLine, T2.[KitPricing] as RptLabelsKitPricing, T2.[KitPrintCompsInv] as RptLabelsKitPrintCompsInv, T2.[KitPrintCompsPS] as RptLabelsKitPrintCompsPS, T2.[KitQtyPer] as RptLabelsKitQtyPer, T2.[KitShipComplete] as RptLabelsKitShipComplete, T2.[KitsLoaded] as RptLabelsKitsLoaded, T2.[LineDesc] as RptLabelsLineDesc, T2.[OrderLine] as RptLabelsOrderLine, T2.[OrderNum] as RptLabelsOrderNum, T2.[ShipDtlCharacter01] as RptLabelsShipDtlCharacter01, T2.[TrackingNumber] as RptLabelsTrackingNumber, T2.[NetVolume] as RptLabelsNetVolume, T2.[NetWeight] as RptLabelsNetWeight, T2.[UPCCode1] as RptLabelsUPCCode1, T2.[UPCCode2] as RptLabelsUPCCode2, T2.[UPCCode3] as RptLabelsUPCCode3, T2.[UOMSymbol] as RptLabelsUOMSymbol, T2.[MXProdServCode] as RptLabelsMXProdServCode, T2.[Calc_ChargeDesc] as RptLabelsCalc_ChargeDesc, T2.[DocOutstandingBalance] as RptLabelsDocOutstandingBalance, T2.[OutstandingBalance] as RptLabelsOutstandingBalance, T2.[SourceInvoiceNum] as RptLabelsSourceInvoiceNum, T2.[ProbReasonCode] as RptLabelsProbReasonCode, T2.[Calc_CProb] as RptLabelsCalc_CProb, T2.[Calc_fCallLine] as RptLabelsCalc_fCallLine, T2.[CallNum] as RptLabelsCallNum, T2.[ShipStatus] as RptLabelsShipStatus, T2.[WarrDescription] as RptLabelsWarrDescription, T2.[Calc_AsmSeq] as RptLabelsCalc_AsmSeq, T2.[Calc_MatNum] as RptLabelsCalc_MatNum, T2.[Calc_MtBillPrice] as RptLabelsCalc_MtBillPrice, T2.[Calc_MtCount] as RptLabelsCalc_MtCount, T2.[Calc_MtExtPrice] as RptLabelsCalc_MtExtPrice, T2.[Calc_MtLinedesc] as RptLabelsCalc_MtLinedesc, T2.[Calc_MtPaNum] as RptLabelsCalc_MtPaNum, T2.[Calc_MtQty] as RptLabelsCalc_MtQty, T2.[Calc_MtRevNum] as RptLabelsCalc_MtRevNum, T2.[ActLabHours] as RptLabelsActLabHours, T2.[BillableLaborRate] as RptLabelsBillableLaborRate, T2.[Calc_ServActHr] as RptLabelsCalc_ServActHr, T2.[Calc_ServDocRat] as RptLabelsCalc_ServDocRat, T2.[Calc_ServExtPrice] as RptLabelsCalc_ServExtPrice, T2.[Calc_ServNum] as RptLabelsCalc_ServNum, T2.[VenPartNum] as RptLabelsVenPartNum, T2.[ServDescription] as RptLabelsServDescription, T2.[Calc_MXImportDate] as RptLabelsCalc_MXImportDate, T2.[Calc_MXImportLocation] as RptLabelsCalc_MXImportLocation, T2.[AgingCreditClearDate] as RptLabelsAgingCreditClearDate, T2.[AgingCreditClearUserID] as RptLabelsAgingCreditClearUserID, T2.[AgingCreditCode] as RptLabelsAgingCreditCode, T2.[AgingCreditHold] as RptLabelsAgingCreditHold, T2.[AgingCreditHoldDate] as RptLabelsAgingCreditHoldDate, T2.[AgingCreditHoldSource] as RptLabelsAgingCreditHoldSource, T2.[ImporterOfRecord] as RptLabelsImporterOfRecord, T2.[ACWPercentage] as RptLabelsACWPercentage, T2.[BWSchedStartTime] as RptLabelsBWSchedStartTime, T2.[MinimizeWIP] as RptLabelsMinimizeWIP, T2.[SchedulingDirection] as RptLabelsSchedulingDirection, T2.[SyncReqBy] as RptLabelsSyncReqBy, T2.[TimeZoneAdjustForDST] as RptLabelsTimeZoneAdjustForDST, T2.[TimeZoneID] as RptLabelsTimeZoneID, T2.[Calc_AddressList] as RptLabelsCalc_AddressList, T2.[ClearBankExchRate] as RptLabelsClearBankExchRate, T2.[DefPosPayEFTHeadUID] as RptLabelsDefPosPayEFTHeadUID, T2.[LogoFont] as RptLabelsLogoFont, T2.[LogoImageID] as RptLabelsLogoImageID, T2.[LogoText01] as RptLabelsLogoText01, T2.[LogoText02] as RptLabelsLogoText02, T2.[LogoText03] as RptLabelsLogoText03, T2.[LogoText04] as RptLabelsLogoText04, T2.[LogoText05] as RptLabelsLogoText05, T2.[LogoText06] as RptLabelsLogoText06, T2.[LogoType] as RptLabelsLogoType, T2.[PositivePayBatchID] as RptLabelsPositivePayBatchID, T2.[PositivePayRemoteID] as RptLabelsPositivePayRemoteID, T2.[PREntryClassCode] as RptLabelsPREntryClassCode, T2.[PRPMEFTHeadUID] as RptLabelsPRPMEFTHeadUID, T2.[SignatureFont] as RptLabelsSignatureFont, T2.[SignatureImageID] as RptLabelsSignatureImageID, T2.[SignatureText01] as RptLabelsSignatureText01, T2.[SignatureText02] as RptLabelsSignatureText02, T2.[SignatureText03] as RptLabelsSignatureText03, T2.[SignatureText04] as RptLabelsSignatureText04, T2.[SignatureText05] as RptLabelsSignatureText05, T2.[SignatureText06] as RptLabelsSignatureText06, T2.[SignatureType] as RptLabelsSignatureType, T2.[BankBranchCode] as RptLabelsBankBranchCode, T2.[FSAEquipmentPartNum] as RptLabelsFSAEquipmentPartNum, T2.[FSAServiceOrderNum] as RptLabelsFSAServiceOrderNum, T2.[ManualDelete] as RptLabelsManualDelete, T2.[PartOptionAvailList] as RptLabelsPartOptionAvailList, T2.[PartOptionSelList] as RptLabelsPartOptionSelList
FROM InvcHeadDocPay_" + Parameters!TableGuid.Value + " T1 LEFT OUTER JOIN RptLabels_" + Parameters!TableGuid.Value + " T2 ON T1.RptLanguageID = T2.RptLanguageID WHERE T1.Company = '" + cstr(Parameters!Pm_INVCHEAD_Company.Value) + "' " + " AND T1.InvoiceNum = '" + cstr(Parameters!Pm_INVCHEAD_InvoiceNum.Value) + "' " + " AND T1.RptLanguageID = '" + cstr(Parameters!Pm_INVCHEAD_RptLanguageID.Value) + "' "
2 Likes
We have also noticed in the RDD if the Label is checked as Excluded and the field is not is still puts the label in the SSRS. We are seeing a log off errors with exceeding space limit or character size when customizing RDD’s.
Everyone within Epicor Support and Development that works with our reporting knows that our standard delivered ARForm is, um, not as optimally engineered as it could be. Yes, let’s say it that way.
Some things we have done in 10.2.300 because of the uniqueness of this report, that helps the entire product:
- As of 10.2.300.4, users should no longer ever see a 1024 column error message when printing any report. The labels we include with the RDDs get put into a view, and there is a 1024 limit. We are now limiting it to not more than 1024 automatically. This might result in a different set of errors coming from Reporting Services if the label is required by the RDD and it isn’t available to the RDL, but, it is very unlikely to occur.
- We have some new, completely undocumented and unsupported functionality that allows anyone to compare what is being included in a RDD to what the RDL is actually querying. Those that attended the Midwest EUG earlier this month got to hear me talk about it and how to use it. Didn’t attend? Working on a way of relying this information in a way that doesn’t make more work for me as it really isn’t supported.
Regarding the second one, we are using this internally so the apps dev teams can optimize their own system delivered RDDs, like ARForm, where we are including many more tables, fields and labels than the report itself uses at the moment. Sometimes we add additional things to an RDD for future use that haven’t been implemented yet (or may not be, or may have been implemented in a different way, etc) so standard RDDs can have some amount of bloat–ARForm is an example of this.
Big picture, speaking for myself, the solution to some of these issues could be addressed if we redevelop all of our standard black box RDDs to use BAQs as the datasource. That would allow us to do lots of cool things like have a sync dataset button on the style and can work exactly as everyone would like it to(!), take away the mystery of the calculated field logic we have(!!), be easier to see the relationships for those that are more comfortable with TSQL (as the BAQ will give you the joins in that format)(!!!), and the list goes on.
2 Likes
We are still seeing the 1024 column error in 10.2.300.5. Should we report this?
1 Like
Yes
The AR Form that we modified in 10.2.300.2 worked perfectly and when we upgraded to 10.2.300.5 it broke and we started getting the 1024 column error. We had to do some really bad changes in order for it to work and it still not right but at least it will preview and print the form.
The query in RDL has huge and pulls everything.
We were trying to find how to see what is was queried and actually used.
I will open a ticket.
1 Like
Yes please.
3 Likes
So the second item from my original comment I made about the unsupported thingamajiggy that I’m being vague about at the moment will definitely help. I’ll definitely put together some info to help you out there as soon as I can as long everyone promises not to contact support if they have questions/comments/concerns about it.
2 Likes
I am going to open a ticket and hope it makes it to developement.
I wish your ticket well. We just upgraded to 10.2.300.6 and ARForm is basically dead. The problem is a struggle with every upgrade. The reports are just a horrific mess.
1 Like
i have found most forms are a royal pain to work with. If you make the slightest change it can really screw things up.
2 Likes