I am looking for a way to remove a tracking number from AX 2012 R3 for UPS and FedEx. I was able to do this with FedEx ShipManager when we canceled a labeled, but not UPS.
However, I recently migrated to a software based labeling system and it does not have a defined method for canceled labels, so in AX I still see the original tracking number. With my software labeling system, I can verify if a label was previously generated and if so, I can reprint if it is less than 5 days old, otherwise we will reprint with new tracking number. I was thinking on the reprint with new tracking, I would trigger this SQL statement, as I have the Packing slip, Sales order, and Tracking numbers.
Delete FROM [TESTAX].[dbo].[SHIPCARRIERSTAGING]
where packingslipID ='017305' and salesID = '017350' and TRACKINGNUMBER ='xxxxxxxxxxxx'
Are there any other tables that I would also need to delete from?
Or, is there a field that I can update that would hide the previous tacking numbers from packing slip journal --> Order Tacking --> Tracking Numbers
The issue having multiple tracking numbers, is that my EDI ASN task will pull all tracking numbers and send them to my trading partners. Some only accept 1, so the chance that an invalid number being passed is valid.
