Construction v21

Sicon Construction is a set of add-on modules for Sage 200, based around the well-established Sicon Job Costing module to capture costs from purchase orders, purchase invoices, stock issues, cash transactions and labour to create reliable and accurate costings linked directly to transactions processed within Sage 200. Handling CIS, CITB, Applications, Retentions and Valuations and Payments.

Release notes:

Make it easier to find your content with:

Expand content Collapse Content New Features Only Issues Resolved Only Release Only Pre Release Only Hot Fix Enhancements Important Only

Know the release number? Use quick search:

210.0.47

Issues Resolved
Issues Resolved
  • Fixed exchange rate calculation on payments in CIS return which have receipts allocated to them
  • Applications wont be allowed to be deleted if its retentions have been released or written off

Date applied: November 12, 2022

210.0.46

Issues Resolved
Issues Resolved
  • v21.0 Only change Calculating retention release on application allocated values
  • Fixed ‘Object not set error’ on Application ledger if invoice postings have been Archived
  • Retention release tax code should come from the tax code selected on the application nominal it is created from
  • Payment date terms will now be applied to application and valuation payment due dates

Date applied: November 4, 2022

210.0.45

Issues Resolved
Issues Resolved
  • Fixed CIS validation error when posting subcontractor valuation invoice and CIS settings not configured.
  • Cleared Details tab if ledger list is emptied after delete.
  • Form should clear down correctly on saving new sales or subcontract order.
  • Invoice Recognition retention releases will now default to the project override instead of retention sales on the valuation and the nominal line will be amendable.
  • Update routines shouldn’t run if applications are not enabled

Date applied: October 20, 2022

210.0.44

Issues Resolved
Issues Resolved
  • When releasing a Retention the nominal cost centre and department overrides on the project should be used on display for the valuation.
  • Enhanced totals on application ledgers to show more total values via a pop up window.

Date applied: September 23, 2022

210.0.43

Issues Resolved New Features Important
Important Info
  • update companies required

New Features
  • Added a setting to be able to control the default Billing method to be set on the Construction Tab within Creating a new project
  • Added Select/Unselect all buttons to the generate application screens in Sales and subcontract orders

Issues Resolved
  • Performance improvements made to supplier applications if CIS calculations are based on nominals
  • Fixed CIS Invoice for a currency subcontractor display on CIS return

Date applied: September 16, 2022

210.0.42

Issues Resolved
Issues Resolved
  • Project levels on the nominal analysis of the Application should match what is selected on entry
  • Added a Sales order/Purchase Order tab to Application lines on the Application Ledger

Date applied: September 9, 2022

210.0.41

Issues Resolved
Issues Resolved
  • Fixed ‘Object not set’ error on application ledger when ledger control account uses CC and dept overrides from the trader

Date applied: August 26, 2022

210.0.40

Issues Resolved
Issues Resolved
  • Made a change to valuation allocation to block changes if ‘Populate outstanding’ was previously used.
  • Show completed lines’ should show completed plus the outstanding order lines
  • The nominal analysis total does not match transaction net value – when reversing the valuation

Date applied: August 20, 2022

210.0.39

Issues Resolved
Issues Resolved
  • Fixed issue not allowing valuation to be reversed
  • Printing Invoice from Customer Application Ledger – Add invoice number in the message

Date applied: July 22, 2022

210.0.38

Issues Resolved New Features
New Features
  • Replaced Allocations tab on applications ledger with ‘Applications’, ‘Valuations’, ‘Retentions’ and ‘Invoices’ tabs to show all linked objects with more detail

Issues Resolved
  • The ‘Retention’ column on the Construction SO will now be populated from the Application retention not the Valuation retentions

Date applied: July 15, 2022

210.0.37

Issues Resolved New Features
New Features
  • Added clear allocated button to valuation populate outstanding screen
  • Added double click function to populate outstanding grid to fill allocated value

Issues Resolved
  • Print button on application screen and application ledger screen should be the same and recalculate the same.

Date applied: July 8, 2022

210.0.36

Issues Resolved
Issues Resolved
  • Reversed Retention releases shouldnt appear on the project enquiry

Date applied: July 2, 2022

210.0.35

Issues Resolved New Features
New Features
  • Project levels column added to populate outstanding on valuations

Issues Resolved
  • Change made to Application correction routine and rebalance projects to create application project transactions for retention release applications
  • Un-allocating a valuation with nominals previously linked to application nominals will now be cleared.

Date applied: June 24, 2022

210.0.34

Issues Resolved
Issues Resolved
  • Adding labour value into deductions line on Rapid PL invoices
  • Populate outstanding on valuation attempted to divide by zero error
  • Retention total not showing correctly in add application screen
  • Applications Ledger view when releasing retentions not showing correctly in outstanding columns.
  • Retention Import should only allow Retention type 1 of ‘Works’ or ‘Materials’ not ‘Material’
  • Error when writing off retention on Applications ledger

Date applied: June 17, 2022

210.0.33

Issues Resolved
Issues Resolved
  • Divide by zero error when generating payment cert
  • Application Retentions Ledger to also show Retentions with a AppLineID
  • Construction Application Import to validate default project header set for retentions

Date applied: June 13, 2022

210.0.32

Issues Resolved New Features
New Features
  • added project filter to retention history screen
  • Adding Retention type columns and search to ret history

Issues Resolved
  • stopped valuations posting retentions if they are not allocated to applications and posting invoice.
  • Batch transaction setting wrong labour value
  • Fixed Resetting of nominal lines when tabbing through in Supplier Application

Date applied: May 26, 2022

210.0.31

Issues Resolved
Issues Resolved
  • Changing labels from Job to Projects on import templates
  • Default analysis codes should be set on new construction orders and applications
  • New routines added to rebuild project transaction structure for applications
  • Batch transaction credit note entry not creating invoice correctly

Date applied: May 12, 2022

210.0.30

Issues Resolved Important
Important Info
  • Update companies required

Issues Resolved
  • Retention percentages increased to 7dp on applications and valuations
  • Adding date picker to select date when writing off retentions for applications

Date applied: April 25, 2022

210.0.29

Issues Resolved
Issues Resolved
  • Fixed error when reversing valuations with posted invoice
  • Discrepancy between retentions ledger and job enquiry values when apply discount first not set on applications
  • Subcontract order line project transactions should use the line date if set instead of the order header date

Date applied: April 4, 2022

210.0.28

Issues Resolved
Issues Resolved
  • Completed project checks will now validate on applications and orders
  • Fixed issue with reverse charge VAT being recorded on CITB audit which could throw out CIS calculations
  • Fixed ‘(Sage.Accounting.Stock.TransactionHistory, ), as the object has been deleted’ error on saving a Sales order line
  • Replaced error with message of only one activity exists on project on application forecast tab
  • Fixed rounding and reconciliation error on sales order applications

Date applied: March 28, 2022

210.0.27

Issues Resolved
Issues Resolved
  • Fixed error when deleting a nominal code from sage
  • Sales order import PSA duplicating first line fix
  • Total deducted value not changing/calculating correctly fix
  • The value must be zero or greater than zero when trying to Reverse Valuation with credit note.

Date applied: March 21, 2022

210.0.25

Issues Resolved
Issues Resolved
  • Speed issue with moving up and down sales order list
  • Added back RCT enabled/disabled integration function

Date applied: March 11, 2022

210.0.25

Issues Resolved
Issues Resolved
  • changed discount percentage to 5 dp on projects construction tab
  • Fixed issue with application/valuation negative nominal line setting tax as positive when tabbing off it.

Date applied: March 7, 2022

210.0.24

Issues Resolved
Issues Resolved
  • Project enquiry retentions view should display all related retentions (not using SiconRetentionJCJobList table)
  • Fixing sales order import not showing despatched value on sales order
  • Adding message box to check user wants to continue when applied for amount is greater than received
  • Fixed CITB not allocating to original transaction when posted.
  • Move up / down button de-selecting and moving to the top of the list bug fix
  • Fixed CIS search error on retention release when the invoice/credit note URN is 0 (opening balance)
  • Adding released and outstanding amount to application ledger

Date applied: February 28, 2022

210.0.23

Issues Resolved
Issues Resolved
  • Allow adding Negative values to retention values on valuations
  • Fixed project lookup on retentions form not filtering correctly
  • CITB tax should be applied to applicable retention release deductions.
  • Fixed issue with nominal posting when application is originally posted the old way but updating the new way. It should still use the old way.

Date applied: February 21, 2022

210.0.22

Issues Resolved
Issues Resolved
  • Loading first Items CIS tab in PL transaction enquiry if first item has a green tick
  • Fixed ‘historicaltransactionsList could not be found’ error

Date applied: February 16, 2022

210.0.21

Issues Resolved
Issues Resolved
  • Converting a sales order Quote to a sales order should create project postings.
  • Updated Sales Application Web API methods to automatically create retention
  • Quotes should save as quote lines on projects
  • Fixed ‘negative value error’ when Reversing valuation

Date applied: February 8, 2022

210.0.19

Issues Resolved
Issues Resolved
  • Fixed progress dialog showing in front of submit CIS
  • Fixed ‘Value must be greater than zero’ error when trying to reverse a credit valuation
  • CITB should be recalculated on CIS Return if an invoice is part allocated to a payment
  • Labour, materials and other % values should calculate correctly CIS tab on PL transaction enquiry

Date applied: January 17, 2022

210.0.18

Issues Resolved
Issues Resolved
  • Restored method to save Project transaction on sales order line save
  • Exchange rate issue on amending an application causing retentions to post again incorrectly
  • Fix for error on adding a context menu item
  • Validation added to retention due dates on application imports

Date applied: December 20, 2021

210.0.17

Issues Resolved
Issues Resolved
  • Fix for PL Valuation not going to the same project header as the nominal line (or the main application transaction in Projects)

Date applied: December 10, 2021

210.0.16

Issues Resolved
Issues Resolved
  • Fixed contract import dialogue not displaying correctly

Date applied: December 3, 2021

210.0.15

Issues Resolved Important
Important Info
  • Update companies Required

Issues Resolved
  • Fixed ‘subquery returned more than 1 value’ error on applications screen
  • Over receipting a valuation will nolonger recalculate any reverse charge VAT. It will only do this if under receipted.
  • Fixed Error received about updating a nominal when creating an currency application from a currency Construction Sales Order that has a retention percentage set on the Project

Date applied: November 26, 2021

210.0.14

Issues Resolved
Issues Resolved
  • Reversing a valuation with reverse charge should not remove the reverse charge on payment/Receipt again.
  • Fix for net valuation adding 1p to gross valuation (disabled the net valuation box)
  • Fix for Construction Sales Orders completing on save
  • Issue with creating applications from foreign currency project with default retention
  • Fix for Issue with posting Application Invoice when it’s for multiple valuations and with split nominal
  • Allow completed lines to show on generate sales applications from sales orders. Then allow negative values to be applied to reduce the applied for amounts.
  • Allow negatives on Populate outstanding application nominals on a valuation
  • Fix for construction transaction not appearing on project enquiry after rebalance project totals (the fix also needs Projects 210.0.21)
  • Added Project description to the construction sales order desktop list
  • Fixed validation of project header on a sales order line if the header is already selected from previous line entered.
  • Prevent users from deleting nominals if they are used in Construction settings

Date applied: November 10, 2021

210.0.13

Issues Resolved
Issues Resolved
  • Fix for Construction transactions displaying incorrectly on project enquiry

Date applied: October 22, 2021

210.0.12

Issues Resolved Hot Fix Enhancements
Issues Resolved
  • Application date selection on construction purchase/sales orders
  • Fix for quotes being marked as completed on save
  • Fix for Figures out by a penny in CIS return
  • Fix for deleted projects not being filtered out on creating application

Hot Fix Enhancements
  • New prompt to pick an adjustment date on the valuation allocation screen. This date will then used for the adjustment nominal postings

Date applied: September 29, 2021

210.0.11

Issues Resolved
Issues Resolved
  • Retention tax was not removing on CIS return if reverse charge VAT used on original invoice
  • Fixed Reconciliation error on PL applications with multiple lines and retention.

Date applied: September 17, 2021

210.0.10

Issues Resolved
Issues Resolved
  • Outstanding calculation on valuations fixed.
  • Fixed issue with tax lines going missing if multiple tax codes used when posting SL application invoices.
  • Fixed PL certificates not pulling values from allocated valuations.

Date applied: September 10, 2021

210.0.9

Issues Resolved
Issues Resolved
  • Fixed typo on Copy Order screen
  • Fix for Subcontractor purchase order lines not updating on ‘Final Application’ process
  • Fix for Subcontractor POs / Construction SO completing only if it’s measured works

Date applied: August 27, 2021

210.0.8

Issues Resolved
Issues Resolved
  • Fix for Copy Order copying processing values
  • Filter valuation lines on nominal spec instead of order and filter out Retention lines
  • Allocation issue screen fix for ‘Clear allocations’ miscalculations
  • Fix for applications being excluded on generating certificate
  • Fix for CIS process generating a purchase credit instead of invoice on Self billing Invoice from a negative timesheet
  • Enabled delete valuation for allocations
  • Enabled reverse valuations or allocations

Date applied: August 8, 2021

210.0.7

Issues Resolved Hot Fix Enhancements
Issues Resolved
  • Fixed duplication of application values on printing PL certificate
  • Fix for wrong values on ‘Auto Allocate’

Hot Fix Enhancements
  • Valuations will now always be saved as Allocations instead of directly linked applications

Date applied: July 12, 2021

210.0.6

Issues Resolved Hot Fix Enhancements
Issues Resolved
  • PL transaction enquiry CIS/RCT/Retention columns will now be loaded on a separate background thread instead of locking the screen when showing a large volume of transactions.

Hot Fix Enhancements
  • Retention setting to change tax rate will now give option to select Tax code on release

Date applied: July 5, 2021

210.0.5

Issues Resolved Important
Important Info
  • Update Companies Required

Issues Resolved
  • Fix for Subcontractor POs showing as completed when there is outstanding amounts
  • Fix for ‘The Allocation value is greater than outstanding’ message appearing when doing CIS and retention on invoice with reverse charge VAT
  • Fix for minus figures when you amend allocation

Date applied: June 28, 2021

210.0.4

Issues Resolved
Issues Resolved
  • Exclude Reverse Charge VAT from ‘CIS Return’
  • Changes on creating CIS Audit record to save 0 as Tax Amount for Reverse Charge
  • Fix for two VAT lines when entering an invoice through application

Date applied: June 15, 2021

210.0.3

Issues Resolved
Issues Resolved
  • Fix for issue with correction routine where it was setting it back again.
  • Made changes to check for duplicate postings of the same retention on CIS return and CIS Payment Allocation
  • Changes to Application/Valuation load screen
  • Fix for Cumulative retentions not displaying correct value

Date applied: June 2, 2021

210.0.2

Issues Resolved
Issues Resolved
  • Application received will no longer display reverse Charge VAT
  • Application value warning on valuation message will only show once
  • Fixed Object Reference error when getting the exchange rate for the application line
  • Fixed Issue with Importing Subcontractor Purchase Orders when ‘Order No.’ is blank
  • Make Default Application Project Headers mandatory
  • Part posting valuation payment should calculate reverse charge portion correctly

Date applied: May 20, 2021

210.0.1

Issues Resolved
Issues Resolved
  • Made valuation over application value message allowable
  • Fix for incorrect value on negative nominal analysis lines on reversing valuations

Date applied: May 12, 2021

210.0.0

New Features Important
Important Info
  • Please install with other v21 versions of sicon modules

New Features
  • Applications in project enquiry will show as full value with drill down to show movements
  • Nominal postings on applications are now forced
  • New write off retention button added to application ledgers
  • QS Default added to a project to be pulled onto new PL applications
  • Applications import will now include Retention values to use instead of retention values (Optional which one to use)
  • New Retentions history menu added. (Removed from Retention ledger)

Date applied: May 12, 2021