Sage MAS 90 and 200 Sage MAS 500 blogs Product Feedback Support Training
Reply
Sage MAS Partner
JKatulka
Posts: 188
Registered: 07-19-2010
0

General Journal History Object?

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?

Justin
Sage MAS Partner
JKatulka
Posts: 188
Registered: 07-19-2010
0

Re: General Journal History Object?

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!

 

 

Justin
Sage MAS Partner
JKatulka
Posts: 188
Registered: 07-19-2010
0

Re: General Journal History Object?

Was able to use the oUI object to pass the values I needed into my script.

Justin
Sage MAS Partner
Elena
Posts: 110
Registered: 12-22-2008
0

Re: General Journal History Object?

Would you by any chance be able to provide this script ?