Purchasing has asked that the default bin and bin description for each parts print on the purchase order form. I modified the report definition to link the PODetail to the PlantWhse and then the PlantWhse to the Whse Bin table to pull the bin and description field data.
I modified the report to print the bin and bin description to the report. The report prints fine if the purchase order lines don’t have multiple releases.
If a line has multiple releases the report fails to print the Ext Price for each part and the purchase order total at the bottom of the page multiples the ext price by the number of releases.
You may need to do this with a sub report. The multiple releases maybe causing you multiple records to come back in the SQL expression of the dataset in the RDL. I think the RelPart is a sub report in the PO already. What fields are you using to link PODetail to PlantWhse to WhseBin.
Adding a sub report was my first option and it produced the errors I described. Epicor support told me that I couldn’t do it thru a sub report, so I tried modifying the data definition. Same result.
After a lot of testing I found that the issue was with the Epicor report itself. Once I got a clear version of the report my sub report worked as designed.
Dan could you expand on how you resolved this issue? What do you mean by a “clean report”? This problem seems to occur with the default unchanged report on the default unchanged data definition as soon as I synchronize the data set.