New Features

Subcontracts

...

Hotfix Release 4.4.10.21

Release 2 Oct 2019

• Rectified an issue where the Job picker was inappropriately limiting Job visibility based on the control parameter 'Allow Foreign FinCo Jobs' being set to ‘No’. This control parameter is applicable to multi-db on-premise environments only.

Hotfix Release 4.4.10.20

Release 27 Sep 2019

• Rectified an issue where subcontract claim retention releases could not be submitted for workflow approval. This does not affect the. standard approval process.

• Rectified an issue with the Contractor Daysheet import.

Hotfix Release 4.4.10.17

Release 24 Sep 2019

• The display of the Job Enquiry - Financial Summary tab is now associated with the existing 'View Job Summary Tab' permission that also controls the named tab.

Base Release 4.4.10.16

Beta Release 23 Sep 2019

New Features

Job Cost Reallocation

A Job Cost Reallocation feature based on the MDE Job Transaction Transfer Enhanced form is now available. It provides for filtering or selecting a job transaction to reallocate, and the transaction is reversed and a new adjustments made. Note: this feature is not to be confused with the Job Transaction Transfer which updates transactions directly.

  Since this functionality reallocates job costs and this is specified in the local currency, foreign currency is not relevant. There is no restriction on invoiced transactions.

Image Added

A.  The Job Transaction Reallocation is under Administration - Utilities, and opens an Adjustments Batch List.
B.  Create a new Adjustment batch as per usual if required.
C.  Click the Batch Number to open the Job Transaction Reallocation screen.
D.  Use the filters to display the job transaction you wish to reallocate in the grid.
E.  Click the [+] on the transaction to reallocate and its subgrid is displayed.
F.  Click [New Line] to create a reallocation.
G.  In our example we are reallocating a partial amount of $300 of the original $675 from Job 4003 to job 4172. Retail is calculated as a pro-rata of the original retail based on the cost reallocated to original cost.
H.  When done we click [Save], and should our reallocation be a partial amount we are prompted in case it may be incorrect.
I.  Confirming the reallocation will refresh our subgrid.
J.  The subgrid now includes the auto-generated transactions:

1. The user specified reallocation transaction
2. The auto reversal transaction of the original transaction.
3. The auto balance line where the reallocation is a partial amount

K.  Should there be a need to edit the reallocation, it is recommended the user marks the auto generated transaction for deletion, and these will recalculate and re-generate.
L.  All transactions reallocations in this batch are visible from the Batch tab.
M.  Clicking the link icon of a reallocation will display that reallocation in the Reallocate tab for editing if required.

Note: the subgrid transactions in the Reallocate tab are non-editable if the transaction was reallocated in another batch.

Feature Revisions

Jobs

• Stopped Work Centre's from being deleted, when it has been assigned to a Job Template or has been used elsewhere in the database. 

• Job List - Changed the Job picker to enable jobs with non-alphanumric alphanumeric characters such as a full stop, dash and underscore. .

• Budgets - Enable the different budget imports from the Job Budget screen. Previously only the Budget Lines could be imported from here.

Timesheets

• Timesheet Approval & Timesheet Administration - Added the Create Tile, Export and the following filters to the Timesheet Approval screens:
  • Completed = Yes/No with the Yes as the default.
  • Approved = Yes/No with the No as the default.

• EBA - When removing 0 timesheet lines, they will not be deleted when the EmploymentAgreementGenerated does not equal 0.

Purchasing

• Purchase Order - The screen now supports a list of PO imports. These are indicated by the ImportHeader.DocType of 'Purchase Order'.
  

• AP Voucher / AP Invoice - The application is now able to revert an AP Invoice created from erroneous AP Voucher data.
  

A.  Say we have approved an AP Voucher and the AP Invoice is created before we notice an error. Previously this situation could not be rectified by a user.
B.  A user with 'Unapprove AP Invoices' permission is now able to Unapprove the AP Invoice, and this displays different buttons.
C.  A user can then Delete the AP Invoice, and if the AP Invoice was created from an AP Voucher then a prompt is displayed.
D.  The user can now agree to Delete the AP Invoice and this updates the respective AP Voucher to a 'Cancelled' status.
E.  Should there be a need to correct the AP Voucher and reprocess, we just need to Uncancel the voucher.

• AP Voucher - The 'Cancel Vouchers' permission has been extended to apply to the workflow assigned person and users with Voucher Admin Review/Approval. Note: the 'Cancel Vouchers' permission was added to the General role to retain compatibility.

Work Breakdown

• Activity - The markup fields have been added to the Subcontract Activity Type.

Billing

• Job Invoice -
  • Corrected printing of new invoices. The display symptom also displayed irrelevant conversations. 
  • Added the Job Description ($JobDescription) and Job Code ($JobCode) tokens to the Report - AR invoice and AR Credit email templates.
  • Print -
    • When selecting "Print" the previewed report will default to the Invoice type saved on the Job invoice.
    • Added the ability to print any job invoice report from the print button arrow which corresponds with the charge type. 
      • Input / Output - all reports in AR Invoice Report Type
      • Claims - all in Contract Claim Report Type
      • Output Claim - all option in Output Claim Report Type
    • The final flag will only be on finalised invoices. Allowing for reports to use this flag. 
    • Note: The additional invoice report is for additional information, not for an alternate invoice report. 

• Input Get Sales - Auto grid saving is added for input based invoicing with multiple pages of lines.

Image Added

A.  If you have multiple pages of input lines and needed to defer or write-off items on multiple pages, it was cumbersome as you had to generate billing on changing pages.
B.  Now you can make required edits or indicate any Deferrals or write-offs as per usual, then,
C.  When you change the grid view either due to pagination or filtering, these grid changes are temporarily stored.

NOTE: You must Generate Billing to create the invoice lines when the lines have been reviewed.

• Claim Get Sales - The Get Sales is enhanced to automatically populate new claims with all lines from all active claim schedules.

Image Added

A.  The Get Sales screen for a new claim is now auto-populated with the lines from all claim schedules associated to the job.
B.  Use the filters as required to find or limit the grid to display lines as required; note the 'This Claim Value' > 0 will display all lines claimed in this claim.
C.  Enter your claim values as per usual.
D.  As usual, use 'Save - Generate' for intermittent saving and to generate the invoice.
E.    Should you need to edit an existing claim and the line was not initially populated, you will have to trigger the auto-line population by clicking Refresh. Previously this would require selecting and populating another schedule.

Subcontracts

• Subcontract -
  • Added a Print button on the Subcontract tab to be able to be able to run related Subcontract reports.
  • The Subcontract Contact person picker now indicates whether a person is inactive.

• Subcontract Dates - The Claim Payment Days used to calculate Claim Payment Due date is now treated as number of working days. The calculation caters for a Saturday & Sunday weekend as well as any holidays that have been setup for the location, as determined by the supplier.

• Work Order - Default the delivery address to the Job site address on a new work order. If the job is changed, the site address will also be changed to the job address of the job entered. 

• Subcontract Claim - Added the Subcontract Job Description ($SubcontractJobDescription) and Subcontract Job Code $SubcontractJobCodeCode ($SubcontractJobCode) tokens to the Report - Subcontract Claim Approved and Subcontract Claim email templates.

• Subcontract Claims List -
  • Now includes a Subcontractor Emailed column indicating the date when correspondence was emailed to the subcontractor for a claim.
  • The Job and Subcontractor are also listed and totals have been added.

Daily Diary

• Time and Plant,  Crew Timesheet - Removed the Parent Job filter in job filter lookup in the grid of the Time and Plant screen. 

Expense Claims

• Expense Claim - Added duplicate line icon to the expense claim. 

Service Desk

• Log Maintenance - Added Asset to the General tab.

Administration

• Users - Prevent inactive users logging in to Workbench. 
• Licences - Add Voucher Approvals to the Purchase Requisition Licence.
• Email Templates -
  • Added the Subcontract Job Description ($SubcontractJobDescription) and Subcontract Job Code $SubcontractJobCodeCode ($SubcontractJobCode) tokens to the Report - Subcontract Claim Approved and Subcontract Claim email templates.
  • Added the Job Description ($JobDescription) and Job Code ($JobCode) tokens to the Report - AR invoice and AR Credit email templates. 

Integration

...

MYOB Advanced

• Increased the import frequency, it is now: 6am to 9pm (for the AWS this is based on GMT +10)

Xero

• Catered for Time and Date format being saved to the Payroll Transaction Transfer table, so that these timesheets will still be exported to Xero. 

Reporting

New Features

• Text Footer Columns - Configurable text based footer columns have been introduced to cater for basic tabular formatted information that is not well supported by the HTML footer. Note: They are only available on the reports listed below and where the report orientation is portrait.

Image Added

•   The footer column text is defined as Lookups where the Type determines what document the footer applies to. The supported Lookup Types are:

•   AP Invoice Footer Grid
•   AR Credit Footer Grid
•   AR Invoice Footer Grid
•   Contract Claim Footer Grid
•   Output Claim Footer Grid
•   PO Footer Grid
•   Subcontract Claim Footer Grid
•   WO Footer Grid

•   The maximum limit for the number of column's is 5 per location and the font size is system adjusted to be smaller with additional columns.

•   You can enter a sequence (priority) for a column that you want to be blank, for placement of the text. Ie: You want text to only be in the 5th column. The font will be 6pt, because you have essentially told the system that you have 5 columns. You would enter Priority 5 for the location with the Description text. You do not have to enter in any other columns with a priority. 

•   You can enter in a combination of sequences (priorities) to space the data, for example deleting the data in Priority 2 of the example will display:

Image Added

Report Revisions

• wbBatchCCCAccrual001 - Contract Claim Accrual - Added Analysis grid to report.

• wbContractsBudget004 - Contracts Budget vs Final Cost Report with Hours - A new wbContractsBudget004 report has been provided.

• wbDebtors002 - Aged Debtors - Report Code Summary - A new Debtors report (wbDebtors002) Aged Debtors - Report Code Summary has been provided.

• wbJob005 - Job Profit - Stopped the Job code from being a mandatory predicate. Changed the number format to have no decimal places.

.