Resolution

Site's can use reporting views, view are populated by SQL tables. The specific table and fields programs are for Tyler internally and sites should not be using tables.

VIEWS:

gl_master = (current/next year posted sum of MasterBal, memo amounts MasterBal + Proof and other account specific data)
gl_master_history = (prior year sum of MasterBal data)
gl_master_bal equal = (current/next year posted sum of each period)
gl_masterbal_hit = (prior year posted sum of each period)
gl_object = Objects in chart manager and chart of account segments
gl_organs = Organizations in chart manager and chart of account segments
gl_project = Projects of 5 or less characters from project master not flagged as PL only.
gl_journal_proof = (GEN, GCR, GNI, GEL & BUA) unposted proof transactions
gl_history = posted journals equal to journal inquiry/print records.

Browser not supported