Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

one line item two distributions

Posted on by 20

I am very very new to GP and all of Dynamics so I don't know if this is a simple question or something that cannot be done. I searched the forum and the web and I don't see this question.

We have an existing eConnect solution in place and are sending in a sales order just fine. We need to change it so that a line item is shown on the Transaction Entry page (and then I assume the invoice?) but when you click on the Distributions it needs to be split across two different Distribution References.

I have had no problem subtracting the amount from the line item amount and adding in an additional distribution. This worked in that you can see it in the distribution list, but as it is not shown anywhere on the Transaction Entry page the Functional Totals for Debit and Credit do not match up. I tried adding the distribution without deducting from the line item but that does not work either.

It seems that what I need to do is to take the sales line item and have it split to two different distributions. Is it possible to do this without having to manually create all the distributions? Currently we have it set to auto create the distributions and not likely going to have enough time to make the change just for this issue.

*This post is locked for comments

  • Mike Smith Profile Picture
    Mike Smith 6,840 on at
    Re: one line item two distributions

    James,

    You may want to explore a customization with your GP partner.

    They can work with you and your team to develop a custom solution around what your requirements are in this particular area.

    Outside of this, I can't think of a way to control this as you can't define the posting accounts at the order level and the defaults won't fall in place until the order to invoice conversion.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans