Hi There,
I have modified the BOMCost report and created a new RDD and style. Additionally, I have created a customized application for printing this report. This application utilizes Erp.Rpt.BOMCostReportSvc/SubmitToAgent in order to print. The issue that I am encountering is that I would also like to include either customer id or price list code as a parameter when submitting this report - I would like to include pricing in my report but require either of these to gather the correct price.
To better understand my use-case:
I have modified BOMCost and created a parts catalog based off of this. Example of my current report (in the early stages, still working on formatting etc):
This report currently displays part number, description, length/width/height/gross weight, and the image stored in FileStore on the part.
The following are the parameters that I currently have to work with within BOMCostReportSvc and example values from running my report once (Function Maintenance utilized to format parameters how required for BOMCostReportSvc):
AgentCompareString: ""
AgentID: ""
AgentSchedNum: 0
AgentTaskNum: 0
AltMethodList: ""
ArchiveCode: 0
AttachmentType: ""
AutoAction: "SSRSPREVIEW"
ConsiderPullAsAsmSettings: false
ConsiderTransferPartAsMtl: false
CostComparisons: false
DateFormat: "m/d/yyyy"
DecimalsCost: 0
DecimalsGeneral: 0
DecimalsPrice: 0
DesignMode: false
EMailBCC: ""
EMailBody: ""
EMailCC: ""
EMailTo: ""
EffDateList: "2025-04-15T00:00:00~2025-04-15T00:00:00~2025-04-15T00:00:00~2025-04-15T00:00:00~2025-04-15T00:00:00~2025-04-15T00:00:00~2025-04-15T00:00:00~2025-04-15T00:00:00"
EffectivityDate: "2025-04-15T00:00:00"
EffectivityDateToken: ""
FaxNumber: ""
FaxSubject: ""
FaxTo: ""
GlbDecimalsCost: 0
GlbDecimalsGeneral: 0
GlbDecimalsPrice: 0
NewPage: false
NumericFormat: ",."
PartList: "1000006~1000008~1000010~1000012~1000015~1000016~1000019~1000025"
PrintReportParameters: false
PrinterName: ""
ProcessCompany: ""
ProcessID: ""
ProcessSystemCode: ""
ProcessTaskNum: 0
ProdGroups: ""
ProdQtyList: "1~1~1~1~1~1~1~1"
RecurringTask: false
ReportCultureCode: "en-US"
ReportCurrencyCode: "USD"
ReportFormat: "EndPart"
ReportStyleNum: 1002
RevList: "PC~-~PC~PC~PC~PC~PC~-"
RowMod: "A"
RptPageSettings: ""
RptPrinterSettings: ""
RptVersion: ""
SSRSEnableRouting: false
SSRSRenderFormat: "PDF"
SysRowID: "00000000-0000-0000-0000-000000000000"
TaskNote: ""
UIXml: ""
WorkstationID:
My question comes around to is it possible to modify this and add an additional parameter to the business object? If not, how can we get around this?
If we are able to utilize one of the current fields that is not being used such as “EMailBody” etc, then how can we have the RDD properly interpret this field as the customer ID etc? The RDD and style will be updated to include the new tables required.
Also to mention, the reason I am not using a simple BAQ report is that I was unable to access FileStore from a BAQ.
Very much appreciate any help as I have been quite stuck on this! 