Construction v22.1

Fixed error CITB when posting invoice for valuation if supplier doesnt use CITB
Changed validation on a CIS Supplier back to restrict the Supplier Name to 56 characters long

Date applied: October 2, 2024

221.0.37

Resolved an issue where an error would be display as part of processing a purchase order with retention, replacing it with an info message
Fixed ‘Divide by zero’ error on health checker rebuild SL application projects routine causing sage to crash.
When adjusting a retention, transaction type is now correct in project enquiry instead of defaulting to ‘PL Retention’
Corrected health checker correction on SL where Retention release valuations are allocated to multiple applications

Date applied: September 4, 2024

221.0.36

New Features

Added validation to PL invoice entry to make sure CITB settings are configured before posting where applicable.

Issues Resolved

Amending value, discount or retention on a valuation created using ‘populate from outstanding’ should post nominals for adjustments.
Fixed ‘Divide by zero’ error when allocating PL transactions that include a VAT only document and the supplier is a CIS subcontractor.
Discount entry will be disabled on the valuation screen if adding new via the populate outstanding screen.
Construction Sales Order Setting Form now closes when clicking ‘OK’ button
Changed CITB error when PL invoice is unauthorised and cannot allocate to be a more friendlier message and also not disrupt the rest of the process including posting CIS.
Turned off Spell checker on base screens used in all construction screens

Date applied: August 21, 2024

221.0.35

New Features

Removed validation to allow duplicate contract ids against RCT suppliers and on the RCT Contracts import.

Issues Resolved

OutstandingNetToCurrency will be populated for valuations on the application ledger.
Correct project number pulls through when creating a new application and valuation.
Added prompt when editing an application or a valuation if the project has been complete and Project Setting ‘allow posting and keep project completed’ is on.

Date applied: August 7, 2024

221.0.34

New Features

Added messaging services to detect if a customer or supplier is being deleted and block if its related to an application, retention or construction order.
Added validation to all application screens to make sure the system is set up with default tax nominal codes in sage.
Validation added to ensure rapid PL invoice references are unique per supplier and date so CIS can match correctly.

Issues Resolved

Sales Receipt screen should not load customisations if applications is not licence enabled.
Changes to Discount and retentions on a valuation should cause a repost of nominals.
WebAPI Endpoint ‘GetSupplierCISSettings’ should return ‘RateDescription’ correctly.
Fixed ‘Unable to cast object of type ‘Sage.Accounting.SalesLedger.SalesBankReversePaymentInstrument’…’ error when reversing a sales payment.
User specified Tax not saving on creating new opening balance retentions.

Date applied: July 24, 2024

221.0.33

New Features

Added code to reset SQL version number on launch so we dont hit sages 255 version number limit
Added ability to set and adjust a tax code on an opening balance retention.
Allowed the ability to create and post a zero value, tax only valuation on the application ledger.

Issues Resolved

Stopped double revenue on the financial enquiry when importing sales orders with opening balance applications and valuations and invoice recognition is set

Date applied: July 10, 2024

221.0.32

Important Info

Update Companies Required

New Features

Added feature to add a retention adjustment application onto the application ledger. (https://www.sicon.co.uk/user-guide/construction-help-and-user-guide/#1-15)
New retention released and retention outstanding columns added to the application ledgers (https://www.sicon.co.uk/user-guide/construction-help-and-user-guide/#1)

Issues Resolved

Added a warning to the save button when releasing retentions with Construction settings on recognise on ‘Application’ but the Application raised on recognise on ‘Invoice’
Fixed ‘String was not recognised as a valid DateTime’ error on PL invoices when suggesting links to outstanding applications that have no expiry date set.
Rebalance on Projects should not clear retention write offs from the project enquiry
Posted nominals tab in Application ledger displays the correct currency.
Write off retentions should allocate to the applications and reduce the outstanding and also post to the project correctly.
Outstanding retention value displayed on the valuation screen should be filtered by Customer/Supplier.
Fixed issue with incorrect exchange rate values when changing the currency on the project from the application ledger.

Date applied: June 12, 2024

221.0.31

Reverse Charge VAT should be included in calculation of CIS labour when part allocating. this will then display correctly on CIS return.
When reversing Invoice valuation, the bank selection window is now titled ‘Payment Bank Selection’.
Performance improvements made to the launch of Application and Valuation screens. Also improved the cumulative calculation methods.
Generate Missing CIS only shows unallocated transactions.
When Importing Sales Orders with Opening Balance Valuation Lines, The project Transactions should display a value rather than zero in the project enquiry.
PostDeductionsForPLTransaction for materials only credit notes should log correct audit details.
Fixed CIS C query flag not clearing on credit notes when authorising them.

Date applied: May 15, 2024

221.0.30

Important Info

Dev Express Version updated to 23.2

New Features

Supplier Application import converted to new format
Reducing a despatch quantity on a Sicon sales order line will also now print an amended despatch note.
Import Application Forecasts converted to new format
Import CIS Supplier Details converted to new format

Issues Resolved

Credit note retentions net value displays correct value and removed totals on Exchange Rate
Warning added when amending allocations and the payment is in a submitted CIS return
Fixes on construction side for project enquiry improvements
Customer Validation on Sales order import works correctly when document type is a Quote

Date applied: May 1, 2024

221.0.29

New Features

Construction tabs added to add and amend project estimate and template screens
Added ability to change allocation quantity on the rapid sales order despatch screen
Added better error handling onto sales order despatch screen to identify line the error occurred on.
RCT offline mode will nolonger lookup and verify contracts on set up or posting payments.

Issues Resolved

Added block to the Correct & Reverse button for the CIS credit notes in Sales ledger
Added a warning if the Subcontractor name is longer than 35 characters
Fixed error when entering a zero value valuation and allocating the outstanding amounts
When recording subcontractor applications containing comment lines on the purchase order, now marks status as complete
Financial enquiry posting date is now correct when amending date on application
Application Recognition Financial Enquiry Posting is wrong when amending the posting date on application
Fixed PL application discounts not updating project totals on Projects advanced list.
Negative retentions will nolonger be copied over to retention released fields on valuations.

Date applied: March 27, 2024

221.0.28

Retention releases should use assigned project levels from linked nominal set on the application (When recognised on Invoices)
Corrected issue with cumulative Invoice value on first invoice print if old opening balance valuations are on the ledger with no InvoiceNo.
Fixed sage crashing with dev express spell checker error when closing new application screen.
Sales CIS will be calculated and deducted where applicable on Releasing retentions.
Fixed ‘Missing projects assembly’ error on SOP entry when projects not installed and CIS only.
Added validation for CIS percentage and nominal code to be setup before posting invoices to prevent error

Date applied: March 13, 2024

221.0.27

Fixed issue with reverse charge VAT being deducted twice on posting payments and receipts

Date applied: March 6, 2024

221.0.26

New Features

Added the ability to set groups on valuations to filter data on printed certificates.
Sales Transaction Enquiry will now use X tables for retentions check
Added a ‘clear’ button to Despatch Sales Orders Form

Issues Resolved

Added pop up for user to suggest nominal to use when single retention release finds a difference in values from nominals. This will stop the ‘The nominal analysis total does not match transaction net value’ error from appearing.
Auto stock allocation setting should action when copying an existing sales order
Payment audits should include any allocated credit notes on a payment
Removed ‘Exclude all ‘materials only transactions’ tick box from CIS return screen
Valuation Invoice and Receipt Allocation Date will now use the Receipt date

Date applied: February 28, 2024

221.0.25

Important Info

Update companies required

New Features

Sales Application Import has been changed to new format. (See help and user guide section on Imports > Import Customer Applications for more information: https://www.sicon.co.uk/user-guide/construction-help-and-user-guide/ )
CIS tab added to sales ledger enquiry
Sales CIS functionality added to sales applications
- Recently there were a fair few requests for CIS (Construction Industry Scheme) to be added to Sales transactions. Typically, CIS offerings are for Subcontractors (Purchase Ledger Suppliers Accounts in Sage) and the ability to have an online submission via the HMRC gateway. Sales CIS is slightly different, from a business point of view, the company within Sage doesn’t have a Gross Payments status with HMRC, that means any Sales Invoices raised is subject to a CIS deduction, either 20% if you are CIS registered or 30% if you are unregistered.
- Prior to the most recent releases, Sales CIS was only available on Sales Ledger Transactions in a very limited way. We are pleased to announce that Sales CIS is available on Sales Transactions, Sales Order Processing (SOP), Invoicing and on Customer Applications.
- Import aspects of the CIS Sales interaction: In all the modules that Sales CIS interacts with, a Credit Note or Invoice deduction is added at the point that the Invoice or Credit Note is posted to the ledger. For the SOP and Invoicing module, as the system allows you to produce documentation, a comment line has been added stating “Order subject to X% deduction equal to XX”, where the X% is the deduction amount set in the CIS settings and the XX is the total Labour deduction value on the Order/Invoice. It wasn’t possible to add the deduction directly onto the Order itself as the Sage prevents the VAT summary having a negative amount for a single VAT code. Sales CIS uses the same VAT code as the Subcontractor deductions (that isn’t included on the VAT Return).

Issues Resolved

Opening balance Valuations should display the correct payment values
Stock Returns from Construction sales orders should be negative and post to a cost project header rather than the revenue code from the order
Updating a project on a construction order should also update the project on the order lines
Fixed the setting for putting supplier accounts on hold for public liability end employee liability insurance.
Removed old references for single valuations to clean up code.

Date applied: February 21, 2024

221.0.24

New Features

Sales CIS added to Sales orders and returns (Including Invoicing module)

Issues Resolved

Fix project level not retained in project when processing supplier application/valuation/invoice.
Fixed ‘Index out of range’ error when clicking pay now on a suggested payment when opening from the suggested payments workspace.
Fixed duplication of displayed data in retentions ledger if project in filters selected.
Fix for Issue with Generate missing CIS when the invoice is in suggested payments.
Fixed CIS calculations on PL rapid Invoice screen when using nominal CIS rules.

Date applied: February 7, 2024

221.0.23

New Features

Nominal posting history added to Applications, Valuations and Application Ledgers

Issues Resolved

100% material CIS postings using PostDeductionsForPLTransaction End point should create a SiconCISAudit record.
Changing a customer/supplier on an application should now repost nominals as an adjustment.
Fixed CIS calculation issue when using CIS nominals and deducting retentions.
Fixed reconciliation error in projects when deleting retention line from an application.
improved validation if Free text order numbers are enabled and DocumentNo supplied is null.
Customer Application Import valuation discount not calculating the same as Application

Date applied: January 24, 2024

221.0.22

New Features

Added new screen to despatch sales orders from multiple orders at once.
Added import an export features to sales order despatch screen.

Issues Resolved

Customer Applications Import not taking into account discount line on valuations.
Error when trying to create an application from subcontract PO for negative value.
Changing customer on the application does not update the customer on the Application and Retention lines in Project enquiry.
Valuation reversal postings when posting invoices will use transaction date rather than due date.
Disabled fields on customer applications unless project and customer code inputted.

Date applied: January 10, 2024

221.0.21

New Features

New Web API methods added for searching and generating construction sales orders and Project construction settings (See WebAPI documentation for more details)

Issues Resolved

Subcontract Application – Invoice No. extended to 20 characters
Enabled the Invoice narrative on Retention release valuation
When printing OB valuation, the pop up box should show ‘confirm credit note details’ in message
Changing customer on application will now update the Retentions customer
Fixed ‘Cash book account specified…’ error on reversing credit valuation
Fixed Error when posting invoice with CITB and the CITB Nominal settings have not been configured

Date applied: December 12, 2023

221.0.20

New Features

Added more validation and changed FreeText type to Order line type column (position in import changed)
Converted RCT Subcontractor import to new format

Issues Resolved

Tick box changed on applications tab on supplier. Unticked will allow both PO and construction SC orders. Ticked will restrict to construction SC orders only.
Deleting an application with a discount nominal line should post a reverse application discount transaction into projects.
Fixed Outstanding calculation on applications on legacy application screens if retention released.
Removed Labour percentage and labour only from RCT set up and posting.
Retention field on the application gets stuck when the number has a comma in it
Remove the Duplicate check on Site Identifier No, when adding a RCT contract
Fixed looping issue on valuation nominals when tabbing

Date applied: November 29, 2023

221.0.19

New Features

Converted construct import to use new projects Timesheet import format
Added a cost of item column to the import sales order feature and converted to new import format

Issues Resolved

Fixed ‘Object not set’ error on applications retention ledger
Fixed duplication of retentions on Application drill down on project enquiry
Fixed ‘Object reference not set to an instance of an object.’ error when allocations are missing/deleted.
Added more details in the history when deleting sales/Purchase order lines
Application drill downs added to Project enquiry transaction totals drill down.

Date applied: November 23, 2023

221.0.18

New Features

New WebAPI methods for getting retentions and releasing SL/PL retentions
Construction SO & PO – add more details in the history
To create valuations automatically from Importing Applications

Issues Resolved

Better validation added to legacy application screens on deleting applications to check they are not allocated to valuations
Amending project header on application retention line should display previous project header for reversal postings.
CITB should be deducted from CIS first when using nominal codes method for labour calculation.
Health check tool to recreate project transaction for recognise on applications should only create application transactions and not retention and valuation.
Unable to reverse/delete Application in same month as originally generated

Date applied: October 13, 2023

221.0.17

Fixed error on CIS supplier details import where it was wrongly validating partnership UTR when its blank.
Unit price text box will not be disabled on construction sales order line if the applied for value has been reversed back to zero.
Fixed ‘SiconSalesOrderLine not found’ error when the order line has been cleared and deleted.
Default tax code applied to project should be used on new applications, valuations and construction sales orders.
View sales order should load retentions tab in view only.
Total should load on retentions tab on sales order if in view mode.
Fixed total calculation error on Construction sales orders.
Heath checker changes for calculate retention release applications and applications in currency

Date applied: September 25, 2023

221.0.16

Important Info

Update Companies Required

New Features

Receipt totals included on customer application ledger totals.

Issues Resolved

Adding retention to invoicing order will now ignore the error ‘The goods total and VAT totals must be zero or greater’ when lines on the order are zero VAT rate but the default on the customer
Deleting opening balance valuation should also include retention lines in confirm nominal postings.
Filters will nolonger clear when project changed on application ledgers
Fixed ‘Index was out of range’ error when selecting a transaction from the purchase transaction enquiry related to a retention.
Print SL valuations will now be filtered by customer
Changed construct export to use new Project Header import format

Date applied: September 1, 2023

221.0.14

New Features

New WebAPI methods added for getting supplier Retention defaults and calculating CIS labour, material and other splits.

Issues Resolved

Changes to Health checker when using recognise on Application mode.
Stopped retention tab loading on save causing slow down of saving a sales order.
Validation error message added when releasing a retention on an application but the customer/supplier, project or project header doesn’t have a nominal configured.
Amending application date should use the previous date for the reverse postings in the nominal adjustment.
Fixed error on doing a mix of invoices and credits in the generate missing CIS screen.

Date applied: August 14, 2023

221.0.13

Important Info

Update companies required

New Features

New setting added to do offline submissions to RCT
Added new import for project construction settings.

Issues Resolved

Fixed some calculation issues in the application health checker
Application ledger should only show retentions relating to applications and not from the sage ledgers
Removed APP from stocktype on project transactions
Nominals should not be posted when deleting opening balance valuation allocated to an opening balance application
Clicking Populate from outstanding on a valuation using old application screen will now pop up the nominal selection form
Changed construct import to use new projects import format

Date applied: July 20, 2023

221.0.12

Important Info

update companies required

New Features

New Import for Customer/Supplier Retention Settings

Issues Resolved

Construction health checker will now consider invoice values if recognised on Invoice
Changing the Project header on the retention nominal line on applications shouldnt change the nominal set
Retentions should display correctly on customer transaction enquiry if generated from a credit note in the invoicing module.
Fixed ‘Object not set error’ when copying an invoice from the invoicing module with a retention line.
Changing the date on confirm nominal postings should also change the ‘reversal’ postings highlighted in blue
Added some more total fields on application ledger to display outstanding invoiced on valuations and applications

Date applied: June 30, 2023

221.0.11

New Features

New logic added to default supplier on new application or valuation transactions

Issues Resolved

Fixed issue with application cumulative totals when changing the application date
Fixed cumulative retention value on applications if retentions have been part released.
Block put in for reversing a SL transaction if it has retention. It will ask the user to do it manually so the retention is also generated.
Invoice recognition valuation allocation will use the valuation date if the valuation is new. Adjustments to the allocation will use todays date.
Fixed issue with application discount lines going missing when rebalancing projects

Date applied: June 13, 2023

221.0.10

New Features

Control nominal setting Added to CIS settings for Sales CIS

Issues Resolved

Fixed Divide by zero error when amending a retention release allocation on Invoice recognition.
Validation added on printing OB valuations to make sure the Document no is unique.
Fixed issue with attachments tab not appearing on amend orders if opened from the desktop list.

Date applied: June 5, 2023

221.0.9

New Features

SpareText/Number entry can now be maintained on Construction Valuations
Application Project Totals Health Checker added

Issues Resolved

Fixed ‘Object not set’ error printing PL valuation from an invoice line in the ledger
Disabled buttons on Customer/Supplier Applications screen until project selected
Payment date on retention release will now default with payment terms logic from trader
Payment date on a retention release valuation should now be enabled
Fixed ‘Object not set’ error on valuation with populated nominals and exchange rate (Application recognised)

Date applied: May 19, 2023

221.0.8

Removed lock on showing completed lines on sales order application generation so you can post a negative.
New columns added to sales and subcontract order import to specify opening balance valuation value.
Stopped default Project level being recreated when adding a new application or valuation
Application and Outstanding values on the valuation screen will be displayed in the currency of the selected customer or supplier

Date applied: May 2, 2023

221.0.7

Issues Resolved Hot Fix Enhancements

New Features

New view added to application ledger to show nominal links if populated from outstanding application nominals.
Currency Lookup added to Application Ledgers to calculate postings in the currency selected. (will change currency on the project)

Issues Resolved

Maintain Exchange rates will now correctly post nominal adjustments for application, Valuation and Retentions
Database upgrade routine added to populate application nominal type as ‘Gross’ is they are null because of older versions.
Restriction to posting valuation invoices when not fully allocated has been removed when Recognising on Application.
Fixed ‘Out of memory’ exception on generating applications from sales orders with large amount of lines
Fixed some rounding issues on populate outstanding using retentions. Any Rounding differences will be added as a separate line to balance.

Date applied: March 20, 2023

221.0.6

New Features

Nominal postings with movements between applications and valuations should use correct exchange rate. recognition on application will also post exchange rate differences.
Narrative will now contain original invoice number if reversed valuation is posted.
Added progress bar to loading of populate from outstanding screen on a valuation
Fixed Issue with exchange rate not updating on applications list
Relabeled WAP with sicon Approvals in Application settings

Date applied: February 17, 2023

221.0.5

Issues Resolved

fixed cumulative retention calculation on application screen
Subcontactor PO line should only show the Cost Project headers
Fixed rounding issue causing allocation window to appear on save for valuations created through populate outstanding
Reversing an Valuation using Recognition on Applications (Supplier) – should now use the date used on the nominal selection instead of todays date.
Supplier application import should post nominals for any valuation values included
Fixed issue when posting Credit Note where SL and PL have the same invoice number
Changing of a sales or subcontract order line will now be disabled if the line has been applied for

Change in Functionality

You can now edit nominal allocation and retention on valuations created through Populate outstanding
Invoice nominals will now pop up on posting invoices for valuations and reversals
Written off retentions now added to Application ledger totals pop up
New filters added to applications ledgers including date range and trading account
Added display to prompt when raising a Supplier valuation if the supplier is CIS registered and no labour value or % has been entered

Date applied: February 6, 2023

221.0.4

Order lines that have not been despatched should not display on the generate applications screen.
Application postings with Invoice recognition will now show pop ups to display nominals it will post for the user to confirm
Expiry or no licence key messages should display on all construction menu options
Change to application totals popup to show application retentions and Retentions Outstanding (maybe also Retentions Released)
Fixed issue when reversing a valuation and raising a new one, the populate outstanding button is not displaying the reversed valuation values
Application import with opening balance valuations will now use the second reference as the invoice number
CIS deduction fields will now be enabled for retention release valuations even if using CIS nominals
Multiple customers/suppliers will not be allowed to be picked on retention releases

Date applied: January 17, 2023

221.0.2

Fixed issue with Valuation Invoices with CIS split on nominals not posting correctly to the audit.
Added validation on application imports for project header type and nominal
Reverse button will be disabled for Opening balance valuations. Instead they will need to be deleted
Fixed issue with URN being set as invoiced value on PL Valuations

Date applied: November 25, 2022

221.0.1