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 - |
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 |