PartAllo

Has anyone tried to do log tracking for deleted allocations? We want to track what users are unallocating. I tried to do a customization on the Unallocation method that fires but i think the records are already gone from the PartAlloc table by then. I am doing a pre method. here is the error i get when i try to grab the data.

image

1 Like

Hello John,
Hope you’re well.

This isn’t enough information to provide much assistance.

What exactly are you trying to achieve? When a part is unallocated, do you want a BPM that puts a comment on an object? Do you want it to create a new entry in your change log associated with a record? Do you want it to send an email to a set of BU heads so they have that information saved via email?

There’s a lot of ways this can be built out, and without a clearer definition, it’s difficult for anyone to advise you on a direction/help with the error. If possible, please provide more information, and show your BPM.

At a high level, you should run a trace log, look at the parameters being passed via the method you are running your BPM on. Check for data changes, and on those, add a condition to log a change somewhere on your object.

If the data is being destroyed, you can also add a condition for that, and on the deletion of those rows, add a tracking message/log somewhere in your system.

Best of luck!

1 Like


we have done something super similar with Order Entry and i was able to get it to work. We are trying not to use C# but if it cannot be helped then so be it.

We are trying to see if it is some rouge bpm that mrp is kicking off that is deleting allocations or it is an employee. The warehouse will pick and pull 200 parts and sometimes the next morning the allocation will be deleted from fulfillment. We are trying to replicate what i built for sales orders, which is if a sales order is deleted it provides the sales order information and then adds the user and a DT stamp to UD04. We then can filter on different keys to setup a dashboard that allows the different department heads to view it. (we also have this for jobs). It was my understanding that we could not use a change long because like the bin tables once someone unallocated a part the record is deleted.

I think i could easily get it to email out the information by doing an in transaction that leads to a standard then doing the emailing from there but they were looking for a way to report on it.

Hello John,
Hope you’re doing well.

Apologies for the delayed response, was a bit bogged down in some work of my own.

Please view the attached image. I used your method of setting fields, and this successfully created a record in my UD07 table.

image

image

Attached are all of the images of what you’ll need to put this together.

  1. Create a UD07 tableset variable
  2. Use the “ds” (dataset) which are the parameters passed to this method, to “set” those fields/data points you are interested in. Note: When setting the fields, make sure you are updating the UD07 tableset variable you created, not the OrderAlloc tableset.
  3. Once you set all your fields, call the update method, passing the previously created, and populated, tableset.

Let me know if you need any further assistance, I’d be happy to help.

Best,
Andrew I.

EDIT: Don’t use the “PartAlloc” DS to get the values such as the “PartNum”, use the OrderAlloc instead, to avoid that issue you are having.

Do:
image

Don’t:
image

1 Like