Cheques missing

[ffarah]

I have run into a situation where Accpac ERP shows AP batch being posted, Payment Batch posted and cheqes issued. Vendor transactions show the cheque Number and association with the respective vendor Invoice. But some how the GL account transactions does not show the cheques being recorded. The cheques were physically created as the bank showed them on their statement. There are 6 cheques missing from the GL bank account and they make up one entire Payment batch. Any ideas how this could have happened?
Appreciate your help
frank

 

[ettienne]

Some possibilities:
1. The GL transactions were not created for the AP check batch
2. The batch was deleted from the GL
3. There was an error batch in the GL
4. The entries are in a different period in the GL

 

[ffarah]

Hi Ettienne
I am sure it is not #4 on your list. How can I find if its one of the first three you mention?
thanks
frank

 

[ettienne]

Look at APPJH.GLBATCH and APPJH.GLENTRY, these 2 fields give you the GL batch and entry the AP payment transaction was written to. If the numbers are zero's then it means the transactions have not been written to the GL.

 

[ffarah]

Hi ettienne. Thanks lots. Using the APPJH.GLBATCH and APPJH.GLENTRY tables, we were able to associate the GL batch and see that it had been deleted
frank