Hi Clint. My DMT adds both to Supplier Price List Tab and Subcontract tab. Data is correct and OPCode comes through but I would just like to add the Subcontract data without the SPL data. GUI allows me but DMT does not.
Not sure what you are meaning (asking) as you are specifically asking about SPL data as your screenshot shows (is from) the Supplier Price List and even has all required fields (DMT) in your screenshot (SPL)?
FWIW, They both exist in the same table… VendPart
Only difference is the sub will have an OpCode value. So, again, I’m not sure what you’re asking for here? As your screenshot shows you are IN the Supplier Price List:
ALL the required fields are in your screenshot except Company (always required) and VendorID (above snip):
PartNum, PUM, EffectiveDate
For subcontract only difference is the OpCode.
The DMT software requires SPL data to be mandatory which I don’t think it should be. Normally I would raise a ticket but my last day in the Epicor world is this Friday so they won;t get any further responses from me beyond that date.
Enter a record manually using only the fields you want. Create a BAQ that retrieves that record with all the fields you filled in, as well as all the fields Epicor filled in for you. Export that to Excel. Change the values so a new record can be created… and try to DMT it in.
And confirmed data only went into Subcontract. Nothing in SPL. I think my original attempt had a couple of additional fields that brought in SPL. Thanks for persevering on this and I will pass on the template internally. Also, I think this marks the 1st post on this item with a solution.