Which Table to use after posting AR Invoice

[ZABARVAN]

We are using ACCPAC 6, we need to reconcile between GL and AR. which table should we use to get AR Invoice amount after posting. We can use posting sequence as a parameter or filter on transaction date.
Will appreciate help.

Zab

 

[Jay Converse]

Why are you doing this at all? Reconciling is easy, you don't need any custom reports.

 

[ZABARVAN]

Their are lot of entries, any easy steps to do reconcilation. between GL and AR. Which Tables and Fileds can we target so that we can quickly do it. Appreciate your help.

 

[Jay Converse]

ARPJH and ARPJD.

 

[ZABARVAN]

Thanks for your help, can we link posting sequence of AR with GL which table...

 

[Jay Converse]

AR posting sequences are not in GL, use ARPJD.GLBATCH and ARPJD.GLENTRY

 

[ZABARVAN]

This way we will print report from AR only, we need to check which entry from AR has gone to GL, some times a users deletes a subledger entry in GL batch that is why our GL and AR does not match. We have to check those entries which are missing in GL.

Thanks for your time.
Zab

 

[Jay Converse]

Change your GL integration settings to Autopost all subledger batches, then your problem is solved.

 

[ZABARVAN]

Yes... but that will be in future, now our auditors are asking why GL and AR have miss matched figures. any way out....

 

[Jay Converse]

ARPJH.GLBATCH and ARPJH.GLENTRY

 

[ZABARVAN]

which GL Table ...

 

[Jay Converse]

GLJEH, GLJED

 

[ZABARVAN]

Thank You so much.

 

[DjangMan]

Keep in mind that if you post a GL batch and it results in an error batch, Accpac doesn't go back to the AR Posting Journal tables to update the GLBATCH and GLENTRY fields to match the re-created batch.