Announcements - Reporting

FY 2017 GL and KK Queries are available

The FY 2017 GL (General Ledger) expenditure and revenue queries and FY 2017 KK (Commitment Control) expenditure, encumbrance and revenue queries are now available.

The following information is pulled directly from the Catalog of SMART Reports, Queries and Inquiries.

Report/Query/Inquiry Name

Type

Description

Navigation in SMART / DW

KS_GL_ACTUALS_EXP_FUND_BU_FY##

Query

Shows expenditures posted to the actuals ledger by Fund, Budget Unit, Fiscal Year and Accounting Period at the Close of SFY##.

Reporting Tools -> Query -> Query Viewer

KS_GL_ACTUALS_REV_FUND_BU_FY##

Query

Revenues and Transfers by Fund, Budget Unit, Program, and Account. Prompts for Bus Unit, Fund, Budget Unit, Fiscal Year, Accounting Period at Close of SFY##.

Reporting Tools -> Query -> Query Viewer

KS_KK_CASH_BAL_DETAIL_FY##

Query

Query of Cash against the CC_CASH and CC_CSH_REV Ledgers by FY, Acctg Period, Agency, Fund, Budget Unit (type 2 only) at the Close of SFY##.

Reporting Tools -> Query -> Query Viewer

KS_KK_EXP_ENC_DETAIL_FY##

Query

Commitment Control Expense Detail including TA & PO encumbrances as well as GL encumbrances at the Close of SFY##.

Reporting Tools -> Query -> Query Viewer

KS_KK_EXPENSE_DETAIL_FY##

Query

Commitment Control Expense Detail at the Close of SFY##.

Reporting Tools -> Query -> Query Viewer

KS_KK_LEDGER_FY##

Query

Commitment Control Query to capture detail out of CC_APR_%, CC_DET_%, CC_IBR_%, CC_OPR_%, CC_OPD_%, OR CC_RVD_% at the Close of SFY##. Allows you to limit your search by Dept Id and/or Fund.

Reporting Tools -> Query -> Query Viewer

KS_KK_PROJECT_FY##

Query

Commitment Control Project Detail at the Close of SFY##.

Reporting Tools -> Query -> Query Viewer


A job aid for the KS_KK_LEDGER_FY## query can be found on SMART web under KK queries in the Commitment Control section: http://smartweb.ks.gov/training/commitment-control-kk