Purpose & Scope:
Spitfire adds triggers in the Microsoft Dynamics SL database for the following functions:
APDOC
- Vouchers not created from 03010 are forwarded to Spitfire (psf_CreateVouchers). Spitfire ignores the vouchers if there is no project, or if the project contract does not exist, or if the user who created the voucher cannot be resolved.
- Updates that set OpenDoc = 0 are forwarded to psf_CloseVouchers, which ignores vouchers that do not have Spitfire documents.
Procedure:
If these triggers need to be removed, the following script can be used to delete them.
- In Query Analyzer, connect to the Dynamics SL Application database.
- Run the following script:
DROP TRIGGER tsf_APDOC
DROP TRIGGER tsf_APDOCClose
DROP TRIGGER tSf_BRMLock
DROP TRIGGER tsf_pjbillch
DROP TRIGGER tsf_PJPAY
DROP TRIGGER tss_PJPENTDates
DROP TRIGGER tss_ProjectPM
Additional Comments:
KBA-01179; Last updated: October 12, 2016 at 11:57 am;
Keywords: solomon application database