Sage 200 Extra 2015 - Fixed Issues

Solution Properties

Solution ID:

200427112319854

Last Modified Date:

Fri Nov 24 08:49:28 UTC 2023

Taxonomy Path:

Case category//How do I...//an integration

Author:

[email protected]

Sage 200 Extra 2015 - Fixed Issues

Description

This article contains a list of fixes that are included in Sage 200 Extra 2015.

For further information about any of the issues mentioned in this article, please search for the relevant Known Issue number in the Known Issues Database.

Cause

Resolution

Tip: If you wish to check if a particular Known Issue is fixed, expand each of the sections below and use the Find option in your web browser to check if the Known Issue number is listed in this article.

Service Pack 3

The following Known Issues are planned for resolution in Service Pack 3 for Sage 200 Extra 2015, which centres around addressing issues with Manufacturing. There will also be requests from the Ideas Portal included. Service Pack 3 is currently planned for release on 29 February 2016. Please note that this date, as well as the list below, is subject to change according to the results of the relevant testing procedures. Please check back regularly for updates.

Module	Known Issue No.	Description	Priority (1-4)
Works Orders	4356	Manually raised Works Orders incorrectly set as 'Allocate/Issue From Completion Warehouse'.	3
Works Orders	3891	Status shows as Allocated or Issued despite only being partially allocated or partially issued.	3
Works Orders	6769	Making several amendments to a works order picking list generates a memory exception error.	3
Works Orders	6773	Performance issue with amending a works order. Note: This stops the list refreshing when an allocation has been edited but does not change the speed that the form loads with.	3
Bill of Materials	4244	Cannot make BOM items inactive/available for deletion.	4
Bill of Materials	6560	Purchase Order from Trial Build uses the average price of the item rather than the price recorded for the supplier on the component stock item.	2
Bill of Materials	4845	'Stock Allocation does not Support Build' error when trying to confirm build.	4
Stock	6191	Unable to use 'Find' on the Stock Item List on the description field. No results were returned.	4
Nominal Ledger	6723	When posting a Non-Vatable Payment into a future period you receive the error: Contract Failure: To Set the Tax code the item must be taxable. This issue is triggered by the ASM > Settings > System Settings > Transaction Settings > Transaction Date Validation setting.	4
Nominal Ledger	6742	Unable to edit the Nominal narrative when reversing transactions.	4
Nominal Ledger	5967	Update Waiting Postings slow to run in Sage 200 Extra 2013.	3
Purchase Ledger	6586	Amending a cheque number when amending suggested payments generates the error 'Index was outside the bounds of the array'.	4
Price Book	6190	Prices are set to zero in all bands if you untick 'Use Standard', edit the price then use Close rather than Save.	3
Sales Orders	6675	Stock becomes corrupted after allocating multiple orders at the same time with different fulfilment methods.	3
Sales Orders	6251	Amending an order where you have previously selected Record Payment with order, then selecting 'Close' on the card payment screen generates an exception.	4
Purchase Orders	6781	Record Purchase Invoice Error on sage.accounting.persistentpcprojectentry.	3
Project Accounting	6702	Slow performance when tabbing between fields whilst entering batch timesheets.	3
Project Accounting	6793	OutOfMemoryException when generating suggested bills on a dataset with a large number of contracts.	3
CRM		Not all records in Sage 200 Extra were included when performing an initial synchronisation even though the integration status shows as 'Success'.	3
Developers	6129	Extending the PLPostedTran and associated views causes errors in Customer Transaction Enquiry.	4
Developers	6717	Endsave issue on Sage.MMS.CashBook.CashBookGroupedTransactionsForm.	2

New Functionality

Module	Description
BOM and Manufacturing	Added a new feature to warn users when compatibility warnings are turned off. A warning label has been added to the BOM and Operation maintenance forms.

Service Pack 2

The following Known Issues have been resolved in Service Pack 2 for Sage 200 Extra 2015.

Module	Known Issue No.	Description	Priority (1-4)
Stock	5977	User and GDI Objects stack on repeatedly opening 'ST - Amend Stock Item Details'.	2
Sales Order Processing	6537	Setting in Intrastat tab of Sales Order Settings/Purchase Order Settings causes 'Unhandled Exception'.	2
Nominal Ledger	6545	No information found when running the report for cash flow.	2
Sales Order Processing	6569	Unable to enter 4-character CV2 value for American Express cards.	2
Nominal Ledger	6574	Narrative not populated when making taxable payment from cash book account.	2
Stock	6593	OutOfMemoryException when amending a batch or serial stock item.	2
Nominal Ledger	6328	Using a journal template and then tabbing through will change all narratives to the title of the journal.	3
Purchase Ledger	5611	Exception error when adding a Query code to a transactions that exists on a payment routine.	3
Purchase Ledger	6460	Reversing a Foreign transaction doesnt behave as it should in relation to notional tax.	3
Desktop	6500	Highlighting Projects on the List View does not filter for enquiries.	3
Cash Book	6564	'Unexpected exception has occurred' when posting standing orders and direct debits.	3
Sales Ledger	6611	Drill down on Transaction Enquiry does not work for Grouped Transactions.	3
Timesheet	6506	Expense Claim Reporting - incorrect totals on Expense Claim Summary and duplications on others.	4
Report Designer	6597	Brought Forward Balance not updated for a consolidated company.	2
Developer programme
	6572	Unable to update an add-on to a later version through System Administration.	N/A
	6529	Sage 200 2015 and Sage 200 CRM 7.3 - using Form Launcher to launch a scripted form throws 'vbc.exe cannot be found' error.	2
	6566	Unable to set the .ConfirmationIntentType property on Sage.Accounting.POP.POPFreeTextLine.	2
The following Known Issues are included from Service Pack 1 and will be re-tested as part of the testing for Service Pack 2.
Nominal Ledger	5970	Unable to import a CSV file containing negative budget values.	2
Desktop	6389	'Unhandled Exception' error message appears when attempting to add a new feature in Menu Design Mode.	2
Timesheets	6469	Enter Timesheet Week - Incorrect Cost Rate saved.	2
Analysis Codes	6470	Issue when editing a newly created analysis code in Sales Order Processing or Purchase Order Processing.	2
Purchase Order Processing	5753	Possible copy an order without saving any supplier details.	3
Nominal Ledger	6318	When importing budgets to the Nominal Ledger, a 'success' message is displayed but the details are not imported.	3
Desktop	6390	Workspace quick filters now display 'part searches'. Previously, the filter would only search on the entire word.	3
Desktop	6400	User preferences not retained when logging out of Sage 200 Extra.	3
Desktop	6424	Adding reports to the Home Pages Favourites now makes the report appear in the Summary screen.	3
Nominal Ledger	6429	Default Cost Centre drop-down list was not displayed on the Consolidation tab of the Nominal Ledger settings.	3
Desktop	6443	'OR' filter not working correctly in Workspaces	3
Desktop	6444	Unable to run reports or layouts from Favourites.	3
Sales Ledger	6451	Save and Allocate button now inactive on the Reverse Transaction form when reversing a receipt or payment.	3
Purchase Order Processing	6480	Multiple Delivery Dates button missing if Project Account Integration not enabled.	3
Desktop	6425	Error generated when creating a new folder in Home Page Favourites and adding a report.	4
Stock	6455	MRP Replenishment Options missing from the Manufacturing tab on the Stock Item screen when using low screen resolution on some low-spec PCs.	4
Desktop	6487	Non-Taxable Receipt launches Taxable Receipt Form.	4
Sage 200 CRM	6432	Ergonomic theme not working as expected after upgrading from version 7.1.	0
Developer programme
	6401	Add-on fails to install when it contains 2 content parts.	N/A

As part of Service Pack 2, a Reports Pack will also be released and will include the following fixes to Known Issues.

Known Issue No.	Description
21	Returns are no longer included on the report.
154	Balance brought forward value being brought forward as 0 if negative in Database.
1765	Sales Ledger Email Statement wrongly including Brought Forward Value.
1999	Purchase Order layout showing the incorrect requested delivery quantity in certain scenarios.
2123	Stock SOP Shortfalls Report.
2571	Segmented Address Fields Not Available On Free Text Invoice Layout.
2632	Profitability reports including credit notes and Sales Returns.
3141	Reprint Text does not display on reprinted purchase orders .
3357	Report lists allocated value in base currency for foreign currency accounts.
3567	Comment line not meant for picking list print causing picking list to be 2 pages.
3599	Statements produced for zero balance accounts.
3906	Only the 'email' sales ledger statement can be automatically emailed.
4157	Inconsistent behaviour of adding lines onto Layouts.
4507	Invalid table specifier error when enable TRAN_PERIOD criteria on nominal day book report.
5590	Unhandled exception: Count must be non-negative when amending Nominal Ledger Cheque layout .
5593	Unable to edit 'Nominal Ledger Cheque' layouts.
5944	Financial Reports always default to Microsoft XPS Document Writer.

New and enhanced features

Drill-down functionality for Sales Ledger summary pages

Service Pack 2 will include work on the Sales Ledger summary pages to allow the customer to drill down further into the details on that page.

New and enhanced reports

The following additional reports will be released with Service Pack 2.

Plain paper layouts

The following reports are formatted with grids and lines, similar to that in Sage 50 Accounts, to allow customers to use plain paper rather than stationery...

POP Purchase Order (Single)

POP Return (Single)

Purchase Ledger Remittance Advice

Sales Ledger Debtors Letter 1

Sales Ledger Debtors Letter 2

Sales Ledger Debtors Letter 3

Sales Ledger Debtors Letter 4

SOP Despatch Note (Single)

SOP Invoice (Single)

SOP Pro-forma (Single)

SOP Sales Order (Single)

The following reports are already available in Sage 200 Standard / Education Online and will be included as part of the Service Pack 2 release.

Stock Control Sales By Product (Detailed)

Stock Control Sales By Product (Summary)

Stock Control Sales By Product By Customer (Detailed)

Stock Control Sales By Product By Customer (Summary)

Stock Control Sales By Product By Customer By Product Group (Detailed)

Stock Control Sales By Product By Customer By Product Group (Summary)

Stock Control Sales By Product By Product Group (Detailed)

Stock Control Sales By Product By Product Group (Summary)

Stock Control Sales By Product By Product Group By Customer (Detailed)

Stock Control Sales By Product By Product Group By Customer (Summary)

Stock Control Monthly Product Sales

Stock Control Monthly Product Sales By Customer

Stock Control Monthly Product Sales By Customer By Product Group

Stock Control Monthly Product Sales By Product Group By Customer

Stock Control Monthly Product Sales By Product Group

The following reports are available to download individually, but these will be wrapped up as part of the Service Pack for better usability.

Nominal Ledger Transactions with Sales or Purchase Ledger Second Reference

Purchase Ledger Accounts with No Transactions

Purchase Ledger Top 5 Suppliers

Sales Ledger Accounts with No Transactions

Sales Ledger Age of Transaction

Sales Ledger Top 5 Customers

SOP Picking List with Additional Charges

SOP Stock Shortfalls With Purchase Ledger Criteria

Stock Control No Transaction History

Stock Control Stock Valuation By Product Group

Service Pack 1

The following Known Issues have been resolved specifically in Service Pack 1 for Sage 200 Extra 2015.

As part of the Sage 200 Extra 2015 release, a wave of retesting focussing on issues found in previous versions of Sage 200 Extra was carried out. As a result of this testing program, we're pleased to advise that a number of issues can no longer be replicated in Sage 200 Extra 2015. In other areas, the redesign of Sage 200 Extra 2015 may mean that a previous issue is no longer relevant.

Module	Issue Tracking System Reference (where applicable)	Description
Nominal Ledger	5970	Users were unable to import a CSV file with negative budget values.
	6318	When importing nominal ledger budgets, a 'success’ message was displayed but the details were not imported.
	6429	The Default Cost Centre drop-down list was not displayed on the Consolidation tab of the Nominal Ledger settings.
Desktop	6389	An ‘Unhandled Exception’ error message appears when trying to add a new feature in Menu Design mode.
	6390	Updated the Workspace quick filters to display part searches. Previously, the filter would only search on the entire word (for example, typing AB would only find a customer with the name AB, it wouldn’t find Abbey etc).
	6400	User preferences not retained when a user logs out of Sage 200.
	6424	Adding reports to the Home Page Favourites now makes the report appear in the Summary screen.
	6425	Creating a new folder in Home Page Favourites and adding the report generates an error.
	6443	Error in Workspaces where the ‘OR’ filter did not work correctly. In previous versions the OR filter was working like an AND. As a result, no details were being returned by the filter.
	6444	Unable to run reports or layouts from favourites.
	6487	Non Taxable Receipt launches Taxable Receipt Form.
Purchase Orders	5753	Could copy an order without saving any supplier details.
Purchase Orders	6480	Multiple Delivery Dates button missing if Project Account Integration not enabled.
Sales Ledger	6451	Save and Allocate button on the Sales Ledger reverse transaction form is now read-only when reversing receipt or payment. This was active in the release version of 2015.
Stock	6455	MRP Replenishment Options missing from the Manufacturing tab on the Stock Item screen when using low screen resolution on some low-spec laptops and PCs.
Timesheets	6469	Enter Timesheet Week - Incorrect Cost rate saved.
Analysis Codes	6470	Issue when editing a newly created analysis code in Sales Order Processing or Purchase Order Processing.
Sage 200 CRM	6432	Ergonomic UI not working as expected after upgrade from 7.1.
Developers	6401	Addon fails to install when contains 2 content parts.

The Known Issues below can no longer be replicated in Sage 200 Extra 2015.

Core Modules

Desktop and User Interface
Module	Issue Tracking System Reference (where applicable)	Description
	136	Screen position information is retained which can cause problems on dual screen computers.
	421	Issue with Right-click when using Find functionality.
	1610	Journal transactions on the transaction audit trail list view are shown multiple times.
	2125	When viewing the Nominal Ledger in List View, the Balance column is left-justified, when it has previously been right-justified.
	3341	Duplicate Transactions are seen on audit trail list view after updating waiting postings.
	5505	Clicking Menu whilst on a web workspace brings up incorrect webpage.
Workspaces	3923	Sorts & filters not retained when Sage 200 Extra is closed and re-opened.
Web Workspaces	5612	'An internal server error has occurred' error appears when trying to run a web workspace (dbo.STKWorkspaceStockItem).
	5622	Error message when reprinting invoice from Customer Current Transaction Enquiry Workspace.
	5663	Period toolbar filter in Nominal Ledger Workspace displays an 'Internal Server Error'.
	5873	'An internal server error has occurred' filtering columns on Nominal Current Transaction Enquiry.
	5896	Access to spool content not working correctly for Spool workspace.
System Administration
	366	Memory leak when changing company.
	2396	Change company option slow.
	3616	User Permission and Spooler files lost on upgrade.
	4980	User numbers can exceed 999, affecting URN numbers.
	5128	SQL 2012 can cause the next User ID to jump beyond 1000.
	5506	An error occurs in System Administration if you update a non-retail database on a system with retail installed.
	6159	Update to Sage 200 Extra 2013 R2 fails due to an attempt to write to PipelineData in WorksOrders.
ASM	935	System displays an unexpected exception error when running balance ledgers for commercials after upgrade.
	3341	Duplicate Transactions on audit trail list view after updating a waiting posting.
	6217	Period exchange rates do not always work on invoicing.
Cash Book	935	Bank record reports fail to with warning, 'Cannot set the value of the Field (.FormatStringDashes)...'.
Cash Book	4896	Short term cash projection gives error ‘Cannot Set The Value Of The Field (.AccountNumber)’.
Nominal Ledger	4359	Cannot run Trial Balance Prior Year report for all prior year periods.
Nominal Ledger	5970	Cannot import negative budget values on first attempt.
Sales Ledger	495	Accounts are being omitted from the transaction listing when selecting criteria by transaction type.
	1765	Sales Ledger Email Statement wrongly includes the Brought Forward Value.
	3593	Turnover figures change when data is purged.
	6062	RCSL Report incorrectly shows the words ‘Tax Registration Code’.
	6161	Slow performance when importing transactions into Sage 200 Extra Online.
Purchase Ledger	1540	Negative discount on suggested payments causes ‘the value must be zero or greater than zero’ error message to be displayed.
Purchase Ledger	5374	The Export to CSV functionality for the Purchase Ledger Trading Report (Summary) returns a blank report.
Purchase Order Processing	4688	The cost centre/dept default nominal account (in Purchase Order Processing settings), are ignored when posting standard cost variances.
Purchase Order Processing	6201	Error displayed when receiving goods for a purchase order with items that have a large text description.
Sales Order Processing	567	Error displayed when trying to delete comment line on Amend Sales Order if it is part-invoiced.
	1767	SOP Permissions stop the ‘negative stock’ warning from appearing on rapid order entries.
	5877	'System.OutOfMemoryException' error when processing within the SOP – Confirm Goods Despatch’ form.
	6239	‘System Out Of Memory’ error displayed when there is a large traceable history.
Stock	3942	FIFO Fulfilment ignored when bin priority fulfilment is set the same across all bins.
	5037	System.OutOfMemory error displayed when processing an internal return that has a stock items with a large number of serial numbers.
	6036	User stuck in loop when writing off stock when it doesn’t have a write off category.
	6182	An error message ‘The Full Allocation Quantity Cannot Be issued’, displayed when trying to issue a full allocation.
Project Accounting	4601	Unable to enter project details on expenses when re-enabling the Post Expenses to Projects functionality.
	6255	Timesheets not being posted to projects if authorisation is switched off.
	6164	Creating a draft bill can cause duplicated selected costs and errors in some circumstances.
	6167	Selected costs disappear from a bill and cannot be selected under some circumstances.
Bill of Materials	4341	'This report could not be found in the list of available reports' message appears when printing BOM AFD reports.
Report Designer
	2003	Exception error displayed when editing reports based on Sales Analysis Values in Report Designer Extensions.
	3845	Settings to access printer are not valid.
	4043	Report Designer 2010 scans all files on the Root of the C drive when opening.
	4341	'This report could not be found in the list of available reports' error displayed when printing BOM AFD reports.
	6068	Memory not released when printing from spooler, eventually causing ‘Out of Memory’ errors.
	6398	'Sage200Desktop.exe has stopped working' message displayed when emailing reports and layouts.
Manufacturing
	4685	Changing the Total Selling Price on the QTY breaks grid doesn't update the Totals tab.
	5616	When using a BOM, any additional information is not retained.
	6188	Cancelling the confirm batch/serial numbers component screen still takes the stock out.
Sage 200 CRM
	2634	Unable to save any files as documents from CRM Task Launcher on Vista.
	4956	Square brackets in integration name causes validation errors when creating new companies.
	5127	"ERP Integration Name" Field Allows Invalid Name Length.
	5556	Uploaded Shipping Addresses do not synchronise with Sage 200 Extra.
	6375	DeleteLog issue - Delete a person from ERP and CRM causes sync to fail.
	6381	Incorrect results showing on RTDV results in Sage 200 Accounts Data tab.
Other
Business Intelligence	5000	Request for more control over the production of the BI Schedule Task log files.
Business Intelligence	6102	Send to Excel does not work with Excel 2013 when BI is enabled.
Sage 50 Payroll	4042	Save as PDF option lost when installing Sage 50 Payroll 2011.
Sage 50 Payroll	6334	Attempting to post a nominal link to payroll v21.00.183 displays an error.
Import Bacpac	5790	'Import bacpac failed’ error when creating new company from downloaded bacpac.
SEOS	5807	Some system generated backups are not visible within SEOS.
SEOS	5876	An MSP error occurs when creating a new customer within SEOS without specifying a Sage Account ID.
Installer	6010	Better handling of errors in Active Directory.

Sage 200 Extra 2015 - Release Version

Module	Issue Tracking System Reference (where applicable)	Description
System Administrator
	5997 & 5998	We have improved the speed of the company database upgrade process. This affects any database that: uses Analysis codes has large numbers of SOP, POP or Stock records, or has large numbers of BOMs or BOM Lines.
	6054	Users were unable to create the MMSUser account on Windows 2012 Essentials when it was integrated with Office 365. Previously the user would see the error message: ‘Cannot add login name_mmsuser to server password validation failed, the password does not meet the requirement of the password filter dll’.
Core 200
Nominal Ledger	1392	Tax type and tax code fields were not displayed on nominal journal templates. Previously, a user would have to set up the template and then enter these details once the template had been recalled prior to processing.
Stock Control	5093	Under certain circumstances, Amend Stock Item Product Group stopped working if outstanding works orders existed. In some cases, an ‘out of memory’ error appeared.
Stock Control	5424	Removing large amounts of stock history records caused on ‘out of memory’ error.
Project Accounting	5476	Users saw the error message; ‘Failed to run SQL script SchemaMigration’ when accessing Project Accounting settings, using the View Project Accounting Settings screen or when saving a project.
Project Accounting	5945	Bills were not generated as part of the Suggested Billing functionality. This issue affected some project item types of ‘stock item’, depending on how the item was set to allow costs and revenue.
Period End	5532	Users saw an exception error when trying to drill-down on a value on the Current Periods Totals screen within the VAT Analysis option. This occurred for users who had previously migrated data from Sage 50 Accounts.
Purchase Order Processing	5541	In some circumstances, a unique reference number (URN) was used if a free text line was analysed to a project. This resulted in a URN that had no postings in the Nominal Ledger.
Purchase Order Processing	6053	Saving a record with a long description on the Confirm Goods Received screen generated a ‘Sage Data Access Error – Cannot set the value of the field’ error.
Sales Order Processing	6066	Users trying to print a quotation for quotations that had been entered via the CRM Form Launcher would see an error message ‘Value does not fall within the expected range’.
Sales Order Processing	6239	Customers, using traceability, received an ‘Out of Memory’ error when processing large amounts of stock after the stock levels had been adjusted.
Sales Ledger	5666	Users saw Out of Memory errors or No Network Connection errors when performing consecutive transaction enquiries.
Nominal Ledger	5924	The details of a held journal were lost when creating another held journal from a template.
Bill of Materials	5767	Overtyping the stock code on Record Built Items could move a quantity into stock for an incorrect item.
	5780	Users sometimes received an exception error in the following scenario: Creating a purchase order within Trial Kitting when the supplier had exceeded their credit limit.
	5904	The Reverse (BOM) Build process took a specific quantity of a finished item out of stock and added the stock back in to the components.
Manufacturing
Works Order Processing	4551	Traceable Enquiry functionality did not work after changing the product group on a stock item.
	6122	Cost of sales postings were incorrect when components were issued to a works order which was completed before the components were invoiced.
	6188	Traceable components were not discarded correctly if the build was cancelled on the Confirm batch/Serial Numbers for Components form.
Estimating	5393	Components held against operations were not converted when estimates were converted to a BOM.
Bill of Materials	6086	Cancelling a BOM build for batch/serial items did not allow any changes to the build, unless the screen was closed and reopened.
	6096	The Build Session created a reserved temporary batch/serial number in BOM and an error message appeared, preventing the user from entering a value in the Quantity field.
	6172	Cost of sales adjustment postings were sometimes posted to the wrong nominal ledger account when building through sub-assemblies.
Other
Process Maps	5564	Enquiry buttons within process maps were not working.
Workspaces	5601	An exception error occurred if the user opened multiple workspaces. We have reduced the amount of system memory required to open multiple workspaces.
Excel Integration	6004	Refreshing data within Excel Integration was not good. We have made performance improvements in this area.

Sage 200 Services

Did you know Sage 200 customers now have access to a range of services direct with Sage. These include a bespoke Report Design Service, a library of How to Webinars and Ideas Portal just to name a few. Explore your potential using Sage 200 Services.

Steps to duplicate