Dynamics Community Forum Thread Details

Audit Trial

Hi,

Can anybody lett me where do i find audit trial document or file on Microsoft Dynamics SL

Thanks

Omidiran Abiodun

Omidiran, there is an audit trial in the Microsoft Dynamics SL Time & Expense for Projects modules. Here's from the help on it:

If the Detail Audit Trail Activated check box is selected in Time and Expense Setup (TM.SET.00) and any field on the current line is being changed, enter the reason for the change. Changes to a line include adding information to it, modifying information in it, and deleting it. You might need to provide a change reason for adding, modifying, and deleting a line or your administrator might configure the system so that you only need to provide reasons for some edits

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------

There is also an audit trail within the Dynamic SL Project series Transaction tables. As of this time there is not a supporting report. Perhaps a partner has written one. Here's basically the idea behind it:

This system provides a means to backtrace a transaction to its originating transaction. For every record written to PJTRAN another record is written to PJTRANEX. PJTRANEX stores the PJTRAN primary key (concatenated) in ID11 or ID12. ID11 will always contain the primary key of the output record. ID12 will contain the primary key of the source or originating transaction (in Allocations and Billings load only). Before any loading the detail num part of the key is expanded to a zero filled string of 10 positions. The audit trail works as follows:

Project Charge---->primary key put into TR_ID11

Time Card App.---->primary key put into TR_ID11Financial xfrs---->primary key put into TR_ID11Allocations ---->primary key of output trans into TR_ID11*primary key of source trans into TR_ID12Billings Load ---->primary key of source trans into IN_ID12Invoice Reg. ---->primary key of output trans into TR_ID11'*Only loaded if Full detail sw set in allocation step

This concatenated primary key method is necessary for Audit trail reports since outer table joins will be used to link the tables 'together.

Bob KrajciSoftware Development EngineerMicrosoft Dynamics SL This posting is provided "AS IS" with no warranties, and confers no rights.

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)