There are a few PM tables to pull data from to help with the reconciliation. It also helps if you're sending the Job (Contract) number to the GL transactions. That will allow you to reconcile each job.

I've just adjusted the integration to send Job numbers in the description field, thanks.

Unfortunately it doesn't help to reconcile the current balance in the account.  Our jobs can last up to a year, so I hate to think I won't have a full audit trail until the old jobs cycle through.

Are you running Revenue Recognition (which is dependent on the accounting options selected)?

Also - if you happen to change the GL accounts that the jobs are posting to mid-stream, that will make it harder.

Did you run revrec?  Or perhaps an AR billing worksheet?

We do run revenue recognition, yes.  I've set that to reference job numbers in the GL integration as well, now.  Part of the problem is that we have a high volume of WIP transactions , and jobs opening and closing.

I could see in the future dumping the WIP GL each month into a pivot table and reconciling that way, but it will be a lot of data parsing.  This would only work with proper labeling within the GL postings, I guess.

I have trouble believing there wouldn't be a canned report for this kind ot thing.  How did Sage imagine that users would reconcile this?

There isn't unfortunately. You take the posting journal reports and work through them. I'd recommend creating some custom queries or crystal reports and start with the records in PMTRAN along with the records in the Revenue Recognition posting journal table.  If you have re-opened any jobs then you'll also need the Reopen posting journals, too.

See if the transaction totals that PJC says it sent to the GL match with what is in the GL batches. Take today as a starting point and keep track of the batches coming from PJC going to the GL and confirm that totals are correct - basically to see if you have an ongoing issue or a static one.