Sunday, August 13, 2006

SAS 99 in Microsoft Dynamics GP

As the administrator of our ERP system, Microsoft Dynamics GP, I spent about 20-25% of my time dealing with our external auditor either to:
a) comply with a report request
b) walk them through the system security
c) audit the database to find historical data submitted to them during the audit
d) other audit requirements for private companies

I found that the audit season had changed a lot after Sarbanes Oxley Act (SOX) started in 2002. Although we are a private company, somehow we are still affected by the Act because of Statement of Accounting Standards (SAS).

What is SAS 99?

Statement of Accounting Standards 99 or SAS 99 (Consideration of Fraud in a Financial Statement Audit) provides needed guidance to auditor charged with providing assurances that clients have not committed fraud. Some experts say " The easiest way to think of SAS 99 is that it's Sarbanes-Oxley for everybody." SAS 99 applies to audits of privately help companies as well.

SAS 99 defines fraud as an intentional act that results in a material misstatement in financial statements. There are two types of fraud considered:
1) misstatements arising from fraudulent financial reporting (eg. falsification of accounting records) and;
2) misstatements arising from misappropriation of assets (eg. theft of assets or fraudulent expenditures)

How to create SAS 99 report in Great Plains?

To comply with the auditor, I had to create a Crystal Report that would:
a) show historical GL data
b) create a parameter for historical year
c) include the Journal Entry Nbr, Account Nbr & Description, Source, Document Type, Transaction Date, Posting Date, Debit/Credit Amounts, Reference and User ID

SQL Tables and linking them:
Step 1
My main table was GL30000 then linked GL00105 by ACTINDX. Last table was GL00100 which was linked to GL00105 by ACTINDX as well.

Step 2
Drag all required fields to the report details including Journal Entry Nbr, Account Nbr & Description, Source, Document Type, Transaction Date, Posting Date, Debit/Credit Amounts, Reference and User ID

Step 3
Create your parameter using GL30000.HSTYEAR field then value type should be Number. Remember to create descriptions for each year since GP would year with comma likie 2,001.00 so you should use 2001(Description).

12 comments:

M.Xavier Jeen said...

Hi I am from India.
I am new to Ms Dynamics GP and need to study about that. Can you give me some links of study materials available sites.

duke said...

I don't know of a site that gives free online training in Great Plains. You can go to forums like Tek-tips and Yahoo then post your questions.

one line guy said...

kamusta ser duke! isa po akong gumagamit ng GP na humahanga sa kagalingan mo. sana po makadaupang palad kita! kita kita kayo sa porums.

-timber

Accounting Solution said...

http://www.ddls.com.au/VendCourse/MBS.ht...
http://www.cambridgeonline.net/training....
http://www.brittenford.com/trainingcours...
http://www.htinstitute.com/mbs_training....
http://www.trainingpressreleases.com/new...
http://www.americanit.org/component/page...
http://www.qa-iq.com/learning/sectionSum...
This is some sources I have listed I'm not sure if training is available for you in Mumbai but, I'm sure there is something here for you. Have you heard of the E-Learning? E-Learning gives you the convenience to study at home at your own rate and you can take the course as much as you want. I used E-Learning when I started and I was very impressed with it. I do believe it would cost you money though I'm not sure how much since my company paid for my training. I hope this helps you out and good luck.

Anonymous said...

Can anyone recommend the well-priced Endpoint Security software for a small IT service company like mine? Does anyone use Kaseya.com or GFI.com? How do they compare to these guys I found recently: N-able N-central service desk
? What is your best take in cost vs performance among those three? I need a good advice please... Thanks in advance!

Anonymous said...

Can anyone recommend the well-priced Remote Management & Monitoring tool for a small IT service company like mine? Does anyone use Kaseya.com or GFI.com? How do they compare to these guys I found recently: N-able N-central network manager
? What is your best take in cost vs performance among those three? I need a good advice please... Thanks in advance!

Anonymous said...

Hello everyone! Who knows where to upload the film Avatar?
I even bought the film Avatar for a SMS to http://rsskino.ru/kinofilm/avatar.html , the link was, but download fails, the system will boot quite strange cocoa something.
Men, advise where to normal as quickly download film avatar?

Anonymous said...

Hello
Companies House Webcheck
Webcheck Companies House
Company House Webcheck
Companies House Webcheck Service

[url=http://perosnalbinking.v3host.be/companies-house-webcheck.html]companies house webcheck[/url]

Anonymous said...

Genial post and this post helped me alot in my college assignement. Thanks you on your information.

Anonymous said...

[url=http://www.facebook.com/pages/weathercom/298713874092l]www.weather.com[/url]

Anonymous said...

I sell a boat-program which will help you to outwit auction and to win, initially the boat was created for the Scandinavian auction http://internet-aukcion.ru/ but now the program can work with similar auctions: gagen ru, vezetmne ru and with ten.
The program-boat stakes for you, i.e. for this purpose it is not necessary to sit constantly at the monitor. The boat can set time when it is necessary to stake, thus you as much as possible will lower expenses for rates, and as much as possible increase the chances of a victory.

The price of the program a boat for the Scandinavian auctions 20$

For the first 10 clients the price 15$

To all clients free updating and support.

Behind purchases I ask in icq: 588889590 Max.

Anonymous said...
This comment has been removed by a blog administrator.