An issue has been found within the Estimating module for Sage 200 2011 SP3.

The issue occurs when a user amends an estimate by adding a new stage or amending an existing stage on the estimate. If this is done, some stages will then have duplications of Stock items that were already added.

A hotfix has now been released.

There is a known issue with Sage 200 2011 SP3 in relation to the consolidation routine.

When the user attempts to consolidate their subsidiary company, they receive an error ‘system.outofmemory exception’

The issue number that this is logged under is 4545. Sage have released a hotfix, this should only be applied to sites with Sage 200 2011 SP3.

If a user tries to expand MRP tags, where the parent tag is for multiple recommendations, the system can become unresponsive and run out of memory.

From testing Sage have found that this is more apparent when there are large quantities of tagged demand, which have generated thousands of recommendations. Sage 200 does not attempt to cache any data fetched for a particular tag and so if it meets the same tag in the tree hierarchy elsewhere it will attempt to explode it again.

This is known issue 4618. A hotfix has now been released and should only be applied to Manufacturing sites that have Sage 200 2011 SP3.

Each BI report is limited to the the number of data rows displayed on the report, and the number of dimension members displayed within the Report Layout pane. To view additional rows on a report you have to use the Page arrows on the BI ribbon. To view further Dimension members you are able to select an option to display the next few.

The default is to display the first 100 rows and 100 Dimension members. The default settings can be changed so more, or less, rows and/or dimension members display.


Within a BI report, click on the in the bottom corner of the ‘File’ section on the BI ribbon.

The Report Layout Options window opens and there is a setting to ‘Limit rows to’, which by default is set to 100. The setting can then be set to the required number of rows and when saved this will force the report to display the equivalent number of data rows on the spreadsheet.

NB. There is also a ‘Limit Columns to’ option within the Column tab.

Dimension Members

Within a BI report Personalise from the Sage BI ribbon. The Personalise window will open where there is a setting for ‘Paging size’ in the Report Layout Panel Paging section. This will be set to 100 but can be changed as required. Once the setting is changed the number of dimension members shown in the Report Layout pane will be up to the entered value.

Using the Sage 200 Report Designer you can choose to sort the data on your reports, into a particular order. For example, you may create a report that shows a list of Sales Orders and want the list to be sorted by Sales Order Date.

Adding a sort to a report, allows you to put the data into an order that is logical for the reports intentions, therefore making it easier for you to analyse.

When a sort is applied it affects the display of data within each section.

NB. It does not affect the order of the sections/groups, just the data within.

The example below is based on the Sales Order, Returns, Pro Formas and Quotations Report (Summary). This is grouped by Customer, and then lists the orders for each customer. The sort we are going to apply will change the order in which the Sales Orders are displayed, for each customer.

Talking Sage 200 – Sorting a Report