Deactivate distribution rule

[too_muihwee]

Hi,

I am trying to deactivate a distribution rule, i am using V9.1 PL10 HF1, i got this error. There are some cost centers in this distribution rule that having Effective date from and to (which is already ended) but Active checked box is still ticked.

For this Distribution rule that I am not able to deactivate, the Effective from is 1/4/12, and Effective to is blank.

Most of cost centers in this rule having effective from 1/4/11, effective to is blank, just one or 2 cost centers having effective from 1/4/06 and effective to is 31/3/13 but active checked box is still ticked.

Must all cost centers in distribution rule have to be same effective from and to? Some cost centers might be inside few distribution rules, so a bit difficult to align all. Hope someone is able to answer my problem, thanks.

[agustin_marcoscividanes]

Hi

if you do not define "effective to" date in cost center, the cost center is active.

To inactive one rule, define "effective to" date in cost center and try again.

Kind regards.

Agustin Marcos Cividanes

[too_muihwee]

Hi Agustin,

When I define 'effective to' date, I got the error that 'Cannot update a distribution rule used in transactions'

Any idea where can I check? Any query?

[agustin_marcoscividanes]

Hi

do you have transactions with future date?

can you deactivate first the cost center?

Kind regards

Agustín Marcos Cividanes

[too_muihwee]

When I tried to change one of the cost center's Date To (shorten it), encounter the first error message.

I suspect is that cost center causing the error, however, I have no idea where to find any pending data as the range is too big. Possible due to open PO, SO? or Invoice/CN/ or JE, there are just too many transactions to check. Any idea where can I narrow down to check?

[too_muihwee]

Anyone can help?