Detecting Fraudulent Activity

CantyComputers
2 Posts
User
New Zealand

Detecting Fraudulent Activity

I have a client who suspects that an ex-staff member may have committed fraud. This person had admin rights to the system.

My understanding is that when you delete or cancel an invoice from MYOB the data stays in the database but is 'hidden' from the application using SQL proceedure programming.

Is there any mechanism / report that can be run against an MYOB Account Right 19.5 (local, not cloud) database to show / enable access to any invoices that have been deleted or cancelled?

 

Thanks

3 REPLIES
Super Partner Kym__Yeoward
1,100 Posts
Super Partner
Australia

Re: Detecting Fraudulent Activity

Hi @CantyComputers - welcome to the Community Forum.

 

See this Support Note from MYOB - Company file - security audits

 

The Note will show you how to run two security reports:

 

- A Journal Security Audit - to see what transactions have been added, edited, deleted, reversed or had system entries

 

- A Session Security Audit - which will show you all activity, by user, over a given period.- including sign-ons and password changes.

CantyComputers
2 Posts
User
New Zealand

Re: Detecting Fraudulent Activity

The event happened a year ago and auditing was NOT turned on, perhaps it should be by default, so this info is of no use.

Ultimate User gavin12345
1,487 Posts
Ultimate User
Australia

Re: Detecting Fraudulent Activity

Hi @CantyComputers

 

The bottom line is no - there is no way to restore deleted transactions. I am puzzled by what version of MYOB you are using as you refer to SQL and then to v19.5.

 

V19.5 does not use an sql database. When a transaction is deleted, it is true that MYOB v19 simply marks the records as deleted without removing them from the file. However when recording the next transaction MYOB will re-use the space from the deleted record. So unless you have a backup taken after transactions were deleted and before new transactions were entered, you are unlikely to find what you are looking for. Accessing the deleted records would require specialised tools - not something a user could do.

 

I noted the audit function was not enabled - this doesn't mean much as the audit function in v19 is very basic and very limited. It will tell you a user deleted a transaction number xxx on a date but very little else about the transaction.

 

Your best bet is if the Contact Log feature was on for Sales. MYOB records a contact log entry for every sale, but does not delete it if the sale is deleted. You may be able to cross reference contact logs entries for sales that don't exist in the file. You would then need to contact the customer to see if they have a copy of the invoice and whether payment was made.

 

Regards

Gavin

Didn't find your answer here?
Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post