we tried to inactive one cost center 9999, and the system says below :
Cost Center 9999 cannot be deactivated, until there are pending postings in Transient layer which can be transferred into Official layer.
we find some things in GL transactions view , we found some cost center is equals to 9999 but with Official Layer ,not Transient layer .
Could you please give me a solution? Thanks !
Would you copy & paste below query in menu 36.25.80 Progress Editor - Click F1 button to run to
double check if 9999 cost center used in any journal entry ?
it will list you the Entity code,Voucher,Posting Date,Daybook.
for each costcentre where costcentrecode = "9999" no-lock,
each PostingLine where PostingLine.CostCentre_ID = costcentre.CostCentre_ID AND true no-lock,
first Posting where Posting.Posting_ID = PostingLine.Posting_ID AND true no-lock,
first Journal where Journal.Journal_ID = Posting.Journal_ID AND true no-lock,
first Layer where Layer.Layer_ID = Journal.Layer_ID AND Layer.LayerTypeCode = 'TRANSIENT' AND true
each company where postingline.company_id = company.company_id no-lock :
disp companycode postingvoucher posting.postingdate journalcode .