Dynamics Community Forum Thread Details

Splitting SOP Distributions Per Line Item

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

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 3^rd 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 3^rd 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

Quick Links

Leaderboard