Skip to content

Releases for version 3.5

Release 3.5.329

Release completed: Wed Feb 05 2025 16:12:27 GMT+0000 (Greenwich Mean Time)

Compared with release number: 3.5.322-1

S200 Excelerator Enhancements

Id Title Product

S200 Excelerator Fixed Bugs Summary

Id Title Product
5489 Allow posting to previous periods via Orchestrator Purchase Ledger Invoices

Release 3.5.322

Release completed : Fri Jan 17 2025 09:22:46 GMT+0000 (Greenwich Mean Time)

Compared with release number : 3.5.297-1

S200 Excelerator Enhancements

Id Title Product
2999 Stock Adjustments Excelerator Stock Adjustments
4944 New validation results screen showing when warnings are displayed. ALL
5128 Update Memo Field from Excelerator in Sage Sales Ledger Invoices
5147 Change wording of "Allow update existing external IDs" option ALL
5388 Warn user if the item level company range is present and the update status isn't ALL
5448 Wider Results Screen ALL

S200 Excelerator Fixed Bugs Summary

Id Title Product
4264 Issue with Calculate value option in nonstandard currencies Sales Ledger Invoices
5019 Stock Unit and Browse missing on the Sales & Purchase Units Stock Master
5365 Option 'Do not ignore blank ranges?' doesn't work for memo and comments Stock Master
5394 External ID range in PL Invoice template Purchase Ledger Invoices
5401 Stock does not save memos for new records Stock Master
5417 Browse should respond to arrow keys ALL
5422 Delete existing lines' option not working Sales Order Quotations
5431 Blank Error Messages for certain errors ALL
5436 Date is not truncated if detail elevated to the header ALL

Release 3.5.297

Release completed : Tue Dec 10 2024 07:06:48 GMT+0000 (Greenwich Mean Time)

Compared with release number : 3.5.221-1

Release completed : Tue Dec 10 2024 07:06:48 GMT+0000 (Greenwich Mean Time)

Compared with release number : 3.5.221-1

Warning

This release contains some breaking changes. These are highlighted in the tables below.

S200 Excelerator Enhancements

Id Title Product
5135 Do not populate any ranges with formula in ALL
5163 Remove Sort by reference on NL Journals Download Posted Nominal Journals
5182 Use account external ID in SL and PL Invoices Purchase Ledger Invoices
5229 Allow the company to be set on a per transaction basis SOP, POP modules, SL and PL Invoices. Stock, customer, suppliers.  Cash receipts and payments.
5248 Breaking change: Allow validation of multiple items that have text that is too long. Repurpose the "Validate on Load" option: Change the menu option to say "Truncate on Load" and invert the setting. Length is always validated but not when the sheet loads. This option now determines whether to truncate values on loading. ALL

S200 Excelerator Fixed Bugs Summary

Id Title Product
5016 Stock: No error, Supplier Code missing(Scenario Specific) Stock Master
5238 Supplier Module Security Error while creating new account Suppliers
5242 Module Security issue with stock deletion Stock
5244 CB Receipts and Payments Allow Negative VAT Amounts CB Receipts/Payments
5258 CB Receipts: Saving to previous years is not allowed. CashBook Receipts
5261 Allow > 2000 allocations per session Sales Ledger Receipt Allocation
5262 VBA Excelerator invocation no longer works ALL
5292 Supplier price list - Message missing on 'Save to Sage' Supplier Price List
5299 PL Invoice: Print Selection doesn't work Purchase Ledger Invoices
5305 Remove the SL Payments modules from the module list. This functionality is included with Sales Cash Receipts.
5333 Company Change on logon not retained ALL
5343 Save and Validation message incorrect when certain options are enabled Purchase Orders Entry
5376 PO Entry: Unable to download By default Supply to Field. Purchase Orders Entry

Release 3.5.254

Release completed : Thu Oct 24 2024 09:54:01 GMT+0000 (Greenwich Mean Time)

Compared with release number : 3.5.221-1

S200 Excelerator Enhancements

Id Title Product
5135 Do not populate any ranges with formula in. ALL
5147 ExternalID field not following the option selected. ALL
5163 Remove Sort by reference on NL Journals Download Posted. Nominal Journals
5182 Use account external ID in SL, PL Invoices, SOP Orders, Invoices and Returns and POP Orders and Returns Purchase Ledger Invoices

S200 Excelerator Fixed Bugs Summary

Id Title Product
3527 S200 Bank Charges for Foreign Currency CB Payments & Receipts CashBook Payments
5019 Stock Unit and Browse missing on the Sales & Purchase Units Stock Master
5113 Browse not available on Request Delivery Date of Order Details Purchase Orders Entry
5160 The tax goods analysis does not match the transaction net value Sales Ledger Invoices
5171 Unable to add additional units of Measure by Excelerator Stock
5189 Browse Issue Purchase Ledger Invoices
5234 S200 Standard templates having test data ALL
5246 Validation message not clear Reference and 2nd Reference character length validation Sales Ledger Receipt Allocation

Release 3.5.242

Release completed : Tue Sep 24 2024 10:43:30 GMT+0000 (Greenwich Mean Time)

Compared with release number : 3.5.221-1

S200 Excelerator Enhancements

Id Title Product
4972 OP Module support saved records tracking
4992 S200 Stock: Position of Details in Designer has changed Stock Master
5022 Analysis Code column headings on browse
5062 Allow multiple banks in SL Receipts/Payments Sales Ledger Receipt Allocation
5090 Separate VAT lines in PL/SL Invoices Purchase Ledger Invoices

S200 Excelerator Fixed Bugs Summary

Id Title Product
4994 Warehouse not pulled for all items when browsing stock Sales Order Entry
4997 Excel Crashes with Save to Sage Nominal Journals
5003 Gross Amount Zero, error on save CashBook Receipts
5004 No error on Zero Gross value(Options) CashBook Payments
5008 Disabled features in SA, permissions not reflecting in Excelerator CashBook Receipts
5009 SA Permissions are not reflected for Non-Vatable Payments. CashBook Payments
5010 Permissions issue, allows the creation of new return, when the feature is disabled in SA Purchase Order Returns
5014 Issue in Permissions Sales Ledger Receipt Allocation
5018 Bring back analysis code labels in column headings Sales Ledger Receipt Allocation
5031 Orphaned processes when company range is used Purchase Ledger Invoices
5054 Generic error message on Saving incorrect data to Sage Invoices
5058 The maximum Stock Level for the item will be exceeded warning as error Purchase Orders Entry
5102 S200Excelerator: Multi Company feature not working correctly
5106 S200 CB Payments - Facing errors on Validate and Calculate Values' CashBook Payments
5117 Prints on selected items list when different items are selected on the sheet ALL
5124 SL/PL Invoice - restore the partial save functionality Sales Ledger Invoices
5130 S200: PL Invoices 'Continue save after error?' not updating the status ranges Purchase Ledger Invoices

Release 3.5.221

Release completed : Wed Jul 31 2024 12:11:18 GMT+0000 (Greenwich Mean Time)

Compared with release number : 3.5.220-1

S200 Excelerator Fixed Bugs Summary

Id Title Product
4988 SOP Quantity Reserved being left Sales Order Entry

Release 3.5.220

Release completed : Wed Jul 24 2024 07:11:39 GMT+0000 (Greenwich Mean Time)

Compared with release number : 3.5.211-1

S200 Excelerator Enhancements

Id Title Product
4879 Metadata Report - a tabular list of the Excelerator metadata and its status ALL
4885 Expose the ExternalIDFieldName field in both traders Excelerators to allow external IDs to be tracked. Customers
4945 Remove menu bar in designer
4947 CSV Import Feature - Raw CSV Import tool ALL

S200 Excelerator Fixed Bugs Summary

Id Title Product
4775 Populate not pulling the right value Stock Master
4827 Save to File Options issue with Macro Enabled Workbook ALL
4884 Trader duplicate validation - needs to allow for generated account numbers Customers
4946 OP Stock Browses show inactive products SOP, POP
4975 PL Invoices Calculate Values Error PL Invoices
4957 Rename StockDTO back to StockDto as it may cause issues with client's own templates Stock Master

Release 3.5.159

Release completed : Mon May 13 2024 14:18:56 GMT+0000 (Greenwich Mean Time)

Compared with release number : 3.5.149-1

S200 Excelerator Fixed Bugs Summary

Id Title Product
4730 S200 Invoicing: Sage settings not getting applied on Cost Centre, Dept Invoices
4743 S200 Stock : Stock Code in Stock Master Excelerator should not be downloaded only Stock Master
4763 Changing Company does not refresh browse cache ALL
4765 S200 Browses:Refresh button not working. ALL

Release 3.5.152

Release completed : Mon Apr 15 2024 12:35:44 GMT+0000 (Greenwich Mean Time)

Compared with release number : 3.5.149-1

S200 Excelerator Enhancements

There are no enhancements in this release.

S200 Excelerator Fixed Bugs Summary

Id Title Product
3531 Gross Amount not populating on Calculate Values in SL Invoice and PL Invoice Template Sales Ledger Invoices
4725 S200 Invoicing: Discrepancy in Nominal Code pulled for Stock Invoices
4726 S200 Customers & Suppliers - Incorrect value on browsing the Tax code Customers

Release 3.5.149

Release completed : Thu Apr 11 2024 06:41:34 GMT+0000 (Greenwich Mean Time)

Compared with release number : 3.5.118-1

Warning

This release contains some breaking changes. These are highlighted in the tables below.

NL Reconciliation is not supported in this release. If you use this module, you should not upgrade without consulting Codis Support.

S200 Excelerator Enhancements

Id Title Product
2179 Codis enhanced logging Sales Order Entry
4539 Improve performance of stock download (after selection of records in browse) Stock Master
4587 Log data read from the sheet ALL
4603 Keep the position of repositioned browse forms ALL
4641 Sage200 Stock Excelerator - Validate Warehouse range should be added if any other Locations range is present on sheet. Stock Issues
4658 Improve Customers Browse performance Customers
4665 Browse - cache results and provide a refresh button ALL
4666 Dont Mirror Download only ranges - Suppliers Price List Supplier Price List

S200 Excelerator Fixed Bugs Summary

Id Title Product
1901 Payment groups with currency, validate the payment group first and the sort code second Purchase Ledger Payments
4274 Print issue Price Bands
4275 Amending Supplier range issue ALL
4491 Discrepancy Discount handled correctly Sales Ledger Receipt Allocation
4523 Unable to amend Average Buying Price when zero. Stock Master
4561 Save not working. Purchase Ledger Pay Allocation
4578 Multi currency fixes Sales Ledger Receipt Allocation
4597 SOP Autodoc setting not being retrieved Sales Orders
4614 Download Supplier, doesn't populate Stock on sheet Supplier Price List
4664 Use the Payment Group code in Suppliers Excelerator - BREAKING CHANGE Suppliers
4669 S200 SL Receipt allocation - Value Incorrect on 'Alloc this time' Sales Ledger Receipt Allocation
4686 Customers Browse fails if > 2100 records selected Customers
4692 Issue in saving amended Sales Return Sales Order Returns
4694 Issues in Download Purchase Ledger Payments
4697 Issue with Multiple_Non-Vatable Local currency upload CashBook Receipts
4702 Errors with Search Category values Stock Master
4723 Browse not available on Search Category and Search Category Value Stock Master

Release 3.5.118

Release completed : Mon Feb 12 2024 10:47:49 GMT+0000 (Greenwich Mean Time)

Compared with release number : 3.3.137-1

Warning

This release contains some breaking changes. These are highlighted in the tables below.

NL Reconciliation is not supported in this release. If you use this module, you should not upgrade without consulting Codis Support.

S200 Excelerator Enhancements

Id Title Product
1905 Option form - have a dropdown list for some options and stop the description from being editable ALL
1936 S200 Sales Return another read-only column from the Sales Order -Sales Order Price Sales Order Returns
1948 Excelerator Save to File - option to save as PDF ALL
3414 S200 Sales Order Excelerator - optional check for duplicate customer order numbers when saving orders Sales Order Entry
3428 S200 SL and PL Invoice Trans Enquiry should allow the exclusion of control postings Purchase Ledger Invoices
3744 NL Journals Download - Allow multiple journal selection and reversal of sign Nominal Journals
3888 Esc should act as Cancel on Excelerator input windows ALL
3889 POP/SOP Returns order browse - option should offer to exclude not completed and an option to not download comments Purchase Order Returns
3980 Excelerator input windows should be owned (always appear in front of) by Excel. ALL
4153 Range resize - option to turn off all formatting ALL
4199 Sage200 - Populate URN for SL Invoice and PL Invoice and include them in Display Save result and return to the sheet Invoices
4276 S200 Excelerator is not handling auto-generation of AccountReference for Customer/Supplier creation Customers
4387 Sage200 Excelerator - PL/SL Invoice 'Duplicate Reference/SecondReference' check option is not working correctly. Purchase Ledger Invoices
4388 S200 Ribbon Company selection should set last used company ALL
4452 New Download Screens in S200 Price Bands Price Bands
4503 Detect Excel Edit Mode and grey out Excelerator module menus ALL
4504 Improve the performance of customers' and suppliers' download Customers
4522 Copy sheet and Rename tools - limit file name characters to 31 ALL
4527 Add count to SL and PL Invoice transaction browse Purchase Ledger Invoices
116 When Logging in - selecting companies - should accept all ALL
133 When downloading journals, have an option to reverse the values. NL Journals
1872 CB Payments and CB Receipts NonVatable - templates amended. CB Receipts
1912 S200 Sales Returns - Downloads or browses should work with the idea that a return can be for multiple orders. Sales Returns
2017 S200 Stock Supplier Ranges - Price Source Ranges and Browse tidied. Stock Master
3236 S200 PL Invoices module (also SL Invoices and other modules) - Spare fields availability. PL Invoices
3438 Expand help and Add help access to S200 modules. ALL
3598 Invoicing should have "Calculate Values" and "Delete Invoices" menu options. Invoicing
3629 Have a "Value" field in S200 NL Journals as an alternative to credit/debits. NL Journals
3723 Customers/Suppliers/Stock Excelerators Populate - clear individual line not sheet. Master
3789 S200 Login - Remember Me does not work - remove it and keep the last selected company. ALL
3821 Sage200 Excelerator -> Clear and close Validation Results windows on Save & Clear it on Validate button. ALL
3836 Re-add 'Download' option for S200 SL Receipts & PL Payments. SL/PL Receipt and Payments
3861 POP/SOP Deletion form - use advanced format browse and add to invoicing and SOP/POP returns. SOP/POP
3871 PLPayAllocation & SLReceiptAllocation, Getting error in AllocationsOnly when Allocation Amounts do not balance. SL/PL Receipt and Payments
3891 Use a later version of log4net. ALL
3893 Breaking change - SOP and POP Returns - optionally copy despatched/received qty to return quantity. SOP/POP
3931 Improve tolerance of orphaned ranges. ALL
3933 SOP/POP Delete Items: allow multiple lines to be selected. SOP/POP

S200 Excelerator Fixed Bugs Summary

Id Title Product
3377 Stock Transfer batch browse does look for last entered product code Stock Transfers
3444 S200 Suppliers template mapped incorrectly Suppliers
3471 S200 - CB Receipts & CB Payments Errors CashBook Payments
3720 S200 Foreign Currency CB Payments - Tax Override doesn't work on upload CashBook Payments
3724 Breaking change - Maintain contact order as the sheet option is not working. Customers
3747 S200 Stock - Supplier 'Lead time unit' browse doesn't populate the value Stock Master
3820 S200 Foreign Currency CB Payments - Cheque number and Narrative don't copy on the detail lines CashBook Payments
3822 S200 Foreign Currency CB Payments - Validation Error Message missing for Non-VAT CashBook Payments
3884 S200 Stock Master - Country of Origin doesn't update Stock Master
3892 Nominal Code for SOP different for Excelerator and Sage generated Orders Sales Order Entry
3935 "Text data found that is too big" error message should include the text that is too big. ALL
3936 Strip 00:00:00 from dates in text ranges ALL
4011 Copy Sheet has stopped working due to Excel names scope. ALL
4029 Browse button in ribbon should be disabled if not logged in ALL
4048 S200 POP - Validation help incorrect if there is no data on the sheet Purchase Orders Entry
4051 Populate not working when Codes are entered in Lowercase Customers
4052 Loop of errors occur on Download( Invalid Company entered on the sheet ) ALL
4053 S200 PL & SL Invoice - Errors in Module Security Purchase Ledger Invoices
4055 S200 Stock does not have Location- Inactive status necessarily Stock Master
4056 S200 Invoicing: Deleting Invoice gives an error Invoices
4057 S200 SL Invoice - uploads invoice to Sage after disabling the feature Sales Ledger Invoices
4059 S200 Suppliers - Module Security Issues Suppliers
4101 S200 CB Payments - Warning message missing for Incorrect goods value on validation CashBook Payments
4110 S200 CB Payments - Doesn't auto-calculate the header Cheque value and Gross value CashBook Payments
4112 Sage 200 Supplier Price List Excelerator Delete error Supplier Price List
4113 S200 CB Receipts- Doesn't auto-calculate the header Cheque value and Gross value CashBook Receipts
4172 S200 Stock: Error in updating a stock item - "Failed to update objects" Stock Master
4200 PL and SL Invoices - marks ignored 0 value lines as saved Purchase Ledger Invoices
4201 Overlapping range validation missing ALL
4247 S200: Price Band - Options Side-by-side designer ranges not updated Price Bands
4252 S200: Purchase Order Print showing wrong information when we hover the mouse over it. Purchase Orders Entry
4253 S200 NL Journal, Purchase Return: Permissions Nominal Journals
4263 S200 Customers: Currency field must have a Browse Customers
4265 S200 Customers: Update Status range not working for Saved, validated. Customers
4266 S200: Credit Notes are generated when 'Enter Sales Credit Note' is disabled in Sage Features Sales Ledger Invoices
4267 S200 NL Journals: Issue in total on the SingleWithRecurringDates sheet Nominal Journals
4268 S200: Stock Transfer- Issue with Print Stock Transfers
4269 S200: Stock Transfer - Module Security - Stocks can be transferred in Excelerator when feature is disabled Stock Transfers
4270 S200 Invoicing: Validation error for Zero quantity Invoices
4271 S200: Price Band - Invalid link for 'Save to Sage' help page Price Bands
4273 S200 Invoicing: Download Cancelled Invoice, no data downloaded in Cancelled Range Invoices
4279 S200: Price Band - Issue in Save to sage with side-by-side sheet Price Bands
4280 S200 Purchase Return: Download Currency for Suppliers producing varied results Purchase Order Returns
4281 S200: Price Band - MultiCompany Range missing in Designer Price Bands
4285 S200: PL Pay Allocation & SL Receipt Allocation - Error on using 'Options' Purchase Ledger Pay Allocation
4287 S200 Sales Order: Renaming Sheet loses the mapping. Sales Order Entry
4288 S200 Supplier Price List : Download Suppliers issue. Supplier Price List
4291 S200: SL Receipts - Exchange Rate not working for non standard currency receipts Sales Ledger Receipt Allocation
4292 S200 Sales Order: Fulfilment other than from stock does not work Sales Order Entry
4294 S200: CB Payments - Error in Multiple_NonVAT-ForeignCurrency Sheet CashBook Payments
4300 S200 Supplier Price List: No mandatory range Suppliers
4330 Invoices not getting saved to sage - due to corrupt data. Invoices
4346 S200 Sales Quotation option error Sales Order Quotations
4380 S200 SOP Entry: unable to delete all line items Sales Order Entry
4381 SOP Fulfilment not from stock - fixed to allow partial fulfilment Sales Order Entry
4418 S200 Invoicing: Issue in Print Invoices
4515 S200 : SL Receipt "Object reference not set to an instance of an object." error occurs on Download Sales Ledger Receipt Allocation
4528 S200 NL Journal : Held and Posted Downloads are not working. NL Journals
3340 S200 Stock Excelerator Time span error on displaying tooltip ​Stock Master
3429 S200 Excelerator Error on Print "Object reference not set to and instance of an Object" SAGE200C2023R1 and above ALL
3442 S200 Customer template mapped incorrectly Customers
3443 S200 Price Band Excelerator template mapped incorrectly Price Bands
3480 S200 - Foreign Currency CB Receipts & CB Payments Errors CB Receipts
3601 In CB Payments foreign currency, it throws an error if Cheque amount is either not on sheet or blank. CB Payments
3625 New licence Computer ID algorithm should tolerate WMI corruption ALL
3644 S200 Foreign Currency CB Payments & Receipts - Errors on uploading 'Non-VAT' transactions CB Receipts
3667 Country of Origin gives an error on validation Stock Master
3701 Supplier's Contact ranges are not shown ticked in Designer. Suppliers
3739 S200 Foreign Currency CB Payments & Receipts - Incorrect figures on Cheque value CB Payments
3809 "Clear Ranges" fails on protected sheets ALL
3817 Suppliers Price List download - multiple suppliers not working Suppliers Price List
3818 Excelerator not handling protected view workbooks well ALL
3870 Resize Detail Ranges fails if expanding into a merged cell ALL
3890 Cannot enter qty in POR Returns Single And Multiple Entry Purchase Order Returns
4105 Sage 200 Supplier Price List Excelerator. Last Order Date downloads a number Supplier Price List
4125 S200 SL Receipt Allocation - Issues on the options help and module security Sales Ledger Receipt Allocation
4126 S200 PL Pay Allocation - Issues on the options help and module security Purchase Ledger Payment Allocation
4127 S200 Sales Quotation: Disabling permission from SA, allows to save SQ, Sage doesn't allow. Quotations
4138 S200 Stock: Inclusion of Bin on the template. Stock Master
4154 PO Returns template - ranges does not match formatting Purchase Order Returns
4184 POP Returns - use "Despatch Date" instead of "Requested Delivery Date" Purchase Order Returns
4249 S200: PL Invoices - Browsing on DocumentType list options that cannot be used Purchase Ledger Invoices
4262 S200: Suppliers - Issues in 'Save validated items immediately' option Suppliers
4298 S200 Sales Quotation: Validates, saves with no permissions in System Admin Quotations
4358 SOP Invoicing - SOP Permission Credit Limit different behaviour expected. Invoices
4538 Advanced browse - keep the selected record grid a constant size ALL