What's new in Sequoia?

IMPORTANT MESSAGE! Make sure you upgrade to this latest version of Sequoia within the next month to access all our new fixes and features

Sequoia v6 - NCTS Phase 5 Development

CDS live Export declarations (inventory linked and non-inventory linked locations) are supported from release 5.51 of Sequoia.

Please refer to Completing Export CDS Declarations for details.

Latest Version

Sequoia v6.6

Click here for upgrade instructions

Goal

On-going preparations for NCTS Phase 5

Release Notes

Item favourites, if configured, are now stored for CDS export declarations when the declaration is Permitted to progress. Please refer to this guide.
CDS Air export declarations Declaration Type (DE 1/1 and 1/2) now defaults to EXD for full declarations only.
CDS Air export declarations, which are linked with shipments, will have Previous Documents (DE 2/1) added on creation. These Previous Documents reference the shipment Air Waybill number(s).

Issues resolved

70002 - Clearance messages (DMSCLE) were not processing for declarations which were not linked to a job.
69759 - Import declaration report was not automatically generating for pre-lodged simplified declarations (Declaration Type = IMF) when declared using the full import declaration form.

Software detail

Release 6 - Sprint 6
Developed 18th - 29th March 2024
Published on 5th April 2024

Sequoia v6.5

Goal

Support for live CDS export declarations
On-going preparations for NCTS Phase 5

Release Notes

The DUCR on an export supplementary declaration now matches the DUCR of the linked frontier declaration (C21 or Simplified declaration, with Permitted to progress or Departed status).
The Customs Action task on a job is 'finalised' (the task has the green tick indicator) when an import declaration receives 'Cleared' status and when an export declaration is departed.
The associationResponse event is now published when a DUCR is successfully associated to a MUCR (or disassociated from a MUCR).
The mucrClosure event is now published when a MUCR is successfully closed.
For information, both of the above events stopped being published when Sequoia was switched to use HMRC's new export inventory linking API, supporting inventory linked CDS declarations.
Declarations are now prevented from being sent if an incomplete previous document is added (one of Type, Category or Reference fields are left blank).
The worksheetFinalised event is now published when a CDS worksheet has been finalised.

Issues resolved

68932 - Export declaration does not change state from 'Permitted to progress' if the acceptance (DMSACC) message is received after the P2P (DMSCLE) message.
69065 - P&R check now prompts the user if the commodity code is not found in the tariff.
69355 - P&R check includes fishery certificates.
69534 - Declaration Country no longer included in the declaration message for inventory linked import EIDR declarations.
69507 - The 'cdsDeclarationAcceptanceNotification' event will always include the declarationUcr element. The element will report "NoDeclarationUcrDeclared" if the declaration did not include a DCR previous document.
69288 - API: GetDeclarationState response shows the correct format for the lastNotificationReceived element.
69227 - ETSF External reference now visible in the CCS-UK Inventory list and searchable using Find CCS-UK Inventory.

Software detail

Release 6 - Sprint 5
Developed 4th - 15th March 2024
Published on 21st March 2024

Sequoia v6.4

Goal

Support for live CDS export declarations
On-going preparations for NCTS Phase 5

Release Notes

This version is recommended for export simplified procedure declarants and DEP users.
Export supplementary declaration CLE previous document automatically added from linked frontier declaration.
Re-transmission of the DEP arrival is now supported from the DEP task.
Improvements made to the Declaration Find data warehouse rebuild.

Issues resolved

69123 - Database modifications to improve CT Guarantee report data retrieval.
69060 - Issue resolved with DEP tasks not updating to Permission to Progress.
68861 - API: Value build-up "Apportioned By" now set correctly based on addition and deductions values.
68749 - Import declaration report is now automatically produced for IMC/IMF declarations.
68453 - Declaration reports now show monetary values to two decimal places.
63812 - Resolved issue with duplicate 'etsfInventoryStatus1Set' events being published.

Software detail

Release 6 - Sprint 4
Developed 19th February - 1st March 2024
Published on 11th March 2024

Sequoia v6.3

Goal

Support for live CDS export declarations
On-going preparations for NCTS Phase 5

Release Notes

Data element numbers can now be shown on the declaration editors instead of SAD box numbers. This is on a per user basis. Please see this guide on how to change between SAD box numbers or data element numbers.
ASM Online Services query response updated to show all movement details. Please refer to the ASM Online Services Export Consolidation guide for details.
CDS replacement for the Declaration Acceptance Exporter plugin.
GetDeclarationState API method added to get the current state of a declaration.
Sending Ocean Inventory Linked Exports now generates an error. This error can be bypassed by sending again, as Ocean Inventory Linked Exports are not yet enabled due to CSP readiness.

Issues resolved

68820 - Resolved issue with updating CDS Import declarations when an inventory record was linked to a saved declaration. Collection notes are now being saved to the job when the inventory is linked to the job. The job reference is now displaying in the agent inventory list.
68041 - CDS Export declarations populating with transport details from associated shipment.
68047 - Inv total [22] column in the declaration report generated from the Declaration Find function is now showing the invoice amount on the header of the CDS export declaration.
67555/67640 - Resolved issue with Declaration Find function.
68531 - "End of Temp Storage" field on the ETSF consignment editor populating with the correct end of temporary storage date(90 days from flight date) when creating or updating an ETSF consignment.
68633 - ETSF External reference now selectable as a column in ETSF list view and Agent Inventory list view.

Software detail

Release 6 - Sprint 3
Developed 5th February - 16th February 2024
Published on 23rd February 2024

Sequoia v6.2

Goal

Support for live CDS export declarations
On-going preparations for inventory linked CDS export declarations
On-going preparations for NCTS Phase 5

Release Notes

Data element numbers can now be shown on the declaration editors instead of SAD box numbers. This is on a per user basis.
Please see this guide on how to change between SAD box numbers or data element numbers.

Issues resolved

68620 - API: Numeric values were defaulting to zero when importing worksheets.
67555/67640 - Problems encountered with Declaration Find due to missing records.

Software detail

Release 6 - Sprint 2
Developed 8th January 2023 - 2nd February 2024
Published on 9th February 2024

Sequoia v5 - CDS Development

Sequoia v5.51

Goal

Support for live CDS export declarations
On-going preparations for inventory linked CDS export declarations
On-going preparations for NCTS Phase 5

Release Notes

NCTS - Unloading remarks can now be submitted to indicate the declared Seals are in an unsatisfactory state.

Issues resolved

68022 - VAT amounts were displaying incorrectly when PVA was used. This was a consequence of the fix applied for bug 66033 in Release 5.50.
The VAT amounts are now displaying correctly in the declaration find results and the job task. The VAT payable amount is being published correctly in the declaration acceptance notification events.

Software detail

Release 5 - Sprint 51
Developed 18th December 2023 - 5th January 2024
Published on 11th January 2024

Sequoia v5.50

Goal

Support for live CDS export declarations
On-going preparations for inventory linked CDS export declarations
On-going preparations for NCTS Phase 5

Release Notes

CFSP: Month end FSD declarations now always include the FINSL AI Statement for late supplementary declarations, even if there are none to report.
The CDS import declaration report is automatically produced when the declaration receives goods released status.
The CDS import declaration report can be automatically sent to your customer when the declaration receives goods released status. Please refer to the customer reports via email guide.
The CDS export declaration report is automatically produced when the declaration receives permitted to progress status.
The CDS export declaration report can be automatically sent to your customer when the declaration is permitted to progress. Please refer to the customer reports via email guide.
The declaration report for CDS declarations now correctly orders the report by declaration and then by item number.
CRM account notes now allow up to 70 characters for the subject line. The maximum number of characters supported for the body of the note has been increased to 1000.
API: The format of the automatically generated LRN for a CDS declaration now matches the format generated through the Sequoia client. The format includes the year, month and day rather than just the year and month, for example CDSLHR2312250000000066 as opposed to CDSLHR2312000000000066.

Issues resolved

66033 - Total VAT was not displaying correctly on the find declaration results when PVA was used.
66672 - Customs Warehousing removal report was displaying the wrong exchange rate.
67150 - Tax base quantity of zero, declared in an import worksheet, was not mapping to the item tax line.

Software detail

Release 5 - Sprint 50
Developed 27th November - 15th December 2023
Published on 28th December 2023

Sequoia v5.48

Goal

Support for live CDS export declarations
On-going preparations for inventory linked CDS export declarations
On-going preparations for NCTS Phase 5

Release Notes

The ability to convert a declaration party to a CRM account record has been added to CDS declaration editors. The "Add to CRM" button will be shown on all party controls when the data does not match an existing CRM account.
CDS Export worksheets now support mapping of the Country of Origin [34a]. The worksheet guidance has been updated.
A validation rule has been added to check Customs Office of Exit [29] has been set for all CDS export declarations. This rule prevents sending of a CDS export declaration if it has not been set.
Declaration amendment messages now build correctly if a document code is modified.
The CDS export declaration report is automatically produced when the declaration is departed.
The CDS export declaration report can be automatically sent to your customer when the declaration is departed. Please refer to the customer reports via email guide.
Corrected the spelling of Consignee on the CDS export declaration report.

Issues resolved

63722 - API: The CDS export declaration schema has been modified to restrict Goods Description to 280 characters. Comments have been added to the party schema to indicate the maximum length of the Consignee and Export names, together with the maximum length of the Consignee, Consignor and Exporter street address. Validation rules have been added to verify these maximum lengths are not exceeded. The party schema restriction cannot be changed as it is shared with import declarations.
65977 - Blank rows were not being ignored when importing worksheet data from a spreadsheet.
66495 - User's full name is now shown on the import and export declaration reports.

Software detail

Release 5 - Sprint 48
Developed 6th - 24th November 2023
Published on 30th November 2023

Sequoia v5.47

Goal

Support for live CDS export declarations
On-going preparations for inventory linked CDS export declarations
On-going preparations for NCTS Phase 5

Release Notes

Representative name and shortcode are now output as part of the Declaration Report.
The dialog for adding saved jobs to a shipment has been changed to use a search rather than automatically displaying all the available jobs in a list.
CDS export supplementary declarations allow the frontier DUCR to be declared. Duplicate DUCR rules were previously preventing this scenario.
The API event 'cdsDeclarationClearanceNotification' is now published for CDS export declarations on receipt of 'Permitted to Progress' status.

Issues resolved

62055 - Duty Method of Payment is now displayed in the Calculation of Taxes section of the import declaration report. This was an issue where the Method of Payment was declared on a separate Taxline to an excise duty declaration.
63762 - Fixed the item number control on CDS export declarations so that the correct item is displayed after tabbing.
65219 - The name of the user who sent the declaration is now always shown on the declaration report at the point of acceptance / clearance.

Software detail

Release 5 - Sprint 47
Developed 16th October - 3rd November 2023
Published on 15th November 2023

Sequoia v5.45

Goal

Support for live CDS export declarations
On-going preparations for inventory linked CDS export declarations
On-going preparations for NCTS Phase 5

Issues resolved

63454 - Gross weight in an ETSF record no longer adds a default decimal place if the value of the gross weight is 7 numerics in length.
63456 - Amendment messages are now building correctly when the Preference Code, Country of Preferential Origin or Country of Origin is changed or added.
64266 - NCTS item gross mass now being apportioned to 3 decimal places when export declaration does not have item level gross mass.
64889 - NCTS item gross mass is apportioned from net mass if the CHIEF or CDS declaration does not have item level gross mass declared.

Software detail

Release 5 - Sprint 45
Developed 25th September - 13th October 2023
Published on 17th October 2023

Sequoia v5.43

Goal

Support for live CDS export declarations
On-going preparations for inventory linked CDS export declarations
On-going preparations for NCTS Phase 5

Issues resolved

62077 - Declaration Find search no longer returning records as PVA when FR1 Additonal Fiscal Reference has been removed.
62158 - API request to cancel a CDS declaration now available from the WSDL.
62965 - Ensure the latest Standing Data is always downloaded after an upgrade.

Software detail

Release 5 - Sprint 43
Developed 28th August - 15th September 2023
Published on 22nd September 2023

Sequoia v5.42

Goal

Support for live CDS export declarations
On-going preparations for inventory linked CDS export declarations
On-going preparations for NCTS Phase 5

Release Notes

Consignor field re-added to CDS Export declaration editor and CDS Export declaration report. This is only needed on a C21E where an exit summary declaration is required (with use of Additional Procedure Code 17X and the Consignor is different from the Exporter).

Issues resolved

61760 - Uploading CDS export worksheet was throwing an exception error if the customer name had an apostrophe.

Software detail

Release 5 - Sprint 42
Developed 14th August - 1st September 2023
Published on 7th September 2023

Sequoia v5.41

Goal

Support for live CDS export declarations
On-going preparations for inventory linked CDS export declarations
On-going preparations for NCTS Phase 5

Release Notes

MRN now set on CDS declarations where the expected ‘acceptance’ messages have not been received from CDS but subsequent response messages indicate that an MRN has been allocated.
Status Event Writer now outputs CDS declaration notifications matching the API schemas (upgrade guide).

Issues resolved

61765 - Default declarant correctly populating when creating a declaration from a template.
61851 - Item level gross mass is mapped directly to the NCTS declaration regardless of whether the shipment gross mass differs.
62087 - Commodity codes starting 2204 and 2206 in the customs tariff no longer causing unrecoverable errors.

Software detail

Release 5 - Sprint 41
Developed 31st July - 18th August 2023
Published on 24th August 2023

Sequoia v5.40

Goal

Support for live CDS export declarations
On-going preparations for inventory linked CDS export declarations
On-going preparations for NCTS Phase 5

Release Notes

Export declarations can now be updated via the API.
Please refer to the API documentation for guidance.
Event published to the Sequoia API for cdsDeclarationAcceptanceNotification when a CDS export declaration is lodged or accepted.
Please refer to the API documentation for guidance.
Event published to the Sequoia API for cdsDeclarationArrivedNotification when a CDS export declaration is arrived.
Please refer to the API documentation for guidance.

Issues resolved

61423 - The etsfInventoryStatus1Set Schema now available for API users.

Software detail

Release 5 - Sprint 40
Developed 17th July - 4th August 2023
Published on 10th August 2023

Sequoia v5.39

Goal

Support for live CDS export declarations
On-going preparations for inventory linked CDS export declarations
On-going preparations for NCTS Phase 5

Release Notes

The declaration report has been updated to include any anti-dumping duty revenue in the "Item Other rev" column.

Issues resolved

60004 - Checkboxes on the Sequoia Installer application have been reduced in size to prevent accidental enabling or disabling of features.
60472 - API: The Taxline.xsd schema has been modified to allow the correct range of values for Tax Base Quantity.
This schema is jointly used for creating and updating CDS import declarations and creating CDS worksheets.
60410 - Improvement in the loading time of the list of jobs available for linking to a shipment.
60360 - Item level Consignee [08] is now mapped from a CDS export worksheet.
57382 - Linking a declaration to an air inventory record, with a newly added air carrier, no longer causes an error.
58064 - Deleting a declaration linked with a large worksheet no longer causes an error.
60025 - It is now possible to finalise a shipment where a linked job is associated with a CHIEF supplementary declaration (ESD).

Software detail

Release 5 - Sprint 39
Developed 19th June - 14th July 2023
Published on 24th July 2023

Sequoia v5.37

Goal

Support for live CDS export declarations
On-going preparations for NCTS Phase 5

Issues resolved

57036 - Method of Payment E no longer defaulting on Out of Warehouse declarations when no deferment is present.
58189 - API is now publishing the 'cdsDeclarationAcceptanceNotification', 'cdsDeclarationClearanceNotification' and 'cdsDeclarationArrivedNotification' events for Simplified pre-lodged declarations.
58390 - Customs Warehousing: The Invoice and Purchase Order numbers are now being mapped from the worksheet when creating stock items.
58588 - External job references no longer being duplicated when more than four were input.
59970 - NCTS declarations are now displaying the full Goods Description on receipt of the Goods Released for Transit notification.
60233 - ETSF: Status 1 is now updating correctly when arriving goods for large consolidations.

Software detail

Release 5 - Sprint 37
Developed 5th June - 19th June 2023
Published on 29th June 2023

Sequoia v5.36

Goal

Support for live CDS export declarations
On-going preparations for NCTS Phase 5

Release Notes

Border Transport Country [21] (DE 7/15) is defaulted from the nationality of the air carrier when the declaration is linked to a CCS-UK inventory record.
The 'parent' record (job, shipment, etc) can now be opened from the records in the outstanding accruals and outstanding sales lists.

Issues resolved

57790 - CDS declaration reports for TDR declarations are no longer handled by the CRM email report service.
58109 - Export commodity codes no longer indicate supplementary units are required when import only supplementary units apply.
58115 - Fixed problem where users upgrading from pre-5.30 version could have their CRM email reports configuration removed on upgrade.

Software detail

Release 5 - Sprint 36
Developed 8th May- 2nd June 2023
Published on 16th June 2023

Sequoia v5.34

Goal

Support for live CDS export declarations
On-going preparations for NCTS Phase 5

Release Notes

Live non-inventory linked [NIVL] CDS export declarations are now supported in Sequoia. These are declarations for goods which would normally be departed via a Ro-Ro port using the GVMS system.
Access to this functionality is being controlled in co-ordination with HMRC and the functionality is not automatically enabled when you upgrade.
There are restrictions imposed by HMRC as some functionality is not yet supported on the CDS platform.
Click this link for more information about the restrictions and how to enable non-inventory linked CDS export declarations.
The data from live CDS export declarations will be mapped to an NCTS declaration when the associated shipment is linked to the NCTS movement. The data mapped is the same type of data mapped from CHIEF export declarations (commodity code, gross mass, net mass, packages, etc). Both CHIEF and CDS export declarations can be linked on the same NCTS movement via the same or separate shipment records.
A "Create Live CDS Export Declaration" privilege has been added to all export security roles. The privilege is enabled by default but can be disabled if you want to prevent users in certain roles from creating live CDS export declarations.
Country of Origin [34a] now included on the export declaration report.
Character restriction modifications for CDS export declarations to align with HMRC technical specifications.
Item favourite column width and order retained on a per user basis.

Known Issues

In certain circumstances Sequoia is indicating, in error, that supplementary units are required for some commodity codes for CHIEF export declarations. This will be fixed in the next release but in the meantime, the warning can simply be ignored. You should only include supplementary units for CHIEF export declarations if required by the HMRC Tariff.

Issues resolved

58055 - Commodity codes which do not require supplementary units throwing exception error for CHIEF export declarations.
56226 - Valuation Indicators (DE 4/13) now greyed out for declaration category H2.
56260 - CDS declaration report realigned to correct layout infringements.
56534 - AI statement now pulling through to out of warehouse declarations when configured on CRM.

Software detail

Release 5 - Sprint 34
Developed 24th April - 5th May 2023
Published on 22nd May 2023

Sequoia v5.33

CDS live Export declarations (non-inventory linked) are supported from release 5.33 of Sequoia

Goal

Support for live CDS export declarations
On-going preparations for NCTS Phase 5

Release Notes

Live non-inventory linked [NIVL] CDS export declarations are now supported in Sequoia. These are declarations for goods which would normally be departed via a Ro-Ro port using the GVMS system.
Access to this functionality is being controlled in co-ordination with HMRC and the functionality is not automatically enabled when you upgrade.
There are restrictions imposed by HMRC as some functionality is not yet supported on the CDS platform.
Click this link for more information about the restrictions and how to enable non-inventory linked CDS export declarations.
The data from live CDS export declarations will be mapped to an NCTS declaration when the associated shipment is linked to the NCTS movement. The data mapped is the same type of data mapped from CHIEF export declarations (commodity code, gross mass, net mass, packages, etc). Both CHIEF and CDS export declarations can be linked on the same NCTS movement via the same or separate shipment records.
A "Create Live CDS Export Declaration" privilege has been added to all export security roles. The privilege is enabled by default but can be disabled if you want to prevent users in certain roles from creating live CDS export declarations.
The declaration report, accessed from the Declaration Find results grid, includes CDS export declaration data.
Please refer to the Declaration Reporting guide.
The number of declaration items is now available for inclusion in the Declaration Find results. To add the 'Number of Items' column, please refer to this guide to adding or removing columns.
Please note, the number of items will be shown for declarations created after upgrading to this release. If you would like to see the number of items for previously created declarations, the search data will need to be rebuilt - please refer to this guide.
The External Reference displayed against an ETSF inventory record will be included on the Release Note report in the remarks section.

Issues resolved

55941 - Duty unpaid stock was not being prioritised when removing stock from the Customs Warehouse to an export procedure.
56983 - Supplementary units were not being set when a worksheet was imported into a CDS export declaration.
56838 - Incorrect duty/VAT amounts were being displayed in Customs Warehousing removal report if the removal currency was different to the out of warehouse declaration currency.

Software detail

Release 5 - Sprint 33
Developed 10th - 21st April 2023
Published on 15th May 2023

Sequoia v5.32

Goal

On-going preparations for live CDS export declarations
On-going preparations for NCTS Phase 5

Release Notes

Duplicate UCN numbers no longer prevent Ocean or Road import jobs from being created. The user is prompted to confirm they wish to proceed and the job reference(s) where the UCN has been used before are displayed within the prompt.
The Job find function includes the ability to search by vehicle registration and also by trailer number.
Exporter [02] and Quota [39] added to the CDS Import Simplified declaration at item level, in line with the CDS tariff guidance.
CreateCdsImportSimplifiedDeclaration and UpdateCdsImportSimplifiedDeclaration API methods have been extended to allow Exporter [02] and Quota [39] to be declared at item level.
Customs Warehousing: Multiple Offline Import declarations (OLI) for CDS declarations can be created for the same MRN, as long as the goods are being moved into warehouse (Procedure code starting '71'). This reflects the original behaviour for OLI CHIEF declarations.
Consignment Status on the shipment editors include the status of CDS declarations.

Issues resolved

53421 - API calls were receiving errors when creating records where duplicate CRM accounts were found.
52596 - API Impersonation Context was not being respected when creating jobs.
53460 - API was not setting the correct customer details when creating a job if there were multiple accounts with matching EORIs.
55625 - Fixed an issue with the database where Sequoia was failing to display a large amount of declarations in the FSD calculation editor.

Software detail

Release 5 - Sprint 32
Developed 13th March - 7th April 2023
Published on 26th April 2023

Sequoia v5.30

Goal

On-going preparations for live CDS export declarations
Support for Microsoft Azure email services using OAuth authentication

Release Notes

Customs Warehousing: The stock record is only created when the declaration is in an arrived state. Previously the stock record was being created when a pre-arrival declaration was lodged.
CDS export declaration report is automatically generated when a pre-arrival is lodged, and again when the declaration is arrived (has permission to progress).
Sequoia supports Microsoft Azure OAuth authentication for email services.
The CRM - Automatic Customer Reports via Email guide has been updated. In addition a new Email Configuration guide has been added with details on how to set this up in Sequoia.

Issues resolved

53020 - CT Guarantee Report not consistently showing the duty/VAT amounts.
53622 - Duty paid stock was not being prioritised when removing stock from the Customs Warehouse.
53825 - SequoiaDB backup was unsuccessful during the upgrade process.

Software detail

Release 5 - Sprint 30
Developed 27th February - 10th March 2023
Published on 30th March 2023

Sequoia v5.29

Goal

Compatibility with Microsoft SQL Server 2022
Enhance data mapping for CDS declarations
Preparations for live CDS export declarations

Release Notes

Sequoia is now compatible with Microsoft SQL Server 2022.
Shipment level data, such as bill of lading numbers and containers, is now mapped when the CDS declaration is created. This applies to both ocean and road shipments.
The Shipment type and mode is used to determine the Arrival, Departure and/or Border Transport Type when creating the CDS declaration.
The Shipment vessel or vehicle registration is now mapped to the Arrival, Departure and/or Border Transport ID when creating the CDS declaration.
The handling of DEFRA notifications (DMSALV) has been re-worked to use the code within the notification to determine the declaration status.
Representation Status is now defaulted from the Importer CRM account rather than the default Declarant.
Deleting the deferment number from a declaration now automatically removes the associated DPO Authorisation Holder and C506 document.
Deleting the guarantee record from a declaration now automatically removes the associated CGU Authorisation Holder and C505 document.
The Consignor fields have been removed from CDS export declarations at header and item level, as they are no longer supported by HMRC. The API schema has been updated to indicate the elements are obsolete. The Consignor fields included in worksheet rows are also ignored.
The P&R Check button now works for CDS export declarations.

Issues resolved

52601 - EDCS gateway now supports Azure Active Directory authentication. Please refer to this guide to re-configure your EDCS gateway.
52828 - Issue interpreting tariff data so certain commodity codes where indicating supplementary units were required.
52598 - The item number control now selects the requested declaration item when you enter the item number and press tab.
52577 - Inland Transport Mode [26] was not mapping to the correct element in the declaration XML for CDS export declarations.
50518 - Ungrouped Worksheet lines were not mapping to the declaration items in order.
52861 - Additional Fiscal Reference for PVA was being removed if the Declarant was added to the declaration after the Importer.
53401 - Global search was not finding declarations where a hyphen was included in Trader Reference.

Software detail

Release 5 - Sprint 29
Developed 6th - 24th February 2023
Published on 9th March 2023

Sequoia v5.27

Goal

Documents and AI Statements can be imported from CRM into a declaration
Customs Warehousing allows mixed currency stock
General CDS enhancements
Preparations for live CDS export declarations

Release Notes

"Add from CRM" buttons have been added to the CDS declaration editor AI Statement and Documents, Certificates grids.
Please refer to this guide for information.
Any AI Statements, Documents or Deferment details associated to a declarant's CRM account are now removed from the declaration if the declarant is changed or removed.
User is now alerted when sending a non-inventory linked frontier declaration.
The import declaration report is now generated on acceptance and clearance of any into warehouse declaration.
The lack of tax notification response to these types of declarations was previously preventing the report from being generated.
Changes made to prevent deferment information being automatically added to simplified declarations.
Customs Warehousing: Stock records now support stock items with different currencies.
Customs Warehousing: The correct authorisation document (C517, C518 or C519) is automatically added, based on the configured warehouse type, when declaring goods into warehouse.
Customs Warehousing: The processing of SDF files has now been improved.
CFSP/SCDP: Supplementary declarations created from a job will have their DUCR set to match the frontier declaration.
This overrides the setting in CRM which could have defaulted the DUCR to reference the Importer or Declarant EORI.

Issues resolved

52082 - Customs Warehousing duty and VAT liability calculations were not working if commodity had multiple standard duty rates.
52076 - Copied declarations re-ordering the original declaration items order.
52560 - Declaration report for an amended pre-lodged declaration was failing when re-printed.
52835 - Unable to view messages if a notification had failed to process.
52189 - Clearance notification was failing to process correctly if it was received before the final tax notification.

Software detail

Release 5 - Sprint 27
Developed 16th January - 3rd February 2023
Published on 13th February 2023

Sequoia v5.26

Goal

Revised export packages mapping for NCTS declarations
Extend API to support CDS declarations
General CDS enhancements
Preparations for live CDS export declarations

Release Notes

The 'Marks' from an export declaration Packages and Marks are now mapped to the appropriate NCTS declaration item. Previously the marks from the first item of the export declaration were mapped to every item of the NCTS declaration where the package kind was the same.
The correct Tax Point date is now used to determine the reporting of IMZ declarations in the Final Supplementary Declaration.
APIs added to update / amend an existing CDS import declaration.
Please refer to the API documentation for guidance.
API added to cancel an accepted CDS declaration.
Please refer to the API documentation for guidance.
Updated the export declaration editors to remove the Declaration Categories drop-down as this is redundant.
Available Decln Type [01] values for export declarations are now displayed in accordance with the chosen export declaration editor.

Issues resolved

52290 - Issues building out of warehouse declarations for stock removals generated prior to upgrading to the CDS release of Customs Warehousing (5.23).
52461 - Issues found with database locking when building out of warehouse declarations in certain circumstances.
52472 - Customs Warehousing removal state could not be reset from the Stock Removal Exceptions list.
49810 - Issue with setting status 1 on an ETSF inventory not consistently updating the CCS-UK inventory.
50821 - API: Delivery Terms Location schema did not allow spaces.
50754 - Issue encountered creating a declaration from a template when the job had no consignor, consignee or description set.
52388 - Invoice Currency should have been set when Currency is included in worksheet data.
51017 - Issue with matching the correct CRM record when populating declaration parties.

Software detail

Release 5 - Sprint 26
Developed 3rd - 13th January 2023
Published on 30th January 2023

Sequoia v5.25

Goal

Add Item Favourites for CDS declarations
Enable TDR (test) export declarations
General CDS enhancements
Enhance the potential duty calculation for NCTS guarantees

Release Notes

Item favourites functionality has been added for CDS declarations.
This works in the same way as it does for CHIEF declarations, however additional fields have been added (Country of Preferential Origin, for example).
Please refer to this guide.
TDR (test) export declarations can now be sent.
Live export declaration functionality, including the declaration report, is still being developed and will be available in a future release of Sequoia.
The signature block of the import declaration report now includes the name of the user who last modified or sent the declaration.
Item summary grid now includes net and gross mass and their totals. The grid also includes the total of the item prices.
Header level origin (DE 5/14) and destination (DE 5/8) countries are now derived from the associated job origin and destination port locations.
Freight charges, and Air Transport Costs where applicable, are now mapped from the job to the declaration.
Import declaration report is now generated when a pre-arrival declaration is lodged.
Enhanced various plugins to provide the CDS Import Declaration report for pre-arrival declarations (optional upgrade guide).
Import declaration report is now generated on acceptance of a simplified declaration.
The lack of tax notification response to these types of declarations was previously preventing the report from being generated.
The 'cdsDeclarationAcceptanceNotification' event is now published on acceptance of simplified declarations or any into-warehouse declarations.
The 'cdsDeclarationClearanceNotification' event is now published on customs clearance of simplified declarations or any into-warehouse declarations.
A Total Net Mass field has been added to the full and supplementary declaration editors at header level.
Completing this field, together with the existing Total Gross Mass [35] field, will allow the item level Net and Gross Mass to be apportioned based on the ratio of the item price against the header level invoice amount.
Please note, the Total Net Mass value is not included in the declaration data sent to HMRC as it is not supported by the CDS system.
Transport Type and ID will be set if the worksheet used to build the declaration has a Transport Identity value. The Transport Type will be derived from the associated job.
The CHIEF import declaration options have been collapsed within the New Customs Declaration dialog to allow a greater focus on the CDS declaration types.
NCTS - The guarantee editor has been modified to ensure potential duty is calculated using the highest duty rate for a given commodity.
This change also ensures potential duty will still be calculated if a commodity has more than one 'Standard Duty Rate'.

Issues resolved

52175 - Issues with stock removals generating ex-warehouse declarations with duplicate DUCR / part number combinations.
52178 - Ex-warehouse declarations being created with stock removal customer not mapping to the Importer [08].
52180 - Customs Warehousing Duty/VAT Liability Reporting timing out.
51073 - Issue with C505 / C506 documents not automatically populating when a declaration was added to a job.
51575 - Badge selection control was not responding to key strokes.
51515 - Exhange rate shown on supplementary declaration report was incorrect if the frontier declaration was accepted in the previous month.
50669 - Date of Entry was not being set on acceptance of arrived declarations causing discrepancies in search results.
51567 - Country of Preferential Origin was not being mapped from a worksheet when creating Customs Warehousing stock items.
51684 - Accepted IMZ declarations were not showing as 'Due and Accepted' in the CFSP Final Supplementary Declaration calculation dialog.
50751 - Declaration status was incorrect if a rejection to a cancellation request was received.
50871 - Tax amounts were not aligning on the import declaration report if the tax description was too long.
50655 - Goods Location and flight details were not being set when a created declaration was added to an inventory-linked job.
52049 - Issue encountered creating a declaration from a template when the job had consignor or consignee already set.

Software detail

Release 5 - Sprint 25
Developed 5th December - 3rd January 2023
Published on 13th January 2023

Sequoia v5.23

Goal

Support CDS out of warehouse declarations in the Customs Warehousing module.

Release Notes

The Customs Warehousing module now allows out of warehouse import declarations to be declared to CDS.
The Warehouse Premises configuration has been extended to include the CDS Warehouse Authorisation number, Operator's EORI and EIR Authorisations, if appropriate.
A ‘Declare Removals to CDS’ checkbox has been added, enabling this will generate out of warehouse declarations to CDS.
Please refer to this guide.
Warehouse Premises standing data editor has been extended to include a lookup to the Supervising Office (this will be required for all into and out of warehouse declarations). This replaces the old SPOFF drop-down used for CHIEF declarations.
The editor can be accessed from Data -> Warehouse Premises from within the Sequoia client application.

Issues resolved

51361 - COY and COZ declaration types were not being reported for CFSP purposes.
51071 - Documents deleted from one item were still being included when that item was copied to a new item.
50649 - Job Consignor details were being copied to an EIDR declaration when not applicable to that declaration type.

Software detail

Release 5 - Sprint 23
Developed 14th November - 2nd December 2022
Published on 12th December 2022

Sequoia v5.22

Goal

Preparations for Customs Warehousing to support CDS declarations

Issues resolved

50715 - Revenue amounts showing incorrectly when pre-arrived declaration are subsequently arrived the following month.
50394 - Supplementary units incorrectly mapped from worksheet data.
50436 - NCTS find results showing incorrect guarantee reference.
50444 - Declaration category drop-down was being reset when Decln Type [01] was set.
50682 - Zero value declared in Taxline Tax Base Quantity was not being included in the declaration message.
50731 - New templates were not being displayed in the template list without reloading Sequoia.
50807 - Delivery Terms were being removed from a declaration after importing worksheet data.

Software detail

Release 5 - Sprint 22
Developed 31st October - 11th November 2022
Published on 29th November 2022

Sequoia v5.21

Goal

Preparations for Customs Warehousing to support CDS declarations

Issues resolved

50516 - Fiscal reference for Postponed VAT Accounting (PVA) was not updating when importer was changed in declaration.
50055 - CDS declaration defaults were not showing correct information in certain circumstances.
50770 - Unable to save changes when creating duty paid Customs Warehousing stock record.
50846 - Failing to send CDS declaration linked to agent inventory record in certain circumstances.
50833 - Customs Warehousing stock removals stuck in processing.

Software detail

Release 5 - Sprint 21
Developed 17th October - 28th October 2022
Published on 18th November 2022

Sequoia v5.20

Goal

Worksheet reporting
Preparations for Customs Warehousing to support CDS declarations

Release Notes

A worksheet report can now be generated from the worksheet editor.
Security enhancements for communications between the Sequoia Server and the ASM update server.
Ability to output the worksheet report on acceptance of CDS import declaration where a worksheet has been used. (optional upgrade guide).

Issues resolved

49886 - Shortcode used in the API payload for one of the CDS declaration parties was not populating the declaration data with the account EORI and address details.
49819 - Badge code drop-down control on the declaration editor has been extended in length.
49829 - Reason field in the Documents, Certificates control in CRM was not accepting special characters.
49809 - Rate of exchange was not showing on the import declaration report for pre-lodged declarations.
49912 - Quantity value of zero in Documents, Certificates grid in the declaration was not being displayed (although the value was being sent in the declaration message).
50447 - CDS Import Declaration report failing to automatically print on clearance.
50760 - Unable to save Stock Record on Customs Warehousing.

Software detail

Release 5 - Sprint 20
Developed 26th September - 14th October 2022
Published on 28th October 2022

Sequoia v5.18

Goal

Add an item level declaration report for CDS declarations
Change of DUCR declaration for supplementary declarations
Preparations for Customs Warehousing to support CDS declarations

Release Notes

A declaration report is now available for CDS declarations. The report is available by right-clicking the 'Find Declaration' results list and choosing 'Declaration Report'.
Please refer to the Declaration Reporting guide for more information.
The DUCR for a supplementary declaration is now declared as a Y - DCR header level Previous Document.
This was previously, incorrectly, defaulting with a Previous Document Category of Z.
Preparatory work has begun to support CDS declarations within the Customs Warehousing module:
The module will now create stock records on acceptance of both CHIEF and CDS 'into warehouse' declarations.
The declaration panel of the stock record has been modified to show data more in line with CDS declarations.
Stock items should continue to be created from the original, CHIEF-style worksheets.
All automatically generated 'ex-warehouse' declarations will continue to be CHIEF declarations.

Issues resolved

49827 - Missing tax information from import declaration report.
49299 - Able to exceed the maximum number of supported declaration items (currently 99).
49309 - Declaration could be created with a duplicate LRN.
49694 - Unable to create a supplementary declaration on same job as an inventory linked declaration.
49301 - Unable to create a C21 EIDR declaration if the user was not in an Air Import role.
49196 - Saved templates not always appearing in the template list.

Software detail

Release 5 - Sprint 18
Developed 6th - 23rd September 2022
Published on 10th October 2022

Sequoia v5.16

Goal

Allow CDS declaration report to be automatically emailed to customers.
Removal of C21 form.

Release Notes

CDS import declaration report can now be emailed direct to customers. The report can be configured to be emailed on initial acceptance and/or at the point of clearance. Please refer to the Automatic Customer Reports via Email guide.
C21 Import clearance request declarations must now be submitted using the full declaration editor. On selecting 'C21I - Clearance Request' from the declaration category menu, or choosing the CO/IM 'J' or 'K' declaration types, the controls which are not applicable to the declaration will be greyed out. Re-loading any previously created C21 declarations will be opened in the full declaration editor.
The API to create a C21 declaration (CreateCdsImportClearanceRequestDeclaration) has been extended to include missing optional elements. Please refer to the updated CdsImportClearanceRequestDeclaration.xsd schema published to the Api\Schemas\Cds folder.
The cdsDeclarationCleanceNotification event, published via the API and Status Event Writer, has been modified to include the latest duty and tax information. Please refer to the updated CdsDeclarationClearanceNotification.xsd schema published to the Api\Schemas\Cds folder.
CHIEF import declarations now allow any 4 alpha numeric characters to be declared in the Commodity Additional Code fields.
The CHIEF CFSP supplementary declaration response report (the CFSP E2 replacement) can now be emailed direct to customers. Please refer to the Automatic Customer Reports via Email guide.
Enhanced various plugins to provide the CDS Import Declaration report (optional upgrade guide).

Issues resolved

49632 - Changes made to a new item were being copied back to the original, copied, item.
48843 - Modified by names were not always being populated in the find declaration results list.
49623 - CDS gateway unable to automatically re-connect after an outage.
49012 - Entry date/time was not included in the cdsDeclarationAcceptanceNotification event for pre-arrival declarations.
49378 - TDR declarations were being included in the CFSP final supplementary declaration calculation list.
49212 - Job could be deleted if linked with an inventory record and/or CDS declaration.
49190 - SDE Authorisation Holder was being automatically populated for IMZ declarations.
48799 - Representative name removed from NCTS declaration after goods released for transit.
49498 - Unable to connect Sequoia to Helios when using a proxy server.
49291 - Error 800012 encountered when creating a Job Costing batch transfer.

Software detail

Release 5 - Sprint 16
Developed 16th August - 2nd September 2022
Published on 15th September 2022

Sequoia v5.15

Goal

Arrival of non-inventory linked CDS declarations
CDS Copy item function

Release Notes

Non-inventory linked CDS declarations can now be arrived from the job task or from within the declaration. Please refer to this guide.
An ArriveDeclaration API has been added. Please refer to the API documentation for guidance.
A new event, 'cdsDeclarationArrivedNotification', is now published on receipt of arrival notifications. In addition there is a specific event published for TDR declarations ('cdsTestDeclarationArrivedNotification'). These events are received through the Sequoia API and Status Event Writer plug-in. Details are available in the API documentation.
The ability to copy an existing declaration item has been added to the CDS declaration editor. A Copy Item button has been added to the item toolbar. Click the button to automatically copy all of the existing item's details to create a new item.
The APIs to create CDS declarations have been modified to allow both country of origin and country of preferential origin to be declared (previously this was a choice within the schema). The existing item level origin element has been marked as obsolete.

Issues resolved

48407 - CDS worksheet was not populating the currency and invoice total at header level
48798 - API schema definition for Authorisation Holder element was incorrect and did not allow 'CW1' as a type
48193 - NCTS declaration failed to send if UN Dangerous Goods code was added and subsequently removed from the declaration
49098 - API config file had EnableTransactionLogging set to True resulting in database size limits being reached. This is now set to False by default.

Software detail

Release 5 - Sprint 15
Developed 25th July - 23rd August 2022
Published on 24th August 2022

Sequoia v5.13

Goal

Enhanced CFSP module supports CDS declarations.

Release Notes

The enhanced CFSP module has been extended to add support for CDS declarations.
The CFSP user guide has been updated to include specific information about the CDS implementation and the differences compared with CHIEF.

Software detail

Release 5 - Sprint 13
Developed 27th June - 22nd July 2022
Published on 1st August 2022

Sequoia v5.12

Goal

Enhancements to CDS declarations functionality.

Release Notes

A new event, 'cdsDeclarationErrorNotification', is now published on receipt of rejection notifications. In addition there is a specific event published for TDR declarations ('cdsTestDeclarationErrorNotification'). These events are received through the Sequoia API and Status Event Writer plug-in. Details are available in the API documentation.

Issues resolved

46681 - It is now possible to schedule a daily shutdown time for the Customs Tariff Service to reduce long-term memory usage

Software detail

Release 5 - Sprint 12
Developed 13th June - 1st July 2022
Published on 6th July 2022

Sequoia v5.11

Goal

Enhancements to CDS declarations functionality.

Release Notes

Amended wording to Valuation Indicators [45] to match tariff.
Declaration report modified to show tax assessed and payment amount totals.

Issues resolved

46925 - CDS Import declaration report no longer showing wrong method of payment.
47369 - ISW worksheet for Customs Warehousing was not populating "Produced Documents [44]" field on the stock detail.
47592 - Communication error when creating a TDR declaration using an imported worksheet with values not supported by the schema.

Software detail

Release 5 - Sprint 11
Developed 30th May - 10th June 2022
Published on 21st June 2022

Sequoia v5.10

Goal

Allow files to be uploaded direct to HMRC for CDS declarations.
Events published on acceptance and clearance of CDS declarations.

Release Notes

Files can now be uploaded to your Government Gateway account in support of CDS declarations. A guide to this functionality can be found in the Declarations (CDS) user guides section of the resource centre.
New events, 'cdsDeclarationAcceptanceNotification' and 'cdsDeclarationClearanceNotification', are now published on receipt of acceptance and clearance notifications respectively. In addition there are specific events published for TDR declarations ('cdsTestDeclarationAcceptanceNotification' and 'cdsTestDeclarationClearanceNotification'). These events are received through the Sequoia API and Status Event Writer plug-in. Details are available in the API documentation.
The description of any security types included in the declaration (IPR, for example) will now be shown in both the revenue details and the declaration report.
The preference code included in the tax notification is now shown on the revenue details form. A guide to how to access the revenue details can be found in the resource centre.
The lookup for Country of Preferential Origin [34b] (DE 5/16) now includes the option to search for both countries and country groups.
The tab order of the CDS declaration item page has been modified to improve logical flow.
The existing declarationAcceptanceNotification API event (for CHIEF declarations) has been extended to include the Total Packages [06] declared. Please note, the Status Event Writer plug-in will need to be upgraded to receive this extra data.

Issues resolved

47639 - Buyer/Seller details were not being imported from CDS worksheets.
47413 - Declaration was failing when item level Additions and Deductions [45] (DE 4/9) were declared. Please note, this was fixed within our messaging platform without the need to upgrade Sequoia.

Software detail

Release 5 - Sprint 10
Developed 16th - 27th May 2022
Published on 9th June 2022

Sequoia v5.9

Goal

CDS declaration enhancements.
Bug fixes.

Release Notes

Modifications to CDS API declaration schemas:
- Trader Reference now allows hyphens.
- Border and Inland Transport Modes now restricted to a single numeric character.
The CDS import declaration report is now automatically re-generated on acceptance of an amended declaration.
CDS declarations are prevented from being amended if their status is 'Goods Released'.
A column for the ETSF external reference has been added to the house air waybill grid.

Issues resolved

47131 - Spaces included in the MUCR (Z-MCR Previous Document reference) were causing UCN validation failures.
47074 - Find Job search results were timing out.

Software detail

Release 5 - Sprint 9
Developed 4th - 13th May 2022
Published on 17th May 2022

Sequoia v5.8

Goal

Bug fixes.

Release Notes

Pentant gateway enabled for CDS declarations.

Issues resolved

46524 - Toolbar containing the TDR Test Declarations section going missing.
46779 - Not able to view simplified TDR declarations in declaration find.

Software detail

Release 5 - Sprint 8
Developed 19th April - 29th April 2022
Published on 5th May 2022

Sequoia v5.7

Goal

CDS declaration amendments.
Modifications to the NCTS and CHIEF export item summary grids.

Release Notes

Accepted CDS declarations (arrived and pre-lodged) can now be amended. In line with CHIEF, any declaration which has received clearance, or is in the process of being cancelled, cannot be amended.

Please note, once your amendment has been accepted, you should manually re-generate the import declaration report (open the Reports dialog and click New Report).

A forthcoming release of Sequoia will automatically re-generate the report for you.
Revenue details for CDS declarations indicate whether postponed VAT accounting procedures (PVA) have been used.
The import declaration report for CDS declarations has been modified to indicate whether PVA has been used.
CDS declarations where PVA has been used are now searchable through the Declaration Find functionality.
CDS import simplified declarations now support arrival transport type and identity (DE 7/9) and border transport mode (DE 7/4). The corresponding API schema for the CreateCdsImportSimplifiedDeclaration request has also been extended to included these elements.
NCTS item summary grid now includes a column for Net Mass.
CHIEF export declaration item summary grid now includes a column for Gross Mass.

Issues resolved

46521 - Space characters in the Additional Fiscal Reference Role field were preventing the declaration from being submitted.
46852 - Incorrect tax information was being output in the declarationArrivedNotified event payload.

Software detail

Release 5 - Sprint 7
Developed 4th April - 22nd April 2022
Published on 26th April 2022

Sequoia v5.6

Goal

General enhancements and bug fixes
To reduce the impact of the auto query of CHIEF for declaration clearance.

Release Notes

Issues resolved

46413 - NCTS declarations linked to ECRs were causing unrecoverable errors.
46633 - Profit and Loss report showing incorrect values.

Software detail

Release 5 - Sprint 6
Developed 18th March - 1st April 2022
Published on 11th April 2022

Sequoia v5.5

Goal

General enhancements and bug fixes

Release Notes

NCTS errors dialog now displaying a meaningful error message if a declaration or arrival has failed to transmit.

Issues resolved

46217 - ISD declarations converted from EIDR declarations were not generating CUSDEC status query messages to establish the clearance date.
46227 - NCTS 060 messages not being processed in the correct order.
46324 - API "Get Customs Report Declaration" now returning latest version of the report.

Software detail

Release 5 - Sprint 5
Developed 7th March - 18th March 2022
Published on 23rd March 2022

Sequoia v5.4

Goal

General enhancements

Release Notes

The Sequoia Archiving application now supports CDS declarations. The archiving application will need to be upgraded separately to support this; it can be upgraded independently of the main Sequoia upgrade.

A guide to upgrading the Sequoia Archiving application can be found here. Please note, neither test (TDR) declarations nor declarations in a state of Cancelled will be archived.

CDS Development

The import declaration report was being generated twice in error, once on acceptance and again at the point of clearance. The report is generated at the point of acceptance.

Issues resolved

46021 - The containerised value on an NCTS declaration was always being set to true on receipt of Goods Released from Transit.
46024 - Validation warning when finalising an export road shipment was not clear.
45996 - Incorrect web address being displayed in the installer if the server is unable to contact http://sequoiaupdates.asm.org.uk.
45994 - NCTS arrival transmission failing if en-route events were declared.
46225 - Profit and Loss report was timing out retrieving the results.

Software detail

Release 5 - Sprint 4
Developed 21st February - 4th March 2022
Published on 16th March 2022

Sequoia v5.3

Goal

General enhancements

Release Notes

A new event, 'DeclarationArrivedNotification', is now published on receipt of an import E2 or export X2 report. This event is received through the Sequoia API and Status Event Writer interface. Details are available in the API documentation.
The declaration report now exports to an .xlsx file to support more than 64,000 rows of data.

CDS Development

Test (TDR) declarations can now be created from templates (this is from within the New Test Declaration dialog).

Issues resolved

45577 - Declaration report was failing when exporting more than 64,000 rows of data.
45652 - C130 report was failing if no commodity code had been declared.
45748 - File document store plug-in metadata file could display the incorrect entry EPU.
46081 - Warnings being logged when linking a job and declaration through the API.

Software detail

Release 5 - Sprint 3
Developed 7th - 18th February 2022
Published on 2nd March 2022

Sequoia v5.2

Goal

General enhancements

Release Notes

NCTS declarations / arrivals will now show details in the errors dialog if there is a failure in transmitting the data.
Office 365 SMTP server now supported for automatic emailing of reports.
Email signature block used for automatic emailing of reports now supports rich text.

CDS Development

Accepted declarations can now be cancelled regardless of their status - except for declarations which have been customs cleared. Any cleared declarations which require cancellation cannot be actioned electronically and would need HMRC intervention.
Import declaration report will now be printed by default on declaration acceptance.
The DMSRCV notification received as an acknowledgement to a cancellation request no longer changes the status of the declaration.

Issues resolved

45361 - CUSDEC message used to update import declaration clearance status could be processed multiple times if the original acceptance message was missing.
45507 - Item level gross mass for NCTS declarations could be calculated with incorrect number of decimal places.
45757 - Fixed mapping of Conveyance Reference in an NCTS declaration.
45699 - Item level gross mass declared on an export declaration is now mapped directly to the NCTS declaration item.

Software detail

Release 5 - Sprint 2
Developed 24th January 2022 - 4th February 2022
Published on 17th February 2022

Sequoia v5.1

Goal

Extend CDS declaration functionality
Enhance Pentant gateway connectivity

Release Notes

Template description now visible in the Templates list for both CHIEF and CDS.
SMTP server settings modified to allow the Domain to be set for automatic emailing of reports.
Pentant gateway settings now allow for connection via FTPS. Previous versions of Sequoia will be unable to communicate with Pentant from 1st March 2022 as they do not support the new connection protocol. The Pentant gateway should seamlessly connect to the FTPS service after upgrading but if you are having problems sending declarations, please click here for a guide to the gateway configuration.

CDS Development

Functionality has been added to quickly add the same document/certificate record to all items in the declaration.
Additional basic validation rules have been added.
CRM client relationship data can now be auto-populated into a CDS declaration that is created from a Job.
A DMSRCV notification will not update the declaration status if the declaration has been cancelled or is in the process of being cancelled.

Issues resolved

45357 - Declaration reports with large amounts of data were timing out.

Software detail

Release 5 - Sprint 1
Developed 10th January 2022 - 21st January 2022
Published on 4th February 2022

Sequoia v4 - Upgrade Enhancements

Sequoia v4.39

Goal

Automated customer reporting
Extend CDS declaration functionality

Release Notes

Declaration reports can now be sent direct to your customers via email. A user guide for this functionality can be found here.
The Unloading Permission Granted response no longer overwrites any existing NCTS declaration data.
The VAT amount displayed in the declaration find results is now consistent with the amount shown on the job customs action task (there was a discrepancy if Postponed VAT Accounting (PVA) procedures were used).

CDS Development

A validation rule has been added to prevent a declaration being sent without the Decln Type [01] being declared.
Additional basic validation rules have been added.
The Additional Fiscal Reference automatically added if the Importer is configured for Postponed VAT Accounting procedures (PVA), will now prefix the account's VAT number with GB.
The 'global search' now supports finding a CDS declaration by it's MRN.

Issues resolved

44580 - Declarations created via the API were not displaying in the declaration find results until they had been submitted to HMRC.
44653 - Errors were being logged when processing ETSF messages due to a logging format issue. This did not affect the processing of the messages.
45023 - Large worksheets were failing to be imported via the API Intermediary Service (file system plug-in).

Software detail

Release 4 - Sprint 39
Developed 20th December 2021 - 7th January 2022
Published on 24th January 2022

Sequoia v4.38

Goal

Bug fixes
Extend CDS declaration functionality

Release Notes

Sequoia client and server now compatible with Windows 11.
Deferment numbers saved against CRM accounts can now be viewed in the CRM list. The 'Deferment Number' column is available from the Column Chooser (right click on one of the column headings to access).
A setting to indicate whether a CRM account is enabled for Postponed VAT Accounting (PVA) can now be viewed in the CRM list. The 'PVA Enabled' column is available from the Column Chooser (right click on one of the column headings to access).

CDS Development

44425 - The latest revenue details for a declaration are now easily accessible from the 'Revenue' button on the declaration toolbar, or from a context menu on the Customs Action job task.
44422 - The errors dialog has been modified to show the MRN included in the rejection message from HMRC. This may be useful in any subsequent conversations with HMRC since we understand they are unable to trace declarations by the LRN. Note it is very unlikely to be the same as the MRN issued once the declaration is accepted.
39080 - Fixed an issue where an error was encountered creating a declaration from a job which only had an origin or destination but not both.
44419 - Enhanced functionality when converting test (TDR) declarations to live and inventory linking them.
44513 - Extended logic around cancellation, enabling cancellation up until the point that the declaration status is "Cleared".
43544 - CDS declaration deferment and guarantee details now being updated when the Importer or Declarant are changed.

Issues resolved

44316 - Resolved currency fluctuation issue with incorrect tax amounts when declarations were accepted and cleared in different months
44239/44269 - Fixed issues with Sequoia not working correctly for users on Windows 11.
44330 - Fixed issue with 060 "Declaration Under Control" status not displaying on NCTS.
44394 - Fixed problem where the response to a declaration created was incorrectly treated as a response to a calculate revenue test declaration when using the word "Mode".
44414 - Resolved issue where CDS declaration status was being set to "Accepted" after cancellation request had been approved.
44449 - Box 30 was not always showing the full location code on export ESS reports.
44483 - Fixed issue with Declaration acceptance notifications not including excise revenue.
44614 - Fixed issue with NCTS Status window not showing when declaration, arrival or unloading remarks were submitted. This was affecting customers on the new CTC API.

Software detail

Release 4 - Sprint 38
Developed 6th December - 17th December 2021
Published on 22nd December 2021

Sequoia v4.37

Goal

Bug fixes

Release Notes

CDS Development

Declarations can no longer be sent once an MRN has been allocated (ie, once the declaration has been accepted/lodged).
Basic validation has been added. Click the Validate button on the declaration editor. This is very much a work in progress and only basic rules have been added so far. More rules will be added over time.
Declarations can now be deleted when the status is "Accepted on Hold DEFRA Check".
Declarations can now be created from a template.
Templates can now be created when you are licensed for TDR declarations (previously live CDS declarations had to be licensed).
The errors dialog now closes automatically if you close the parent declaration editor.
A rejection message containing just a code and description is now displayed correctly in the error dialog.
Lookups now work for the Supervising Office [44] and Presentation Office [44] controls.
Any 'B05' revenue amounts are included in the VAT totals displayed on the job or in declaration find results. B05 is a Northern Ireland specific tax type.
Any carriage return / new line characters are automatically stripped out of the declaration (but not from the Goods Description) - this was causing messaging failures.
On receipt of particular error messages the declaration status is updated to "Inventory Failure" for clarity.
Sequoia prompts to update a created declaration when it is opened from a job that has an inventory record associated. This will then automatically update the Total Packages [06] to match the inventory record and add the MUCR (Z-MCR Previous Document) with the inventory reference.
TDR declarations can no longer be sent with a MUCR (Z-MCR Previous Document) as the TDR system does not support inventory links.
The global search now works for TDR declarations (previously live CDS declarations had to be licensed).

Issues resolved

44661 - NCTS Unloading Permission and Goods Released for Transit notifications failed if item level dispatch or destination countries were declared. This will only affect you if you have already been switched over to the CTC messaging system.
44667 - NCTS declaration rejection notification failed if the reason text exceeded 70 characters. This will only affect you if you have already been switched over to the CTC messaging system.

Software detail

Release 4 - Sprint 37
Developed 22nd November - 3rd December 2021
Published on 14th December 2021

Sequoia v4.36

Goal

Bug fixes

Release Notes

Due to Microsoft Office phasing out TLS 1.0 and 1.1 we have upgraded to .NET Framework 4.5. This has resolved issues some users were experiencing with intermittent emails failing to send from various email plug-ins.
NCTS Gross Mass calculation was pulling through negative figures causing an Orchestration Error with outbound messaging failing and in turn causing a Transmission Failure

Issues resolved

43937 - Emails intermittently failing for Office 365 when sending through various email plug-ins.
41216 - Fixed issue with Customs Tariff resetting Sequoia scale and font to higher than recommended settings.
44262 - Fixed issue with NCTS Gross Mass pulling through negative values.

Software detail

Release 4 - Sprint 36
Developed 1st November - 19th November 2021
Published on 25th November 2021

Sequoia v4.35

Goal

Enhance event notifications

Release Notes

An event (declarationClearanceNotification) is now published to notify when an import declaration has been updated to customs cleared status. The event is available to be received through both the API and Status Event Writer plug-in once configured.
The API has been extended to allow a currency to be declared on an export declaration for statistical value. The DeclarationGbExportItem.xsd schema has been extended to include an optional statisticalValueCurrency element. Sequoia will use the latest exchange rate for the specified currency to calculate the statistical value in GBP.

Issues resolved

43464 - Fixed problem with importing CRM accounts through the toolbox.
44142 - Fixed issue with NCTS transit mapping - rework to map gross mass, packages and previous documents per shipment.
44153 - Fix to NCTS TAD Report items section, which was not showing all produced documents.

Software detail

Release 4 - Sprint 35
Developed 4th October - 29th October 2021
Published on 9th November 2021

Sequoia v4.33

Goal

Enhancements to NCTS declaration data mapping

Release Notes

Total Packages [06] control has been added to the NCTS declaration editor. This field is optional but will be mapped from jobs linked to the transit movement.
The API now supports inclusion of header level Total Packages when creating NCTS declarations. The element is optional.
The mapping of Packages [31] from export declarations to the NCTS declaration has been simplified. If all of the Package Kind values are the same, a single Package [31] record will be added to the NCTS declaration with the number of packages/pieces reflecting the total number of packages. Any other items on the NCTS declaration will also have a single Package [31] record with the same Kind but zero showing as the number of packages/pieces. A warning will be displayed to the user at the point of loading the NCTS declaration if Total Packages [06] does not equal the sum of all of the Package [31] numbers.
Number of packages/pieces is now included as a column in the item 'summary details' grid of an NCTS declaration.
Handling of the Unloading Permission Granted (043) message has been modified to allow for circumstances where any Package Kinds do not match recognised UK Package Kind code values.
Transit Guarantee editor will no longer just append 00 to the 8 digit export commodity code but will check for the first code that has a duty measure in order to calculate the potential duty and VAT.
Goods Location [30] on import declarations will be defaulted to the shipment destination (if this has been set to a GB location) for road and ocean imports.

Issues resolved

43377 - Pentant Users: CUSDEC messages introduced to automatically update declarations with cleared status have been fixed
43367 - Anti-dumping duties were not always being included in the Total Duty value displayed on the C88 report
43090 - Customs Sub Place is no longer considered mandatory when saving an NCTS Profile set for Normal procedures
41375 - "Item Origin Country" (column CV) on the declaration report has been renamed "Item Origin Country [34a]" and "Orig cntry [34a]" (column CB) has been renamed to "Orig Cntry" as this is mapped from the job origin (if the declaration is linked with a job)
43420 - Produced Document/Certificate ('740', for example) not being mapped when creating an NCTS declaration from a shipment
42486 - Guarantee amount was not being released for cancelled NCTS declarations

Software detail

Release 4 - Sprint 33
Developed 6th September - 1st October 2021
Published on 12th October 2021

Sequoia v4.31

Goal

Enhance import declaration status updates
Include AIS reference in ETSF outputs

Release Notes

HMRC CHIEF system will be interrogated on a regular basis in order to check whether accepted import declarations have been granted clearance. The declaration status will then automatically be updated to 'Accepted and Cleared'.
The reference used by the CCS-UK AIS RoRo (Advance Information System) system to generate movements to your ETSF can now be captured and stored against the ETSF record. It can also be configured to be automatically added to an air import or road import job as an external reference. External job reference types added/configured through the Data menu can now be selected to be used to 'Map external reference on inventory link', meaning the external job reference type will automatically be added to the job when the inventory record has the ETSF external reference set.
The reference generated by the CCS-UK AIS system will also be included in the API 'publishETSFStatusChange' and 'publishAgentStatusChange' events, described here. These are published whenever the status of an ETSF inventory record is updated.

Issues resolved

43208 - The order of Routing Countries on an export declaration submitted through the API was not being maintained

Software detail

Release 4 - Sprint 31
Developed 23rd August - 3rd September 2021
Published on 24th September 2021

Sequoia v4.30

Goal

Bug fixes
NCTS enhancements

Release Notes

A profile can be chosen when creating an NCTS declaration regardless of the profile used when creating the Guarantee record. This change is applicable to those users with multiple NCTS profiles configured. This reverses the change made in release 4.27.
The installer now has a button on the summary page to generate information about the system for licensing purposes.

Issues resolved

42141 - Processing of SDF file caused duplicate stock removals to be created
42218 - API marks and numbers made optional in the Package schema to support circumstances where the package kind does not require marks and numbers to be declared
42271 - Full stop was being added automatically to email addresses in CRM
42285 - Using the text 'MODE' in the Trader Reference/DUCR was causing the CUSRES message to fail
42410 - Entries using PVA seem to be creating a small VAT paid charge on the C88
42484 - Draft C21 report was printing but not saving to the job / declaration reports dialog
42492 - Transhipment Removal (TSR) was allowing letters in the onward AWB Number field
42662 - Transportation service was logging a warning when printing an AWB

Software detail

Release 4 - Sprint 30
Developed 26th July - 27th August 2021
Published on 2nd September 2021

Sequoia v4.28

Please do not upgrade to this version if you have more than one NCTS Profile with the same Guarantee Reference number. In this instance please upgrade to version 4.25 (see below).

Further NCTS enhancements are due in version 4.30

Goal

NCTS enhancements
Bug fixes

Release Notes

The ability to manually set the status of an NCTS movement to Declaration Cancelled has been added. This is accessible through the Status History dialog and is available to users who have the "Manually Set Transit Status" security role privilege.
NCTS movements can now be deleted where their status has been set to Declaration Cancelled.

Issues resolved

42080 - The declaration editor was allowing invalid characters in the Commodity additional code field.

Software detail

Release 4 - Sprint 28
Developed 12th - 23rd July 2021
Published on 28th July 2021

Sequoia v4.27

Please do not upgrade to this version if you have more than one NCTS Profile with the same Guarantee Reference number. In this instance please upgrade to version 4.25 (see below).

Further NCTS enhancements are due in version 4.30

Goal

NCTS enhancements
ETSF Find options extended
Bug fixes

Release Notes

NCTS declaration data is now built from the linked export declaration data. Data from each item of a linked export declaration is mapped to an item on the NCTS declaration. This includes commodity code, goods description, gross mass, net mass and packages, marks and numbers. The Creating a Transit movement page of the user guide has been updated to reflect these changes.
Item level gross mass on an NCTS declaration is included as a column in the item 'summary details' grid.
Business Continuity configuration has been removed from CRM and added to the NCTS Profile page in Sequoia Configuration.
The ability to set a default procedure type has been added to the NCTS Profile page in Sequoia Configuration. The procedure can be defaulted to Normal or Simplified and can also be left blank (this will be the default for existing profiles or when adding a new profile). When a profile is chosen at the point of creating the NCTS declaration, the procedure type will be defaulted however it can still be changed by the user.
The ability to set a default Principal has also been added to the NCTS Profile page in Sequoia Configuration. This can be used to override the default NCTS Principle configured in CRM.
The profile chosen when adding the Guarantee details to the NCTS movement will also be used when creating the NCTS declaration. This change is more visible to those users with multiple NCTS profiles configured.
Configuring transit guarantees has been enhanced to show the associated profile description alongside the guarantee reference.
ETSF find functionality has been extended to include the ability to search by external reference. A column for the external reference can also be added to the results grid by right clicking any of the column captions and choosing Column Chooser (this guide details how to add columns to existing grid layouts) .

Issues resolved

41414 - CRM accounts deactivated by using the right-click context menu were still available for use in a declaration
41482 - Templates created from an EIDR declaration were not subsequently available for use when creating new EIDR declarations
41634 - Attempting to delete an EIDR declaration caused an unrecoverable error
41865 - NCTS status history showing Declaration Cancelled status when the cancellation request had been refused

Software detail

Release 4 - Sprint 27
Developed 14th June - 9th July 2021
Published on 20th July 2021

Sequoia v4.25

Goal

Bug fixes / CFSP enhancements

Release Notes

Total Packages [SAD box 06] can now be amended after acceptance of a non-inventory linked declaration.
Extended CFSP functionality to track Branch References and be able to submit FSD's for each Branch Reference.
The CFSP user guide has been updated to include details of this functionality.

Issues resolved

41267 - Unrecoverable error when attempting to create a declaration against an air inventory consignment which had an inter-airport removal lodged
41329 - Sending NCTS unloading remarks was not adhering to the correct security role privilege
40575 - Certain fields (Total Packages, Commodity additional code, packages and marks) were not being validated correctly when populated through the API
40772 - Identified cross-threading issues within the Sequoia installer
41290 - Customs Warehousing stock removals stuck in a 'processing' state
41463 - Failure to produce C88 if the declaration included Registered Consignee [SAD box 44] or Government Contractor [SAD box 44]

Software detail

Release 4 - Sprint 25
Developed 31st May - 11th June 2021
Published on 24th June 2021

Sequoia v4.24

Goal

Bug fixes / minor enhancements

Release Notes

API schemata have been extended to include an external reference when creating or modifying an ETSF consignment as well as including the external reference when retrieving ETSF consignment details. This is not a breaking change.
The "freightStatusNotification" event has been extended to include the ETSF consignment external reference.
The inter-shed removal notification (CUKFSA P5) will set the external reference on the ETSF consignment if this is included in the message from the AIS system.
A new "interShedRemovalNotification" event is published on receipt of an inter-shed removal notification message. This event can be received via the API or through the Status Event Writer plug-in (the event name will need to be added to the plug-in configuration).
The dialog used to link existing job records with an inventory record has been modified. This allows the user to perform a search for a particular record rather then returning all available records in one long list.

Issues resolved

41174 - Fatal exception on saving/opening an NCTS declaration
41358 - Minor fixes to the Account Importer tool

Software detail

Release 4 - Sprint 24
Developed 17th - 28th May 2021
Published on 2nd June 2021

Sequoia v4.23

Goal

Bug fixes / minor enhancements

Release Notes

The dialog used to link existing inventory records with an air or road import job has been modified. This now allows the user to perform a search for a particular record rather then returning all available records in one long list.
The ability to import account data into Sequoia from a CSV file has been added to the toolbox application. A user guide for this feature can be found here.
External reference field added to ETSF consignment form in preparation for AIS data capture.

Issues resolved

40851 - Find job results were not returning road import or export jobs
41063 - CCS-UK inventory record showing incorrect nominated agent name

Software detail

Release 4 - Sprint 23
Developed 3rd - 14th May 2021

Sequoia v4.22

Goal

Bug fixes

Release Notes

Issues resolved

32789 - API Intermediary Service (file system plug-in) fails to write file to the deadletter folder if a file with the same name exists
40083/40379 - Occasional failures to send CUSCAR FRC messages when arriving goods into ETSF
40607 - API Intermediary Service (file system plug-in) not processing all files when service started
40618 - NCTS error messages not being displayed
40730 - Windows account used to run the Sequoia services is less restrictive
40775 - New and Open buttons to add or open a Transit Guarantee had been disabled in a previous release
40969 - Configured CFSP start date was occasionally being reset
41012 - Unable to link existing Ocean Export declarations to a job

Software detail

Release 4 - Sprint 22
Developed 19th - 30th April 2021
Published on 11th May 2021

Sequoia v4.21

Goal

Bug fixes

Release Notes

When automatically creating the charge lines in Job Costing records - only a duty line is created when using PVA procedures

Issues resolved

40551 - ESS report header now shows 'United Kingdom' rather 'European Union'
40649 - Standalone print client no longer requires a separate licence.
40560 - FSD report query timeout is now configurable
40521 - Need valid EORI number in DUCR to calculate revenue
40466 - Added MRN / LRN to the error message for support purposes
39700/38439/32906 - Minor typographical errors fixed

Software detail

Release 4 - Sprint 21
Developed 5th April - 16th April 2021
Published on 21st April 2021

Sequoia v4.20

Goal

Bug fixes

Release Notes

List service performance problems were identified and have been resolved. This was something that has come to light due to the increase in the volume of declarations being submitted since January.
DeleteGbDeclaration API was allowing an accepted declaration, which had subsequently received an inventory failure, to be deleted from Sequoia. In this circumstance, the declaration should be updated with a reason for cancellation and the SendGbDeclarationCancellation API should be used. The DeleteGbDeclaration API will now prevent a declaration in this state from being deleted.

Issues resolved

40413 - Speed issues reported but relates to list service performance problems
40436 - Find Job function not returning results due to database timeout
40206 - API allowed an accepted but inventory-failed declaration to be deleted
40383 - Error when looking up existing declarations to link to a job

Software detail

Release 4 - Sprint 20
Developed 22nd March - 1st April 2021
Published on 8th April 2021

Sequoia v4.19

Goal

Installer enhancements
Worksheet enhancements
Modifications to Postponed VAT Accounting (PVA) reporting
Bug fixes

Release Notes

The installer now shows the progress of file lock checking and prerequisite checks alongside the progress bar.
Duty and VAT methods of payment can now be specified in worksheet data and are included in the Excel template files and the XML schema. The methods of payment can be used when the 'auto populate tax lines on declarations' setting is enabled. Specifying these values can be used to override Sequoia's default behaviour where 'D' or 'F' are used depending on whether a deferment number is specified in the declaration.
The time taken to open a worksheet has been improved. This is more noticeable when opening larger worksheets.
Import declarations using PVA procedures now report the VAT amount on the C88 as a separate value. 'Total Other' is no longer shown as a negative value on the C88. 'Declaration find' search results for declarations made after this upgrade will no longer show a negative 'Total Other' value (this will not affect declarations made prior to upgrading).

Issues resolved

40275 - NCTS 'Write Off' date not being reported correctly in the 'Find transit declarations' results
40179 - API Intermediary Service failing to connect to the Sequoia API Service
40177 - NCTS declarations duplicating item data when problems encountered saving to the database
40029 - Deleting an item from an NCTS declaration was not re-numbering the remaining items

Software detail

Release 4 - Sprint 19
Developed 8th - 19th March 2021
Published on 25th March 2021

Sequoia v4.18

Goal

Configuration enhancements
Bug fixes

Release Notes

Warehouse authorisation configuration now allows different authorisation prefixes (previously this was restricted to only allow 'A', 'C', 'D' or 'E' warehouse authorisations).
Multiple changes can be made to gateway configuration pages without having to reload the Sequoia configuration (MMC) between each change.
Validation added when creating customs warehousing stock items to ensure the same currency code is used for each item.

Issues resolved

39715 - API service logging exceptions when client had disconnected
39818 - Unrecoverable error when attempting to link a consolidation to an NCTS movement if a related shipment was already linked to a movement
39932 - Error occurred when linking shipment to an NCTS movement and a declaration linked with the shipment had no commodity code declared
40089 - 'Declaration find' results were not always showing the associated job reference
40022 - NCTS unloading remarks error response was not being displayed when clicking the errors button

Software detail

Release 4 - Sprint 18
Developed 22nd February - 5th March 2021
Published on 16th March 2021

Sequoia v4.17

Goal

NCTS enhancements
Bug fixes

Release Notes

Declaration Find criteria has been extended to allow a search for all declarations where Postponed VAT Accounting (PVA) procedures were used.
The Declaration Report now includes the Job Customer, Containers [31], Tax Line [47] details and the current declaration state.
Finalising an Ocean or Road shipment/consolidation (required to be able to link them with an NCTS movement) no longer requires a Master UCR (MUCR). If the MUCR is not set on an Ocean or Road shipment/consolidation then clicking the Finalise button will automatically set the status to "Finalised" without sending the association / close MUCR messages.
NCTS statuses have been improved to give more feedback if there is a failure when sending declarations to the NCTS system.
The UCN field on a Road Import job is removed when the job is linked with a CCS-UK inventory record as it is redundant.

Issues resolved

39622 - Duty tax lines not automatically added when commodity is duty free under certain preferences
39947 - Carriage returns included in Produced Documents [44] on an NCTS declaration caused the declaration message to fail
39681 - Underscores included in a CHIEF declaration resulting in CONTRL message rejections
39686 - Declaration Find results showing incorrect Consignee / Consignor if declarations had been copied and those parties changed. Note, this only occurred if the data warehouse database had been rebuilt
39686 - Profit and Loss report was incorrect if accruals had been apportioned
34537 - Sequoia Client experienced an unrecoverable error if NCTS unloading remarks were accessed after manually setting the status to Unloading Permission Granted
39699 - Accepted, non-inventory linked, Road Import declarations were not being set to Accepted and Cleared (a stored procedure runs daily to update the previous day's declarations since no "clearance" message is sent from CHIEF)
39711 - NCTS declaration API schema modified as the 'Other Information' element for a Previous Document was mandatory
39718 - Problems with downloading Sequoia licence resolved
39729 - Installer was failing if the Print Client folder had a Windows file lock

Software detail

Release 4 - Sprint 17
Developed 8th - 19th February 2021
Published on 23rd February 2021

Sequoia v4.16

Goal

NCTS enhancements
Bug fixes

Release Notes

Characters which are not permitted in an NCTS message (carriage returns, tabs) are now removed at the point of sending the declaration.
The TAD report is automatically printed if the status of an NCTS movement is manually set to 'Declaration released for transit'.
Declaration Acceptance Notification API event payload has been extended to include item commodity and tax line details. These details include the tax type, method of payment and amount of duty / VAT calculated by HMRC.

Issues resolved

39677 - User can now finalise a road export shipment without having to be associated with an air export role
39729 - API UpdateImportGbDeclaration failing when the declaration had AI Statements and/or Documents declared at item level

Software detail

Release 4 - Sprint 16
Developed 27th January - 3rd February 2021
Published on 9th February 2021

Sequoia v4.15

Goal

NCTS enhancements
Bug fixes

Release Notes

Enhancements made to the NCTS gateway to handle the issues encountered when failing to connect to the NCTS system webservice.
Sequoia will automatically retry a number of times to connect.
A Transit MRN stored against an ETSF inventory record is now mapped through to the inventory linked import declaration as a Previous Document.
NCTS Movement is labelled if the record is in fallback.

Issues resolved

39567 - Auto generated NCTS Guarantee amount formatted incorrectly with a comma when the value exceeded GBP1000
39488 - Failure when converting an EIDR declaration to an ISD
39608 - Declaration report incorrectly identifying 'road' declarations as 'ocean'
39522 - Failure when opening a declaration where all items had previously been deleted
39544 - Failure after deleting an item when the declaration had been created through the API

Software detail

Release 4 - Sprint 15
Developed 11th January 2021 - 26th January 2021

Sequoia v4.14

Goal

Brexit enhancements
Bug fixes

Release Notes

Transit Customs Offices can now be added and edited within the Sequoia Client. The list of known offices can be accessed through the Data menu option and selecting EU Customs Offices. This list now supports the options to add new records as well as edit or delete existing records.
A link to the Sequoia Resource Centre website has been added to the Help menu within the Sequoia Client. This will allow users to quickly and easily access the various user guides to Sequoia's functionality.
Installer enhancements.

Issues resolved

39309 - NCTS declaration items were not maintaining the correct order when the declaration was created through the Sequoia API service
39312 - NCTS declaration transit offices were not maintaining the correct order when the declaration was created through the Sequoia API service
37798 - AI Statements and Documents were not showing when a declaration item was copied
39386 - GEN53 AI Statements were being duplicated when a declaration item was copied
39526 - Unable to send an NCTS Declaration when Consignee or Consignor declared at item level
39445 - Non-standard X-Socket port used by Sequoia Client not retained on upgrade

Software detail

Release 4 - Sprint 14
Developed 21st December 2020 - 8th January 2021

Sequoia v4.13

Goal

Brexit enhancements
Bug fixes

Release Notes

HMRC have issued Customs Information Paper #8.
We have added functionality that from 1st January 2021 all declarations which have Procedure Codes indicated in the CIP will have the GEN53 AI Statement automatically added to the declaration item.
The date required will be taken from the flight date of the inventory record (for air) or the shipment date (for ocean or road).
The 'into warehouse date' will be used for all ex-warehouse declarations.
Where the job is not linked to a shipment then the AI Statement will be added but the date the goods were imported into the UK will need to be completed.
These settings are time-limited and will automatically come into effect between 1st January 2021 and 30th April 2021 (or 31st December 2021 for ex warehouse declarations).
The default Border Transport Mode [SAD box 25] for declarations linked with Road jobs has been set to '6' for RoRo as it is deemed the most likely 'use case' from 1st January.
A prompt has been added when setting Goods Location [SAD box 30] to confirm the correct Border Transport Mode [SAD box 25] to use when the port supports 'mixed' mode traffic.
The VAT Tax line Method of Payment code of 'G' for PVA enabled Consignee's (click here for guidance) is now being set when a worksheet with the 'Auto populate tax lines on declaration' setting is imported into a declaration.
Installer enhancements.

Issues resolved

39164 - Out of warehouse declarations were not creating the B00 VAT Tax line, as specified in the tariff, if the Tax Rate had not been set for the stock record.
39043 - The installation/upgrade process should not fail when unable to test connections to ASM web services. A warning is displayed instead.

Software detail

Release 4 - Sprint 13
Developed 7th December - 18th December 2020

Sequoia v4.12

Goal

Brexit enhancements
Bug fixes

Release Notes

The option to default VAT tax lines to use 'G' Method of Payment to support Postponed VAT Accounting (PVA) has been added. Details of this enhancement can be found here.
Barcode for the MRN added to Export declaration ESS reports.
Default search option for EIDR declarations has been added to the Find Declaration functionality.
EIDR declarations are supported through the API (CreateImportGbDeclaration request). Validation is in place to prevent sending of an EIDR to HMRC through the API.
The ability to 'arrive' pre-arrival Road Import declarations from the Consolidation, Shipment and Job lists has been added. Details of this enhancement can be found here.
Manual printing of an import C88 report is now available through the Reports option in the declaration editor when the H2 or E2 report has been received. This has resolved a technical issue where, on occasion, the acceptance response message (which normally creates the C88) had 'failed' at the CSP.
The badge used for sending a declaration can now be changed prior to acceptance of a declaration.
ETSF Consol notes and Release Note comments are now editable for created pre-arrival consignments.
Road Consolidation and Shipment trailer number restriction has been increased to allow 35 characters.
File System Clean-up plug-in has been modified to work with multiple folders.
ASM services which are used by specific plug-ins (ASM MSMQ REST Reader and the ASM REST MSMQ Writer services) can now be left running during upgrades.

Issues resolved

38782 - File Document Store plug-in not outputting the LRN/MRN for a NCTS TAD report
39041 - Email Report Broker plug-in only emailing to the 'Export' email address when configured at Site level

Software detail

Release 4 - Sprint 12
Developed 23rd November - 9th December 2020

Sequoia v4.11

Goal

NCTS Enhancements
EIDR Declaration
Bug fixes

Release Notes

The ability to print an NCTS TAD/TSAD document in Fallback has been included. The CRM record for the Principal captures the Business Continuity Authorisation Number together with serial numbers for the fallback procedure. A checkbox has been added to the NCTS Movement to indicate that fallback procedures are in place and once checked the system prevents the sending of the CUSDEC message and allows printing of the TAD/TSAD report with the Business Continuity stamps.
To support the ability to defer import CFSP supplementary declarations from 1st January for up to six months, an EIDR (Entry in Declarant's Records) editor has been added. Details of this new functionality can be found here.
The Declaration Acceptance Exporter plug-in has been further extended to allow output to be filtered on transport mode as well as the option to suppress the creation of sub-folders for the output files.
The Find Transit Declarations function now returns results where the NCTS Movement record exists but the declaration does not (for example, where an Arrival has been rejected).

Issues resolved

38128 - NCTS - Incorrect Movement status on receipt of 029
37747 - Export Value Build Up - Net Mass Apportionment is incorrect Box 38
38262 - Terms & Conditions on the reverse of Master AWB need updating
38764 - Multiple Duplicate CUSCAR messages being generated causing Message Process errors
38862 - Commodity Code Supplementary Values are not being output when using API GetGbDeclaration
38933 - Sequoia Print Client - ASM.Sequoia.Reporting.PrintService.exe.config merge failure during upgrade

Software detail

Release 4 - Sprint 11
Developed 9th November - 20th November 2020

Sequoia v4.8

Goal

Urgent bug fixes.

Release Notes

Urgent bug fixes for NCTS

Issues resolved

37721 - NCTS declaration blank after transit message received
37747 - Export Value Build Up - Net Mass Apportionment is incorrect Box 38
37826 - The unloading date on NCTS Remarks incorrect
37956 - Installer isn't showing an error on failure

Software detail

Release 4 - Sprint 8
Developed 25th September - 9th October 2020

Sequoia v4.7

Goal

Preparations for Brexit and the Northern Ireland protocols.
Updates to the installer functionality to simplify some of the dialog wording.
Updates to the installer to allow the user to continue the installation when only warning level prerequisites are displayed.

Release Notes

To support the requirement for Import declarations for goods moving between mainland GB and Northern Ireland from 1st January 2021, validation restrictions on Jobs have been removed to allow Origin and Destination to both be locations within GB.
Work has been undertaken to allow the Community Status SDC codes to be removed from ETSF functionality from 1st January 2021 without affecting current functionality or viewing pre-Brexit records.
User is now prompted to update a saved declaration's Total Packages and/or MUCR when a Road Import Job's packages or UCN is amended. This replicates the existing behaviour with Ocean Import Jobs.
Modifications to the List Service's base query settings are now retained when upgrading the software.

Issues resolved

37554 - CCS-UK Inventory Consignments list not displaying the Status 2 values
37465 - Unclear terminology used when prompting to start the Sequoia services at the end of the installation/upgrade
37724 - Sequoia Service Monitor service mode being set to 'Automatic' and not respecting original service mode on upgrade

Software detail

Release 4 - Sprint 7
Developed 3rd August - 25th September 2020

Sequoia v4.3

Goal

Enhance installer functionality to simplify the upgrade process.
API Enhancements.
Custom EP plug-ins.

Release Notes

The Installer had been enhanced to add extra safety checks and also to implement bug fixes / improvements to the software upgrade.
New EP Plug-in available for AS400 processing, to create shipments in Sequoia.
Customs Export Creation EP plug-in now supports Road Export consignments.
Search by declaration status in declaration find.
Enhancement to allow creation of consolidations via the API
Enhancement to link shipments to consolidations via the API
Enhanced metrics gathering.

Issues resolved

32670 - Re-running the MSI generates a new unique organisation identifier
35876 - NCTS / Transit job find not working correctly
36404 - Unable to modify the printer configuration in the installer after the upgrade is complete
36395 - Automatic database backup functionality within the installer is not working as expected
36403 - Unable to amend job reference format within the MMC configuration snap-in
36483 - Enhance logging to determine why certain services have issues starting
36751 - Standing data is down-graded on upgrade

Software detail

Release 4 - Sprint 3
Developed 20th July - 31st July 2020

Sequoia v3 - Archiving and Worksheet Enhancements

Sequoia v3.20

Goal

Extend the API to support Consolidations.
Add DEP functionality to Ocean and Road Jobs.

Release Notes

The Sequoia API service has been extended to allow the creation, modification and deletion of Consolidation records.
The Sequoia API service has been extended to allow a Consolidation to be linked with a Shipment record.
Ocean and Road Export Jobs now allow their associated Declaration(s) to be arrived in DEP. Please note that only a DEP that is operated by CCS-UK is supported.

Issues resolved

34643 - Problem occurred where E2 and E8 messages for the same declaration were processed simultaneously
36662 - Problem occurred processing DEP update messages (UKCINV ERS) where the DEP location differs to CCS-UK PIMA address location

Software detail

Release 3 - Sprint 20
Developed 26 May - 19 June 2020

Sequoia v3.18

Goal

Urgent bug fixes.

Release Notes

An event is now published when an export declaration is departed (this occurs on receipt of a CUSRES where the SOE is 8). This 'declarationDepartureNotification' event can be added to the API configuration. Schema defining the event payload is included with the API documentation.
The Status Event Writer plug-in (which captures published events and writes the data to the file system) has been extended to include the ability to write out the 'declarationDepartureNotification' event. The plug-in has been further extended to have the ability to write the event payloads to a message queue instead of, or as well as, the file system.

Issues resolved

34698 - GetFullAcceptedDeclarationResponse API method was not returning the correct entry route following arrival of a pre-arrival declaration
34634 - Creation of Road Import jobs required the user to be in an Ocean Export role as opposed to an Ocean Import role
34710 - NCTS IE025 and IE058 messages were overwriting the original creator of the declaration
20164 - Toolbars in Sequoia were able to be removed but not easily restored
35156 - Unable to use Goods Location 'LON' when creating an Import declaration through the API
35473 - C130 report was not displaying the entire commodity or procedure code
35720 - Unable to associate Shipment to an NCTS Movement when the Shipment was linked to an OLE record

Software detail

Release 3 - Sprint 18
Developed 17 February - 22 May 2020

Sequoia v3.11

Goal

Urgent bug fixes.

Release Notes

Issues resolved

34214 - Deadlock occurrences processing NCTS CUSDEC message
34242 - Unable to specify 3 letter Carrier Code in ETSF consignment

Software detail

Release 3 - Sprint 11
Developed 3 February - 11 February 2020

Sequoia v3.8

Goal

Urgent bug fixes.

Release Notes

Declaration Acceptance Exporter plug-in (which writes out data to the file system when a declaration is accepted) has been extended to no longer require the declaration to be associated with a Job. This is a configurable option.
New CCS-UK port location for Basildon (IATA code TBY) supported for inventory-linked import declarations.

Issues resolved

32752 - ESS Report missing Premises and SPOFF details for multi item declarations
32897 - Global search could return records marked as deleted by the data archiving process
33251 - Ocean Export role permissions were not being respected for Declarations associated to Ocean/Road Export jobs

Software detail

Release 3 - Sprint 8
Developed 16 December - 03 January 2020

Sequoia v3.5

Goal

Urgent bug fixes.

Release Notes

Export Fallback message handling re-worked as the structure of the message was changed from the original CCS-UK specification.

Issues resolved

32086 - NCTS Declaration not updating when Release for Transit message received
32244 - Error encountered when fetching Freight Status Updates
32478 - Default CFSP Badge for Supplementary Declarations not respected

Software detail

Release 3 - Sprint 5
Developed 04 November - 15 November 2019

Sequoia v3.3

Goal

Enhance the Archiving application to boost performance.
Remove all deleted data from the database.
Add the ability to change the Customer of a Worksheet.
Support deletion of multiple Worksheets.

Release Notes

The Archiving application allows the creation of a Job Report for every Job being archived to be suppressed. Where users have separate systems which already capture the Job data, the production of the Job Report may not be required and can therefore be prevented from being automatically produced. This is a configurable option (Job Reports for archived Jobs are enabled by default). Preventing the Job Reports from being produced will improve the overall speed of the archiving process. A further issue was discovered where the Sequoia Client was found to be inoperable during the archiving process - this has been resolved.
When records are deleted in Sequoia (Jobs, Declarations, Shipments, ETSF, etc) they are retained in the database but marked as "inactive" and are unrecoverable. They are hidden from the Sequoia client but remain in the database. These records will now be permanently deleted during the upgrade process.
The Customer of a Worksheet can now be changed after the Worksheet has been created. The Customer cannot be changed if any part of the Worksheet has been used in a Declaration or if the Worksheet has been "finalised".
The "delete" context menu on the Worksheet list now allows multiple Worksheets to be selected and deleted (previously only one Worksheet could be deleted at a time).
Option for "passive mode" has been added to the Pentant gateway to support an "Active" or "Passive" FTP connection.

Issues resolved

31378 - API Intermediary service configuration removed on upgrading to a new version of Sequoia
31464 - File Document Store EP plug-in does not ignore certain reports
31369 - Unrecoverable error while processing multiple 'SDF' removals from Customs Warehousing

Software detail

Release 3 - Sprint 3
Developed 09 September - 30 October 2019

Sequoia v2 - NCTS Declarations

Sequoia v2.7

Goal

Enhance ETSF functionality to allow a record to be linked to an NCTS Movement by the Transit MRN.
Enhance Road Import functionality to allow CCS-UK inventory records to be linked to Road Import jobs.
Enhance Declaration Find functionality to include the Border Transport Mode.

Release Notes

ETSF records now include a Transit MRN field in order to indicate a discharged transit declaration has "moved" into the CCS-UK inventory. The ETSF Find functionality has been extended to allow searching for ETSF records by this Transit MRN. The "Transit MRN" column in the results grid is available from the "Column Chooser" menu.
'TRK' can be used as the Carrier on an ETSF record to indicate the consignment has moved by road.
Road Import jobs can now be created from CCS-UK inventory records. In addition, an "inventory task" can be added to Road Import jobs to allow linking existing CCS-UK inventory records to a job. The frontier declaration created from a Road Import job which has an inventory associated will be created with the Master UCR (MUCR) generated from the inventory record. The Transport Identity [SAD box 21] will be taken from the vehicle registration / trailer number (if there is a shipment record associated to the job), otherwise the inventory carrier and flight number will be used. Border Transport Mode (SAD box 25) will default to "3 - Road Transport".
The Declaration Find now includes the ability to search for, and display, the Border Transport Mode. The "Border Transport Mode" column in the results grid is available from the "Column Chooser" menu. Upgrading to this release will automatically populate the existing records in the Sequoia Data Warehouse database with their Border Transport Mode.

Issues resolved

31037 - Permission denied when opening an export declaration linked to a Road Export job

Software detail

Release 2 - Sprint 7
Developed 26 August - 6 September 2019

Sequoia v2.6

Goal

Enhance NCTS Find Transit Declarations search options.
Enhance API NCTS functionality to be able to get Movement status and publish Movement status changes.

Release Notes

The API now supports retrieval of an NCTS Movement Status. There was already a method to get an NCTS Declaration status but if the NCTS Declaration was created as the result of an arrival message being sent, the status would always be "Declaration Created".
The API now publishes an event whenever an NCTS Movement's status is updated. The payload of this event contains the LRN, MRN (assuming an MRN has been allocated) and the current status in plain text (i.e. 'Declaration MRN allocated'). This event is also published if the status is set "manually" via the Status toolbar button on the NCTS Movement editor.
The NCTS Find Transit Declarations functionality has been extended to allow searching by Movement Status. In addition, the 'potential guarantee amount' of the NCTS Movement has been included in the search results data.

Issues resolved

30670 - Issue with Destination Country [17a] and Declaration Report

Software detail

Release 2 - Sprint 6
Developed 12 August - 23 August 2019

Sequoia v2.5

Goal

Enhance NCTS Transit Guarantee Functionality
Inclusion of Safety and Security information in an NCTS Declaration
Enhancements to NCTS to be able to search for existing transit movements / declarations

Release Notes

The NCTS system does not support declaration of GB issued guarantees however it is being extended in the near future to allow this. The Transit Guarantee functionality within Sequoia has been extended to allow a guarantee to be automatically added to the NCTS declaration once the system supports this inclusion. This is set to false by default.
NCTS declarations can now be sent including safety and security information. This will also include production of a Transit Security Accompanying Document (TSAD).
Search functionality is now available for NCTS.

Issues resolved

30233: Customs Duty Rate and VAT Rate not accurate in Declaration Report. Duty Rate not matching Tariff caused by rounding issues

Software detail

Release 2 - Sprints 4 & 5
Developed 15 July - 09 August 2019

Sequoia v2.3

Goal

Enhance NCTS to declare Security details and print reports.

Release Notes

The external NCTS test system is not currently working. This means that we have been unable to fully test the NCTS message build. We have compared the message build to the previous version (before security declarations were added to NCTS in Sequoia) and have found that NCTS builds messages in the same way. Recommend that this does not get deployed to any users who currently use NCTS until we can get a proper response from the NCTS test system.

Issues resolved

30066: Find Job - No Records returning - Timing out - Versions 1.163.40 & 1.189.38 & 2.2, 2.3
29546: New Job form can be resized so it hides the Relationships controls
30237: Controls missing on all parties on air import jobs
30185: The NCTS Declaration validation Routing dialog when attempting to delete records is incorrectly worded

Software detail

Release 2 - Sprint 3
Developed 1 July - 12 July 2019

Sequoia v2.2

Goal

Enhance NCTS to include ability to declare Security details.

Release Notes

NCTS Security Declaration Details will save, but currently will not be sent in an NCTS declaration message.
On this upgrade/installation and every subsequent upgrade from this release onwards, the message log table will be truncated so that it will contain records of messages from the last year only.

Issues resolved

30033: NCTS Seals grid has a horizontal scroll bar once more than 3 seals are declared
29969: Declaration Find not pulling all records from the data warehouse into Sequoia
29972: Air Export Jobs tab is not updating after processing a batch via API
29307: ICS code not populating on Sequoia Find Declaration Summary pane

Software detail

Release 2 - Sprint 2
Developed 17 June - 28 June 2019

Sequoia v2.1

Goal

Continue implementing CDS Worksheet functionality

Release Notes

Minor bug fixes are included in this release.

Issues resolved

29318: Default Declarant ISD Badge overwrites the value on a saved Declaration
29197: Customs Warehousing: Stock Item state not set to 'Processed'
28200: Warehouse site not being populated when reopening a declaration

Software detail

Release 2 - Sprint 1
Developed 3 June - 14 June 2019

Sequoia v1 - Road

Sequoia introduces the following features...

Sequoia v1.189

See previous 'Whats new' document