David Eagar
10th March 2006, 04:46
Scenario
We wish to present Rebates in Sales Statisics in the period when the sales order was invoiced. Currently they appear in the period when the 'Update Sales Statistics' is run.

A few questions:

Is anybody else running with this sort of setup? If so, what steps are required?

Which session updates rebates into tddsst012 (sales stats master file)? If it is 'Update Sales Statistics', surely this must make Month End a nightmare - it takes so long!

Any help appreciated

Andreas
10th March 2006, 15:15
Which session updates rebates into tddsst012 (sales stats master file)? If it is 'Update Sales Statistics', surely this must make Month End a nightmare - it takes so long!

Hi David,
first, yes it is 'Update Sales Statistics'.
second, we do it every night in a job.
Why takes it so long? Do you perform a full update? Then it will indeed take a very long time. We make our update with the flag actual Customer data which only updates the changes since last update, so in our case only the data entered the last day. This works correct for almost 3 years now.

Andreas

David Eagar
11th March 2006, 23:17
Indeed you are right - we do the same thing, so actually I have no issue at all. Other than getting the rebates to appear in the right period
Thanks