Page History: Project Job Cost Report
Compare Page Revisions
Page Revision: Mon, 09 Sep 2019 11:02
General Information
Default Menu Location Reports >> Project Management >> Project Job Cost Report
Screen Name JOBREPORT1
The Project Job Cost Report displays project cost data from the Project Job Cost tab, along with invoice and payment totals. The report data is based on invoices associated with projects included on the report. In order for details to appear on this report, the
Sales Order Type Overflow (SOTYPE2) rule must be set up with sales order types that create Job Cost Report data when invoiced.
 Project Job Cost Report |
Date Range: Enter a date range to filter the report results based on the invoice date of invoices from flagged sales order types associated with the project records.
Sort By - Project: The default sort method lists projects alphanumerically by project number.
Sort BY - Sales Person: Groups the report by salesperson name, then alphanumerically by project number.
Delete ALL existing records before import: If checked,
ALL existing MBS Description details will be deleted prior to importing. This checkbox should only be used if you intend to do a complete re-import of
ALL MBS Description details.
Import duplicate records: If checked, duplicate line entries for the same item record will be imported and will append to any existing MBS Description details for the same item record. If unchecked, only the last line of information associated with an item record will be imported.
Additional Information
MBS X-REF Attribute: The MBS X-Ref Attribute (text1 Name = 'MBS X-REF') must exist in Rule Maintenance with the 'MBSDESCRIP' form name. The MBS Description (XRef) Import will NOT create the required MBS X-REF attribute for all imported item records. The MBS X-REF attribute must be added to each item record before or after the MBS Description (XRef) Import.
MBS Description File Definitions
Required fields are indicated with an *
*Item - Item code in Adjutant
*MBSDesc - MBS Description used to match the MBS import details to the Adjutant item code (allows 50 characters, alphanumeric)
MBSColor - MBS color value from MBS file (allows 20 characters, alphanumeric)
MBSPart - MBS part value from MBS file (allows 21 characters, alphanumeric)
MBSThick - MBS thickness value from MBS file (allows 6 digits, with a decimal in the format ##.#### or ###.###)
MBSCCode - MBS color code value from MBS file (allows 2 characters, alphanumeric)
MBSClass - MBS color value from MBS file (allows 30 characters, alphanumeric)
