Getting "GetAccountsFull" error when accessing YO account groups due to duplicate CommentID's and AddressID's
Summary |
---|
This error comes up when viewing or clicking one of the account groups from the account list. This is due to accounts sharing the same AddressID and CommentID which are supposed to be unique. |
Fix |
---|
There are two ways to address the issue:
|
Editing the GetAccountsFull procedure |
---|
ALTER PROCEDURE [dbo].[GetAccountsFull] |
Update the affected accounts via account export and import. |
---|
Identify which accounts or account groups are affected and export the account details in a csv file. Prior to making any changes, a backup of the database must be saved on a different folder/location than of the default backup location.
|
Attachments: