PackSlipRptParam odd question

Epicor ERP 10
1

We do this wild thing where the invoice comment on our packslip is the skid for the shipment. In other words, turned our packingslips into makeshift masterpacking slips. And yes, I have slowly gotten them to try masterpack shipment for one client right now… waiting to get enough shipments under their belt before we do it everywhere.

So… we print labels by the packline… Well, I want to use the base SSRS packslip report and I need to pass it the packline to print and that’s what the rest of this is about. How would I pass the pack line as a parameter or even a filter value I can use in the rDL.

Does anyone know what the PackNum parameter is used for on the PackSlip report? It’s always 0 and I might try and use it as a field to pass a parameter to the base SSRS report.

PackingSlipParam[0].PackNum = 0;

In the PackingSlipPrintSvcContract PackSlipParams dataset does?

I always see this parameter populated instead.

PackingSlipParam[0].PackNumList = “123456”

I might populate the packnumlist with the pack line and then filter the RDL on just the first packslip in the list.

I am generating the report like this:

    this.CallService<Erp.Contracts.PackingSlipPrintSvcContract>(pslip => {
      
    Erp.Tablesets.PackingSlipPrintTableset dsPslip = new Erp.Tablesets.PackingSlipPrintTableset();
      
    //define function params
      dsPslip = pslip.GetNewParameters();
      dsPslip.PackingSlipParam[0].PackNum = 0;
      dsPslip.PackingSlipParam[0].PrintingOptions = "S";
      dsPslip.PackingSlipParam[0].AssignLegalNumber = false;
      dsPslip.PackingSlipParam[0].EnableAssignLegalNumber = false;
      dsPslip.PackingSlipParam[0].EnableIncludePCID = false;
      dsPslip.PackingSlipParam[0].IncludePCID = false;      
      /*need param here*/dsPslip.PackingSlipParam[0].PackNumList = "282574"; //NEED PARAM HERE FOR PACK NUM
      dsPslip.PackingSlipParam[0].AutoAction = "SSRSPrint";
      /*need param here*/dsPslip.PackingSlipParam[0].PrinterName =  // NEED PARAM HERE 
      /*need param here*/dsPslip.PackingSlipParam[0].RptPageSettings  = //NEED PARAM HERE
      /*need param here*/dsPslip.PackingSlipParam[0].RptPrinterSettings = //NEED PARAM HERE
      dsPslip.PackingSlipParam[0].ReportStyleNum = 2; //your report style number
      dsPslip.PackingSlipParam[0].DateFormat = "m/d/yyyy";
      dsPslip.PackingSlipParam[0].NumericFormat = ",.";
      dsPslip.PackingSlipParam[0].ReportCultureCode = "en-US";
      dsPslip.PackingSlipParam[0].ReportCurrencyCode = "USD";
      dsPslip.PackingSlipParam[0].SSRSRenderFormat = "PDF";
      dsPslip.PackingSlipParam[0].FaxSubject = "";   
      dsPslip.PackingSlipParam[0].EMailTo = "";   
      dsPslip.PackingSlipParam[0].EMailBody = ""; 
      dsPslip.PackingSlipParam[0].AttachmentType = "PDF";
      dsPslip.PackingSlipParam[0].RowMod = "A";
      pslip.SubmitToAgent(dsPslip, "SystemTaskAgent", 0, 0, "Erp.UIRpt.PackingSlipPrint");
      pslip.Dispose();
      });
1 Like
2

You could use the TaskNote field.

3

thanks man thank you so much.

1 Like
4

Can you elaborate on where that field shows up though on the SSRS rdl report side? I don’t see it included in any of the datasets on the ReportServer DB.

5

I feel like I’ve seen a post of yours on that. if you wanna link me to the thread I’ll read and try and figure it out.

6

Looking at it further it might not. Crap, give me a minute.

7

That field was brought down by default in BAQ reports, I assumed it was in these types too, but alas, the answer is no.

Maybe write a ud field on the pack itself, pull that in the rdd ?

1 Like
8

Ok I got something that might work, but I don’t know what this field is actually for, so caveat emptor.

The report parameters have a field called DocCopyNum that is passed down to the report.

This is what the report sees:

[
    {
        "Company": "MS67964",
        "AssignLegalNumber": false,
        "DCHdrList": "",
        "DemandContractList": "",
        "DocCopyNum": "Utah",
        "DraftMode": false,
        "EnableAssignLegalNumber": false,
        "EnableIncludePCID": true,
        "IncludeInventoryAttributes": false,
        "IncludePCID": true,
        "PackNum": 0,
        "PackNumList": "77680",
        "PrintingOptions": "S",
        "StyleNumExt": 1001,
        "ReportCultureCode": "en-US",
        "ReportCurrencyCode": "USD",
        "ThousandsSeparator": ",",
        "DecimalSeparator": ".",
        "DecimalsGeneral": 2,
        "DecimalsCost": 5,
        "DecimalsPrice": 5,
        "GlbDecimalsGeneral": 2,
        "GlbDecimalsCost": 5,
        "GlbDecimalsPrice": 5,
        "DecimalsQuantity": 2,
        "CompanyExecutionTime": "2024-11-12T12:30:37.173"
    }
]

You can modify the rdl to pull it in the RptParameter dataset.

="SELECT T1.DecimalsQuantity, T1.DocCopyNum FROM RptParameter_" + Parameters!TableGuid.Value + " T1"

image

image

1 Like
9

Yeah that could work then, I’ll check Haso’s chm to see if it has anything on what that field is for, but yeah that’s what I was hoping to do, hijack a field.

1 Like
10

The question is though, is that available in this code as a parameter.

11

Should be, was available in the bpm for SubmitToAgent.

12

image
image1130×599 14.4 KB

1 Like
13

Pic reuploaded, wrong service the first time.

14

You inspired me to start a new thread with some stuff:

https://www.epiusers.help/t/fun-with-ssrs-troubleshooting-tools/120836

1 Like
15

Thanks, I was about to go back and look at the trace!

1 Like
16

is this on swagger page?

1 Like