Category: Sage 200


I have recently started looking into and working with a number of the great Sage 200 add-ons available from Eureka Solutions.

Eureka Solutions have created a large portfolio of add-on’s which make Sage 200 even better than it is.

What can often happen during a Sage 200 implementation is the need to fulfil a GAP in customer requirements, which Sage 200 doesn’t do itself. This is then fulfilled with bespoke development which can have huge knock on effects to the project in terms of time frames and costs.

What Eureka Solutions have done is identified and filled a lot of the more common (and often basic/obvious) gaps. In particular differences between Sage 50 and Sage 200, speed of order entry, ease of creating new records such as Stock items, and customers.

As well as this they have identified industry specific requirements to suit Retail, Telecommunications and Wholesale (to name a few).

So the question that I ask is why would you recreate something that already exists as an ‘Out of the box’ solution? My recommendation is that you shouldn’t. Especially considering there are no additional costs when it comes around to upgrading as recompiles are done as part of support.

A free ‘Starter Pack’ of Sage 200 add-ons is available. This can be installed and used at no cost and gives access to 10 functions such as creating a New Stock Item during order entry, creating a New Customer during order entry, the ability to save and despatch a sales order and create a Return from a Sales order.

Most recently I have been working with the Stock Alias, Stock Kitting and Data Exchange products.

Stock Alias (part of the plus pack for Sage 200) allows you to set up additional codes to identify stock items. Ideal if your Sage 200 Stock Code is different from say your Website code, the SKU in EBay or some other form of identification.

Stock Kitting is much more like the Sage 50 BOM. It is Ideal for kit type products as opposed to items that are assembled or manufactured. For example you sell individual items such as Dinner Plates, Side Plates, Dessert Bowls and Mugs but you also sell these together as part of a Dinner Service of 6 of each individual item.

The Standard Sage 200 Stock record has an extra tick box to identify an item as a kit. Selecting this enables a Kitting tab where the individual parts and their quantity in the ‘Kit’ can be specified.

Finally I have been using Data Exchange, something which I have had experience of using before. This allows for an automated Export and/or Upload functionality for exchanging data between Sage 200 and other systems such as Websites. With my current project we are using plugins that link Data Exchange to EBay and Amazon accounts and extract orders from these to then import into Sage 200.

As I say, more to come on the specific functions available, but what I enjoy about these products is they are simple to use, quick and easy to set up and they are not over complicated in any way.

Ctayts

A question that often makes us shiver is when a Sage 200 user poses the question “How do I make my Stock Control reconcile to my Nominal Ledger?”

Now, its not often helped by it being the first time in Months, Years or maybe ever, that they have tried to reconcile.

However, it is an area that I cannot help but admit is not easy. There are a mass of variables that impact on this subject. Costing method, Stock Settings, POP Settings, SOP Settings, Nominal structure………and so on……

I have created the following document which details the settings that need to be considered, some common errors and some Sage 200 functional issues that should be considered.

Enjoy, and good luck!

Talking Sage 200 – Stock Reconciliation Checks

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.