Does anyone have a working template for the Supplier Price List.
I have tried nearly every combination of fields but keep getting the following error:
Record with VendPart: ABC not found
are you trying to do add new or update or both?
On this occassion Iām trying to update existing records.
Try checking both the add new & update. Also, do you have the header as SupplierPart#VendPartNum?
Sometimes the order is important as well. Try to follow as listed in the required fields.
My template is as follows:
Company
VendorID
PartNum
PUM
EffectiveDate
BaseUnitPrice
Record with VendPart: ABC not found.
Add New works fine but then I end up with 2 records.
That sounds like a bug if youāre getting two records. That DMT template is very close to what Iāve used. I am on version 4.0.48.1 and that works. Do you have another workstation/server with a different version?
I tried 4.0.32.0 - no joy - 2 different workstations.
I tried 4.0.66.0 - no joy - 2 different workstations.
You may have to try adding records without the vendpart and then doing another DMT to update with just required fields and vendpart.
1 Like
I tried SupplierPart#VendPartNum - same error.
I tried VendPart - error āThe Following columns are invalid: VendPartā
The fields you list are correct. Is āABCā a partnum that exists in your system? I know DMT will say āVendPartā in its error log pertaining to the supplier price list but it doesnāt always mean their is an issue with the PartNum itself, but instead with one of the other fields associated with that PartNum.
I always check the following in my templates as I have been burned by these before.
No hidden formulas
No truncating of zeroes off partnums (Excel likes to do this)
No hidden spaces before or after any data in the spreadsheet
No blank columns in between the columns Iām trying to load.
So, Vend Part is not an editable field and only works as add new. I have ran into this recently, and I had to run a DMT delete, then run a new upload to update the vendpart field.
If you are just trying to update some other values from vend part, then exclude that field for the update, as it isnāt required. I tend to just put a blank column between the fields to load and those that are informational to me. the blank column acts as a stop with DMT so it reads nothing past that.
I donāt have VendPart in my template.
I also used the exact template to upload all of my data into the live system.
Iām running out of things to try.
Company
VendorID
PartNum
PUM
EffectiveDate
BaseUnitPrice
Hi Roberto,
I too have struggled with this DMT but eventually got it working but itās been a little while. I recall that the EffectiveDate is actually a key field. You will get multiple supplier price list records if you have a record in there with say 1/1/2021 and you upload a 8/26/2021 one.
I usually download all my existing supplier price list data to get the effective date and use that old one in my āupdateā so I do not get additional unwanted new records. Could this possibly be the problem for you too?
I also needed to upload vendor part no records separately like Andrew mentions above, but it doesnāt sound like you need those.
I suggest a query of what you have in there, tie vendpart to vendor and show fields like this, to review and see if it helps you get it working from looking at data thatās exising.
Nancy
1 Like
@Nancy_Hoyt - thanks for the input.
The EffectiveDate was the issue.
My initial plan was to update this field to today when updating the price list but this turns out to be the source of the problem.
Because I have a mismatch on the Db EffectiveDate - DMT errors out with Record with VendPart: ABC not found.
If I match the EffectiveDate - it works.
How intuitive.
Roberto.
1 Like
Hooray! Yeh, using the effective date as a combination key seems very strange to me and has bitten me before with dupe records unexpectedly. Glad itās working for you now!
Nancy