KBA-01274: Conversion failed when converting the varchar value “ISNULL(ex_act_amt,0) + ISNULL(ex_com_amt,0)”KBA-01274: Conversion failed when converting the varchar value “ISNULL(ex_act_amt,0) + ISNULL(ex_com_amt,0)”

Problem: When loading a budget or forecast spreadsheet the following error appears: ‘An error – ‘Conversion failed when converting the varchar value ‘ISNULL(ex_act_amt,0) + ISNULL(ex_com_amt,0) to data type int. occurred

KBA-01272: Folder tab options on the Batch Upload Tools Configuration screenKBA-01272: Folder tab options on the Batch Upload Tools Configuration screen

Summary: The Folder tab in the Batch Upload Tool‘s Configuration dialog box allows you to configure the following options: Set the folder Name from which you will upload your scanned files.

KBA-01271: How to Troubleshoot sfBatchLoader auto-updatingKBA-01271: How to Troubleshoot sfBatchLoader auto-updating

Purpose & Scope: Spitfire‘s Batch Upload Tool will automatically check for updates and update accordingly when you open the application. If the Batch Upload Tool does not update, here are

KBA-01268: SQL Server Versions with Service PacksKBA-01268: SQL Server Versions with Service Packs

Summary: SQL Server Versions This great chart is from http://sqlserverbuilds.blogspot.com/ (excessive advertising notwithstanding) See also https://support.microsoft.com/en-us/kb/321185 You can determine what version SQL Server is running by using this Query: Select @@version, @@MICROSOFTVERSION @@Version

KBA-01255: Full Text Index on SQL 2005 Populates AutomaticallyKBA-01255: Full Text Index on SQL 2005 Populates Automatically

Summary: With SQL Server 2005, population of the Full-Text Index can occur on an automatic basis. Spitfire Catalog searches of the Full Text Index should then always be up to date. Requirement: In ICTool,

KBA-01254: Processing Inbound Email RepliesKBA-01254: Processing Inbound Email Replies

Question: How does Spitfire know to which document an inbound email is in response? Answer: Spitfire examines the SMTP headers of the inbound email looking for the echo of special

KBA-01250: Two Contact Records in Spitfire for One PersonKBA-01250: Two Contact Records in Spitfire for One Person

Problem: Two Contact records are in Spitfire for one person. This usually occurs when the person is entered in Microsoft Dynamics SL as an Employee and also as a Vendor.

KBA-01249: Cannot find file when clicking the Export to Excel icon on the Executive DashboardKBA-01249: Cannot find file when clicking the Export to Excel icon on the Executive Dashboard

Problem: Clicking on the Export to Excel icon on the upper left corner of the Executive Dashboard opens Microsoft Excel but then a message says that it cannot locate the file. Solution:

KBA-01248: Project has Change Orders, so Create SOV option does not appearKBA-01248: Project has Change Orders, so Create SOV option does not appear

Problem: Your Project Setup document is Committed, and Change Orders have been created. Therefore the Create SOV option is not available on the Project Setup‘s drop-down Options menu. Solution: If using