We are using Payables 8.1A

Yesterday we had a major problem with our Payables module.

First we had a problem when two small cheque runs were entered into AP and posted (one for CDN and one for USD). Both batches performed as normal (print/post) in AP, but the batch refused to retrieve to the ledger. We were able to clean this up only by deleting the file in our data, reversing the batch in AP, then deleting the second corrupt file that that generated for ledger, and then beginning again.

The second problem occured at posting invoices at day end. A batch was created for yesterday's invoices for all four branches (as we always do, everyone adds to this batch all day, it gets posted at day end.) When we went to post this batch, it said there was an error in the batch, and it left the batch there. At the time I believed that there was something wrong with one of the invoice numbers, and so we amended each invoice in this batch with an "A" at the end of it, and reposted. Again we had the error. At this point, we abandoned the idea of posting this batch, and finished off our day end by retrieving to the ledger and looking over all the reports that were then generated. Turns out that the batch that AP refused to post, had retrieved to the ledger (yes, the same batch that had refused to post, TWICE, because of errors.) Since it had retrieved (twice to the ledger) I went and investigated each vendor affected. Sure enough, the batch posted twice in AP. Yet it was still sitting there in AP looking like an unposted batch.

The only thing we did differently yesterday (than normal) was post batches DURING THE DAY while other users were in AP.

This feels exactly like the problem we had in inventory when multiple users were posting. The same sort of odd error problems.

To test this theory, I took our live AP data this morning and dumped it into our test data. We then made sure TWO people were in the test data, and reposted the batch that was acting so oddly yesterday. The batch posted WITH ERRORS. All invoices except one did post and clear out of this batch this time. One person then exited the batch and tried reposting the left over transaction. No problems this time.

It seems that we are now able to post in AP regardless of how many people are in that module. But we are also getting errors when this happens. I know you are working on a "hot fix" for inventory because of the same type of errors when multiple users are accessing and posting.

Could the same thing be happening in AP? There was an upgrade that we put in the same day we put the upgrade in for inventory...

Barb