Financial Batches

[bradth]

I was wondering if someone could tell me what table the posted financial batches are stored in. In GP when you go to Transactions > Financial > Batches and select a batch to post, the batch is stored in the SY00500 table. After the posting goes through, the batch is moved to another table. Any idea what this other table is? Or even is there a form somewhere in GP where you can view historical financial batches that have been posted? Thanks.

Brad

 

[klewis10367]

The batches are posted to the GL20000(This is the Year to date table). The gl30000 is history. You can view historical by going to Inquiry>Financial and then choosing Historical.

 

[bradth]

There doesn't seem to be a batch number associated to these tables though, therefore you can't tell what batch is what.

Brad

 

[VictoriaYudin]

I believe in both GL20000 and GL30000 the batch ID associated with each row will be in ORGNTSRC. The batch information is not stored stored separately anywhere once the batch is posted.