- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic to the Top
- Bookmark
- Subscribe
- Printer Friendly Page
General Journal History Object?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
07-28-2010 08:26 AM
Has anyone ever accessed GL General Journal History data using BOI?
I'm looking to access information for a posted General Journal Entry. The GL_GeneralJournalHistory and the GL_DetailPosting tables have the information I need, but in the File Layouts and Program Information chm they both say that their Bus Obj is 'GL_GeneralJournal_upd'.
I checked the object reference and didn't see anything related to GJ history.
Can the GL_GeneralJournal_upd object be used to retrieve this data or is there another object that should be used?
Re: General Journal History Object?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
07-29-2010 09:14 AM
Tough question I guess.
I would have liked to use the actual business object to retrieve this data, but was still able to get the information I needed using ODBC in the script.
The script will be used to reverse a GJ entry - I've watched all of Steve's insights videos where I understand he did something similar to this from the account maintenance transactions tab, but didn't find a section dedicated to it. I've tested the script stand-alone and it reverses the entry as long as it is provided the journal number/positing date.
Does anyone know how I can get the journal number/posting date from this tab?
I'm using an external link to fire off my script, but the only variables available to pass to the script are from the GL_Account object (which don't include the journal detail I need), and the current business object (oBusObj) is not available from an external link right?
If anyone knows of anyway I can get the journal number/posting date from the transactions tab or the journal drill down into my script I would reallllllllly appreciate it!
Re: General Journal History Object?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
07-30-2010 01:23 PM
Was able to use the oUI object to pass the values I needed into my script.
Re: General Journal History Object?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
03-10-2011 10:40 AM
Would you by any chance be able to provide this script ?


