Home » Listing Details
Top Websites
  1. Dynamics GP Help
    Over 6400 resources listed.
  2. Mark Polino's DynamicAccounting.net
    Over 5100 resources listed.
  3. Rose Business Solutions Blog New
    Over 2200 resources listed.
  4. Developing for Dynamics GP - By David Musgrave and the MS GP Dev Support Team
    Over 1100 resources listed.
  5. Mariano Gomez at The Dynamics GP Blogster
    Over 1000 resources listed.
  6. Microsoft Dynamics Partner Community Blog
    Over 900 resources listed.
  7. Christina Phillips, Steve Endow & Lorren Zemke at Dynamics GP Land
    Over 700 resources listed.
  8. Mohammad Daoud's Dynamics GP Blog
    Over 600 resources listed.
  9. Vaidy Mohan at Dynamics GP - Learn & Discuss
    Over 500 resources listed.
  10. Inside Microsoft Dynamics GP Official Blog
    Over 500 resources listed.
  11. eOne Business Solutions Blog
    Over 400 resources listed.
  12. About Dynamics, Development and Life
    Over 300 resources listed.
  13. Frank Hamelly at GP2theMax
    Over 300 resources listed.
  14. Dynamics CPM
    Over 300 resources listed.
  15. BKD Dynamics GP Insights Blog
    Over 200 resources listed.
  16. Leslie Vail at Dynamics Confessor Blogspot
    Over 200 resources listed.
  17. Victoria Yudin's Dynamics GP Website
    Over 200 resources listed.
    Victoria Yudin
  18. Janakiram M.P. at DynamicsBlogger
    Over 100 resources listed.
  19. VS Tools Forum
    Over 100 resources listed.
    Your Resource for Visual Studio Tools for Dynamics GP
  20. Inside Microsoft Dynamics GP Official Blog
    Over 100 resources listed.
  21. US Dynamics GP Field Team Blog
    Over 100 resources listed.
  22. Catherine Eibner MBS Developer Evangelist
    Over 100 resources listed.
  23. Sivakumar Venkataraman at Interesting Findings & Knowledge Sharing
    Over 100 resources listed.
  24. Dynamics Small Business
    Over 100 resources listed.
  25. Belinda, The GP CSI
    Over 100 resources listed.

Title:Audit Tools within Microsoft Dynamics™ GP
Description:In prepping for a presentation to a local CPA audit team, I’ve compiled some useful summary information becoming even more important in this economy.

Most powerful, least used—Audit Trails, the module
Captures change history with a time, date and user ID stamp on each event. Before-change and after-change data values. Query, reporting, and export to Excel capabilities. “Closed system,” i.e., the audit information is retained in a database separate from DYNAMICS and company databases. A la carte module available to users holding Professional and BRL Advanced Management licenses.

Audit Trail Codes
Part of a company’s standard Posting Setup, Audit Trail Codes are part of the glue of the drilldown capability from the general ledger to subsidiary modules. Audit Trail codes are generated at the transaction source document level. While someone creating a General Ledger transaction can use an Audit Trail Code typically generated at the subsidiary module level, they can’t access the numbering sequence used by the system—so we have a telltale indication if a journal entry hasn’t been created via the typical process.

Activity Tracking
Part of the standard System Manager, Activity Tracking logs activities, login/logout, table access, processes, and posting. This is the most common audit capability activated because there’s no additional charge for this functionality in either Business Essentials or Advanced Management. Activity Tracking creates tables which can get very large, very fast if they are not routinely purged. Activity Tracking does not meet the criteria for a “closed system.”

Posting Numbers
Track journal entries as they are posted. Much fewer gaps than journal entry numbers which can be easily deleted resulting in gaps in sequence. Journal entry numbers also duplicate with recurring and reversing entries.

Use of SmartList During Audit
Auditors need to sample transactions. SmartList queries nearly all modules’ master records and transactions. It provides up to 4 restrictions and can be set to search to “Match All” or “Match 1 or More.” If SmartList can’t meet needs, SmartList Builder is the novice report writer’s tool that can access any SQL table.
Category:SECURITY IN GP: Audit Trails
Link Owner:
Date Added:June 17, 2010 05:10:45 AM
Number Hits:90
RatingsAverage rating: (0 votes)

No Reviews Yet.


Thank you for your support for GPWindow. It helps us cover part of the hosting costs for GPWindow.