I second this question.  Where is the system getting the Batch Status from if not from the field in this table?

Batch status is determined on demand in Sage 100.  I am not certain how or if this this can be accomplished using a Sage Alert.   

 It is possible through scripting to check if a batch is available or not making use of the GL_CompanyActiveBatch_svc service object.

To check if a batch is available in AP Invoice Entry.

glCompanyActiveBatchSvcOH = o.Session.AsObject(oSession.GetObject(“GL_CompanyActiveBatch_svc”))

batchMod = ”A/P” ‘ Sets the module code of the batch to check

batchType = ”01” ‘  Sets the batch type of the batch to check

batchNo = ”00002”  ‘ Sets the batch number of the batch to check

retVal = glCompanyActiveBatchSvcOH.CanAccessBatch(batchMod,batchType,batchNo) ‘ Will return success if batch is available, failure if batch is not available.

If retVal = 0 {

                failureMessage = glCompanyActiveBatchSvcOH.LastErrorMsg$ ‘ Why batch was not available

}

Batch status is determined on demand in Sage 100.  I am not certain how or if this this can be accomplished using a Sage Alert.   

 It is possible through scripting to check if a batch is available or not making use of the GL_CompanyActiveBatch_svc service object.

To check if a batch is available in AP Invoice Entry.

glCompanyActiveBatchSvcOH = o.Session.AsObject(oSession.GetObject(“GL_CompanyActiveBatch_svc”))

batchMod = ”A/P” ‘ Sets the module code of the batch to check

batchType = ”01” ‘  Sets the batch type of the batch to check

batchNo = ”00002”  ‘ Sets the batch number of the batch to check

retVal = glCompanyActiveBatchSvcOH.CanAccessBatch(batchMod,batchType,batchNo) ‘ Will return success if batch is available, failure if batch is not available.

If retVal = 0 {

                failureMessage = glCompanyActiveBatchSvcOH.LastErrorMsg$ ‘ Why batch was not available

}