Tag Archive: Sage


This week saw the release of the Spring Enhancements edition for Sage 200.

Sage 200c has now become Sage 200cloud. Previously the C stood for connected but for whatever reason Sage 200cloud is now the name (until the next name change!). This is still an “On Premise” / Locally installed solution.

Anyway, down to real business and what new features are there included?

Hide and Restrict Nominal Accounts

There is now the ability to hide a Nominal Account. This prevents it from being visible within Nominal Selection drop downs.

Against Amend Nominal Account you can simply select the Active Status.

The system does not check if there is a balance or recent transactions. Anything waiting to be posted will still be updated and any balances are still accounted for within the P & L or Balance Sheet.

The Hide function is enabled by a new Nominal Ledger Setting “Restrict account selection to existing and active accounts”

If this setting is enabled (and I love this!) then only Nominal Account Combinations which exist can be specified against a transaction. Previously it has been possible to code a transaction to an account which does not exist. But this will prevent that from happening.

Hide Bank Accounts

It is also possible to Amend Bank Account Details and set an active status.

Hide Combined Budgets

You may wish to hide a combined nominal budget if it is no longer being used or maybe you have created a new budget which isnt ready to be used yet.

This removes the budget from lookup lists used for entering purchase requisitions, and helps prevent the budget being selected by mistake

Auto Refresh List Views

The automatic refresh functionality applies to Commercial List Views only (currently):

  • Sales Order Processing
  • Purchase Order Processing
  • Stock
  • Invoicing
  • Price Book

There is an Auto Refresh tick box at the top of the list view which must be selected to get the lists to refresh automatically.

Create Pro Forma for Prospect

It has been possible for a long time to be able to enter a Quote for a Prospect account. This is now possible for Pro Forma Invoices using the same Prospect account.

This works similarly to the Quote, and when converting a Pro Forma you can either select a Customer or Create a New Customer using the details entered against the Pro Forma.

Convert Quote to Pro Forma

There is a new option within Quotations which allows a Quotation to be converted to a Pro Forma Invoice. Once the Pro Forma is generated it is used in the same way as before and can be converted to a Sales Order.

GDPR

No software, and Sage 200 included, will make you GDPR compliant. Sage 200 now has 3 new reports to help you review your data to make a decision about whether you need to be holding data.

GDPR Contact Check report is within ASM > System Utilities > General Data Protection Regulation. This allows you to search for a contact across multiple Modules.

There are reports in Sales and Purchase Ledgers to identify customers and suppliers that have not been traded with for a period of time.

Sales Ledger > Reports > Account Analysis > Customers With No Transactions From.

Purchase Ledger > Reports > Account Analysis > Suppliers With No Transactions From.

 

 

 

 

 

Advertisements

As part of the Sage 200c release last summer, Sage announced their intention to release more regular feature updates, rather than Annual releases followed by multiple service packs.

Following up the successful summer release, which saw the much requested features such as an Invoicing Module and Hiding Customer/Supplier accounts, this week saw the release of the Sage 200c Winter 2017 Enhancement.

This release introduces the meaning of ‘c’ in Sage 200c and that is Connected (not cloud!!!)

There are further enhancements to the Sage Bank Feeds function, with the introduction of ‘Rules’. So if there are common transactions which are not picked up until the point of bank reconciliation you can set rules so the Bank feeds will post these automatically, instead of you having to manually identify and enter them.

There are further improvements to Office 365 integration, with Sage contact. This is in the form of an App/plugin for Office 365 which allows users to view key account information from within Outlook. This includes Balance, Credit Limit, recent transactions, memo’s. My personal opinion is “the jury’s out” on this one. It sounds great, but in reality I am not sure how much it will be used. Possibly the key is how much further Sage take it for future phases of development.

Document storage functionality has been introduced to effectively allow the automated archive of a document, as a .PDF, to a specified location at the point of it being Printed or Emailed. The storage location can be a designated place on the server or, further connecting to Office 365, One Drive. The negative for this is that Sage haven’t made it available to ALL layout types. In particular, it isn’t available for Remittance Advices (which I would have hoped for as there is no re-print option for these).

Budget functionality has seen more enhancements, following on from the summer release. You are now able to specify an Original budget and a Revised budget.

Checks are available within POP Authorisation to ensure the budget is not breached without permission. Validation reports are available if an authoriser decides not to authorise (although the standard ones will need some tweaking to add more detail such as the Item details).

There are a number of fixes as part of this release, these are detailed on the Sage website, follow the link below.

Sage 200c – Fixed Issues

 

 

In line with the theme for much of Sage 200c new features, a long-requested feature by users was a way of “Inactivating” a customer (or supplier) account. Generally, this is because the customer / supplier is no longer traded with, but the account history makes it difficult to archive and purge transactions to get to a position where the account can be deleted (without effecting other account history)

The Amend Account Status screen (Sales Ledger > Sales Accounts > Amend Account Status) has two new fields, so not only allows you to place an account ‘On Hold’ but also to change its Active status to Hidden, and specify a reason.

Accounts Status

The ‘On Hold’ functionality is the same as in previous versions, so you can tick the box to suspend an account and stop new transactions from being entered for it.

The active status is designed for an account which you do not want to use on a more permanent basis. For example, if an account is no longer trading. By selecting ‘Hidden’ this removes the account from the Customer/Supplier list accordingly and prevents the account from being selected for transactions in error.

NB. You can hide an account at any time, even if it still has a balance so care should be taken before deciding about if to hide it.

If a user hides an account in error, you can still choose the account from the ‘Account Status’ screen and set its Active status back to ‘Active’.

How to view ‘Hidden’ accounts

  • Customer (or Supplier) Account Enquiry – Hidden accounts are included on the look up list for this screen. So, you can view the account details of any hidden account.
  • Accounts Not Activereport – New reports have been added to the Sales and Purchase Ledger (Reports > Account Analysis) so you can print a list of hidden accounts.
  • List of Accountsand Account Details reports (Reports > Account Analysis) – You can choose whether to include hidden accounts on these reports.

Viewing ‘Reasons’ for hidden accounts

A new report called Accounts Not Active has been created and can be found in the Reports > Account Analysis area for the Purchase and Sales Ledgers. These reports display the ‘Reasons’ field from the Account Status screens.

New transactions on hidden accounts

Transactions that can be accessed without selecting a customer account can still be processed against hidden accounts. That is:

  • If the account has outstanding invoices or sales orders, these can still be selected and processed from the Invoicing and Sales order lists.
  • Direct debits / standing orders can still be processed.

You should check these transactions as part of your process to make an account ‘Hidden’.

 

 

 

 

 

 

 

 

 

It has been roughly three months now since the release of Sage 200c. As we are beginning to roll this out for new and existing sites, I looking closely at the new features, how they work and user opinions.

There were a number of new features based on user requests for improved functionality and also bringing in features familiar to Sage 50 users. The first feature we will look at is the new functionality for adding Purchase Invoices, Rapid Purchase Entry.

No features around entering Purchase Invoices have been removed/replaced but Sage 200c introduces a Rapid Purchase Invoice entry screen. This is like the batch entry function within Sage 50 and brings a quicker way of entering multiple purchase invoices into Sage 200. Each invoice is entered on a separate line of a grid based form, and you can enter multiple invoices for different suppliers.

The screen is designed in such a way that it not only allows users to enter multiple invoices quickly (rather than saving after each one), but also to add information into the screen quickly too. This is helped by the grid format (rather than moving to different fields and sections) and Hot Keys which give users a quick way of doing things such as copying information from a cell above, deleting a line or calculating the Net value (if you only know the Gross).

Attached here is a step by step guide which you can download Sage 200c – Rapid Purchase Entry

Service pack 3 has now been released for Sage 200 Extra 2015. There are a number fixes included as detailed in Sage 200 Extra 2015 SP3 Issues Fixed .

Sage 200 Manufacturing

Stock Projection Details

Some changes have been made to improve compatibility with Windows 8, Windows 8.1 and Windows Server 2012, these changes also make a consistent look and feel with other areas of Sage 200 Extra.

As a result of these changes, the following graphs are no longer available:

• Graph tab on Stock Projection Item Details

• Graph tab on Monitor Operation Times

• Histogram tab on Monitor Operation Times

The changes also prevents some workspace options (for example, opening, saving, Copy to Clipboard, print and the tools to change the display of the charts).

MRP – Unable to amend the first recommendation on the system

When the user runs MRP within Manufacturing for the first time, the MRP numbering sequence runs from MRP000000, rather than MRP000001.

As a consequence of this, the first recommendation will not be selectable on the MRP Recommendations form.

To renumber the recommendations you must run the MRP twice on a new dataset, before actioning or maintaining any recommendations.

Subsequently, MRP need only be run once.

Sage 200 Suite Tools

Sage 200 2015 SP3 uses a new version of ManufacturingCSVFileConversion.exe

If you attempt to use the previous tool, the following message appears:

Error launching application. Could not load file or assembly ‘Sage. Manufacturing, Version – 17.0.0.1’.

 

Yesterday finally saw the release of the much-anticipated Service Pack 2 for Sage 200 Extra 2015.

One of the key items as part of this is the support of Windows 10 operating system.

There are lots of fixes and some additions as detailed in this document released with the update –

Reports

There are some New Reports to be aware of which are not installed automatically as well as Layout updates too. Check these out with your BP. The introduction of the SOP Profitability reports which include Returns and Credit Notes will be music to some people’s ears, although if you needed this previously you have probably had the report written already.

There also some nice Stock reports, offering different views of Sales by Customer, Product Group and Monthly Sales etc.

Summary Screens

My particular favourite addition in this service pack is the added drill down functionality to the Summary screens. Previously a great visual aid (and Sage Sales Persons dream!) they were not altogether complete from a ‘day to day’ point of view. However we are now able to drill all the way down to the transactional items which makes them much more beneficial as an analysis tool.

Sales Summary Outstanding Debt (Totals)

Sales Summary Outstanding Debt (Totals)

 

Sales Summary Outstanding Debt (Drill down to Customers)

Sales Summary Outstanding Debt (Drill down to Customers)

 

Sales Summary Outstanding Debt (Drill down to Transactions)

Sales Summary Outstanding Debt (Drill down to Transactions)

Installation

Service Pack 2 can be applied to sites running either the Base version of Sage 200 Extra 2015 (all SP1 updates are included) or sites with Sage 200 Extra 2015 Service Pack 1.

As with Service Pack 1 there are two installation files:

  • Sage200v2015SP2ClientPrerequisites.exe
  • Sage200v2015SP2.msp

On client machines, both files must be run in the order listed above.

Sage200v2015SP2ClientPrerequisites.exe checks the client files to ensure the correct registry keys are present on the machine.

Sage 200v2015SP2.msp updates Sage 200 Extra.

NB. On a server, you only need to install the Sage 200v2015SP2.msp file.

As ever this Sage 200 Extra 2015 SP2 Installation and Release Notes document gives all the information needed to install the service pack.

 

Short, important post!

Microsoft have now released Windows 10. Please be aware that this is NOT supported for any current versions of the Sage 200 suite.

All being well Service Pack 2 for Sage 200 Extra 2015 will include Windows 10 compatibility. This is currently scheduled for 30th September 2015.

 

I have hit this issue on my last couple of installations where the Core components fail to install when accessing Sage 200 2015 System Administrator. Sage have identified this as being an issue which relates to virtual environments (which both of my examples were).

When you access System Administration for the first time after install, various messages appear throughout the initialisation, including those referring to the core components and the building of models. You may notice the system freeze during this.

The issue relates to the available resource on the machine. Clearly the virtual environment must meet the minimum System Requirements for Sage 200 2015. For standard single-server environments, this requires at least a dual-core processor and 4GB of RAM.

Interestingly for my examples the servers should have been fine, however the memory was set to be Dynamically allocated and for some reason was remaining below 4GB. Once this was changed to a Static amount, well above the minimum, the core components installed correctly.

After upgrading a Sage 200 site to Sage 200 2015, an error message may be displayed when accessing System Administration for the first time. The message advises of an error in XML document (9, 3).

 

This is caused by not removing any Add-Ons before commencing the upgrade to Sage 200 2015.

Previously, the Add-Ons could be uninstalled in System Administration but when you try to remove the Add-Ons , the below error is displayed.

Exception has been thrown by target of an invocation

This is because in Sage 200 2015, the schema version number has changed so the Add-On trying to be removed does not have the expected schema number assigned to it and so can’t be removed.

In order to complete the upgrade:

Note: You must take a backup of the Sage 200 Configuration Database before proceeding.

  1. Close any errors and select the Add-Ons option in the left pane.
  2. Make a note of the name of each Add-On installed on the site.
  1. Backup the Sage 200 Configuration Database before proceeding.
  1. Open the configuration database in Microsoft SQL Management Studio and open the tblAddon table.
  2. Look for the Add-Ons that were noted in Step 2 in this table. For each add-on, make a note of the AddOnID in the first column.
  3. Remove the entries from the table for each of these add-ons. This should leave only the standard Sage 200 entries in the table, for example, Sage 200 Accounts, Sage 200 Bill of Materials, Sage 200 Accounts Compiled Model.
  4. Close Microsoft SQL Management Studio and re-open Sage 200 System Administrator.
  5. The core components should now install successfully. You will then need to reinstall any applicable Add-Ons, ensuring first that they have been re-compiled for use with Sage 200 2015.

Sage 200 2015 Service Pack 1 is now available.

Business Partners should note the different method of installation on Clients.

This service pack contains two files:

  • Sage200v2015SP1ClientPrerequisites.exe
  • Sage200v2015SP1.msp

On a client PC both files must be run, in that order, to ensure the service pack installs correctly.

Sage200v2015SP1ClientPrerequisites.exe checks the client files and ensures that the correct registry keys are present on the client machines. Sage 200v2015SP1.msp updates Sage 200 Extra. Failure to run the files in this order will cause errors when you try to run Sage 200 Extra 2015.

On a server, you only need to install the Sage 200v2015SP1.msp file.

Sage 200 Extra 2015 SP1 Installation and Release Notes

The following Known Issues have been resolved in Service Pack 1.

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

Sage 200 Extra 2015 SP1 Feature Updates and Issues Fixed gives some further details of items included in this update.