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 :
Microsoft Dynamics GP (Archived)

Distribution Types

(0) ShareShare
ReportReport
Posted on by 360

Hopefully someone can give an answer on this quickly as it is halting the processing of transactions for my client.  They use project accounting, and they just updated to GP 2016 R2.  With the upgrade, they lost the ability to modify distributions at the document level for their purchasing receiving entry.  Error pops up and says to go to the item detail distributions.  They opened a case with MS, and were instructed to use a workaround.  Without going into too much detail, the goal is that they want to break out their COGS amount between two accounts.  The error pops if they try to enter any account or change any amount or really if they do anything in the distribution window, EXCEPT if they add an account and use the distribution type of OTHER, then it works.  This is how MS instructed them to do it, however the concern is what these distribution types actually affect.  Is this going to cause issues elsewhere in the system or with reporting if they are now using this distribution type of OTHER?  Does anyone know where I can find documentation explaining what is affected by the distribution types?

For example, before upgrade, they would have distributions looking like this:

ACCT     TYPE        DR            CR

1000      COGS      50.00

1001      COGS      25.00

2000      Contra Account      75.00

After upgrade, they look like this:

ACCT     TYPE        DR            CR

1000      COGS      75.00

2000      Contra Account      75.00

1000      OTHER                    25.00

1001      OTHER    25.00

As you can see, before when they wanted to split the COGS to two different accounts, they'd simply add the other account in the distribution and change the amounts.  AFTER the upgrade, they are stuck with the COGS and CONTRA account as-is, so only way to break it out to another account is to credit it back from the original COGS account and debit it into a new one.  But as I said, can't change anything in that window and can't add anything to that window, UNLESS it has the type of OTHER.  So simply wondering what affect this will have on everything.

Thank you,

Tanner

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Tanner Profile Picture
    360 on at
    RE: Distribution Types

    The reason they couldn't change distributions as they could before is because they use Project Accounting and the newest version of GP requires you to now edit those distributions at the line level if you use project accounting.  Since posting this, Microsoft got back to us and ensured that using a type of "OTHER" for the distributions going forward as shown in my example will have no negative affects on any other aspect of the system, which is really all I wanted to verify before moving forward.

    Thanks.

  • Community Member Profile Picture
    on at
    RE: Distribution Types

    Is this an "intercompany" transaction? To where they would need to make sure that Intercompany box is check-marked on the Transaction Entry screen prior to Distributions? I know in the company I work for, we have many Intercompany transactions, so that box needs check-marked as well as each company needs to have that same Distribution account # made in that company's GP log-in.

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans