Friends, I’ve posted this question before, but unfortunately, the solutions to the first question are not an option
I am trying to extend a customer to a vendor or a vendor to a customer programmatically.
I want to get my application certified for the marketplace. However, SQL Views are forbidden. SO, my current solution will prevent me from getting a certification.
Here is the issue. There does not seem to be a way within C# and the available DACs to retrieve a deleted customer or vendor record.
If I try to extend a customer to be a vendor programmatically, when I add the vendor account, it errors because Acumatica sees it as a duplicate.
I need to be able to
- determine if a vendor account is in the db with a DeletedDatabaseRecord = 1
- if it is there and of a deleted status, change it to no longer deleted.
If I cannot find a way to extend a customer to a previously deleted vendor without using SQL Views, I kind of screwed.
Best answer by Dmitrii Naumov
View original