
So when I’m attempting to delete a customer address ID, and later attempting to print an invoice which used this address, the address is blank. Is there a way to circumvent this issue? There are certain addresses I would like to clean up since they’re not longer used or mistakenly input in the first place. myPennMedicine Login
Hello Blythe,
It appears the system does let you delete an address ID that is currently being used, such as on a posted invoice. I would recommend to use some sort of reporting (Smartlist, etc) to first check to see if you have any open invoices using this address ID before you delete it from the system. You could also check the RM Open Transactions table in SQL with a script such as this:
select * from RM20101 where CUSTNMBR = 'ADAMPARK0001' and ADRSCODE = 'TEST' and CURTRXAM <> '0.00'
--update the customer ID and address code ID as needed. If you get a result, then do not delete this address ID.
Hope that helps.
Cheryl
Microsoft Support