AUOM DMT, how?

[jbooker (Josh Booker)]

Almost exactly a year later, still working on trying to DMT from Pilot to Live.

DMT - Dynamic Attributes error

Has anyone successfully DMT’d Dynamic Attribute Classes for AUOM? Trying to reload AUOM Dynamic Attribute classes after pilot refresh and I cannot get past the error: Attribute enabled for MRP are Required everywhere. It likely refers to the Demand, Supply, Inventory options seen here: [image] However, the data doesn’t exist in the DynAttrClassDtl table and the DynClassAttrDtlReq table doesn’t exist in the DMT template. The closest I can find are the two fields seen here (DynAttrClassDtl…

Does anyone know how to DMT export the values from Inventory Tracking panel. Many fields in the template don’t exist in the tables.

DynAttrClassDtl.IsFinalExpression for example:

is not shown in BAQ or DataDictionary

How do I get these values out of one env so I can import into another?

TIA,
Josh

[aosemwengie1 (Alisa Osemwengie)]

So I don’t have access to an environment with AUOM right now to be able to figure this out but I can tell you how I would figure it out. Go into that screen, turn on tracing, and flip the flag on and off. Then look at the payload for the network calls. It should show you which dataset the flag actually belongs to. But keep in mind, not every field can be modified with DMT. Alternatively, if its not too much data, you might be able to paste-insert using classic, if you still have access to a classic screen for that UI.

[aosemwengie1 (Alisa Osemwengie)]

It looks like I still have access to the schema even without the license. Its here:

[jbooker (Josh Booker)]

Thanks! The table is not found in BAQ designer. Tried via SQL and got this:

reference to not registered table DynAttrClassField

Any workarounds to this?

I just need the data to export, so I can finish the DMT for supported fields in the template.

[aosemwengie1 (Alisa Osemwengie)]

I know some tables are intentionally hidden in the baq designer (i.e., file store) but I can’t imagine why that one would be. Seems very strange. Do you have access to the read only database? I believe that syncs everything even when hidden from the designer. Otherwise you can probably query it in c# in a function and write it out to a file? Or log a support case?

[jbooker (Josh Booker)]

No read-only db. ;( Prolly an oversight as AUOM seems half-baked, IMO. Thanks again.

[jbooker (Josh Booker)]

Look like these are in this endpoint:

/api/v1/Erp.BO.DynAttrClassSvc/DynAttrClassDtls

[BradBoes]

Josh, I worked with the AUOM at the last company I was at. There are multiple tables related to the AUOM dynamic class setup and values.
Our setup was fairly simple with just a few dynamic classes so we manually did the setup test to live. We did load beginning inventory values with the DMT though. I lived through the startup years on AUOM and 2024.1 and up is much better than the prior to that version.