Skip to contentSkip to content
Spitfire Client Services

Spitfire Client Services

  • Support
    • KBA
    • Downloads
      • Implementation – Getting Started
      • Implementation – Templates
    • Training
  • Documentation
    • Focus Guides/TWP
    • What’s New in Spitfire
    • System Requirements
  • Newsletter Articles
  • Webinars
  • Video Library

KBA-01251: Dates on the Project Cost by Account Category report

Spitfire Client Services >> Knowledge Base>> KBA-01251: Dates on the Project Cost by Account Category report
January 5, 2011January 5, 2011| Dorothy McGovernDorothy McGovern|
Categories:
  • Knowledge Base

Question:

The Project Cost by Account Category report has two date ranges in its filter parameters. What dates are these date ranges using?

Answer:

The Project Date Range looks for the Current Start date on the Spitfire Project Setup (Contract) document‘s Date Tab.  If this date doesn‘t exist, it then looks for a start_date in Microsoft Dynamics SL‘s pjproj table. The Project Finish Date Range looks for the Current Finish date on the Spitfire Project Setup (Contract) document‘s Date Tab.  If this date doesn‘t exist, it then looks for a end_date in Microsoft Dynamics SL‘s pjproj table.


KBA-01251; Last updated: November 10, 2016 at 9:04 am;
Keywords:  project date

Tags: Account Category, Dates, Reports: Executive

Post navigation

PREVIOUS Previous post: KBA-01245: Routing Catalog Files
NEXT Next post: KBA-01194: What are the workstation prerequisites for using the BFA, SOV or PD workbooks?

Related Post

KBA-01639: In the BFA or SOV workbooks, why does Excel prompt Save As …KBA-01639: In the BFA or SOV workbooks, why does Excel prompt Save As …

Question: When working in the BFA or SOV workbooks, I click Save, but Microsoft Excel prompts me to Save As. How can I fix this? Answer: In newer versions of

Read MoreRead More

KBA-01455: Import Data: Importing Paid Sub/Vendor Pay RequestsKBA-01455: Import Data: Importing Paid Sub/Vendor Pay Requests

Purpose & Scope: When importing data from your old system into your new Spitfire system for Go-Live, Spitfire supports importing one summary Pay Request per commitment for those Pay Requests

Read MoreRead More

KBA-01170: Change a column label in the Project LookupKBA-01170: Change a column label in the Project Lookup

Question: In the Project Lookup, how can I change the Address2 field label to Floor? Answer: Add the following script to Site_Wrapup.sql UPDATE dbo.xsfLookupField       SET label = ‘Floor‘, WParamLabel= ‘Floor‘

Read MoreRead More
  • KBA-01876: Using Workflow to Approve Docs Regardless of User Permission
  • KBA-01878: Releasing Retention on an SOV Pay Application
  • KBA-01877: Assembled PDF Output in Power UX
  • KBA-01874: Bulk Export from Catalog in Power UX
  • KBA-01875: Viewing Field History in Power UX
  • Client Webinars
  • Documentation
  • Knowledge Base
  • Newsletter Articles
  • Rules
  • Spitfire Reports
  • Training
  • Uncategorized
  • Videos (Power UX)
  • Videos (Quick, Basic Q&A)
  • What's New
  • Workflow Scripting

Meta

  • Log in

Spitfire Management, LLC
5219 Monticello Avenue #5444
Williamsburg, VA 23188

VW Machine Learning WordPress Theme Copyright 2025 Spitfire Management, LLC. All rights reserved.

Scroll Up