web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Splitting SOP Distribu...
Finance | Project Operations, Human Resources, ...
Unanswered

Splitting SOP Distributions Per Line Item

(0) ShareShare
ReportReport
Posted on by Peter Muchira 1,912

Hello,

I am wondering if there is a way of splitting DISTRIBUTIONS on a SOP Invoice, per line item (even if the various items are mapped to the same SALES account). By default, the system groups and sums up  distributions of LINE ITEMS that are mapped to the same account. But I have a unique requirement to split DISTRIBUTIONS per line item, even if these items are mapped to the same SALES account e.g.

ITEM     QTY       EXTENDED-PRICE    ACCOUNT MAPPED

AAA         1                      $200                            50056

CCC       2                      $320                            50056

By default, the system will show me a combined distribution of $520 against account 50056. Is there a way I can have GP split the distributions(one for $200 and the other for $320)

Am open to suggestions.

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Andrea Melroe Profile Picture
    Andrea Melroe 3,437 on at
    RE: Splitting SOP Distributions Per Line Item

    Hi Peter,

    There is not a way to automatically split SOP distributions by line item in Microsoft Dynamics GP out of the box.

    To get your desired results, you’d need to adjust the distributions manually prior to posting.                                                                                                                             

    I’m not aware of any 3rd parties that offer this functionality off hand, but maybe some other members of the community will have further insight into that for you.

    Here’s a link you can use to search for 3rd parties/ISV’s who may be able to provide this functionality:

    http://thelistmobile.com/

    I also think this would be a great product suggestion! If you’d like to see this functionality added to the core GP product in the future, you can add a product suggestion for that here:

    https://experience.dynamics.com/ideas/

    I hope this helps!

    Thank you for using Microsoft Dynamics Communities,

    Andrea Melroe

    Sr. Technical Advisor

    Microsoft Dynamics GP

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 703 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 582 Most Valuable Professional

#3
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 542

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans