MYOBCommunity
Partner Zone
|
|
Partner Zone

Detecting Fraudulent Activity

This thread is now closed to new comments.
Some of the links provided in this thread may no longer be available or relevant.
If you have a question please start a new post.
CantyComputers
2 Posts
User
New Zealand
CantyComputers

2Posts

0Kudos

0Solutions

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

4 REPLIES
Super Partner Kym__Yeoward
1,334 Posts
Super Partner
Australia
Kym__Yeoward
Super Partner

1334Posts

700Kudos

98Solutions

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
CantyComputers

2Posts

0Kudos

0Solutions

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,957 Posts
Ultimate User
Australia
gavin12345
Ultimate User

1957Posts

1520Kudos

296Solutions

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

Contributing Partner bwilgar
8 Posts
Contributing Partner
New Zealand
bwilgar
Contributing Partner

8Posts

1Kudos

0Solutions

Re: Detecting Fraudulent Activity

Hi CantyComputers

We track deleted entries from MYOB for this exact reason but unfortuantely you have to have our software connected to be able to get the benefit of this.

We track a lot of other anomalies in MYOB which do go back in time & may assist in determining if anything untoward is going on in your MYOB file.

Check out our software here www.watchfuleyesoftware.com & get intouch with us via our contact form if you want to discuss.

thanks

Brett

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