Category: Sage 200


The new versions of Spindle Professional have been released and are now available to download.

Spindle Professional 5.87 includes
support for Sage 200 2013 R2 On Premise and Online.

Originally posted on Journey to SQL Authority with Pinal Dave:

[Notes from Pinal]: I am working with SQL Server for almost 10 years. I have seen the most ignored databases on any database server is system database. We hardly pay attention to them. Just for the sake of it – try to run queries in your master database and see how many user databases already exists there. I am sure unless and until you have strict policies in the place, there will be a handful of the tables available there. Similarly try to ask DBA question about what is the exact importance of the MSDB database and you will find it that there are so many of the DBA without its knowledge. I often talk about this with my friend Tim. I asked him if he can help us out  with the tricks to keep MSDB system database at its optimal settings.

Linchpin People are database coaches and…

View original 418 more words

Originally posted on Journey to SQL Authority with Pinal Dave:

When we have to move a database from one server to another server or when we have to move a database from one file to another file, we commonly use Database Attach or Detach process. I have been doing this for quite a while as well. Recently, when I was visiting an organization I found that in this organization lots of developers are still using an older version of the code to attach the database. I quickly pointed that out to them the new method to attach the database, however it was really interesting to find out that they really did not know that sp_attach_db is now a deprecated method to attach the database. This really made me to do today’s SQL in Sixty Seconds. I demonstrate in this SQL in Sixty Seconds how to attach or detach the database using a new method of attaching database.

The code which…

View original 220 more words

Originally posted on Journey to SQL Authority with Pinal Dave:

There are multiple reasons why a user may want to make a copy of the database. Sometimes a user wants to copy the database to the same server and sometime wants to copy the database on a different server. The important point is that DBA and Developer may want copies of their database for various purposes. I copy my database for backup purpose. However, when we hear coping database – the very first thought which comes to our mind is – Backup and Restore or Attach and Detach. Both of these processes have their own advantage and disadvantages. The matter of the fact, those methods is much efficient and recommended methods.

However, if you just want to copy your database as it is and do not want to go for advanced feature. You can just use the copy feature of the SQL Server. Here are the settings, which you can…

View original 122 more words

‘Login failed for user ‘.’ Please run System Administration to check company settings.’ error

2013 - Login failed for user

Check the following points:

  • Ensure the Windows user has been linked to the relevant Sage user in System Administration.
  • The Windows user, e.g. ‘JohnBull’, has been included as a user in the ‘Sage Users’ group which is set up as part of the installation process.
  • Check that the ‘Sage Users’ and ‘Sage Administrators’ groups have sufficient permission to access the Sage shared folder (by default, C:\Sage).
  • The ‘Sage Services’ user set up as part of the installation process must have sufficient security permissions on the Sage shared folder.
  •  IIS v8 only – Ensure ‘HTTP Activation’ has been enabled within .NET 4.5 as per the below:

2013 - Login failed for user_IISv8HTTPactivation

I am a bit late posting about this. But at the beginning of April Sage 200 2013 R2 was released.

This isn’t a simple Service Pack, and should be treated as a “New Release”. The key thing here is the introduction of some new features, as well as bug fixes and roll up of fixes from Sage 200 2013 SP1. That said this is the only version of Sage 200 2013 that will now be shipped.

The issues fixed are documented in Sage 200 2013 R2 Release Notes released by Sage.

Please also be aware of updates to the ‘Deployment and installation Guide’ and the ‘System Requirements’.

Part of this release see the introduction of functionality which allows you to analyse Stock Item Sales Order Lines, to Projects. This is quite exciting for me, as I was actually involved in the first workshop at Sage Newcastle, to brain storm how this would work. So to see it come to life some 4 may be even 5 years later is brilliant.

 

Ctayts

 

 

Sage Business Blog – Guest Blog

Check out my guest Blog on the Sage Business blog!

This is about Mobility, and how Technology now makes it possible to run your business on the move. Sage 200 2013 is a great example of this.

Will that be to go?

Ctayts

Licencing for Sage 200 has changed for 2013.

There are now two licencing options for Sage 200. A subscription option allows you to pay monthly for your use. This is available to both Online and On Premise deployment options. For On-premise there is also the perpetual licensing that there has been for previous versions.

As well as the way you can can pay, there are also more types of user available. There is the option of a Full Sage 200 user or Web user licences (NB. Full users also get access to the Web/Self Service user). For CRM users there is also the CRM User and Suite user options still available.

The way we enter Licences has also changed. Gone are the days of typing out 24 blocks of 5 letters. Licences will now be activated using your account and serial number. These numbers are entered within the System Administration, which launches an automated system (online) that links to Sage’s internal systems. The details are authenticated in order to allow you to licence the system by selecting a licencing button.

Licences are stored in an  XML certificate.

If for some reason you do not have an Internet connection, there is a manual option available.

If you Right Click on ‘Licence’, in System Administration and select ‘Generate Licence Request’. A licencerequest.xml file is generated. This can be manually emailed to Sage, who will send the XML file back, to be imported into System Administration.

One of the key elements of Sage 200 2013 is the choice of deployment that it offers. Companies can now choose between an On-Premise and an Online (Cloud) deployment.

Cloud ERP solutions are becoming a serious option for companies. This is increasingly due to the savings they can make on infrastructure requirements such as the latest Hardware, Security and Backup systems. In the past, companies have been wary about how secure Cloud solutions are, as their key business data is involved. But Cloud solutions (generally) have much more sophisticated security and data recovery systems than what business can implement internally.

Sage 200 2013 Online has no upfront expenses for hardware just a single monthly subscription fee. You pay for what you use and there is more flexibility than before to add and remove users or modules.

With Line 100 becoming end of life in April 2014; Sage 200 online offers more companies an affordable upgrade option without the loss of key functionality, as now there is an upgrade option for Sage 200 without the added costs of new servers and other required components such as Microsoft SQL server.

For certain businesses it can still make sense to invest upfront, They may wish to keep data in-house and have the resources required to invest in technology/infrastructure as well as continue ongoing maintenance.

On-Premise has all the same functionality as Online, but the addition of modules which are not currently available to the online option. Therefore the requirements ofa company may dictate which option they can go for. For example if a Manufacturing solution is required, the On-Premise deployment would need to be implemented.

MODULE

ON-PREMISE

ONLINE

Financials

YES

YES

Commercials

YES

YES

BI

YES

CRM

YES

Project Accounting

YES

YES

WTE

YES

YES

BOM

YES

YES

Manufacturing

YES

This document from Sage gives further details about the differences between Sage 200 2013 On-premise and Online.

Sage 200 2013 ON PREMISE

It’s finally arrived after months of anticipation.

Today sees the launch of the ON PREMISE release of Sage 200 2013. This follows on from the online version which was released in July.