RDD Field doesn't show up in table field list for APR Routing

Epicor ERP 10
, , ,
1

I’m trying to pull in the “SellingRemainQty” into an email template through SSRS routing. I unchecked the ExcludeColumn and ExcludeLabel values for that field, but it doesn’t show up for selection.

2

If it’s a field on the RDD, even a calculated one (which I know, the one you’re referencing is not, just throwing it out there), it should be available to use in the routing. Make sure you have the correct RDD on the report style with the routing. Close out of report style maintenance and try again. If you still do not see it, then create a new report style with the RDD in question (the one that you’ve unexcluded the column on) and make a new routing from there. The field in question should now be available.

3

Tried copying the report style - no luck. The RDD in question is the PackSlip RDD and report style. Could my version of Epicor be the reason? Working with 10.2.100.17 here.

4

Mr. Kyle: I just tried on my end. Same thing SellingRemainQty not found in available Field list for breaking/routing email.

Very interesting - maybe an EpiCare ticket?

DaveO

5

SellingRemainQty is an external field, and in my experience, they are typically not displayed on RDDs (eg. TotalShipped on OrderDtl, it’s an external field that is not on the OrderDtl table for the OrderAck RDD). It’s strange that Epicor would even display all these external fields on the RDD field selection for ShipDtl, because regardless of exclusion status, they will not generate on the reporting temp table that’s created. Long story short, there is a Calc_DspBackOrdQty on ShipDtl that should get you what you need, and it is available on the RDD.

1 Like
6

Thanks for the clarification, and the suggested field did help for my needs.