We have a large number of custom price lists for customers. To keep the number of people with access to some of the data that is also found in customers, we are managing the price lists through IT. I thought I had sorted out an issue that keeps happening with updates to prices where it errors out do to trying to “update” the UOM.
I would agree with the message. UOM is a key column and should not be changed. However it is also a required column for this DMT type. I have forced the part number field to “text” as a work around previously but seem to have this ongoing issue. I did put in a ticket to Epicor. That didn’t seem to go anywhere. Any other suggestions?
I ran into this before and it was an issue with my file. Once I changed it to csv and opened it in notepad++ I was able to find extra spaces, removed them and then my DMT worked. Maybe you’ve already verified the exact characters in your file, just throwing it out there in case its helpful.
Thank you for the suggestion. I did find one issue looking at it in that format with some weirdness on a lower record with " ". I’m not at 100% failure now but it’s still most of them. I don’t see extra spaces.
I suggest opening this file in an app like MS Excel.
When you open it, you will have 5 columns shown (duh! )
Here is the thing, sometimes when copying and pasting info in apps like Excel, you might activate unnecessary columns, let’s say column 7 for example.
You will not see anything there after deleting the value, but the column is still active.
So my suggestion is that try this:
Select the 6th column (which should be empty) and select next few columns (lets say up to column 15).
When selected, just hit delete button on your keyboard.
So I purposely start with a template out of DMT instead of the file provided by the end user. Then I can manage what the column headers are and not run into these issues like you have listed. I am using a .csv file.
I paste values only from the provided files to eliminate any other issues.
I’ve been there, DMT just does not work sometimes for inscrutable reasons. Other things that sometimes help, closing and reopening DMT, changing the order of the columns in the file, using a sledgehammer on my laptop.
If the listcode is something else then it would be a different price list overall. The structure here is weird in that you have a price list (header), price list parts (parts on the price list) and then a customer cross reference to the price list. The list code is the link between price list and price list parts.
The UOMCode is not editable manually or otherwise. That’s why it would be my assumed choice based on the error message. The only way I know of to change it would be to delete the line all together and redo it with the right UOM.