DMT - quote detail how to get price?

Epicor ERP 10
, ,
1

Hello,

I am trying to enter Quote Details with DMT. I was able to enter the Quote Headers succesfully but I am having trouble with the details. I can’t seem to get the price in there. There are what seems to be a bunch of price fields but none seem to work. Does anyone have any experience with DMT and Quote Details? Here is what I am using:

image

And here is what ends up in Epicor:

image
image1103×720 52.9 KB

Nothing fancy here just a part (not in part master), a quantity, a price, description.

Any help would be appreciated!
thanks

2

Looks like I forgot the quantity in my example as I was trying to simplify the data but even when I had the quantity in there, the price would not load.

3

I had a similar issue with a BPM that creates quotes and ended up setting these fields if it helps: SellingExpectedQty, OrderQty, OverridePriceList to true, and DocDspExpUnitPrice.

4

Thanks but those didn’t work. I tried a couple others as well and no price shows up on the quote line. ugh!

Any other ideas?

5

If you know the line numbers, try putting the line into the spreadsheet twice, once to create the record and the second to update it?

6

No luck. It just seems like this shouldn’t be so difficult. I tried the QuoteQty# fields and all those do is add quantity break records. I can’t get the unit price to load.

7

OK figured it out. I’m not actually sure what I did but these are the fields I boiled it down to and it works now! :stuck_out_tongue_winking_eye:

image
image1151×271 33.3 KB

image

8

OK well it turns out that that was not the solution. I thought it worked because I saw numbers on the quote but those numbers are not from the DMT import but the price from the Part master, which I don’t want.

So I am back to square one, with not being able to import quote details with prices.

Any other ideas? thanks

9

Hi Jim,

I’m about to do this myself - I think it might be the QuoteQty where the price needs to be.
I’ll update once I’ve had a go.

Thanks

Mark

image
image801×646 35.4 KB

10

Hi,
Confirming this it’s QuoteQty#WQUnitPrice that does this.

Thanks

Mark

image

11

It was DocDspExpUnitPrice

image
image1073×89 4.91 KB

1 Like