joe wrote:One question RodW.
What do you mean with a drill down on the Customer Maintenance to the transactions. Isn't a link just sufficient?
/Joe
Yes, I think a simple link to the Customer Transaction Enquiry screen would be sufficient that was pre-populated with the customer name in the "Select a Customer:" prompt. Personally, I think the default date range should be set to more than one months data, probably the last 12 months or to the start of the current fiscal year.
joe wrote:You are right RodW, regarding the fields you mentioned to go to the default contacts on the Customer/Branch.
I will have to add them too.
/Joe
That would be great Joe.
Just one more thought. While you are mucking about with the customer screens, I wonder if it would be worth adding a couple of sales totals and even current balances as that is probably something that is sorely missing. Simplest would be a table of total sales for fiscal year in the system, eg for me:
Balances Total Current 30 days 60 days 90+ days
$ $ $ $ $
Sales
2011/12 $
2010/11 $
2009/10 $
Bells and whistles would be to present an array of monthly sales for each fiscal year. eg for me:
Balances Total Current 30 days 60 days 90+ days
$ $ $ $ $
Sales Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Total
2011/12 $ $ $ $ $ $ $ $ $ $ $ $ $
2010/11
..
The link to the Customer transactions could be the fiscal year label which would set default values for the date range
Sorry to keep adding to your todo list but these statistics are not really visible anywhere and most competing systems would show this sort of stuff. It is not really relevant to my current business as there is not much repeat business but in a previous B2B situation it would be vital data.
If you can get these reporting routines established then you would be set to write a customer size report that listed each customer by total annual sales by month from the biggest down. These sorts of reports generally need some $ value filters on total annual sales so that you could set a cutoff at say $500 to limit the data set. Everybody needs to know their top 10 customers .