"System message 28002" error when you clear the Allow posting to closed fiscal periods option on the GL Setup screen in Microsoft Dynamics SL

This article provides a solution to an error that occurs when you try to clear the Allow posting to closed fiscal periods check box on the GL Setup (01.950.00) screen.

Applies to:   Microsoft Dynamics SL
Original KB number:   2550945

Symptoms

When you try to clear the Allow posting to closed fiscal periods check box on the GL Setup (01.950.00) screen, you receive the following error message:

System Message 28002 - 'Can not disable posting to prior periods because unreleased batches in prior periods exist'.

Cause

This problem occurs when a batch that has a prior period to post hasn't been released yet.

Resolution

To resolve this issue, delete or release the unreleased batch that has a prior period to post. To do it, follow these steps:

  1. Run the following SQL statement in SQL Server Management Studio against your Microsoft Dynamics SL application database to identify the unreleased batch:

    selectBatNbr,EditScrnNbr,Status,PerPost,Module,*fromBatchwhereSTATUSIN('B','H')
    
  2. Identify the batches that have a value in the PerPost field prior to the current fiscal period. Delete or release the batches on the screen that are noted in the EditScrnNbr field.