Construction v22.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 Hot Fix Enhancements Important Only

Know the release number? Use quick search:

221.0.30

Issues Resolved New Features Important
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

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

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

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

Date applied: March 6, 2024

221.0.26

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

Issues Resolved New Features Important
Important Info
  • Update companies required

New Features

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

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

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

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

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

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

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

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

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

Issues Resolved New Features Important
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

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

Issues Resolved New Features Important
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

Issues Resolved New Features Important
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

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

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

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

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

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

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

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

Issues Resolved New Features
New Features
  • Re-allocating valuation from one application to another should display nominal lines if it is created from populate outstanding

Issues Resolved
  • Fix to display allocated retention releases in the project enquiry correctly when recognised on invoice
  • 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