Sage 100

 View Only
  • 1.  Expanding GL Account Structure - V2021

    Posted 11-16-2021 11:59
    Have a client wanting to expand the GL account structure.  Currently they are ABCD-12-34-567.  They would like ABCD-12-NNN-N34-567 (insert a new segment and expand an existing segment).

    Unfortunately, it appears that you can't INSERT a new segment into the existing structure, ONLY ABCD-12-N34-567-NNN.  This is a bit bewildering that since Sage uses a nine character key behind the scene, one would think an insert segment function would be possible.

    Am I missing something?

    Otherwise, it appears that we'll have to add the new segment to the end, then renumber all the accounts via an import.

    Thanks in advance.

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------


  • 2.  RE: Expanding GL Account Structure - V2021

    Posted 06-07-2024 11:51

    I have to scratch this itch again so I am bringing back for comment.  Since the account key is central, does anyone have any technical reason why we just can't insert a segment?  I understand since Sage had such a difficult time with the reversing date concept IDEA request at the MOTM conference this request might be out of reach.  Trying to determine if this is truly a technical issue or just a programmer inertia problem.



    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    (540) 221-4444
    ------------------------------



  • 3.  RE: Expanding GL Account Structure - V2021

    Posted 06-07-2024 12:54

    One example where this would be a problem is the IM option for GL segment to use for warehouse specific accounts.  It just references the segment number and inserting a segment would throw that off.  Any other feature / enhancement that references a segment number in a similar way would break by allowing inserted segments.



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 4.  RE: Expanding GL Account Structure - V2021

    Posted 06-07-2024 13:00

    There is also the fact that later reviewing GL PDF reports with the old account structure, it could be difficult to understand what the old account segments were referring to.

    NNNN-NN

    to

    NNNN-NN-NN

    Where the second NN is new, and the third NN is the old second segment.  If that was allowed, it would be... bad (IMO).



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 5.  RE: Expanding GL Account Structure - V2021

    Posted 06-09-2024 08:48

    Wouldn't the workaround be to just change the segment when you go live?  Regarding old PDF's, you have the ability to run the transaction register by source as well as rerun any other GL reports.  



    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    (540) 221-4444
    ------------------------------



  • 6.  RE: Expanding GL Account Structure - V2021

    Posted 06-10-2024 14:27

    You asked if there were technical reasons... IMO, there are.  Can they be dealt with?  Sure... most things can... but why?  I'd rather Sage programmers spend their time on things that matter more.



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 7.  RE: Expanding GL Account Structure - V2021

    Posted 06-10-2024 16:57

    I asked for technical (programming) reasons that prevents Sage from allowing a simple insertion between segments.  Not gotchas that you should be aware of and easily resolved. if you did.  And yes, I think we all have ideas better served by the programmers.  That is the purpose of the Ideation tab.  Companies do outgrow their GL structure and need the ability to expand it.  Sage did provide that utility 15 plus years ago.  It works, just as long as you add the segment at the end.  It works for most users, but some ask questions why segments can't be inserted.  I am currently dealing second and third client asking the question.  The first one is transitioning away from Sage because they didn't like the response Sage gave them - NO.



    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    (540) 221-4444
    ------------------------------



  • 8.  RE: Expanding GL Account Structure - V2021

    Posted 06-10-2024 17:22

    We have clients that have stopped using old GL segments, and it would certainly be nice to have the ability to clean things up, but they understand how that's not technically feasible and live with it (segments that are always "00").

    Someone moving off Sage 100 because they can't insert a segment (only append...) seems silly.  They must have been looking for an excuse.



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------