The table ENPRISE_BANKREC_AUDIT holds the batch numbers for each batch generated. Once you have identified the batch in question, you can either check the OPEX table and manually add the field PymDocAmnt for each line in the batch or run the following script:
exec sp_executesql N'Select Sum(PymDocAmnt) BatchTotal from OPEX O, Enprise_BankRec_Audit A Where O.AbsEntry = A.AbsID and A.Batch = @batch',N'@batch int',@batch=1
Please make sure that you substitute your batch number at the end of the script. This script will return the batch amount/total only.
Comments
0 comments
Please sign in to leave a comment.