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.
jeff


(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

PODetail#ScrUnitCost,PODetail#DocScrUnitCost

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.
Thanks