DMT add a material

Does DMT have a way for the system to generate the material sequence for an added material automatically? Or do I have to calculate that myself?

I know there are some goofy codes that you can use to make it do extra things, but I can’t seem to find any help files. Does anyone know where to find the help information for DMT?

Side note on this, is there any side effects to simply deleting an assembly via DMT? In testing it looks like it’s letting me do it, however I’m a little leary of the other things (operations, materials, or other assemblies) that are below the assembly not deleting correctly and leaving some orphaned records. And insights or previous horror stories on this?

As you can probably piece together, I am trying to make a DMT solution to changing things from and assembly to a material on jobs to facilitate last minute decisions to buy things instead of make them. I would use pull assembly, except I can’t trust others to do the necessary transactions for that to work reliably. (issuing parts to the job). If i actually change it to a purchase direct material, everyone does things like they normally do and the transactions get done.

I believe you need to generate it yourself. I use a sql query to find the spot where I want the material to be then just add +5 or so as they are usually in increments of 10. Making sure that the update checkbox is cleared, it shouldn’t be an issue.

Good to know. I ended up doing a sub query that looks at the assembly sequence material list and adds 10 to the max. I think that will work out ok.