4.7.3 - 11 Nov 2024
Workbench Release Notes
Upcoming Functionality & News
Stock Reconciliation with Financials
Previous versions of the Stock Valuation report calculated the value of stock from the quantity and unit cost, based on the costing method (Period Average, Last, Standard). While useful as an approximation, this almost never reconciled with the value of stock as recorded in the financials, and was a point of confusion.
A new Stock Valuation Reconciliation report will show the opening value, and the value of transactions recorded for the month, for each stock item to give a closing valuation. As it includes the value of all stock transactions, all these transactions must also be exported to the financials. The total on this report will reconcile with the stock valuation on the financials, and so keep the accountants happy.
A second report, displaying similar information by batch will help you cross reference and troubleshoot if required.
This will probably be released in the new year.
Plant Meter Redesign
A review of the Plant Meters tab is underway with the objective of providing improved usability and
maintenance. You can look forward to these enhancements in a future release.
Contract Progress Claim Process - upcoming changes you need to know
The new Claiming process that records Certified values as well as Claimed values for Contract Claims is now ready and in beta phase with some clients.
This will be soon documented in detail so you can look into it and get your users ready to start using it.
Feature Revisions
Jobs
Contracts - Contract Payment Certificate
Improvements to the Contract Payment Certificate reports:
The Total Qty To Date, Less Prev Qty, Qty This Claim columns had a Total at the bottom agregating different quantity units and did not make sense. The total at the bottom of this column have been removed.
Reports:
Detailed Payment Claim Certificate wbContractClaim005
Detailed Payment Claim Certificate (Schedule) wbContractClaim017
Detailed Payment Claim Certificate by Line Status wbContractClaim015Signature section at the bottom of the Payment Claim Certificates:
The Claimed By and Date, are there to be completed manually, but as people now send a digital document, these are not used. These have been removed.
Approved By and Date. The Approved by is populated with the signature of the user approving the Contract Claim (internal approver, not the client that certified the claim).
This has also been removed.
Reports:
Detailed Payment Claim Certificate wbContractClaim005
Detailed Payment Claim Certificate (Schedule) wbContractClaim017
Detailed Payment Claim Certificate by Line Status wbContractClaim015
Payment Claim Certificate wbContractClaim003
Purchasing
AP Vouchers - Supplier picker:
The supplier picker on the AP Credit Voucher has been amended to allow editing to cater for the instances where the credit voucher is created by Xtracta and the GST / ABN number is used across multiple supplier records, typically for supplier branches. Previously the first supplier record was automatically selected and not editable.
Plant
Displaying Custom Views - Main Tab or Extension Tab:
We have made a change on where a user chooses to display the Plant Custom View, and this is to improve performance.
A custom View can now either be displayed on the Main tab or on the Extension Columns tab.
This improves loading time, and avoids confusion for users as they wonder if there is a different field and/or meaning due to showing on different tabs.
The only 2 options on a Custom View new are:Main tab
Extension Tab
The Both option has been removed. If Both was selected, it will display on the Main Tab.
Plant Maintenance Logs:
A few tweaks to improve performance when loading the list of Maintenance Logs.
Resource Scheduling
'Scheduling by Person' report:
Changes have been made so that when the date filters Start and To Date are used, the scheduled people whose dates intersect or overlap the days in the filters are included in the report.
Month End
Provisional Contract Claim Accruals and WIP (Work In Progress):
In 4.6.40 there was a fix for double counting of revenue when generating WIP, where there were provisional claim accruals. The provisional claim accruals should be excluded from the revenue calculation for WIP.
However, we have identified that when the claim accrual batch is finalised, and the unapproved claim moved into the next period, the provisional flag was not being removed and these accruals stayed as provisional. This was preventing the accruals from being included in the WIP calculations. This has been fixed, and the process now works as expected.
There is also a data fix to flag all old claim accruals, and any current ones which have been finalised (i.e. reversal created) as non-provisional.Location on Export Control
The Location of the batch has been added as a new column on Export Control, and as a filter. This will help users with knowing which batches to export.
Additionally, a reminder that Locations can have a batch prefix number that can display on a batch number if configured on the Batch Prefix rules.
System Setup
Retention Types - tidy up:
A few changes will be made in the next release to improve understanding of Retention Types. Nothing to worry about. They are aimed at making them easier to use and avoid confusion.
Step by Percent (Schedule Type):
when selecting this one on a Retention Type, the current label Estimate Basis will change to Schedule Basis. This is just a fix.
Increased Costs, Other Costs, Recharges, and Contingency options will be removed from the Schedule Types, as these are not options for Schedule Types when creating a Contract Schedule. Only Original and Approved Variations are valid types, and these are the types that the Retention calculation includes when generating retentions on a Contract Claim.
Subcontracts - valid retention types:
Any Retention Types with the type Step by Percent (Schedule Type), will not be available as a selectable option on a Subcontract, as this is not a valid one, and if chosen Retentions are not calculated. This type is only valid for Contracts.
Administration
Data Imports - Activities:
The Activity import has been updated to correctly handle Markup% values and to support the update of existing Activities based on Activity Code.
The description has been updated to clarify what it does:
”Imports all types of Activities. This import can update/overwrite existing records if they already exist. If no matching record is found, it will insert a new record.”
Fixes & Technical changes
Upvise
Project Filter in Files app
A new column filter has been added in the files application in upvise to allow users to filter files linked to a project.
Things we are busy working on...
Contract Claims: record claimed and certified values on each Claim (like in Subcontract Claims). New approval process on Contract Claims to resemble the certification process.
Custom Views on List screens, and exploring the ability to add extension columns to these views. This will expand your reporting ability on the List screens.
Audit for configuration changes.
Month End Process: controlled and easy to follow.
Analysis graphs on Sales Invoices.
🔨 Interval- Based Equipment Maintenance in Upvise (e.g. 250-hour increments- 250, 500, 750, 1000 repeat)