I am trying to DMT customer pricelist, since the SeqNum determents inherence of the list. New price list needs to be on top. So, I have SeqNum as ‘1’ for all the customers with new price list. which should move all the existing records down by 1 and add the new record on top. but when I clicked process, it gives error for all “SeqNum” is constrained to be unique.
NOTE: on DMT I only have “Add New” checked off. unchecked “Update”
I have tested “Add New” and “Update” checked off, but this just replaces the top record, not adding new on top.
If you are trying to rearrange them you will need to use the existing lists and renumber them above the new ones in your list and I would suggest ordering the list in a descending order and place the new lists outside of the current list range to prevent issues with both add new and update checked. FWIW: I have never tried ordering lists in this way.
Ya, but if they have the same lists across lots of customers groups would make more sense and alleviate the DMT need and ease of updating list priority within a group versus the customer record.
Yes, but if you only have 4 customer groups it would be simple to add list to groups and order properly versus adding list to MANY customers individually
The same list can be contained within multiple groups AFAIK.
After testing with DMT tool I have found that it will not allow you to update with a list that exists in the customer record already, so update for this fails, also records are numbered starting at 1, so using 1 would fail as you saw earlier. I have found no way to add records at the top using this tool alone.
In my experience, you have to “unwind” the existing price lists by using a DMT delete run, then reload the new stacks completely. In this case you could use a BAQ to get the Delete run and then increment the numbers and added the new list for each customer who needs it in position 1.
Does it matter where it appears in the list, as long as the date range is correct?
(I guess if you have overlapping date ranges, you could have a preferred order.)
When you add one via the UI, doe it automatically get added to the end of the list, and then you’d have to use those “Move …” buttons to reorder it?
I would enable the trace log then click the “Move Up” or “Move Down” buttons to se what BO method is firing. You might need to make a BPM the calls that method as many times as necessary. Although looping through a BPM isn’t really possible - maybe can be done in a custom code block. Just make checks to see if the new reocrd includes some unique identifier so you can tell that it was a DMT load.
This was one of the only issues I saw IF @k.patel really needs to be at the top due to overlapping dates, and since they only asked about DMT I did not figure they were wanting to accomplish this another way, but this would be nice if the DMT would utilize a -1 as move to top of list on add as the missing or assumed 0 should just add to bottom of list. Nice would be a BPM looking at a DMT with -1 and use the BO you are referring to until this record bubbles to the top Without the BPM, just using the DMT this is not possible without a BAQ grab current list, DMT delete current items, DMT add with new list followed by old current list.
Without the BPM, just using the DMT this is not possible without a BAQ grab current list, DMT delete current items, DMT add with new list followed by old current list.