I have recently noticed that two records dealing with two differents PaymentMethodID in our PaymentMethod table have the save NoteID value.
I'm new in the Acumatica's world but it seems to me that a given NoteID value should be unique in its tenant.
I have decided to change the NoteID value of one of my conflicting records but to do so, I have to check before for potential uses of this value in other tables. Am I exhaustive if I search for the value to be changed in all tables having a NoteID column or can NoteID values be also used in columns having an other name ?
Best answer by Django
View original