Hi there,

Are your parameters correct? Looks like you’re sending the shipment type to the order type and the customer order number to the Order Number. 

Thanks for the reply!

I was typing “type” and didn’t notice it defaulted to the shipment type!

Order type is not available from the selection, so I hardcoded “SO” for type and now I get an error.

What is the error you get?

And are you sure that the customer order number mapping is correct?
 

Hi @ltussing03 ,

In my opinion, you missed something while mapping the parameters, if a hardcoded Sales Order number is passed in the Value of "OrderNumber" parameter, the report displays the expected output. If the Customer Order number is different from the Sales Order number, it is possible that the report may not match, and the data may not be displayed correctly. Therefore, it may be necessary to pass the Customer Order number as a parameter instead of the Sales Order number. 

Regards,

Sweta

Thanks.

You are correct!

The customer order number is not the same as the sales order number!

Thanks!

What is the error you get?

 

And are you sure that the customer order number mapping is correct?
 

 

Can mapping to find joining DAC fields ?

frederickodendaal77,

Thanks for the reply.

This is resolved and was a silly mistake by me.  Please see my note posted above.

“The customer order number is not the same as the sales order number!”

Thank you for sharing your solution with the community @ltussing03 !