Primary key rename functionality is not working

Hi All,

When working with Shipment orders we found that one of the selected dimensions (Inventdim’s pallet id) is wrong and further i found that pallet id is coming from another device (RF guns) and due to that some wrong pallet ids can be there in system.

And I need to change them to correct ones.

I have changed the Pallet id using the standard renaming function from the form WMSPallet.

Pallet ids in InventDim (Field : InventDim.WMSPalletId) table have been changed but Pallet ids in WMSOrderTrans (Field : WMSOrderTrans.palletIdPicked) are still showing original pallet Id.

I am not sure why WMSOrderTrans.palletIdPicked have not been updated.

But I found field InventDim.WMSPalletId is having WMSPalletId EDT and WMSOrderTrans.palletIdPicked is having WMSPickPalletId EDT.

WMSPalletId EDT has relation with WMSPallet table (Pallet master) and WMSPickPalletId has no relation with this table.

Please help to find out all the references related to pallet id in system and how can we change\rename them?

Regards,