SMART Messages

SMART Logo

 
DATE December 3, 2012
Module GL
Subject Query changes

The following queries and report have been changed. The query/report change(s) are listed below:

Query - KS_GL_ACTUALS_DETAIL

Query - KS_GL_ACTUALS_DETAIL2

Modified prompt heading text to include wildcard symbol (%) to remind users that the fields cannot be left blank.

Query - KS_GL_ACTUALS_DETAIL

Query - KS_GL_ACTUALS_DETAIL2

Query - KS_GL_ACTUALS_DETAIL_INCL

Query - KS_GL_ACTUALS_DETAIL2_INCL

Modified criteria in each query to use JOURNAL_DATE instead of FISCAL_YEAR and ACCOUNTING_PERIOD to make the time frames consistent for all of these queries.

Report - Trial Balance By Fund

Removed requirement in the criteria to pull only Active funds. All Active and Inactive funds now show in this report.

Query Descriptions:

KS_GL_ACTUALS_DETAIL -- Shows detailed journal information such as transaction ID, Vendor ID, Vendor Name and Budget Date by Expenditure and Revenue Account Types posted to the ACTUALS Ledger. The results do not include BI (billing) or CA (contracts) transactions.

KS_GL_ACTUALS_DETAIL_INCL -- Shows detailed journal information such as transaction ID, Vendor ID, Vendor Name and Budget Date and INCLUDES ALL Account Types posted to the ACTUALS Ledger. The results DO NOT include BI (billing) or CA (contracts) transactions.

KS_GL_ACTUALS_DETAIL2 – Shows detailed journal information such as transaction ID, Vendor ID, Vendor Name and Budget Date for the Expenditure and Revenue Account Types posted to the ACTUALS Ledger. The results ONLY include BI and CA transactions

KS_GL_ACTUALS_DETAIL2_INCL -- Shows detailed journal information such as transaction ID, Vendor ID, Vendor Name and Budget Date and INCLUDES ALL Account Types posted to the ACTUALS Ledger. The results ONLY include BI and CA transactions.

SMART Team

 

 

Quick Links

Search the Site

Contact Us

Send us an email

Sign Up

Sign up for the SMART InfoList