DMT - Order Detail Secret Sauce

(Jeffrey Henslee) #1

Looking for the secret sauce for importing Sales Order Detail information?
I’ve gotten everything EXCEPT (for some reason) the unit price.

I’m importing the unit price, docunitprice, list price, doclistprice - even tried initialing the over price and override price list field s to true and still nothing. there’s nohints in the template. The field listed on the sales order is called curunitprice.

any ideas?

Please advise.

(Ernie Lowell) #2

Try DocDspUnitPrice.

(Ed Stang) #3

UnitPrice, DocUnitPrice are your magic fields if you are using the Sales Order Detail DMT Templates

(Jeffrey Henslee) #4

winner! winner! chicken dinner!
Thank you!

(Jeffrey Henslee) #5

OK want to try for double jeapordy?

Having the same issues with purchase orders.

(Ernie Lowell) #6

Drum roll, please…

Try DocUnitCost, but I think the bigger issue on PODetail was CalcOurQty.

(Ed Stang) #7


This was a nightmare to find the golden path - these two fields work consistently.

(Jeffrey Henslee) #8

Man this is frustrating as all heck.

I got the unit cost to come out on the screen - now I need to get the extended cost/price to appear on the Purchase order. The extended cost appears on the PO entry form - but is not printing on the PO itself.

I’ve got:
Unit cost, docunitcost, scrunitcost, docscrunitcost for cost fields
I also have calcourqty, pricingqty abd base qty fields filled in
I also have pricingunitprice filled in as well!!

I’m staring at the template and I can’t see any more quantity or price/cost fields in there. I don’t see any extended fields in that table either…(at least not in the template)

Ideas? Thanks, Jeff

(Greg Payne) #9

I looked at my template from loading into E9.I had CalcOuQty, UnitCost and DocUnitCost like you. I also had CostPerCode set to E and QtyOption set to Our.

(Jeffrey Henslee) #10

I’ll bet the quantity option might be it… Will advise.