WSDL: UpdateJob.jws

Method: UpdateJob

Underlying File Maintenance

Prior to importing Job-Update information, these maintenance areas in System Administration > Installation must be completed.

• Job Cost
• General Ledger > G/L Master File Maintenance
• General Ledger > Departments
• Accounts Payable > Routing Code Maintenance
• Accounts Receivable > Customers
• Accounts Receivable > Sales Tax Code Maintenance
• Accounts Receivable > Unit of Measure File Maintenance
• Job Cost > Job Maintenance
• Job Cost > Phase Maintenance
• Job Cost > Cost Type Maintenance
• Job Cost > Tax Classification File Maintenance
• Job Cost > Phase Categories Maintenance
• Job Cost > Job User-Defined Fields Maintenance
• Payroll > Employee Maintenance
• Payroll > Tax Table Maintenance
• Payroll > Worker's Compensation Code Maintenance
• Work Order > Site File Maintenance
• Enterprise Management > Cost Center Maintenance

Assumptions and Dependencies

• The Job Master Update web service will update any existing data for the defined Job.
• The Job Master cost center flag is validated against the customer cost center.
• The Job Master Update does not modify existing AR Contracts for the Job.
  • It creates new AR Contract for the Job if the Customer_Code is defined. It will use the Original_Amount field as well if defined but it is not required to create the AR Contract.
  • If the AR Contract exists then a message is provided that it cannot be changed. The user will have to manually change the information on the Contract itself via Accounts Receivable.
• A new Contract is set up when a NEW Customer code and Original_Contract is defined in the layout.
• An existing Contract will not be update if the Customer code and Original_Contract is defined. This is an Accounts Receivable function not a Job function.
• The T+M Billing setup occurs when the Price_Method_Code is defined as Cost Plus or Time+Material and the Customer code is defined.
• The Report_Calc_Override field controls the 'Override Calculation for the contract status and profitability reports?' option. If defined as Y then one of the following fields needs to be defined
  • Entered_Perecent_Complete
  • Entered_Projected_Complete
• The Override Payroll work tax codes must be unique for each of the three defined.
• The earned calculation logic is based on the Price type defined on the Job.
• Phase mask, start/end major group and start/end minor group default from the Job Installation screen if fields are blank.
• Master Job logic
  • The Master Job tied to the Sub Job must be valid and not have a complete status.
  • The Master Job and Sub Job must have the same Phase length.
  • The Sub Job will be created with the same Phase setup as the Master Job.
  • The Sub Job will default the Master Job's Customer and Tax classification if left blank.
  • The T+M billing submitted by each Sub Job option is selected on the Master Job and defaults to unselected unless a Sub Job defines the Bill_From_Master field option. The last created Sub Job controls this feature on the Master Job.
• The Job Setup page has an option to setup the Default Job Address used on the Purchase Orders. The 'Ship-to name' must be defined in order to modify the other fields such as address information and/or comments as needed.
• The Job cannot have both the Davis-Bacon and Prevailing wage options selected.
• The Estimated and Actual complete dates must be greater than or equal to the Estimated and Actual start dates.
• The Key personnel display as Job contacts if the Job Cost Installation option validates to the Employee code.
• The PR_OH_Type_Code field
  • The following fields are not dependent on the PR_OH_Type Code field being defined -
    • Payroll_OH_Percent
    • PR_OH_Amount
    • OH_Phase
    • OH_Cost_Type
  • If any of the above fields are populated they will be updated if they meet the PR_OH_Type_Code current setting.
  • If the PR_OH_Type_Code field is defined as (N)one then it will ignore the above four fields.
• Cost center information will only be allowed in if the Company is set to a Pending or Yes status.
• Any field that is left blank will not be updated in Spectrum. The service does not delete values that exist in Spectrum; it only changes data defined in the layout.

Field Descriptions