Sicon Projects is designed specifically for Sage 200, integrating with Purchase ledger, SOP, POP, Stock, Time Recording and Works Order Processing. It provides solutions for clients in manufacturing, construction, software development and all types of contract management.
Release notes:
210.0.59
Issues ResolvedIssues Resolved
- Fixed ‘Object not set…’ error on selecting pop address when Enhancement pack is also installed.
- Fixed sorting of descriptions on project enquiry Totals tab.
Date applied: November 11, 2022
210.0.58
Issues Resolved Hot Fix Enhancements ImportantImportant Info
- Update companies required.
Issues Resolved
- Added project lookup sorting setting to project enquiry.
- Project levels shouldnt be available if marked as completed
- POP Invoice quantity validation will now check the whole invoice is not 0 instead of each individual line
- COS date should update if date on the order has changed
- Fixed COS reconciliation issue if order with multiple lines of the stock item is added and despatched.
- POP issue stock at POP cost will now apply exchange rate
- Fixed errors on corrections of a SO invoice when splitting out to multiple lines
- Sales Transaction import creating Unexpected exception error
- Fixed ‘Specified argument was out of range…’ error when creating a new project and activities enabled but not phases
- Fixed Object not set error when deleting activity0 and creating a new activity on a project.
Change in Functionality
- Added Budget margin % to the advanced desktop list
- Added Landed cost functionality to the POP Invoice API methods
- New column added to Budget Import for Reason for change
- New Web API method added to delete Timesheet project transaction
Date applied: October 28, 2022
210.0.57
Issues ResolvedIssues Resolved
- Limited custom field labels to 100 characters and also stopped overlapping fields on the tab
- Fixed loading of project levels tab when project saved and refreshed for new project
- Fixed ‘Object not set…’ error when collapsing all on project levels tab
- Maintain Projects will now remove Analysis codes tab if they are not enabled
- Date on COS posting will now update on despatch or sales order
Date applied: September 30, 2022
210.0.56
Issues Resolved ImportantImportant Info
- New WebAPI methods to get and update project header links on a project
- New WebAPI methods to get, post and delete period budgets
- New WebAPI methods to get, post and delete budget items
Issues Resolved
- Invoice paid status on projects list view should display ‘no invoices’ if no invoices are on the project
- WebAPI method for budgets will return budget hours in the place of spare number 1
- extended Analysis code fields on the project desktop lists to 512 to stop error and red x
Date applied: September 23, 2022
210.0.55
Issues Resolved ImportantImportant Info
- Update companies required.
Issues Resolved
- Setting to disable default nominal extended to be used on SOP and POP Lines
- Fixed ‘Index out of range’ when amending quotes and not all analysis codes are enabled. Also added analysis 6 and 7
- Header types will now be ordered correctly on project enquiry project totals tab
- Fixed Importing NOMCASHP using Import Transactions not showing correctly in the All costs tab
Date applied: September 16, 2022
210.0.54
Issues ResolvedIssues Resolved
- Project journals will now display the journal reference in document number in the project enquiry.
- Fixed Incorrect committed quantity total in Timesheets (Labour) tab in Project Enquiry.
Date applied: September 15, 2022
210.0.53
Issues ResolvedIssues Resolved
- Added lock check to updating Exchange rates when updating SOP and POP orders
- Fixed ‘Out of memory’ exception on the project enquiry when changing the project in the lookup multiple times
- Stopped database timeout when reversing a credit note
- Log files and project filter added to COS routine
Date applied: September 2, 2022
210.0.52
Issues ResolvedIssues Resolved
- Added stock COS adjustments when COS filtered on project enquiry.
- Removed buttons from budgets tab when viewed from project enquiry.
Date applied: August 26, 2022
210.0.51
Issues ResolvedIssues Resolved
- Importing with Project levels – added validation to prevent the importing of levels if not turned on in Project Settings
- Fixed linking to existing Sales order when using Generate Billing and Billing Profile not working
- Adding validation to timesheets making sure override values are not negative
- Timesheet import pulling through wrong rate
- Users will not be allowed to enter or copy a project ID tag in the narrative for journals or invoices
- Comma separation added to values in the budgets screen and enquiry tab
- Fixed speed issue on saving Authorisation screen
- COS created from SO with kit items is not being reconciled to projects
Date applied: August 19, 2022
210.0.50
Issues ResolvedIssues Resolved
- Fixed amending nominal postings of a journal entry causing multiple ID tags.
- Fixed COS issue with multiple stock check ins and despatching on a sales order.
- Issue fixed with self billing not handling change in rates during date selection, causing ‘Nominal Analysis total does not match transactions net value’ error.
Date applied: July 29, 2022
210.0.49
Issues ResolvedIssues Resolved
- Fixed COS reconciliation on Invoicing module credit notes.
- COS should apply exchange rate to set SIJCTRN to base value.
- Fixed Entering Purchase invoice using Rapid invoices screen failing validation then causing multiple ID tags on the narrative.
- ‘Unhandled Exception when selecting additional projects in the Project Enquiry window.
Date applied: July 22, 2022
210.0.48
Issues ResolvedIssues Resolved
- Hide/Show inactive buttons on Project Headers window were the wrong way around.
- Added ‘View Transactions’ button on the ‘Revenue’ tab in Budgets.
- Fixed error: ‘SiJcCHd with Code = ‘—‘ could not be found [0]’ on Rapid purchase invoices.
Date applied: July 15, 2022
210.0.47
Issues ResolvedIssues Resolved
- Fixed SOP invoice reconciliation error when there is a zero value line.
- Fixed SOP invoice reconciliation error on orders that have a comment line.
- Fixed SOP invoice reconciliation error on orders with non euro foreign currency.
- Fixed error on Project enquiry load with no project yet selected. Occurs if timesheets are set to display grouped by week or period.
Date applied: June 30, 2022
210.0.46
Issues ResolvedIssues Resolved
- Validating a line quantity entered will now occur when trying to dispute a POP invoice.
- Change made to SiconJCJobHeaderTypeView to speed it up.
- Fixed duplicates issue on PL invoice correction if only the project analysis has changed.
- Changed message on post POP invoice when validating GRN matching to show available GRN quantity in the error message.
Date applied: June 25, 2022
210.0.45
Issues ResolvedIssues Resolved
- Error on SOP Despatch routine in Projects settings if linked SOPOrderReturnLineID on SIJCTRN is deleted from the order.
- PL and SL imports fixed to post transactions.
Date applied: June 24, 2022
210.0.44
Issues ResolvedIssues Resolved
- Issue with POP disputed invoices being resolved with credit notes. It should now allow the user to amend lines.
- ‘Reconcile past PL invoices’ routine will now include POP Invoices.
Date applied: June 20, 2022
210.0.43
Issues ResolvedIssues Resolved
- Fixed issues with saving project transactions on rapid purchase invoice screen.
- COS amend despatch issues not setting SIJCTRN quantity correctly.
- Nominal transaction import nominal analysis code length validation.
- Sage crashing when entering a purchase Invoice and changing VAT.
- Timesheets import for MISC ’employee’ fixed.
- Project Enquiry scroll bars disappearing if re sized, vertical scroll bar.
- Fixed Sage crashing when trying to raise a Purchase Invoice for a supplier and changing the tax code.
- Rounding differences on POP invoices will now create a ‘differences’ variance line for the user to configure.
- Fixed Project transactions not showing on the Supplier Authorisation Screen with exchange rates.
Date applied: June 13, 2022
210.0.42
Issues Resolved New FeaturesNew Features
- New WebAPI methods added for project levels to add, get, amend and delete.
- Added employee rate migration routine.
- Added info dots to data correction routines screen.
- New routine added to reconcile past PL transactions.
Issues Resolved
- Fixed issue with SOP reconciliation correction routine not picking up all lines that are not unique.
- Excluded comment lines from SOP Invoice confirmation screen.
- Changed rounding on landed cost percentage on POP invoices to be ‘away from zero’ if 3dp is 5.
- Saving SOP lines will only update related SOP type lines and not items linked to generate billing.
- Fixed issue cost price changing on COS when removing despatched quantity to delete.
- Bypassing order line validation when zero and does not have nominal code set.
Date applied: May 23, 2022
210.0.41
Issues Resolved ImportantImportant Info
- Update Companies required.
Issues Resolved
- Fixed COS issue when part checking in stock and despatching then checking in more stock.
- Fixed issue with SOP despatch when amending despatch.
- Issue with disputed invoice goods value text box being disabled.
- Issue with importing timesheets using MISC function.
- Period budget import file example duplicated column change.
- Employee name still being displayed on All cost tab despite labour display setting being changed to Employee Number.
Date applied: May 9, 2022
210.0.40
Issues ResolvedIssues Resolved
- Fixed SOP Values (Commit & Actual) not showing in all revenues tab in project enquiry.
- Tidied and fixed WebAPI method api/SiJcBudgets/GetBudgetByPhase (wasn’t returning its results correctly).
- Fixed Red cross when clicking on project list advanced when its calculating budget variance and the budget is zero.
Date applied: April 25, 2022
210.0.39
Issues Resolved ImportantImportant Info
- Update companies required.
Issues Resolved
- Timesheet journal cost nominal will default if project cost centre and department override is invalid.
- Fixed Reconciliation error on non vatable payments and receipts if the date on lines is changed
- Fixed error – ‘Unable to case object of type…’ When trying to add an appointment in the employee schedule.
Date applied: April 8, 2022
210.0.38
Issues ResolvedIssues Resolved
- Fixed issue with grouping on generate billing where a group contained a mix of positive and negative values.
- Credit note quantities when running SOP reconciliation routine should be negative.
- Fixed ‘Object not set…’ error when clicking option ‘Add activity (with no Phase or Stage)’ on projects levels tab.
- Project integration on repeat order templates should now work again.
- Fixed auto issue calculation on actual quantity on POP lines in the financial enquiry.
- Fixed issue with project level tab not loading if phases not enabled, only stages or activities.
- Fixed Up/Down buttons on project levels tab.
- Fixed conversion of quote not updating project totals if setting turned of to show quotes.
- Completing project checks will not be restricted by SOP and POP. It will check all costs and revenues.
- COS setting in projects will now require the setting for COS to be enabled in sage stock settings.
- Removed Update workspace button from define fields screen.
- Fixed Mandatory Fields on project custom fields. It will also now highlight which fields are mandatory on validation.
- Fixed issue with construction retention releases when running Period end routine to correct periods on projects.
Date applied: April 4, 2022
210.0.37
Issues ResolvedIssues Resolved
- ‘Fixed ‘Object not set..’ error on invoice if no default nominal set on trader adding a blank line in project tab then changing the reference.
- Completed project check on on rapid stock issue
- Fixed issue with corrections to PL and foreign currency making lines disappear
- Fixed Index error on POP invoice routine
- Fixed conversion of quote not updating project totals if setting turned of to show quotes
Date applied: April 1, 2022
210.0.36
Issues ResolvedIssues Resolved
- ‘COS posting should reconcile to nominals on Invoicing module transactions.
- Free text invoice “Unable to case object type SalesFreeTextInvoiceWithBank to SalesFreeTextInvoiceWithBankNominal” error.
- Discount percent not showing correctly on POP invoice.
- truncated line description to 50 on ‘Order line has not been set with a valid nominal code. Please amend before posting.’ message on printing.
Date applied: March 21, 2022
210.0.35
Issues ResolvedIssues Resolved
- ‘Fixed unbilled costs calculation if POP lines are despatched but not invoiced
- Actual Completion date prompt should show when completing a project and not setting this date.
- Fixed Issue in SOP Invoice Posting when one line total on the order is 0 causing the rest of the invoice not to post in projects.
Date applied: March 11, 2022
210.0.34
Issues Resolved ImportantImportant Info
- Update companies required.
Issues Resolved
- SiconProjectSelfBillingView changed so that timesheet import payrate overrides default rate when imported.
- ‘Update project selection to include a range of projects on some transaction correction routines including create budgets routine.
Date applied: March 7, 2022
210.0.33
Issues Resolved ImportantImportant Info
- Update companies required.
Issues Resolved
- ‘Fixed ‘Requested by’ lookup not loading list of employees.
- COS routine will now pick up lines that are not despatched encase they have despatches removed.
- Fixed a problem with COS adjustments being created incorrectly if the same stock item is used multiple times on the same sales order.
- ‘Fixed COS issue when same stock item used on same order and partially despatched.
- Fixed ‘balancing’ error when posting SOP return credit notes.
- Fixed reconciliation error when amending a nominal posting but only changing the project detail that doesnt update the nominal posting.
Date applied: February 28, 2022
210.0.32
Issues ResolvedIssues Resolved
- Fixed ‘Object not Set’ error when clicking on ‘Insert’ on SOP invoicing document.
- Fixed ‘balancing’ error when posting SOP return credit notes.
- ‘Object not set to ref’ error fix on transaction enquiry form.
- Change to un billed costs to exclude PO’s with billed invoices.
- Fix with PSA child item add and list refresh.
- Increase to timesheet hours to be infinite.
Date applied: February 28, 2022
210.0.31
Issues Resolved ImportantImportant Info
- Update companies required.
Issues Resolved
- Fixed Red cross on stock tab on project enquiry if it contains imported transactions with no stock item link
- Fixed SI-SOPQUOTES not following show quote rules on project totals
- When clicking the project levels button on an operation but only one activity exists it will now pop up a message to notify user of this instead of an error.
Date applied: February 7, 2022
210.0.30
Issues Resolved ImportantImportant Info
- Update Companies required.
Issues Resolved
- Increase on number of hours allowed on timesheet setting.
- Selecting a stock item on plant hire orders should limit the description to 255 characters.
- Made speed improvements to views used on project enquiry.
Date applied: January 28, 2022
210.0.29
Issues ResolvedIssues Resolved
- Project levels should be copied over to reversal transactions in PL.
- Fixed validation of a dropdown type of custom field if set as mandatory.
- Made a change to filter the header types on the budgets.
- Fixed Reconciliation error on vatable payments and receipts if the date on lines is changed.
- Fixed ‘out of memory’ exception on Movement balance deletion messaging that caused a knock on database timeout on SOP despatching.
- Added ‘SiconJCBillingProfile’ to data model.
- Collection on plant hire timesheet should update the linked PO with any changes to the duration.
- Made change to keep progress bar in front when loading all project levels on maintain project.
- Customer on project will now be validated and warned if on hold when selecting.
Date applied: January 21, 2022
210.0.28
Issues ResolvedIssues Resolved
- Fixed COS issue on SOP despatch on stock item with negative stock then adding stock with new price.
- Made a change to the budget views to exclude financial application transactions.
- Fixed ‘Out of memory’ exception on adding project levels to a project caused by history tab loading all history for everything when it should be clear for new items.
- Project header should be set on new rapid issue lines after posting previous lines.
Date applied: January 17, 2022
210.0.27
Issues ResolvedIssues Resolved
- Fix problem when writing off stock (removing movement balance records) and the process never finished (out of memory). This is because if stock integration with nominals is turned off, then the posting URN is 0 and we don’t want to update transactions
- speed improvements to deleting a stage
- Fixed indexing issue on project desktop list when moving and removing columns causing columns to display wrong fields.
- Tax on POP invoice should be amendable if not set on pre invoice screen.
- Analysis Validation added to Phase, Stage & activity Import.
- Transactions import will now store invoice numbers in the document reference field in SIJCTRN.
- Project header should save first time on new employees.
Date applied: January 7, 2022
210.0.26
Issues Resolved ImportantImportant Info
- Update Companies required
Issues Resolved
- Fixed issue with POP invoices remaining on committed if invoiced before GRN
- Fixed reconciliation error on sales import with non euro exchange rate
- Fixed grouping issue with labour transactions on generate billing
- Fixed ‘Object not set’ error on purchase invoices on foreign accounts relating to VAT validation.
- Fixed issue with Sales order list with projects loading slowly when filtered.
- Committed Timesheets will display highlighted in yellow on generate billing. Quantities will also be displayed for timesheets
- Adjustments to stock issues should include nominal detail on the project enquiry
- Financial enquiry should display total selling price on POPs that are still committed
- Only load the project levels tab on project maintenance when selected
- Fixed duplication of project headers on the project enquiry totals
- Fixed ‘Object not set’ error when adding an activity to a project with Activities Only Enabled
Date applied: December 24, 2021
210.0.25
Issues ResolvedIssues Resolved
- Some performance improvements loading Project levels tab + added a progress bar
- Made amendments to COS routine to pick up transactions with split stock Transaction history
- Fixed issue with stock adjustment posting duplicating the main COS posting.
- Fixed issue with over receipting a PO causing a negative committed quantity on the project
- COS should be updated to actual on re-despatching after adjusting the despatch down.
Date applied: December 20, 2021
210.0.24
Issues ResolvedIssues Resolved
- Fixed ‘Object not set’ error on generate billing and adding to existing sales order that has a comment line as the first line.
- Fix for first line duplicating when a transaction is split over multiple nominals with the same value instead of the separate records being added
- Fixed loading bar getting stuck on project enquiry. It occurred when the construction module is not installed.
Date applied: December 10, 2021
210.0.23
Issues ResolvedIssues Resolved
- Filtered out JOURNALS and revenue Project header transactions.
- Trim whitespace on the reference field on NL Import to stop grouping issue
- [ID:xxxxx] tags in narratives for Imported NL transactions will be cleared before processing
- Option added to exclude control accounts on Nominal Reconciliation. defaulted off
- Speed improvements to Project reconciliation screen
- Fix for blank PSA being created on converting template even if template has other PSA + fix for item not found error when template has a planned purchase
- fix for Project analysis transactions not appearing on Authorisation (Fix for incorrect exchange rate when it’s not a euro currency)
- Fixed issues on POP invoice where the nominal value is not updating correctly and duplicating from the line below
- Fix for error when using a not euro currency (Added a check to see if currency is euro-based)
- Fix for activities not loading on project if only activities are enabled
- Fixed loading bar getting stuck on project enquiry. It occurred when the construction module is not installed.
Date applied: December 3, 2021
210.0.22
Issues ResolvedIssues Resolved
- Change to saving a project to make sure there’s a link between projects and project header if it doesn’t already exist.
- Fixed exchange rate rounding issue on correcting sales invoices/credit notes.
- Fix for issue with Total Selling Prince (All costs) 0 if order isn’t invoiced.
- Changed to use Realised Cost rate instead of the total to match to the nominals.
- When adding stock, any related internal issue adjustments will now be recorded in projects.
- Pull PO Number from project on Generate Billing Sales Order.
Date applied: November 26, 2021
210.0.21
Issues Resolved ImportantImportant Info
- Update Companies required
Issues Resolved
- Fixed an exchange rate issue found on imports
- Fix for error on NL Transaction Enquiry Screen
- Fixed object not set error on Transaction Enquiry Screen if Project levels are not enabled
- Made change to reconciliation tools to allow search of project transactions that are marked as matched.
- Fix for error ‘Unable to reconcile…’ when reversing a journal with transactions with different dates
- Fix for error when entering a second invoice without closing the screen
- Fix for wrong warehouse/bin being populated when entering a record exists for that stock item and sage user
- Fix for Construction transactions not appearing on the project enquiry (partial, the rest is in Construction v210.0.14)
- Changes made to loading high volumes of budgets on the project enquiry screen.
Date applied: November 19, 2021
210.0.20
Issues Resolved ImportantImportant Info
- Update Companies required
Issues Resolved
- Use -Math.Abs instead of * -1 for order return transaction
- Removed the load of project tabs on saving the job to decrease the save time
- Error on adding nominal templates when no default project & project header
- When using Selling Unit that isn’t Each, the SOP wasn’t displaying on the Project Correction
- Character limit of 255 will be enforced on adding new objective lines.
- Fixed error on adding budget with new specified stages
- Changed tab order on maintain project rates
- create project from template will copy objective summary
- moved dropdown that was covering label on crate project from template screen
- Fixed issue with Tax value on POP invoice resetting to sage calculated value
- Creating project from template on sales order will now set the project on the order header
- Fix for invalid column name error
- Fixed Exchange rate rounding precision issue on reconciling invoice nominals
- Stopped blank lines creating when clicking on convert estimate to project grid
- DocumentNo and URN will now be included in transaction Editor Export
- Fixed Red cross on define custom fields if a linked custom tab is deleted
Date applied: November 6, 2021
210.0.19
Issues ResolvedIssues Resolved
- COS adjustments will now be recorded and nominal reconciled.
- COS will now use the transaction date stored on the stock history posting rather than the SOP requested date.
- COS to display correct quantity for returns
- Fix when importing sales orders to get the correct nominal and override dependent on the project that has been imported for the sales order
- Don’t filter PSA if they’re not enabled
Date applied: October 22, 2021
210.0.16
Issues Resolved ImportantImportant Info
- Update Companies required.
Issues Resolved
- ‘GrossValueLessNotionalTax’ error on POP invoice for older versions of 200c.
- Blocked deleting timesheet if a journal has been generated for it.
- Index error on saving a SOP quotation when not all analysis codes enabled for projects and setting on to create projects for SOP.
- Changes to projects level tab on amend project to not refresh the whole list.
- Added better error handling when using Sicon stock transfers to transfer to a job.
- Added a Get ProjectNominals WebAPI method.
- Fixed grouping issue on generate billing for labour lines where employees are alternated in the grid.
- Zero quantity lines on grouping generated billing will set quantity as 1 to stop ‘Quantity must be greater than zero’ error.
Date applied: October 7, 2021
210.0.15
Issues ResolvedIssues Resolved
- Fixed issue with SOP not posting invoices to projects.
- Budgets for the same project header type should be grouped.
- Added Case Sensitive validation on Project header import for Header Type.
- Fix corrected the namespace for Distribution, Barcoding and EP to get the stock transfer scripts to run for projects.
- Tidied the projects script for displaying the project despatch button when it is project transfer else use the standard buttons.
Date applied: September 7, 2021
210.0.14
Issues ResolvedIssues Resolved
- Fixed an issue with some COS lines not reconciling when using the COS correction routine.
- Committed costs including COS should load on the enquiry Project totals tab breakdown.
- Fixed looping error when selecting a Postponed VAT code (Later versions of 200c) on POP invoice.
- Fixed Timeout error on POP invoices.
Date applied: September 1, 2021
210.0.13
Issues Resolved New FeaturesNew Features
- SOP invoicing will now update billing detail on any linked Bill costs.
Issues Resolved
- Zero balance SOP invoices will now also create nominals to reconcile to.
Date applied: August 20, 2021
210.0.12
Issues Resolved ImportantImportant Info
- Update Companies required.
Issues Resolved
- Issue with authorising a corrected invoice picking up the incorrect nominal line.
- Reconciliation error on authoisation with multiple lines.
- Fixed issue with VAT variance on a Euro POP invoice.
- Grouped billing should be split out per project on the sales order.
- ‘Object not set’ error when adding a second new project after saving the first.
- Filter out STOCK transactions when looking for invoice on ‘copy invoice’.
- ‘Object not set…’ error on invoicing credit note screen.
- Fixed some exchange rate rounding issues on Project enquiry.
- Exchange rate issues found on Posting POP invoices.
- Changed payroll routine to use SQL script
- Fix for no description on POP Invoice transactions in generate billing screen.
Date applied: August 17, 2021
210.0.11
Issues Resolved ImportantImportant Info
- Update Companies required.
Issues Resolved
- Fixed issue where defined Tax value on post POP invoice is not following through to invoice screen.
- Fixed exchange rate rounding issue found on authorise PL invoice causing projects tab not to populate.
- Changed generate missing COS routine to be more standardised.
Date applied: August 6, 2021
210.0.10
Issues ResolvedIssues Resolved
- Project transactions will be created for SOP invoices if the nominal balance equal 0 and no nominal is actually posted in sage.
- Changed Reconcile past SOP routine to also create project transactions where nominal found.
- Fix for Budgets not displaying on enquiry screen ‘Project Totals’ tab when the project has no transactions.
- Fix for SOP Return showing as a positive value on project totals enquiry when it’s been printed but not posted.
Date applied: August 2, 2021
210.0.7
Issues ResolvedIssues Resolved
- Fix for nominal line not being pulled on authorisation screen when it’s in foreign currency.
- Prevent POP invoice posting without nominals.
- Fix for PO number disappearing on changing lines.
- Fix for Goods value changing when you change the VAT analysis.
- Fixed issue with project cost totals on excluding pop variances on the advanced desktop list.
- Fixed ‘Object not set..’ error on saving prompt to set project on lines that don’t have a project transaction after saving sales order.
Date applied: July 13, 2021
210.0.6
Issues ResolvedIssues Resolved
- Fix for Transaction Narrative changing on authorisation.
- Fix for object reference error on ‘Export All’ in Budgets tab.
- Fix for POP Order transaction showing in unbilled costs on project enquiry.
- Projects Issues List (Item 76) – Changes to Project Issue Item Attachments path.
Date applied: July 2, 2021