Hi folks, I’m interested in hearing how other companies are doing frequent updates to supplier pricing when there are a lot (>50) across many suppliers…
Doing those manually is very inefficient and they occur daily. Many vendors are not sophisticated enough to do any sort of data interchange. We get spreadsheets and text lists in emails…
The users responsible for this are feeling the pain and asking for access to DMT, which I don’t want to do because of the dangerous broad access that it provides.
Are there any other ways to mass enter price updates without giving access to DMT??
BTW, these are the steps I was told they are currently taking (mind you, I don’t have any idea how this part of the job function works, so excuse me if the question seems obvious).
Navigate to Material management > Purchase management > Setup > Supplier price list
Enter supplier number, hit tab
Select New Part from pull down on top left
Enter part number
Validate effective date
Check Primary Supplier box
Enter new price on minimum line value and base unit price
It is incredibly annoying to work with the supplier price list interface IMO. We use DMT to upload bulk changes. You don’t want that though… I noticed there’s an option to import per below. I wonder if you did an export and looked at the data, then it might give info on how you need to upload it. Actions / Import or Export in the SPL program. One thing to be wary of that has bitten us, you can have multiple supplier price list records accidentally if you do not realize, effective date is used as a key. To replace one SPL record with another, either upload with same part number, supplier id, effective date, OR delete existing one first then upload.
Thanks for the tips – I’ll have them investigate the import process. I guess too that I could write a REST API interface in our Intranet web to make it easier for them (basically do the same thing has the DMT tool is doing).
