You’re offline. This is a read only version of the page.
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.
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:
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
Share
Report
All responses (
Answers (
