Hello All,
I am trying to DMT to LEAD Box in the Supplier Price List. I have used them template builder to create what I thought would be an easy DMT, but I cannot get anything to change this Box after processing MRP. I have tried Vender, Price List, Part Plant Tables, but nothing is working to DMT these parts. I could do it manually, but now this is just bothering me! Has anyone successfully DMT’d this data table?
The part number on the Excel spreadsheet is not the same as the one in SPL.
Was just using as an example. I cannot figure out where that data field is. It is driving purchasing decisions. I have changed it for a collection of parts in Part Plant, Supplier Part, Supplier Price List, but they all just keep staying the same on the price list and on the NEW PO Suggestions. I don’t understand what other data tables their are to DMT.
The Supplier Price Break table also requires the effective date to match in the your spreadsheet. It is a part of the key, otherwise, DMT won’t know which record to update. It’s a tricky table to update in batch.
@sspiewak, how many parts are you thinking of updating ?
Have you thought of UBAQ? You can use the below as an example and put some criteria or parameters to get the results and publish it as a dashboard.
Once done, you can run that dashboard, copy it to excel, update the lead time and use Paste Update option and then hit save. That should do the trick.
Here is the UBAQ:
PricelistCheck.baq (33.6 KB)
Thanks All - Updateable BAQ was awesome! It updated all the pricelists. However, I ran MRP on this part and PO Suggestion still is saying 10 in lead time!
What am I doing wrong?
What is the effective date of your SPL? Check to make sure the price is valid for when the PO Suggestion is for.
Hi Shawn,
Are you using Part Plant in DMT? The below columns are the only ones required to update the LeadTime, try only using these columns.
Remember, Plant field is case sensitive also so ensure this is the same on the DMT file as what it is in the system.
If this doesn’t work, let me know what message you’re receiving when running the DMT.
Yes the Part plant was the first table I looked too. No where do these parts have a lead time of 10 days, but in NEW PO Suggestions it is getting 10 days from somewhere. I for the life of me cannot figure it out.
Purchased parts can get lead times from the Supplier Price List as well. They take precedent over PartPlant.
Thanks Mark - Those are also updated. I am running out of places to look! I have a ticket open now, hoping Epicor can tell me where that lead time is being pulled from.
Did you check the MOM to make sure it isn’t hard coded on the material?
John,
I had not thought of that so I did review, but that is also not the case. In fact time phase also shows the correct lead time. The only place it shows the 10 days (as opposed to the correct 15) is in the PO suggestion module. It is driving me crazy.
I had not thought of that, but sadly that was not the issue either. Epicor can’t seem to tell me where that number is coming from either. Very strange.
Did you check Part Class?
I did not John. But I just did and the default was 10. Is there a reason that PO Suggestions would bi-pass all the other lead times?
Perhaps there is a lead time hierarchy?
PS - Thank you so much for following up with me on this.
THEORETICALLY, hierarchies such as this work from the bottom up… so that a PartPlant value would be looked at first, and if it was set to zero at that level it would go up a notch to PartClass (I’m leaving out Urgent Planning here).
If it isn’t working that way (and it sure looks like it isn’t), enter in a support call and see if it’s a known bug in your version. This one has BIG implications for a lot of people.
Just for fun, remove the value from the Part Class screen (set it to zero) and re-run Generate Suggestions… see if it then follows the PartPlant value.
Thanks Ernie,
I will try to remove from Part Class. I have a ticket open with Epicor, agree it is a big issue. Thanks for the suggestion. I will let you know how it goes,
I tried, processed MRP - Still says 10 in the New PO Suggestions. It is 15 at PArt Plant, Price Lists, Everywhere, except where it matters! This is driving me crazy.
Is there anything in the Urgent Planning fields?
