We help IT Professionals succeed at work.

Sales Forecasting software

532 Views
Last Modified: 2013-11-15
hi all

can anyone recommend a Sales forecasting tool that there company uses or they have had experience of using in the past? it would need to be able to handle 2000+ products and also have a SQL back end

any advice appreciated

mal
Comment
Watch Question

Act! Evangelist - CRM Consultant
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
no, but im just about to !
Mike LazarusAct! Evangelist - CRM Consultant
CERTIFIED EXPERT

Commented:
Let me know if you need any help with it

Author

Commented:
from taking a quick look at it, it seems to be more of a customer relations management system than a fully fledged sales forecasting tool?

 
Mike LazarusAct! Evangelist - CRM Consultant
CERTIFIED EXPERT

Commented:
Sales Forecasting is one of it's functions

Author

Commented:
ill be honest i know very little on forecasting - but im trying to pre empt what will be needed in the near future when people decide our excel model is no longer up to the job..

we will have 2000 + products to forecast, and around 5 years of historical data to help build a sales profile, plus we are very seasonal - where one good week could send our sales sky high and vice versa, so really i think we need a tool that's primary focus is forecasting
Mike LazarusAct! Evangelist - CRM Consultant
CERTIFIED EXPERT

Commented:
That's ok if you don't want to then be able to identify and report of the forecasts by territory or down do specific customers on a historical basis.

For that, you also need those core CRM capabilities.

What you said is like saying "I don't need Excel because I'll only be adding columns and I don't need a product that can also multiply"

Author

Commented:
yea true when you say it like that! :) as i said i am a little ignorant on the subject!
i have a few questions for you on acts

1)with sage acts, would i be able to integrate it with our current ERP system - Syspro which is SQL based to retrieve customer information such as regions etc or would it involve setting this all up in acts again?

2)would it allow us to create a 12 month rolling weekly forecast for 2000 + products in a stable manner(i mean system performance)

3) is it sql based

4) does it allow for rule creation that can allow us to adjust the forecast on the fly depending on variables such as weather

5) does it allow for categorisation of products eg matching redundant stock codes to newer stock codes for sales profiling  
Mike LazarusAct! Evangelist - CRM Consultant
CERTIFIED EXPERT

Commented:
1. I don't know Syspro... but there are various ways to link ACT! data to SQL data

2. Yes

3. Yes

4. Not something I've tried to do, but I can think of a few ways to do it

5. Not out of the box

Author

Commented:
Cheers for the advice GL, I must give the product more thought and maybe download the demo and have a play with it

Mal
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.