Drill to Journal Chartfield

Description

This project contains the code to extend the Journal Entry component to accept chartfields as parameters to drill directly to the journal lines that contain those values.

This can be extremely valuable when trying to navigate to the journal lines you care about (such as drilling from a report to see which journal lines touch your department in a very large journal.

The parameters can be passed by appending parameters to the URL to drill to a page (in this circumstance &ACCOUNT=402000&DEPTID=21600):

 http://www.gsdemo.com/psp/ps/EMPLOYEE/ERP/c/PROCESS_JOURNALS.JOURNAL_ENTRY_IE.GBL?BUSINESS_UNIT=US005&JOURNAL_DATE=2004-03-31&JOURNAL_ID=MKMAR5&UNPOST_SEQ=0&PAGE=JOURNAL_ENTRY2_IE&ACCOUNT=402000&DEPTID=21600

Downloading the Project

Here is how you can download this project for your own use:

The current version of the PeopleTools objects can be installed in your environment using the following attachment . Here are the instructions for how the installers work. Also, at the bottom of this wiki page are attachments for the other revisions in the source code repository.

Any other objects can be downloaded directly from the pshome folder in the source tree

Please note: To enable this project in your environment, you will need to manually copy the following PeopleCode to the PageActivate? event on the JOURNAL_ENTRY_IE2 page.

Bugs/Feature Requests

Existing bugs and feature requests for DrillToJournalCf are here.

If you have any issues, create a new ticket (requires registration).

Source

You can browse through the source code here.

Registered users can check out DrillToJournalCf from  here using Subversion.

Recent Changes

[84] by larry.grey on 2010/07/29 05:26:46

Completed code by accepting any set of chartfield values as parameters.

[83] by larry.grey on 2010/07/29 05:24:38

If journal is editable, then instead of searching, set the cursor position to the row with the passed account number.

[82] by larry.grey on 2010/07/29 05:19:08

Extended to take passed account parameter and use the delivered adjust_line_scroll function (for PeopleTools 8.4x and greater).

Note: to apply this to your journals, copy the peoplecode here to the appropriate PageActivate? PeopleCode in the JOURNAL_ENTRY2_IE page. (previous check-in had bad reference)

[81] by larry.grey on 2010/07/29 05:11:35

Initial Check-in. Sample code to accept ACCOUNT as a parameter and display it in a message box.

Please note that to enable this project, you need to copy the PeopleCode in this funclib