• Replies 3 replies
  • Subscribers 217 subscribers
  • Views 125 views
  • Users 0 members are here
Related

new GL codes

Dale Aucoin
$organization

My finance department wants to change some of our GL codes mid fiscal year and I wanted to get some advice from anyone who has done this.

Our current GL format is something like this 1192-9032-GEN.  The word at the end indicates a purpose restriction, unrestricted GLs all have "GEN" at the end.

Our finance people want to get rid of "GEN" and replace it with "DEVINC".  This would affect some 15-20 different GL codes.

The main complication with this that I can see is that GL reports going forward will have two rows for each kind of general operating income.  Are there other issues I should worry about?

This would only be for development income, not ticketing.

Any advice would be appreciated.

Thanks!
Dale

  • $organization

    Dale,

     

    I've done something similar in the past.  We added a segment to all of the GL numbers mid-year.  I don't think there are too many concerns beyond the reporting issues you mentioned.  However, because we were completely replacing the GL codes with new ones, we chose to update the GL history tables as well so that the reporting would have only the replacement GLs, even for data generated prior to the change.

    I have some SQL scripts to accomplish this if you are interested.  It involves temporarily deactivitaing some foreign key constraints in order to update the various tables needed to make the change and then reactivating them.

    We also used these scripts during our consortium database merging to accomplish the same thing.

  • $organization in reply to Levi Sauerbrei

    Thanks Levi,

    I would love to see the code you wrote for this purpose.  I'm pretty sure I'm not going to mess with the tables on this one but I'd like to see how you did it.

    My feeling is that its our Finance department that wants the chance, so they can deal with the wacky reporting for the next few months.  Is that mean?

    Dale

  • $organization in reply to Dale Aucoin

    Dale,

    I uploaded the script to my profile.

    I don't think its mean to make them stick with the odd reporting.  But from a selfish standpoint, I would be worried that somewhere down the road, that incongruity would land on my desk again. "We really need this to all look the same or we will fail our audit." and then I'd end up fixing it anyway :)