Topic Options
#32208 - 06/11/12 03:28 PM A/P MANUAL CHEQUE BATCH
KSCL Offline
Stranger

Registered: 12/06/11
Posts: 2
Loc: Canada
We have run into a problem with Accounts Payable Manual Batch. Out of no where the program has picked up Manual Check Batches from last year. I was having no problem and all of a sudden when I went to create a new manual check batch I got the error message that the batch was already in existance and the program could not create the new batch. Each time I tried the batch number would increase. Did do an integrity check and there was a problem so we had that fixed, but still it would not create a new batch. When I did an inquirety into the manual cheque batch it listed 68 batches (our last good batch was #37 ) and upon further investigation I found that the additional batches were from 2011. These batches are showing as already posted and are not effecting the GL, is there a way that we can delete this fake batches and re set the batch numbers. I did bring my back up over that I did just before posting my last batches and it has the same problem - it must of occured when I created my last manual cheque batch. We are using Adidgo Accounts Payable version 8

The Invoice Batches list esactly as they should. Many thanks for any help given.


Edited by KSCL (06/11/12 03:31 PM)

Top
#32210 - 06/11/12 03:40 PM Re: A/P MANUAL CHEQUE BATCH [Re: KSCL]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11550
Loc: Vancouver, BC Canada
Hi KSCL,

Batch files in Adagio Payables are stored as a set of individual files, and a master Batch Control file keeps track of batches of all types. The likely situation is that some time last year, a backup of Payables data was restored without first removing the pre-existing data. This would have replaced the master batch control files, but not remove the individual batch files. Thus the files are out of synch, and those 'fake' batches from 2011 are actually 'orphaned' batch files from last year.

You probably will want to get the assistance of your Adagio consultant to assist in fixing this. But in general, recognized open batch files (that appear as such on the Batch Status report for manual checks) will look like a set of 3 files in your data directory of the form APC####x.dat, where #### is the batch number, x is either D, H or I, and dat is your data extension. If you see a set of files for a particular batch number #### that does not appear when you open the Manual Check batch list (and likely have dates from 2011), then these would comprise a set of 'orphaned' batches that could be removed (as long as no-one is in the data). Ensure that you or your Adagio consultant makes a backup of your data before doing anything.
_________________________
Regards,
Softrak Tech Support

Top
#32217 - 06/12/12 04:41 AM Re: A/P MANUAL CHEQUE BATCH [Re: Softrak Support]
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4511
Loc: Wynnewood, PA
Hi KSCL

I had a similar situation, and I ended up having to reset the batch number to 1 in order to fix it. One way to reset the batch number to 1 is to perform Year End processing, but you may have a reason for not wanting to do this in June. The only other way to do it is to use a tool available to consultants like me but not to the average end user.

You might want to try running Data Integrity Check, but I'm not optimistic it will find and fix the problem.

Otherwise as Softrak suggested you should contact your Adagio consultant if you are not willing to run Year End processing.

Steve

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 50 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14467 Topics
70662 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30