Page History: Project Job Cost Report
Compare Page Revisions
Page Revision: Mon, 09 Sep 2019 10:56
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)
Sales Order Type Overflow 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
Map Fields: Fields must be mapped prior to importing. If no changes have been made to the column headings, the mapping screen should show all green, and you can click OK to continue. If any of the Input Field Name columns on the left are red, single-click on the line on the left column, and then double-click the desired mapped field in the right column to complete the mapping. Repeat for any red lines on the left that should be mapped. If there are additional columns in the source file that should NOT be mapped, they can be left unmapped (displayed in red). Mandatory fields will require that they be mapped before clicking OK.
Export Template: Generates a blank MBS Description Import file
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)
