Views Reply Votes
Grace Zha
Grace
 0
Can't inactive COST CENTER
96
1
0 (0 Votes)
Posted: Aug 10, 2017   
Votes
Kevin Wang
Kevin
 5
Replied 

Hi Grace,

 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

no-lock,

each company where postingline.company_id = company.company_id no-lock :
disp companycode postingvoucher posting.postingdate journalcode .
end. 

--

 

 

0 (0 Votes)
Replied: Aug 22, 2017
Forums
All
Forum Help
Help Using Forums