Open Forum

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
------------------------------

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
------------------------------

Original Message:
Sent: Jan 08, 2021 03:50 PM
From: Blair Christensen
Subject: GL Account inheritance

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
------------------------------

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
------------------------------

Original Message:
Sent: Jan 08, 2021 03:50 PM
From: Blair Christensen
Subject: GL Account inheritance

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
------------------------------

@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
------------------------------

Original Message:
Sent: Jan 08, 2021 03:50 PM
From: Blair Christensen
Subject: GL Account inheritance

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
------------------------------