Does anyone know of a way to track material allocations and unallocation? I want to be able to see when something was allocated, whom the user was, and the same thing when something is unallocated. Where can I pull that information?
Hi Zach! Welcome aboard!
I would look at the PartAlloc and/or PartAllocTran tables. Do a quick query on those and see if they have the information you’re looking for.
1 Like
Welcome Zach!
As @dcamlin says, the PartAlloc table (as far as I know) is the key table here. Records are created in this table when allocations are made, the records are deleted when the allocation is fulfilled (or deleted)… so a Change Log wouldn’t be useful as the log itself is deleted when the record it is attached to is deleted.
I honestly don’t know what the PartAllocTran table does, but it has fewer records in it than the PartAlloc table and I can’t really relate them to anything. If someone else has more information please share!
From the 20 minutes or so I’ve spent looking at this, it seems your best bet for some type of log would be to use a UD table, and create a Data Directive on PartAlloc that would update your UD table for any addition or deletion to PartAlloc… then probably a dashboard so you could review the data later on.
1 Like