********************************************************************************************
*** Sys Msg 821 'One or more documents within the batch is out of balance' in AP in 4.x. ***
********************************************************************************************

Document ID.......: 126431
Date Created......: 8/9/2000 1:09:00 PM
Date Last Modified: 9/27/2001 3:52:51 PM
Language..........: English - United States
Country...........: USA
Product...........: Solomon IV 4.x
Versions..........: 4.x
Modules...........: Accounts Payable

System Message 821 - 'One or more documents within the batch is out of balance. 
Do you want to edit?' occurs in Accounts Payable in Solomon IV Version 4.x.
POTENTIAL CAUSES:

1. Occurs when attempting to release a Voucher and Adjustment Entry (03.010) 
batch when documents are not out of balance and the APDEBUG indicates that the 
batch will release correctly. The NbrCycle value in the BATCH record is 
incorrect. 

Update the BATCH table with the correct NbrCycle value using a Query Tool. 

**************************************************************************************************
*** 4.5 Schema:                                                                                ***  
***                                                                                            *** 
*** NbrCycle INTEGER smallint                                                                  ***
***                                                                                            ***  
***  If not a recurring Journal Entry, indicates the number of documents in the                ***
***    batch that are out of balance.                                                          *** 
***  For recurring journal entries indicates number of remaining cycles for thebatch to recur. ***
**************************************************************************************************

NOTES:

1. If a suspended batch occured in Solomon IV Version 4.21 Service Pack 2b, 
please contact Solomon Technical Support prior to correcting the batch. The 
Development team needs more information to determine the root cause and to 
prevent future suspended batches.

2. This resolution should be used only after it has been confirmed that the 
Batch is actually in balance.

************************
*** CORRECTION STEPS ***
************************

1. Make a BACKUP of the database which can be restored in case an undesired data 
loss occurs.

2. Using a Query Tool, access the appropriate Application database and run the 
following statement to verify that the NbrCycle field in the BATCH table is 
updated with an incorrect value:

SELECT * from BATCH where BatNbr = 'XXXXXX' and Module = 'YY'

(where XXXXXX = the appropriate Batch Number and YY = the appropriate 2-letter 
Module code)

3. Run the following statement to update the NbrCycle field to zero in the BATCH 
table:

UPDATE BATCH SET NbrCycle = '0' where BatNbr = 'XXXXXX' and Module = 'YY'

(where XXXXXX = the appropriate Batch Number and YY = the appropriate 2-letter 
Module code)