Archive for October, 2014


When the first Sales order line of a Sales Order has a zero value and no Nominal analysis but further order lines do have Nominal analysis, the  nominal drill down within the SL Transaction enquiry shows the Narrative ‘Intended For -//’

  1. Create a Sales Order with a Free text line with a zero value and no nominal analysis.
  2. Add a second and third order line with Nominal analysis
  3. Save the order and process through to completion (post the invoice).
  4. Within the Sales Ledger open the transaction enquiry for the selected customer and highlight the Invoice
  5. Select the Nominal Drill Down and see the narrative. All lines show ‘Intended for -//’

My occurrence was due to the user using the Free Text line for a comment/note. This is what the Comment line is intended for. The alternative is to enter the Free Text Line at the end.

Advertisements

When logging in to Sage 200 the following error will occur due to certain Authentication settings being configured incorrectly. The error will only be on the clients machines. Logging in to Sage 200 on the server will not cause this error.

Communication Error

IIS Windows authentication settings

  1. Within IIS, expand Sites > select Sage 200 App Services > double-click the Authentication icon in the Features area.
  2. Select Windows Authentication. Ensure this is set to Enabled. If not, select Enable in the Actions panel on the right.
  3. Also in the Actions panel, select Advanced Settings…
  4. Ensure the checkbox for ‘Enable Kernel-mode authentication’ is ticked > OK.
  5. Reset IIS

IIS Anonymous Authentication settings

  1. Within IIS, expand Sites > select Sage 200 App Services > double-click the Authentication icon in the Features area.
  2. Select Anonymous Authentication.. Ensure this is set to Enabled. If not, select Enable in the Actions panel on the right.
  3. Also in the Actions panel, select Edit…
  4. Ensure ‘Specific user’ is selected > Set…
  5. Enter the fully qualified Sage 200 Services username and password. This is the username and password you specified during the installation of Sage 200. For example, <domain>\Sage200Services.
  6. Press OK and reset IIS.

LAN Manager Authentication level

  1. Select Start > Control Panel > Administrative Tools > Local Security Policy.
  2. Double-click the Local Policies folder and select Security Options.
  3. From the list of policies, double-click ‘Network security: LAN Manager authentication level’.
  4. From the drop-down list, select ‘Send LM & NTLM – use NTLMv2 session security if negotiated’ and select OK.

If the error persists…

  • If you are using a Workgroup, password protected sharing will cause the above message to appear. This should be turned off within the Control Panel > Network and Sharing Centre > Change Advanced Sharing Settings.
  • Ensure the server that hosts the Sage 200 Web Services has been added as trusted site within Internet Explorer Options. You can access this within Internet Explorer > Tools > Internet Options > Security tab > Trusted Sites > Sites.

Where an IIS reset is required above, all users must be logged out of Sage 200 and indeed any other system which use’s IIS.

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