USP_DATAFORMTEMPLATE_ADD_FENXTIMPORTACCOUNT_PRELOAD

                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_FENXTIMPORTACCOUNT_PRELOAD
                    (
                        @PDACCOUNTSYSTEMID uniqueidentifier,
                        @NUMBEROFACCOUNTS nvarchar(200) = null output
                    )
                    as
                        set nocount on;

                        -- displays message in the UI showing the number of accounts that will be imported

                        select @NUMBEROFACCOUNTS = convert(nvarchar(10),count(*))+ ' accounts will be added from Financial Edge NXT'
                            from dbo.FENXTACCOUNT
                        where not exists (select 1 from dbo.GLACCOUNT where GLACCOUNT.PDACCOUNTSYSTEMID = FENXTACCOUNT.PDACCOUNTSYSTEMID and GLACCOUNT.ACCOUNTNUMBER = FENXTACCOUNT.ACCOUNTNUMBER)
                            and FENXTACCOUNT.PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID
                            and FENXTACCOUNT.PROJECTREQUIRED = 1;

                        return 0;