Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Sales Distribution Accounts - Change by Class

Posted on by 475

GP 10 Advanced Management - Here's the Scenario - We have Customers that are "Distributors" and Customers that are "Direct."     90% of our Sales are for "Distributors" where we don't recognize the Revenue until it is "Sold Through."  The other 10% are just regular sales.  We have 2 Item Classes, call it class A and Class B.  Each Item Class has it's own Revenue Account (Revenue - Class A and Revenue Class B) and  we have one Deferred Revenue Account.  Right now the Sales Accounts are pulling from the Item Card (SOP Setup).  This is great for the Direct Customers, but that's only 10%. 

I would like to have the best of both worlds.  I want to have the Sales Account Pull from the Item Card from the Customer Class of "Direct" and the Sales Account to pull from the Customer Card on Customer Class "Distributor." 

It seems like GP only lets me have one or the other.  Switching it around makes it so that Deferred Revenue pulls from the Customer Card on Sales for "Distributors" which is nice.  But the Direct Customers Sales pull through as blank accounts because I can't populate those accounts at the Customer Card level because the Sales Account depends on which item is being sold (one of 2 different Accounts or even both on the same order).  My solution would be to just leave it at pulling from the Item Card have the order entry person flip the Revenue Accounts to Deferred Revenue on each Distributor Order.  I know I could also probably write a customization to do this as well.  But is there some standard fuctionality that I am overlooking that will help me do this?

 

*This post is locked for comments

  • Darren C Profile Picture
    Darren C 240 on at
    Re: Sales Distribution Accounts - Change by Class

    I don't belive there is a way for GP to handle this out of the box. There is a third party add on called Advanced SOP GL Defaulter that does exactly what you need.

    http://www.m4systems.com/m4_advanced_SOP_GL_defaulter.aspx?param=1

    You can default the segments from a combination of Debtor, Debtor Class, Item, Item Class, Salesperson or entered value.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans