Open Forum

Expand all | Collapse all

GL Account inheritance

  • 1.  GL Account inheritance

    GPUG ALL STAR
    Posted 9 days ago
    For GL Accounts, my understanding is that there is an inheritance structure which starts at a Company level and then proceeds down to a Customer level then to the Item level and finally to an invoice level, where the lower or more granular the account is designated as taking precedence.  One of my accountants is wondering if there is a way to set an exception to this hierarchy.  (I don't think there is but if you have a workaround, I'd love to hear about it.)

    Just to clarify, but she wants the Customer GL to override the Item one but only for a couple of items.

    ------------------------------
    Blair Christensen
    Database Administrator
    Oppenheimer Companies, Inc.
    Boise Idaho GPUG Chapter Leader
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: GL Account inheritance

    TOP CONTRIBUTOR
    Posted 7 days ago
    Hi @Blair Christensen,

    For SOP, there is a setting that lets you ​​decide whether the item posting accounts come from the item or the customer, but that changes the entire hierarchy, and it sounds like you just want it for a handful.  The hierarchy doesn't go to item when the customer is blank under this option either so that still doesn't achieve what you want, unfortunately.


    My other thought short of that is that if you have GP Power Tools, you could write a trigger on the windows you're wanting to impact and have it override the account settings for the customer/item combinations you're interested in.

    Does that make sense at all?

    Thanks,

    Samantha

    ------------------------------
    Samantha Higdon ,CPA,CGMA
    Consultant
    Lagom, LLC
    Carmel IN
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: GL Account inheritance

    TOP CONTRIBUTOR
    Posted 6 days ago
    Blair,

    eOne has a product, Flexicoder, that allows you to set a wide variety of rules to set your GL accounts.  I think it's worth a look.

    Chris


    ------------------------------
    Chris Donnelly
    Sr Mgr of Info Systems and Financial Reporting
    Healthmark Industries
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: GL Account inheritance

    GOLD CONTRIBUTOR
    Posted 5 days ago
    @Blair Christensen   if you are still looking for a solution, we offer a SOP Enhanced Posting Flows that allows you to create rules based upon items and customers.  If you'd like more information, please let me know.

    https://paradigmtechnologyconsulting.com/microsoft-dynamics-gp/enhancements-for-dynamics-gp/

    https://paradigmtechnologyconsulting.com/wp-content/uploads/2019/11/Dynamics-GP-SOP-Enhanced-Posting-Flows.pdf


    ------------------------------
    Michael Gummel
    Prod Engineer
    Paradigm Technology Consulting
    Allentown NJ
    mtgummel@ptcsolutions.com
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role