AP Payement and Invoice Batch entries lost

[ZABARVAN]

In continuation of the previous post. We have the printout of the invoice batch enty (PO Generated), but cant find any such entry. Is there any way to find if the entry was deleted or there is some data corruption. The user is saying that they didn't delete the entry. Plz. help if we can find who has deleted one of the batch entries if at all it was deleted.

Regards

Zab

 

[Jay Converse]

First you said a payment entry, now you say invoice entry. Is it one or both?

But, if your AP setup allows external batches (i.e., PO) to be edited, then it is possible to delete invoice entries before they are posted. Either don't allow editing, or train the users not to delete them.

 

[ZABARVAN]

I have this problem with both Inv. and payment batches.

The point is, can we find if the entry has been DELETED not just lost due to data corruption. In case of paymnet batch it is a big issue because the supplier can claim that he didn't receive the payment. ACCPAC should have some way to find the deleted entries.

 

[Jay Converse]

If you're so concerned about this, purchase and install the Audit Logged add-on:

http://www.pacifictechsol.com/products/auditlogger.shtm

If you think you're losing entries due to data corruption, then you have bigger problems than just employees who are stealing. In 100% of my installations, invoices and payments are never lost.

 

[ramam1]

Zabarvan,
Your bank will know if the check was cashed so you don't have to worry about that.

Sometimes we delete invoices or other documents when we've created them incorrectly - are you sure this wasn't corrected in a way you're not considering? User's can be very creative in trying to fix their mistakes and get past their problems. If you haven't already, consider discussing the issue with your Accpac users in private to see if anyone might know what's going on.

In any case:
-Have you done a DB restore lately?
-When was the last time you ran a data integrity check?
-Has your DB reported any errors?
-When was the last time you did a security audit: Who has direct access to your DB? Who knows the admin password to Accpac? What authorizations do users have?

 

[DjangMan]

An AP invoice batch created by the PO module will show 'PO' in the source application. Deleted batches will leave a record in APIBC unless you are clearing history which I never lightly advise. The batch status will read 'Deleted'. Check the AudtUser field for those records.

 

[ZABARVAN]

Thank you all for providing your technical advice. I think the batch entries have been deleted as I checked the data integrity there are no errors.

Thank you all once again.

Zab