Construction v20

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:

200.0.59

Issues Resolved
Issues Resolved
  • Reversing valuation causing error ”Nominal analysis total does not match transaction net value”

Date applied: September 7, 2022

200.0.54

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

200.0.53

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

200.0.51

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

Date applied: March 11, 2022

200.0.51

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

200.0.50

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

200.0.49

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

200.0.48

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

200.0.47

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

200.0.46

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

200.0.45

Issues Resolved
Issues Resolved
  • remove message box on error

Date applied: December 3, 2021

200.0.44

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

200.0.43

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

Date applied: November 10, 2021

200.0.42

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

Date applied: November 3, 2021

200.0.41

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

200.0.40

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

200.0.39

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
  • Fixed Object reference error on CIS screen

Date applied: August 27, 2021

200.0.38

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

200.0.37

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

200.0.36

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.
  • Fix for SiconCISPaymentAudit saving the wrong values for CIS credit notes

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

Date applied: July 5, 2021

200.0.35

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

200.0.34

Issues Resolved Important
Important Info
  • Update Companies Required

Issues Resolved
  • Fix for credit note not appearing in URN list on CIS Submit screen
  • Fix for Subcontractor POs showing as completed when there is outstanding amounts

Date applied: June 16, 2021

200.0.33

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 15, 2021

200.0.32

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

200.0.31

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

200.0.30

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

200.0.29

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

Date applied: May 4, 2021

200.0.28

Issues Resolved Hot Fix Enhancements
Issues Resolved
  • Fixed Retention Write off issue postings with Credit Notes

Hot Fix Enhancements
  • Added Tax Code column to SO and PO
  • Recording Tax Code change history on SO and PO

Date applied: April 26, 2021

200.0.27

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.
  • ‘R’ query flag should be cleared on PL credit notes before allocation.

Date applied: April 21, 2021

200.0.26

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

Date applied: April 9, 2021

200.0.25

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

200.0.24

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.

Date applied: March 26, 2021

200.0.23

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

Date applied: March 12, 2021

200.0.22

Issues Resolved Important
Important Info
  • Update Companies Required

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

200.0.21

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

200.0.20

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

200.0.19

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

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

200.0.18

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

200.0.17

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

Date applied: November 20, 2020

200.0.16

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

200.0.15

Issues Resolved Hot Fix Enhancements Important
Important Info

*Update companies required


Issues Resolved
  • fixed ‘Object not set’ errors when adding nominal lines on a valuation from the application ledger
  • Fixed issues with generating retention history list values
  • Application status should calculate correctly for applications with allocated valuations
  • Reversed credit note valuations should also reverse the invoiced value.
  • Prompt for nominal code should only occur once on opening balance retention release
  • CITB percentage should load correctly on invoice deductions screen.
  • Deleting applications linked to orders should reset the applied for values correctly
  • fixed application outstanding calculation with released retentions when posting to projects
  • fixed outstanding on retentions loaded from the application ledger

Hot Fix Enhancements
  • Tick box added to opening balance retentions to post to projects (default not checked)

Date applied: October 23, 2020

200.0.13

Issues Resolved
Issues Resolved
  • Released amount and customer on retention form history lines not appearing
  • Exchange rate issue on valuation nominal postings when deleting a valuation and releasing retentions
  • Issue with no tax value added to valuation nominal line when releasing a retention and no default code set on the project
  • Issue with retrieving CITB nominal when releasing retentions
  • Nominals not setting correctly on CITB settings screen.
  • Fixed error on convert Quote to construction order and creating a new project. This occurs when comment lines are on the quote.

Date applied: September 25, 2020

200.0.12

Issues Resolved
Issues Resolved
  • Fixed rounding and loading speed issue when populating from outstanding on valuation from application ledger
  • Routine added to reconcile application retentions to a nominal on the application to keep updated.
  • Fixed issue with Valuation nominals not posting when invoicing from the application ledger.
  • Validation added to post SL valuation payment to check it has already been invoiced.

Date applied: September 18, 2020

200.0.11

Issues Resolved
Issues Resolved
  • RCT payment postings will now resubmit contract to ROS to get latest deduction rate before posting.
  • Fixed issue on Rapid PL invoice where the CIS deduction is inflated by 100.
  • Nominal Transaction enquiry drill downs will only load if Retentions or Applications are loaded. This is to resolve issue with no Projects installed and CIS only enabled.

Date applied: September 4, 2020

200.0.10

Issues Resolved
Issues Resolved
  • Fixed common deduction posting method to include CIS rate nominal override

Date applied: August 21, 2020

200.0.9

Issues Resolved Hot Fix Enhancements Important
Important Info
  • Update Companies Required

Issues Resolved
  • Sales orders will automatically save when saving an order line.
  • margin % Total added to sales orders
  • Fixed total refreshing on sales orders if a sales order line is double clicked to edit
  • Sales order lines row numbers will be re-sequenced when deleting a line and saving the order.
  • Sales order lines screen will be kept open after saving new lines.
  • select all and invert buttons added to sales order back to back purchase order generation screen.
  • Add, edit and delete on sales order now have ALT hotkeys.
  • Order lines on order header screen will now be colour alternated.
  • View sales orders, Subcontract orders, Retention and applications can now again be drill downed from the Sicon Project enquiry screen
  • Stock items wont be allowed to be deleted if they are used on a construction Sales order
  • labour and material Nominal selection wont lock the screen if selected with no nominal code entered
  • Labour and service items allocated quantities on a construction sales order should match the despatched quantity.

Hot Fix Enhancements
  • default tax code added to sales quote header to default on lines.

Date applied: August 14, 2020

200.0.8

Issues Resolved
Issues Resolved
  • Fixed issue with retention value going missing on retention release applications
  • Fixed ‘Missing Transaction History ID’ error when adding an item but then closing the form
  • Service and miscellaneous stock items will nolonger post stock issues on despatching Sicon Sales order.
  • Valuation print will now only use ‘CON Valuation Invoice.layout’

Date applied: August 3, 2020

200.0.7

Issues Resolved
Issues Resolved
  • invoices/credits linked to Retentions will be blocked for using the correct and reverse features and instead asked to do it manually.
    This will ensure that deduction documents will be generated for them.
  • Fixed ‘Divide by zero’ error on loading CIS
  • Fixed issue complete message appearing for every line on CIS transaction import.
  • RCT contract lookup will get deduction rate using either ns3 or ns2 nodes in response file.

Date applied: August 3, 2020

200.0.6

Issues Resolved
Issues Resolved
  • Tax code added to sales order import
  • generated invoice number will be set as Reference 1 on retention releases
  • Fixed issues with apply CIS setting not applying on Customers and also not posting on invoices.

Date applied: August 3, 2020

200.0.5

Issues Resolved Hot Fix Enhancements Important
Important Info
  • Update Companies Required

Issues Resolved
  • Fixed pop up on PL invoices to link the invoice to an open application.
  • QS notes and reference moved to the valuation screen

Hot Fix Enhancements
  • New button added to supplier applications to link an existing invoice to a valuation

Date applied: August 3, 2020