AP batch posted to GL batch 1

[vbdbcoder]

When an AP batch is posted, Accpac generates its GL batch. Is there a way to identify the source posted AP batch and its associated GL batch?

I see table GLJEH has two fields, DRILLDWNLK, DRILAPP, is there a table that these 2 fields might be referenced to point to the source AP batch?

Thanks in advance.

 

[DjangMan]

APPJH is where those GL fields point to. APPJH has the GL batch number that it created but you can't guarantee that the GL batch didn't have some problem when it was posted and the entries moved to another batch.

DRILAPP = Source ledger of the transaction (eg AP)
DRILSRCTY = Transaction type (eg 0 = IN/CR 1=Payment etc)
DRILLDWNLK = reading from the left, first digit is the length the posting Seq no, next digit is length of the batch number, next x characters (as indicated by the first digit) is the posting seq number, last x characters (as indicated by the 2nd digit) is the batch number. eg 221720000000000 would indicate that the post seq and batch numbers are both 2 digits in length(22), so the post seq number is 17 and the batch number is 20.

The entry number is sometimes on the end of DRILLDWNLN

 

[vbdbcoder]

Thanks. It worked great!