Construction v20.1

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 Change in Functionality Important Only

Know the release number? Use quick search:

201.0.45

Issues Resolved
Issues Resolved
  • Retention total not showing correctly in add application screen

Date applied: June 24, 2022

201.0.43

Issues Resolved
Issues Resolved
  • Changing ‘Job’ labels on import templates to ‘project’
  • Invoice not getting created correctly when using batched transaction entry
  • Stopped valuations posting retentions if they are not allocated to applications and posting invoice.

Date applied: May 16, 2022

201.0.42

Issues Resolved Important
Important Info
  • Update companies required

Issues Resolved
  • Retention percentages increased to 7dp on applications and valuations

Date applied: April 25, 2022

201.0.41

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

201.0.40

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

201.0.39

Issues Resolved
Issues Resolved
  • 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

201.0.36

Issues Resolved
Issues Resolved
  • Speed issue with moving up and down sales order list

Date applied: March 11, 2022

201.0.37

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

201.0.36

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

Date applied: February 28, 2022

201.0.35

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

201.0.34

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

201.0.33

Issues Resolved
Issues Resolved
  • Converting a sales order Quote to a sales order should create project postings.
  • Quotes should save as quote lines on projects

Date applied: February 8, 2022

201.0.32

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

201.0.31

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

201.0.30

Issues Resolved
Issues Resolved
  • Add validate method to check for errors before creating an application and subcontractor order

Date applied: December 3, 2021

201.0.29

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

201.0.28

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

Date applied: November 10, 2021

201.0.27

Issues Resolved Hot Fix Enhancements
Issues Resolved
  • 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

Change in Functionality
  • New prompt to pick an adjustment date on the valuation allocation screen. This date will then used for the adjustment nominal postings

Date applied: November 3, 2021

201.0.26

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

201.0.25

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

201.0.24

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

201.0.23

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

Date applied: August 8, 2021

201.0.22

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

Date applied: July 12, 2021

201.0.21

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.

Change in Functionality
  • Retention setting to change tax rate will now give option to select Tax code on release

Date applied: July 5, 2021

201.0.20

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

201.0.19

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

Date applied: June 28, 2021

201.0.18

Issues Resolved
Issues Resolved
  • 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

201.0.17

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

201.0.16

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

201.0.15

Issues Resolved
Issues Resolved
  • Made changes to change the VAT code on retention release to Reverse charge if that is the trader default
  • Fixed ONS error on PL retention release on Applications ledger
  • Made changes to record the previous Tax Code in the history log of SO and PO

Date applied: May 4, 2021

201.0.14

Issues Resolved Hot Fix Enhancements
Issues Resolved
  • PL ledger retention release button should open up valuation in Supplier mode
  • Fix for incorrect value on negative nominal analysis lines on reversing valuations

Change in Functionality
  • Added Tax Code column to SO and PO
  • Recording Tax Code change history on SO and PO

Date applied: April 26, 2021

201.0.13

Issues Resolved
Issues Resolved
  • Attempt to divide by zero error when reversing retention release fixed
  • Validation of valuation going over application should occur on new valuations
  • Generate Subcontractor order applications should filter out canceled orders.
  • On generating applications from orders. Tick box will initially highlight the correct lines text box to key in value.
  • Fixed UnreserveNextSupplierApplicationNo error
  • ‘R’ query flag should be cleared on PL credit notes before allocation.

Date applied: April 21, 2021

201.0.12

Issues Resolved
Issues Resolved
  • CIS Audit tax value incorrect on PL applications if reverse charge tax code used

Date applied: April 9, 2021

201.0.11

Issues Resolved Important
Important Info
  • Update companies Required

Issues Resolved
  • Fixed ‘Object not set…’ error on release retention button on Supplier Application ledger.
  • Nominal reversal postings will not occur on delete valuation if the valuation is not allocated to applications.
  • 2nd reference will now also be used on grouping deductions on rapid PL invoices.
  • Fixed rounding issue on allocation valuations when setting status of applications to ‘Retentions Only’
  • Decimal places (5dp) added to sales order percentage complete
  • Fixed ‘Divide by zero…’ error on Construction sales orders if the stock item has no price.
  • Populate outstanding button on valuation with application that has multiple lines. it should show values selected and calculate the total bar.
  • Fixed rounding issue on allocated valuations displayed in Application form (not Application ledger)
  • ‘Print Invoice’ should be enabled on allocated valuations on application form.

Date applied: April 1, 2021

201.0.10

Issues Resolved
Issues Resolved
  • Fixed rounding issue with application allocation valuation ratios.
  • Fixed issue with Print invoice button not appearing enabled on allocated valuations
  • Option to reprint invoice should be available on application ledger print button.
  • Fixed polarity issue on Invoicing module credit notes with retentions.
  • If application has multiple lines, then the populate outstanding should be enabled on initial load when creating directly from an application.
  • Totals bar on valuation should calculate after using ‘Populate outstanding’ button.
  • Fixed issue with reprint option on print invoice on a valuation

Date applied: March 26, 2021

201.0.9

Issues Resolved Important
Important Info
  • Update companies required

Issues Resolved
  • CIS Reverse charge VAT will not be included on Sales valuation Receipts.
  • Project CC and Dept overrides will be applied to retention deduction nominal lines on an application
  • Raising negative applications should create retention lines if applicable.
  • Amending PL allocations wont be allowed if RCT
  • Fixed PL Application ledger asking for a customer when clicking retention Release

Date applied: March 12, 2021

201.0.8

Issues Resolved New Features Important
Important Info
  • Update Companies Required

New Features
  • New setting to disable gross value on application and force cumulative only.

Issues Resolved
  • Applications movement history in projects will now occur if nominal postings are not turned on.
  • Reverse charge VAT detail added to valuation view to be picked up on reports
  • Project CC and Dept overrides will now occur on Application nominal postings
  • Retention Totals on application ledger fixed when released.
  • Opening balance value will be included in application ledger invoiced total.

Date applied: February 25, 2021

201.0.7

Issues Resolved Important
Important Info
  • Update companies Required

Issues Resolved
  • Self billing on a negative timesheet in sicon projects should now do the correct CIS deduction.
  • Fixed PL applications, valuations and retentions having a -1 in the quantity column in sicon projects enquiry.
  • Fixed issue with Subcontract order application % on measured works if the application is later deleted.
  • Fixed issue with exchange rates when changing the project currency on applications screen.
  • RCT Contracts will nolonger validate the Site identification number
  • Previous allocated nominal values will now be stored, displayed and used in calculations when clicking the populate button on a valuation.

Date applied: January 22, 2021

201.0.6

Issues Resolved
Issues Resolved
  • Fixed valuation nominals duplicating when using the populate outstanding button.
  • Invoice validation on paying valuations should check the invoice net value.

Date applied: January 13, 2021

201.0.5

Issues Resolved Hot Fix Enhancements
Issues Resolved
  • When clicking the retention release button on applications, It should now use the correct nominal code.
  • Fixed ‘Cast’ error on nominal transaction enquiry when going through the account summary breakdown.
  • Fix for duplicate nominal lines created on valuation.
  • Fixed issue with sales orders not creating project transactions on save.
  • Valuation nominal posting adjustments will now use the invoiced date

Change in Functionality

– Setting Added to turn off RCT integration on Payment processing
– Creating applications for construction orders will now prompt for an application date before posting.


Date applied: December 24, 2020

201.0.0

New Features
New Features

– Customer/Supplier code included in application nominal postings
– New nominal codes added to move retention values between Application and valuation
– WAP authorisation moved to valuations
– PL application ledger added


Date applied: December 18, 2020

201.0.3

Issues Resolved
Issues Resolved
  • Generate missing CIS on a credit note should display correctly on transaction enquiry and CIS return.
  • Fixed Issue with allocating a receipt to a credit note with CIS
  • Application nominal posting adjustments should now post in the correct current period.
  • Fixed speed issue on saving a sales order line on an order with a large amount of lines.
  • RCT test gateway changed to https://softwaretest.ros.ie

Date applied: December 6, 2020

201.0.2

Issues Resolved
Issues Resolved
  • Fixed ‘Object not set’ error on releasing single release retentions
  • Fixed issue with retentions not displaying correct value when part released on applications
  • Valuation invoices will now include project ID tags on narrative to be picked up on WAP authorisation
  • Fixed issue with part released retentions setting applications to paid
  • Supplier application ledger should display Supplier detail on selected lines

Date applied: November 20, 2020

201.0.1

Issues Resolved
Issues Resolved
  • Made change to CIS reconciliation to not create audits on opening balance unless they are ticked. It was automatically creating these on load before.
  • Added totals bar to retentions history
  • Fixed error on SOP invoicing amend screen when CIS only enabled and projects not installed.
  • CIS will not auto allocate deduction transaction if the original transaction has a query flag on save set by a third party module.
  • Fixed issue with RCT deduction transaction not picking up the correct nominal set up for the rate.
  • Fixed Rounding issue on retentions when doing a final application

Date applied: November 7, 2020