Changing the Period of a Bank Reconcilation Batch

[Kwekoolio]

Hello all,

I am working on reconciling bank statements from a few months ago. For the month of May I didn't change the date of the batch (entries were done in July), assuming that by having the proper date in each individual entry that everything would post properly.

Now I have a bunch of May entries (dated properly) listed in Period 7. Is there any way to change this? Do I have to post a reverse batch and then re-post the reconciliation batch as a new one? Any assistance would be appreciated.

 

[Jay Converse]

Just edit BKCHK, there's no harm.

 

[Kwekoolio]

I'm going to be showing off how little I know here...where do I go to edit BKCHK?

 

[Jay Converse]

Pervasive: Control Center
MSSQL: Management Studio
Oracle: Toad
DB2: I feel sorry for you

 

[Kwekoolio]

I've managed to change the entries in the table (they were in BKJENT because that time I entered the checks as entries instead of going through AR). Now my problem is getting ACCPAC to load the new data.

Last question (I hope): where do I go to load the changes??

 

[Jay Converse]

You don't "go" anywhere, you changed the data live.

 

[Kwekoolio]

the problem is that the account history still shows the May transactions in period 7 even though BKJENT has been changed. Does the GL account history program pull data from another table?

 

[Jay Converse]

Yes, of course it does. If you need to fix the GL, too, do a manual journal entry.

 

[Kwekoolio]

Ok, so to clarify: In order to fix the problem that there are transactions listed in the wrong period in the GL Transaction History program, I have to post a GL entry (or entries) to reverse them.

In other words, I cannot edit the entries themselves to change the period with each line item but have to either reverse each entry and re-post or do something else that has a similar effect. Is this correct?

Thanks for your help with this.

 

[Jay Converse]

Correct.