Hi,
I would like to ask does anyone has a script or store procedure for us to run the reconciliation of financial batches?
we are having a scenario here with 60,000 journals in open GL batches table (WORK TABLE). We would like to reconcile it but using the application function, it might run 1 full day of 24 hours.
does anyone can help me with solving this?
thank you.
*This post is locked for comments
here is something to get started.....batch table is SY00500.
all you have to do is update the SY00500 with a count(jrnentry) and sum(DEBITAMT+CRDTAMNT) group by bachnumb , jrnentry from the GL10001 and GL10000. I would restrict it to just the batches with bchsttus =0 and mrktpst = 0 so your not effecting batches with errors. ( confirm the field names mentioned). Your on your own with creating the proper syntax. If you cant, then you shouldnt be doing this yourself. Test it of course and you will see it probably only takes 10-15 seconds even with the # of transactions you have, which is a ton by the way. Hopefully you dont have a single JE per batch. if so then you shold look at changing your process.
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,403
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
