Good evening,
I am working on a DMT to add Quote Detail lines. I have part descriptions added to all lines in the LineDec field. For whatever reason when I run the DMT some of the lines fails with: QuoteNum:855589, QuoteLine: 4 Table:QuoteDtl: Msg: Description is required.
The part is not in the part master but from what I can see that should not be an issue as I have other parts that are similar that loads just fine.
Anyone have any suggestions?
TIA,
Kristine
Can you provide an example of one that fails including your DMT template headers?
Are the lines that are failing the non-Part masters?
Yes they are.
Just a thought, are you supplying something to be used when the Part isn’t on file?
According to the DMT template if a part is not in the part master you need to add the LineDesc column. All my parts have descriptions.
The error is probably misleading as you are including the LineDesc column. There is a CheckPartDescription column too that for those lines perhaps set to FALSE. Maybe even the KitFlagDescription set to P (Parent part)
Sometimes a trace of manually entering in a line can help using Jose’s trace helper Kinetic Trace Helper Utility 1.0 (Kinetic Web) Chrome Extension
My next step would be to see what happens in the screen if you supply just the data for that one line. Usually the error messages the screen gives you are more detailed. I’ve had to do this for a few loads in the past, to identify the ‘edge cases’ and change how those are loaded.
(I get a big Part update every so often and there seems to be something new with each one)
I can manually enter the line with part and description without an issue that is what is so frustrating. I am sure it is a silly thing in the end I am just not seeing it right now.
Which is why I suggest using the trace helper so you can see the data in the REST calls.
What happens if you strip the file back to just Company / QuoteNum / QuoteLine / PartNum / LineDesc and upload?
Presume Add New & Update are ticked?
Here is the DMT template I used when importing legacy historical records.
I uploaded 19400+ quote detail lines with no errors, so this worked for me. It may come down to column order.
Agree with the column order shout
