Displaying country of origin on packing slip

Epicor ERP 10
1

I created our commercial invoice by modifying the standard packing slip. We assign the country of origin on the part master, so I thought I could either join to the Part or ShipCOO table. Both of them result in the report doubling the shipped quantity, even though there is only one line and one country of origin. The RDD offers Part as a pick link for ShipDtl, but it only returns the country number…we want to display the country name.

Duplicate rows in SSRS always seem to be due to duplicate rows in the joined table, but that is not the case here. I am stumped.

1 Like
2

I know it has been a while, but did you ever find a solution? I am running into the same issue and I’m not sure why the ShipCOO is causing the values to double.

3

I was meaning to answer this earlier and completely forgot…what I ended up doing was moving the Country of Origin and other export information to a subreport. That way the mysterious duplication didn’t affect the top level report.

1 Like
4

Thanks! I ended up making it work with a second dataset and lookup function. A subreport would have been good too!