GLInterface
GLInterface
GLInterface
Version 8.0
DISCLAIMER
Written by MAXIMUS-ERP Solutions Group, March 2004. This training manual is considered to be proprietary and confidential and may not be reproduced for any reason other than stated below without prior written consent of MAXIMUS-ERP Solutions Group.
EXCLUSION
This training manual has been prepared exclusively for the State of North Dakota PeopleSoft Project. Information contained within this document may be used by the State of North Dakota for the sole purpose of personnel training. Additional manuals may be reproduced and edited as needed for training. All other uses are prohibited without prior written consent from MAXIMUS-ERP Solutions Group. Copyright 2004 MAXIMUS-ERP Solutions Group, Inc. All Rights Reserved.
Table of Contents
DISCLAIMER ............................................................................................................................. 2 EXCLUSION ............................................................................................................................... 2 Table of Contents .................................................................................................................... 3 Running the GL Interface Processes..................................................................................... 4 Overview............................................................................................................................... 4 Running the GL Interface ..................................................................................................... 7 Running the Cashiering GL Interface ................................................................................. 14 Validating the GL Interface................................................................................................. 21 Reviewing GL Interface Messages ..................................................................................... 21 Reviewing GL Interface Messages ..................................................................................... 25 Reviewing Application Message Publish Messages........................................................... 27 Reviewing the Generated Accounting Lines ...................................................................... 32
terms accounting entry and accounting line are synonymous and are used interchangeably in this document. The GL interface process creates accounting lines for all PeopleSoft Student Financials transactions except for departmental receipts. Run the Cashiering GL interface process to create entries for departmental receipts and any over and short entries required to balance your register (cashier) at days end
A. The first time this process is run a new Run Control ID will need to be created. Click on the link, enter the run control ID of GL_INTERFACE and click the button. B. For future use of the GL Interface program click the control or just input the run control in the field. button to select the run
2. A. B. C.
Enter to GL Interface process parameters. Enter your Business Unit. Always select a Journal Template of STUDENT. Enter the Term for which you want the interface to run. The system selects all GL records less than or equal to the term code you select here. It is recommended that you select a term such as 0910, so that this value will not need to be updated and GL transactions will always be generated for all terms.
3. Initiate the process. A. Click the button. The following page will be displayed.
B. Select the Server Name of PSNT. C. Select the GL Interface 8.4 process by clicking in the check box. D. Click the button and you will be returned to the previous page.
Note that this is a PeopleSoft Job, which contains multiple definitions. Therefore more than one process instance number has been generated.
4. To make sure your GL Interface was successfully processed, click on Process Monitor. The following page will appear.
10
A. To ensure the process ran successfully, you will want to confirm that the Run Status displays Success. B. If necessary, you can view additional information regarding the process by clicking on the Details link.
11
link.
12
D. This message just verifies that the full process has successfully run. If the process had not been run successfully you might have to restart the process and run it again. NOTE: The fact that a Success message was generated does not mean that the process had the expected results. It simply means that it executed all of its code without failing. You should always verify that the process had the expected results through inquiry panels in the application.
13
A. The first time this process is run a new Run Control ID will need to be created. Click on the link, enter the run control ID of GL_INTERFACE and click the button. B. For future use of the Cashiering GL Interface program click the the run control or just input the run control in the field. button to select
14
2. Enter to GL Interface process parameters. A. Enter your Business Unit. B. Select the Cashiers Office. You will need to initiate this process for each Cashiers Office at your institution. C. Select the Business Date for which you will be running the process. This process will need to be run for each day the Cashiers Office has been opened. D. Always select a Journal Template of STUDENT. 3. Initiate the process. A. Click the button. The following page will be displayed.
15
E. Select the Server Name of PSNT. F. Select the Cashiering Interface 8.4 process by clicking in the check box. G. Click the button and you will be returned to the previous page.
16
Note that this is a PeopleSoft Job, which contains multiple definitions. Therefore more than one process instance number has been generated.
4. To make sure your Cashiering GL Interface was successfully processed, click on Process Monitor. The following page will appear.
17
B. To ensure the process ran successfully, you will want to confirm that the Run Status displays Success. C. If necessary, you can view additional information regarding the process by clicking on the Details link.
18
link.
19
E. This message just verifies that the full process has successfully run. If the process had not been run successfully you might have to restart the process and run it again. NOTE: The fact that a Success message was generated does not mean that the process had the expected results. It simply means that it executed all of its code without failing. You should always verify that the process had the expected results through inquiry panels in the application.
20
button and a list of the process instances that generated error A. Click the messages will be displayed. The highest number will be the most recently run process with errors. B. Click on the process instance ID to view the error messages associated with the process. The following page will be displayed.
21
22
3. Research Debits Does Not Equal Credits Message A. The most common error is the Debits Does Not Equal Credits. This is generally due to credit being applied to a charge with missing GL interface. B. Start by identifying the student or external organization that is receiving the error and the transaction id (Item Number) of transaction that is erroring out of the process. C. Navigate the Students (External Organizations) account. The following page will be displayed.
Student Name
D. Use this page to determine the account that contains the un-interfaced item. E. Navigate to the Item Details page to identify the charges to which the un-interfaced credit applied
23
F. View the Detail Transaction page for each of these charges. This will allow you to identify the actual charge item types. G. Navigate to the item type set up for these item types and verify all of the required accounting information is specified.
24
A. Enter the Cashiers Office for which you are verifying the interface. B. Click the button and the following page will be displayed.
25
2. Review the Messages A. This page will contain a row for each business day that this cashiers office has been opened. B. It will indicate if the Cashiering GL Interface has been run for that business date. C. If the interface has been run, click on the GL Run Error Detail link and the following page will be displayed.
D. If an error message was generated, the detail regarding the message will be displayed. E. The most common error messages resultting from the Cashiering GL Interface process result from accouting information not be set up for either the Cashiers Office or the Tender Types. To correct, make the accounting information on these values has been entered and re-run the Cahiering GL Interface for that business date.
26
A. Enter the Process Instance for which you wish to review the status. B. You can also enter a Process Status to search process in a specific status. Typically you will search for Pending, or un-interfaced processes or those in Error. C. Click the button and the following information format will be displayed.
27
F. All of the process instances that meet your criteria will be displayed. If they show a Process Status of Pending, the accounting information has successfully generated in Student Financials, but has not yet been published to General Ledger. If they show a Process Status of Completed, it means Student Financials has successfully published the lines to General Ledger. If they cannot be accessed on the Financials side there is probably a problem with Application Messaging and a PTR should be submitted. If they show a Process Status of Error, it means the Batch Publish Process has failed and a PTR should be submitted. G. If an error message was generated, the detail regarding the message will be displayed. H. The most common error messages resultting from the Cashiering GL Interface process result from accouting information not be set up for either the Cashiers Office or the Tender Types. To correct, make the accounting information on these values has been entered and re-run the Cahiering GL Interface for that business date.
28
2. View the accounting lines for the process instance you are reviewing. A. O the Process Instance for which you wish to view the accounting lines. B. Click on the . The following page will be displayed.
C. The Main tab displays general accounting line information. It will provide you with information regarding the student and specific transaction that generated the accounting line. D. Click the Detail link next to an accounting line to access the SF Accounting Line Detail page where you can view all fields for the accounting line record. The following page will be displayed.
29
Student Information
E. Click Return to return to the previous page. F. Click on the Journal Info tab and the following will be displayed.
30
G. The fields on the Journal Information tab display the information published from PeopleSoft Financials. The tab also contains the GL journal line number, journal ID, and line date, which are populated with the data returned to PeopleSoft Student Financials through the STUDENT_SF_ACCTG_LINE subscription message after the journals are generated in PeopleSoft Financials. H. Click on the Chartfield 1 tab and the following page will be displayed.
I. The Chartfields 1 and Chartfields 2 tabs show information sent to PeopleSoft Financials. The GL Interface process populates some of these fields depending on what fields you populated during the setup of your item types.
31
32
1. Enter the search criteria required to locate the accounting information you wish to review. A. Select the Student ID to view the accounting lines for a single person. Enter an EmplID in the field to the right. B. Select Receipt Number to view the accounting lines related to a single receipt. Enter the receipt number in the field on the right. C. Select Ext Org to view the accounting lines for a single external organization. Enter the External Organization ID in the field to the right.
33
D. Select Run Date and Sequence Number to view the accounting lines for a specific GL Interface process instance. Enter the date and the sequence number in the fields to the right. E. Select Chartfields to search for accounting lines that coded to a specific chartfield string. Enter as many chartfields as appropriate. NOTE: This section has the potential to pull back the largest number of rows. When selecting lines by Chartfield string only, make sure you enter enough criteria to limit the data retuned to a manageable size. 2. View the accounting lines matching your search criteria. A. Click on the . The following page will be displayed.
B. The Main tab displays general accounting line information. It will provide you with information regarding the student and specific transaction that generated the accounting line. C. Click the Detail link next to an accounting line to access the SF Accounting Line Detail page where you can view all fields for the accounting line record. The following page will be displayed.
34
Student Information
D. Click Return to return to the previous page. E. Click on the Journal Info tab and the following will be displayed.
35
F. The fields on the Journal Information tab display the information published from PeopleSoft Financials. The tab also contains the GL journal line number, journal ID, and line date, which are populated with the data returned to PeopleSoft Student Financials through the STUDENT_SF_ACCTG_LINE subscription message after the journals are generated in PeopleSoft Financials. G. Click on the Chartfield 1 tab and the following page will be displayed.
H. The Chartfields 1 and Chartfields 2 tabs show information sent to PeopleSoft Financials. The GL Interface process populates some of these fields depending on what fields you populated during the setup of your item types.
36
37