[Cobo] FW: GL Quick Tips

[LeFlore, Bobby]

-----Original Message-----
From: owner-core-general at youroklahoma.com
[mailto:owner-core-general at youroklahoma.com]On Behalf Of
jeanie.robards at osf.state.ok.us
Sent: Thursday, June 03, 2004 4:26 PM
To: core-general at youroklahoma.com
Subject: GL Quick Tips






Communication Liaison;

The following General Ledger Quick Tips will be helpful to both GL and AP
end users.


1)    Deposit Form to Office of State Treasurer's
      -Ensure in the Department field there is a leading "0"
      Hint:  If using excel to enter the information, make sure the cell
format is set for text
      -Ensure in the Business Unit field, (if your agency number is less
      than 100), there is a leading 0.  For example Business Unit 04900.
      Hint:  If using excel to enter the information, make sure the
Business Unit cell is set for text.

2)    Wild Cards (%) and Underscore (_) to use in the Inquiry Panels:
      Examples for chartfield Account:
      % 20= All Account values ending with "20"
      2% = All Account values beginning with "2" (all Liability accounts)
      __20% =All Account values with "20" as the 3rd and 4th digits

3)    Journal entries Status
      Hint: Run Review Journal Data inquiry to find and clear Journal
Entries that have not posted.
      D =   Deleted - anchor jrnl unposted
      E =   Journal Has Errors
      I =   Posting Incomplete-Repost ASAP
      M =   Valid SJE Model -- Do Not Post
      N =   No Status - Needs to be Edited
      P =   Posted to Ledger(s)
      T = Journal entry Incomplete
      U = Unposted
      V =   Valid Journal - Edits Complete
      Z =   Upgrade Journal - Can't Unpost

Jeanie Robards
CORE Project
3812 North Santa Fe, Suite 100
Oklahoma City, OK 73118
Phone: 405 962-2420
Fax:      405 524-9983
E-Mail: Jeanie.Robards at osf.state.ok.us