Sage 100

You need to use the GL Utility to Delete Accounts.  Extract the GL accounts in Excel, narrow the file down to accounts to delete.  Create a VI job for GL_Accounts into the delete utility.  Postings in all modules must be done in advance.  Make a backup of the company data before deleting.  KB ID:  223924250030927

Thank you for replying Michelle.  However, this is what I have been trying to do all along.  The accounts are marked with status "Deleted" but are NOT DELETED.  Again, these accounts have never been posted to.  Fiscal year end just leaves them all as is.

You need to use the GL Utility to Delete Accounts.  Extract the GL accounts in Excel, narrow the file down to accounts to delete.  Create a VI job for GL_Accounts into the delete utility.  Postings in all modules must be done in advance.  Make a backup of the company data before deleting.  KB ID:  223924250030927

What happens when you click the Proceed button?

Thank you for replying Michelle.  However, this is what I have been trying to do all along.  The accounts are marked with status "Deleted" but are NOT DELETED.  Again, these accounts have never been posted to.  Fiscal year end just leaves them all as is.

You need to use the GL Utility to Delete Accounts.  Extract the GL accounts in Excel, narrow the file down to accounts to delete.  Create a VI job for GL_Accounts into the delete utility.  Postings in all modules must be done in advance.  Make a backup of the company data before deleting.  KB ID:  223924250030927

What happens when you click the Proceed button?

Thank you for replying Michelle.  However, this is what I have been trying to do all along.  The accounts are marked with status "Deleted" but are NOT DELETED.  Again, these accounts have never been posted to.  Fiscal year end just leaves them all as is.

You need to use the GL Utility to Delete Accounts.  Extract the GL accounts in Excel, narrow the file down to accounts to delete.  Create a VI job for GL_Accounts into the delete utility.  Postings in all modules must be done in advance.  Make a backup of the company data before deleting.  KB ID:  223924250030927

That's what I am doing.  I get the Delete Accounts Log showing the accounts with status changed to Deleted, but the accounts are NEVER deleted.

What happens when you click the Proceed button?

Thank you for replying Michelle.  However, this is what I have been trying to do all along.  The accounts are marked with status "Deleted" but are NOT DELETED.  Again, these accounts have never been posted to.  Fiscal year end just leaves them all as is.

You need to use the GL Utility to Delete Accounts.  Extract the GL accounts in Excel, narrow the file down to accounts to delete.  Create a VI job for GL_Accounts into the delete utility.  Postings in all modules must be done in advance.  Make a backup of the company data before deleting.  KB ID:  223924250030927

Then you do a general ledger year end processing and the accounts are still there?

That's what I am doing.  I get the Delete Accounts Log showing the accounts with status changed to Deleted, but the accounts are NEVER deleted.

What happens when you click the Proceed button?

Thank you for replying Michelle.  However, this is what I have been trying to do all along.  The accounts are marked with status "Deleted" but are NOT DELETED.  Again, these accounts have never been posted to.  Fiscal year end just leaves them all as is.

You need to use the GL Utility to Delete Accounts.  Extract the GL accounts in Excel, narrow the file down to accounts to delete.  Create a VI job for GL_Accounts into the delete utility.  Postings in all modules must be done in advance.  Make a backup of the company data before deleting.  KB ID:  223924250030927

Thank you for replying Michelle.  However, this is what I have been trying to do all along.  The accounts are marked with status "Deleted" but are NOT DELETED.  Again, these accounts have never been posted to.  Fiscal year end just leaves them all as is.

You need to use the GL Utility to Delete Accounts.  Extract the GL accounts in Excel, narrow the file down to accounts to delete.  Create a VI job for GL_Accounts into the delete utility.  Postings in all modules must be done in advance.  Make a backup of the company data before deleting.  KB ID:  223924250030927

Any budget data for those accounts?

Thank you for replying Michelle.  However, this is what I have been trying to do all along.  The accounts are marked with status "Deleted" but are NOT DELETED.  Again, these accounts have never been posted to.  Fiscal year end just leaves them all as is.

You need to use the GL Utility to Delete Accounts.  Extract the GL accounts in Excel, narrow the file down to accounts to delete.  Create a VI job for GL_Accounts into the delete utility.  Postings in all modules must be done in advance.  Make a backup of the company data before deleting.  KB ID:  223924250030927

Kevin -  No budget, no anything!

Any budget data for those accounts?

Thank you for replying Michelle.  However, this is what I have been trying to do all along.  The accounts are marked with status "Deleted" but are NOT DELETED.  Again, these accounts have never been posted to.  Fiscal year end just leaves them all as is.

You need to use the GL Utility to Delete Accounts.  Extract the GL accounts in Excel, narrow the file down to accounts to delete.  Create a VI job for GL_Accounts into the delete utility.  Postings in all modules must be done in advance.  Make a backup of the company data before deleting.  KB ID:  223924250030927

As a test or workaround try merging them into one account.  If that works then try to delete the remaining account.

Kevin -  No budget, no anything!

Any budget data for those accounts?

Thank you for replying Michelle.  However, this is what I have been trying to do all along.  The accounts are marked with status "Deleted" but are NOT DELETED.  Again, these accounts have never been posted to.  Fiscal year end just leaves them all as is.

You need to use the GL Utility to Delete Accounts.  Extract the GL accounts in Excel, narrow the file down to accounts to delete.  Create a VI job for GL_Accounts into the delete utility.  Postings in all modules must be done in advance.  Make a backup of the company data before deleting.  KB ID:  223924250030927

Doug - I have tried that approach.  I imported the first 1000 accounts to merge (out of 110,000) and the utility ran for hours and never completed.  When I go back in to see, nothing has changed.

As a test or workaround try merging them into one account.  If that works then try to delete the remaining account.

Kevin -  No budget, no anything!

Any budget data for those accounts?

Thank you for replying Michelle.  However, this is what I have been trying to do all along.  The accounts are marked with status "Deleted" but are NOT DELETED.  Again, these accounts have never been posted to.  Fiscal year end just leaves them all as is.

You need to use the GL Utility to Delete Accounts.  Extract the GL accounts in Excel, narrow the file down to accounts to delete.  Create a VI job for GL_Accounts into the delete utility.  Postings in all modules must be done in advance.  Make a backup of the company data before deleting.  KB ID:  223924250030927

Kevin -  No budget, no anything!

Any budget data for those accounts?

Thank you for replying Michelle.  However, this is what I have been trying to do all along.  The accounts are marked with status "Deleted" but are NOT DELETED.  Again, these accounts have never been posted to.  Fiscal year end just leaves them all as is.

You need to use the GL Utility to Delete Accounts.  Extract the GL accounts in Excel, narrow the file down to accounts to delete.  Create a VI job for GL_Accounts into the delete utility.  Postings in all modules must be done in advance.  Make a backup of the company data before deleting.  KB ID:  223924250030927

Hmm... Within SQL, try searching all tables for some of the AccountKey values, to see if there is something hard-to-find that might be blocking the delete?  (Google provided this query years ago, and it has proven handy...).

USE MAS_TST

DECLARE @SearchStr nvarchar(100) = 'SEARCH VALUE'

DECLARE @Results TABLE (ColumnName nvarchar(370), ColumnValue nvarchar(3630))

SET NOCOUNT ON

DECLARE @TableName nvarchar(256), @ColumnName nvarchar(128), @SearchStr2 nvarchar(110)

SET  @TableName = ''

SET @SearchStr2 = QUOTENAME('%' + @SearchStr + '%','''')

WHILE @TableName IS NOT NULL

BEGIN

    SET @ColumnName = ''

    SET @TableName =

    (

        SELECT MIN(QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME))

        FROM     INFORMATION_SCHEMA.TABLES

        WHERE         TABLE_TYPE = 'BASE TABLE'

            AND    QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME) > @TableName

            AND    OBJECTPROPERTY(

                    OBJECT_ID(

                        QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME)

                         ), 'IsMSShipped'

                           ) = 0

    )

    WHILE (@TableName IS NOT NULL) AND (@ColumnName IS NOT NULL)

    BEGIN

        SET @ColumnName =

        (

            SELECT MIN(QUOTENAME(COLUMN_NAME))

            FROM     INFORMATION_SCHEMA.COLUMNS

            WHERE         TABLE_SCHEMA    = PARSENAME(@TableName, 2)

                AND    TABLE_NAME    = PARSENAME(@TableName, 1)

                AND    DATA_TYPE IN ('char', 'varchar', 'nchar', 'nvarchar', 'int', 'decimal')

                AND    QUOTENAME(COLUMN_NAME) > @ColumnName

        )

        IF @ColumnName IS NOT NULL

        BEGIN

            INSERT INTO @Results

            EXEC

            (

                'SELECT ''' + @TableName + '.' + @ColumnName + ''', LEFT(' + @ColumnName + ', 3630)

                FROM ' + @TableName + ' (NOLOCK) ' +

                ' WHERE ' + @ColumnName + ' LIKE ' + @SearchStr2

            )

        END

    END   

END

SELECT ColumnName, ColumnValue FROM @Results

Kevin -  No budget, no anything!

Any budget data for those accounts?

Thank you for replying Michelle.  However, this is what I have been trying to do all along.  The accounts are marked with status "Deleted" but are NOT DELETED.  Again, these accounts have never been posted to.  Fiscal year end just leaves them all as is.

You need to use the GL Utility to Delete Accounts.  Extract the GL accounts in Excel, narrow the file down to accounts to delete.  Create a VI job for GL_Accounts into the delete utility.  Postings in all modules must be done in advance.  Make a backup of the company data before deleting.  KB ID:  223924250030927