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:
200.0.63
Issues ResolvedIssues Resolved
- Rolled down changes for setting VAT on POP invoices.
Date applied: September 20, 2022
200.0.62
Issues ResolvedIssues Resolved
- Rolled down Speed improvements to SOP despatches.
Date applied: September 14, 2022
200.0.60
Issues ResolvedIssues Resolved
- Fixed issue with grouping on generate billing where a group contained a mix of positive and negative values.
- COS setting in projects will now require the setting for COS to be enabled in sage stock settings.
- Fixed issue with construction retention releases when running Period end routine to correct periods on projects.
Date applied: April 4, 2022
200.0.59
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
200.0.58
Issues ResolvedIssues Resolved
- 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
200.0.57
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
200.0.56
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.
Date applied: February 15, 2022
200.0.55
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.
Date applied: February 8, 2022
200.0.54
Issues ResolvedIssues 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.
Date applied: January 28, 2022
200.0.53
Issues ResolvedIssues Resolved
- Project levels should be copied over to reversal transactions in PL
- 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.
- Collection on plant hire timesheet should update the linked PO with any changes to the duration.
- Customer on project will now be validated and warned if on hold when selecting.
Date applied: January 21, 2022
200.0.52
Issues ResolvedIssues Resolved
- Fixed COS issue on SOP despatch on stock item with negative stock then adding stock with new price.
- Project header should be set on new rapid issue lines after posting previous lines.
Date applied: January 17, 2022
200.0.51
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.
- 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 17, 2022
200.0.50
Issues ResolvedIssues 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
- Budget total should display on the project enquiry totals
Date applied: December 24, 2021
200.0.49
Issues ResolvedIssues Resolved
- 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
200.0.48
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).
Date applied: December 3, 2021
200.0.47
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
200.0.46
Issues ResolvedIssues 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.
Date applied: November 19, 2021
200.0.45
Issues ResolvedIssues Resolved
- When using Selling Unit that isn’t Each, the SOP wasn’t displaying on the Project Correction.
- Fix for invalid column name error.
- Fixed Exchange rate rounding precision issue on reconciling invoice nominals.
- Fixed Red cross on define custom fields if a linked custom tab is deleted.
- Fix for Projects Advanced List crashing when removing columns.
Date applied: November 6, 2021
200.0.44
Issues ResolvedIssues Resolved
- Return from GenerateCOSAdjustments if COS not enabled.
- Fix for issue with credits showing as positive figures on project enquiry.
- Projects Issues list Item #113 – Error on adding nominal templates when no default project & project header.
Date applied: October 29, 2021
200.0.43
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
200.0.41
Issues ResolvedIssues Resolved
- Fixed analysis code error on loading a quote.
- When cancelling a plant hire, the extended plant transaction will now be removed from the project too.
- Fixed POP transactions not following setting rules to use document date instead of requested date.
- Change to allow Tax value to be amended on POP invoice.
- Fix for wrong (old) nominal code saved on PL correction.
Date applied: October 8, 2021
200.0.40
Issues ResolvedIssues 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.
- 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: September 21, 2021
200.0.39
Issues ResolvedIssues Resolved
- Fixed issue with SOP not posting invoices to projects.
Date applied: September 21, 2021
200.0.38
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
200.0.37
Issues ResolvedIssues Resolved
- Zero balance SOP invoices will now also create nominals to reconcile to.
Date applied: August 20, 2021
200.0.36
Issues ResolvedIssues 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
200.0.35
Issues ResolvedIssues 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
200.0.34
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.
Date applied: August 2, 2021
200.0.33
Issues ResolvedIssues Resolved
- Get original goods value after JC reconciliations.
- Fix for errors on updating pending transactions in Sales Ledger.
- Fix for SOP Quote transaction showing on project when the setting is off.
- Fix for Project Analysis not copying on Copy Invoice (SOP, Invoicing module).
Date applied: July 20, 2021
200.0.32
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.
Date applied: July 20, 2021
200.0.31
Issues ResolvedIssues Resolved
- Fix for Transaction Narrative changing on authorisation.
- Fix for object reference error on ‘Export All’ in Budgets tab.
Date applied: July 2, 2021
200.0.30
Issues ResolvedIssues Resolved
- Fix for Nominals not overriding from project settings on Web API.
- Invoice lines with no project info supplied will go to N/A + checking invoice job transactions response for errors.
- Fix to payroll week generation routine causing a duplication in April 2021.
- Fix for timesheet error when the project on a timesheet line is completed.
Date applied: June 25, 2021
200.0.29
Issues ResolvedIssues Resolved
- Negative Time sheets creating a negative sales order when Billing transactions are grouped.
- COS unit selling price will be set as 0 as it is already billed.
- Fixed issue with COS resetting to incorrect value after print invoice.
- Purchase Invoices that still don’t match the receipted value.
Date applied: June 19, 2021
200.0.28
Issues ResolvedIssues Resolved
- Fix for corrected invoice not showing on Project Enquiry.
- Entering a Plant Hire order line does not pick up the project header linked on the stock item.
- Update SOP and POP Order line nominals on import.
Date applied: June 18, 2021
200.0.27
Issues ResolvedIssues Resolved
- Fixed a rounding issue on posting stock issues.
- Duplicate project line issue when authorising invoices with foreign currency
- Discounted unit price on PO’s is not being carried through to purchase invoice screen
- Export to excel not matching displayed lines in grid on Maintain billed transactions (Was showing auto issued lines)
- All Costs view (Project Enquiry) change for Unit Value column to use the relative unit value instead of relative line total
- Changed to use correct Nominal ID and URN on COS posting
- Fixed nominal validation of balance sheet codes to only display if setting is enabled.
Date applied: May 24, 2021
200.0.26
Issues Resolved ImportantImportant Info
- Update Companies required.
Issues Resolved
- COS nominal reconciliation will look at realised cost on order for goods value
- Fixed issue on generate billing and grouping mixed transaction types
- Fixed ‘Object not set’ error on SOP despatch on non stock lines.
Date applied: May 11, 2021
200.0.24
Issues ResolvedIssues Resolved
- Fix for COS where an order contains more than one line with the same stock item.
- Fixed ‘Exclude project from desktop lists’ not saving.
Date applied: April 19, 2021
200.0.23
Issues ResolvedIssues Resolved
- Allowable warning on quantity over on POP invoice Web API method.
- Transaction date on Nominal bank postings
- Project level on stock postings.
- fixed Incorrect goods value on POP invoice if stock line is using multiple of stock unit.
- If clicking on deleting phase it will allow and delete Stage and activities if none of them are in use.
Date applied: April 2, 2021
200.0.22
Issues ResolvedIssues Resolved
- Prompt to create Project for Sales order will not pop again if ‘No’ selected
- Fixed committed quantity column on all cost tab in projects enquiry..
Date applied: March 15, 2021
200.0.21
Issues ResolvedIssues Resolved
- Timesheet import should filter deleted employees.
- Fixed error message popping up on payroll extract.
- Project rates should display project header only rates.
- Fix for Timesheet journals duplicating nominal lines on post.
- Postings from the invoicing module should have a source of ‘Invoicing’.
Date applied: March 2, 2021
200.0.20
Issues ResolvedIssues Resolved
- Fixed Issue with Timesheet postings not creating the corresponding Nominal entries on the Work In Progress Detail Export.
- Validation to customer deletion added to check if its assigned to a project
- Fixed Web API method to post POP invoices not updating the committed value.
Date applied: February 11, 2021
200.0.19
Issues Resolved ImportantImportant Info
*Update companies required.
Issues Resolved
- Budgets will now warn user if activity doesn’t exist (If activities turned on).
- Fixed ‘Out of Memory’ Exception when running large amount of lines in generate billing.
- Unit selling price on project enquiry will be 0 if non chargeable.
- SiJCEnquiryRetrospectiveView changed to use Invoice views.
- Fixed Total profit calculation on advanced project list.
- Printing on invoicing module will print either Invoice or credit note instead of both with same document number.
- Fixed Notes not setting on Timesheet Import.
- ‘Error converting data type varchar to bigint’ fixed on Nominal Transaction enquiry if narrative has a [ID:EXCLUDED] tag.
- Zero unit values will be excluded from timesheet journals.
- ‘Could not format node ‘Value’ for execution as SQL’ Error fixed on project rates.
Date applied: February 6, 2021
200.0.18
Issues ResolvedIssues Resolved
- Negative timesheets should create negative entries in generate billing
- Fixed screen locking when loading projects on the nominal transaction enquiry
- Printing SOP Invoices shouldnt validate nominals on comment lines
- Fixed ‘Cannot set the value of the Field’ on nominal transaction enquiry if the project level is large
- Transaction Editor will now display all transactions when project is selected
- Fixed ‘Object reference not set to an instance of an object’ error when clicking on Save and Print in invoicing and a custom layout set up
- Project enquiry totals are now formatted to 2dp
- Fixed double drop down occurring on project manager on maintain project.
Date applied: January 22, 2021
200.0.17
Issues ResolvedIssues Resolved
- Validation added to project header to stop cost codes being forced in on ‘Revenue’ SOP Sales Invoicing.
- Reversal transaction on corrections should use correct original date instead of the new date if changed.
- View transactions screen from budgets will now filter down by project level if applicable
-
Fixed Timesheet causing budget duplication.
Date applied: January 8, 2021
200.0.16
Issues Resolved Hot Fix EnhancementsIssues Resolved
- Fixed Actual value column not showing on Customer/Supplier transaction enquiry projects tab.
- Invoice Correction with nominal change should display correct ID tags in narratives.
- Invoice reversal with a negative line included should not throw a reconciliation error.
- On Print Sales order invoice, it will now validate that the order lines have a valid code before printing then posting. This will stop unassigned lines not matching with projects.
- Fixed sorting issue on maintain billing transactions for date and decimal columns
- Project analysis should display correctly on maintain billing transactions.
- Exporting from maintain billing transactions to excel should display all columns.
- Stopped duplicate budgets being created if activities only is enabled.
- Fixed ‘Cast’ error on nominal transaction enquiry when going through the account summary breakdown.
- POP Auto issue with serial items on GRN should now pop up a selection forms for serial numbers. Instead of ‘Null’ error.
Change in Functionality
- New methods added to project level factory to create and return project levels for a project.
Date applied: December 19, 2020
200.0.15
Issues Resolved ImportantImportant Info
- Update Companies required.
Issues Resolved
- When posting then adding another invoice without closing the form, fixed issue with line disappearing from the Projects tab after changing the reference.
- Fixed issue on correcting invoices but only changing the nominal code on a line.
- When adding a new budget this should then update the project summary on the job enquiry.
- Cost column removed from rapid stock issue as it was not used.
Date applied: December 4, 2020
200.0.14
Issues Resolved New FeaturesNew Features
- New Web API methods to integrate SOP/POP/NL Journals methods with projects.
Issues Resolved
- Fixed error on hired in plant when generating a purchase order for a line using service stock item. (Requires Common components update).
- Fixed error on converting quotations to sales orders when copying header project analysis.
Software dependancies: Requires Common components update
Date applied: November 20, 2020
200.0.13
Issues Resolved ImportantImportant Info
- Update companies required.
Issues Resolved
- Improved right click display of imported miscellaneous PL invoices.
- Project headers with WAP type ‘T’ and other types separated by comma will display as a labour type in budgets
- Generate billing transactions screen now has a separate filter for phase stage and activity. (Will also filter billing profiles)
- Routine for reconciling unassigned PL transactions now has filter popups for date range and project.
- Fixed more issues with exchange rate differences on POP invoices.
- Fixed issue with PL corrections if the project header and nominal are changed only.
- Fixed error on timesheet when looking for project rates but the line type is not ‘Project’
- Fixed reconciliation error on correcting transactions.
- Timesheet journals should not be loading timesheets with ‘N/A’ project and header
- New routine added to correct invoice nominals that have missing project transactions.
Date applied: October 20, 2020
200.0.12
Issues ResolvedIssues Resolved
- Excluded Messaging services on SOP/POP if integration is turned off.
- Phase/Stage lookup lists will expand if descriptions are bigger than the size of the control.
- Fixed zero tax resetting goods value on sales and purchase imports with projects.
- Exchange rate will now be applied on project transactions from rapid PL invoice.
- fixed auto issue not setting correctly on receipt transactions. and displaying on project enquiry.
- Fixed period filter on project enquiry.
Date applied: October 9, 2020
200.0.11
Issues Resolved Hot Fix EnhancementsIssues Resolved
- Nominals will not be allowed to be deleted if they are in use by a project header or on a project override.
- Nominals on project headers tab on a project can now be cleared.
- Fixed ‘Out of Memory’ exception on posting POP invoices with a large amount of lines and setting to update line costs with invoice value turned on.
- Validation added to POP invoices to make sure quantity on lines is entered.
- Fixed issue with missing project transactions when doing a PL invoice and correcting the supplier.
- Rapid PL invoice should post correctly to projects when authorisation turned off. Also record ID tag when authorisation turned on to be recognised in WAP.
- Fixed issue of nominal saved on one project header copying on other headers when selecting them in the list.
- Rate will not be allowed to be imported on completed projects
- Project rates list can now be sorted
- POP/SOP invoices can now be visible on maintain billing transactions screen.
- Fixed issue with default phases being created when creating project from template.
- Fixed issue with actual quantity displaying as negative on enquiry expenditure tab when auto issued but actuals on invoice.
- Stock Returns on Purchase orders with aut issue will now return at issued cost.
- Fixed issue with Project analysis not copying over to Sales order before viewing when converting from a quote.
Change in Functionality
- New Routine added to period end routines to generate payroll weeks for a selected year.
- Project analysis added to view POP screens.
Date applied: October 9, 2020