Hello,

I will update distribution history data.
We use Informix 7 database on Baan IV. To update data I will use a SQL-statement
directly.
I updated the Field t_creg (region) in customer basic data.
Now I will update history to correct the reports of distribution statistics.
Using statement like

update history_data
set t_creg = '01'
where customerno in (select customerno from customers where t_creg = '01');

I changed deliveries but there ist no effect on statistics??
Do someone know the correct or another table name I have to update?
Are there following steps I have to do?

Please help!!!

best regards
sportingt

Hello,

I will update distribution history data.
We use Informix 7 database on Baan IV. To update data I will use a SQL-statement
directly.
I updated the Field t_creg (region) in customer basic data.
Now I will update history to correct the reports of distribution statistics.
Using statement like

update history_data
set t_creg = '01'
where customerno in (select customerno from customers where t_creg = '01');

I changed deliveries but there ist no effect on statistics??
Do someone know the correct or another table name I have to update?
Are there following steps I have to do?

Please help!!!

best regards
sportingt

Hello,

sales statistic is based on sales history.
Used tables in BaaN IV are tdsls050 for header and tdsls051 for lines.

purchase statistic is based on purchase history tdpur050 and tdpur051.

Regards

Thank you for answering,

I updatet tdsls040 and tdsls050 but there is no effect!?

We use Programm tdsst0401 for printing statistics.
Are there another steps to do?

best regards
sportingt

Only update the sales history tables (sls050/sls051) has no effect for already processed data from the history tables in the statistic (tdsst) module.

Please check the help for option "Full Update" in session tdsst0201m000 "Update Sales Statistic".


Regards,
Juergen