Sage ERP 300 (6.1) Sales Analysis Problem

[drtayao]

Hi Anyone experienced the following problem with Sales Analysis:

1. Sales Analysis is working if the license is unregistered with 30-days expiration but once you registered. The error is "An unexpected error occurred while checking the license. Error #1402."

2. Sales Analysis SQL database not compatible with Latin1_General_Bin, make sure SQL_Latin1_General_CP1_CI_AS (SQL default) your database collation before you activate this module. Once activated Sales Analysis, this program automatic created another SQL database with UNI at the end of the database filename. For example the SAMINC, now the new additional SQL database with name SAMINCUNI is for Sales Analysis only with SQL_Latin1_General_CP1_CI_AS databse collation.

3. Database Dump not included Sales Analysis table.

 

[ettienne]

Sales Analysis is a flaky program. Most companies stopped using it and do reporting from OESHDT (OE sales history detail) using other reporting tools.

1. I suspect your Sage installation folder is the default c:\program files(86x)\sage\sage 300 erp\yada yada?
2. Yes that is so
3. Yes that is so

Sage 300 ERP Certified Consultant

http://www.adssglobal.net

 

[drtayao]

Hi ettienne,

No, the folder loacation is C:\Sage\Sage 300 ERP

 

[Jay Converse]

Error 1402 is a registry reading problem, make sure you install it and run it as an administrator.

 

[drtayao]

Hi tuba2007,

it run as an administrator also applied hotfix HF2101002917_SS2012A but not working.

For item 2 - 3, answered and well explained from Sage Asia.