I’m trying to use DMT to do a number of quantity adjustments related to my end of year physical inventory. I do not want to process this whole list by hand but my year end processes need to finish ASAP.
I am in DT and forced to use the DMT client assigned by the update routine. We are current on this machine, windows 10.
I make a template and fill it in. The template tells me the following are required when I validate it. All columns are valid. I hit Process
So I add these two optional columns. I can validate, but get the same error again when processing.
What is odd is if I rename them to this I get this error here when I load the file, (error at vaildate)
But I can actually process the file now! But then I get this error
If your company config is configured to use Inventory Adjustment Reasons (Modules/Materials/Inventory/General), you will need a reason valid reason code, so make sure it is populated with one that is. So check either Material Management/Inventory Management/Setup, Production Management/Job Management/Setup, Production Management/Quality Assurance/Setup or Sales Management/Customer Relationship Management/Setup to confirm that the reason code you have is valid.
If any of your part are serial tracked then you would also need to populate a serial number (although I have never had a need to use that personally).
I’m surprised the header validated with the (Company Preference) in the column header.
Also, and this is a shot in the dark, I have seen some postings where DMT is particular on the case of characters for certain fields. In your last screen short, of where the import works, the plant is different to the other screenshots.
I posted this. My screenshots are for a 1 line DMT. This is in Dedicated Tenancy and I can’t download a different DMT than the one pushed by the autoupdate client to my machine.
It really looks like someone who programmed it set two columns as required which can’t be part of the file. I think they wanted an informational error and instead made “SerialNo (SN Tracked Parts)” required instead of leaving it optional, and made “ReasonCode (Customer Preference)” a required field, neither of which are field names - so you could never process. Looks to me to be a straight up programming and QA issue.
Case CS0001858931 was logged off of the VM I left and they identified this as a known issue and sent me a ZIP of a different DMT program to try. I am doing that now.