Troubleshooting Duplicate Quantity breaks on QuotForm

Epicor ERP 10
, ,
1

Hi All, I’ll preface with I’m new to Epicor in general and SSRS as well. My company recently upgraded to E10.2 cloud and I’m working on getting the quote form to look the way my contracts team want it. I’ve gotten it 99% of the way there, except my price breaks are printing 2x for each line. I get output like this:

image
image.png1424×568 35.4 KB

I’m lost trying to troubleshoot why this is happening since I can’t get at the server and don’t have a lot of background to draw on. Any tips on where I might start?

2

Did you click “Sync Datasets”? If so, you may want to start over on your SSRS. This added a ton of things to the SQL statement that play havoc on reports.

3

Yes, to my knowledge there’s no way to bring in additional tables without that. Is there another way?

4

Yes. It requires you to hand-edit the dataset’s SQL in the SSRS Report.
It’s not “fun”, but you’ll thank yourself in the long run.