DMT - How to override price list lookup in sales order detail upload

[rfarnsworth (Ryan Farnsworth)]

I am importing orders from another system and sometimes there is special pricing. I want the SO detail to just take what I have in my spreadsheet and override the price list lookup price. I have PriceLock in my template and it has made no difference. Searching the forum, I didn’t find anyone that really had this working.

Here are the fields that I am using.
Company OrderNum OrderLine PartNum XPartNum SellingQuantity NeedByDate OpenLine UnitPrice LockPrice

Any help would be appreciated.

[aosemwengie1 (Alisa Osemwengie)]

LockPrice works for us - are you populating that column with TRUE?

[rfarnsworth (Ryan Farnsworth)]

Yes, here are the fields with data.

Company OrderNum OrderLine PartNum XPartNum SellingQuantity NeedByDate OpenLine UnitPrice LockPrice

AE 482358 2 044-80012-0420 2 10/21/2022 TRUE 4.09 TRUE

[aosemwengie1 (Alisa Osemwengie)]

The only difference I can see with ours is we are uploading DocUnitPrice instead of UnitPrice. I don’t know if that would make a difference.

[lgraham (Lacey Graham)]

Agree, try DocUnitPrice. Not sure why UnitPrice sometimes does not work

[rfarnsworth (Ryan Farnsworth)]

I should have tried that first. It works with DocUnitPrice, but not with UnitPrice. Thanks so much

[Mark_Wonsil]

@lgraham

Not sure why UnitPrice sometimes does not work

Currencies. If we set the UnitPrice then there is no way to calculate the various currency variances. At least that’s how it was explained to me once.