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, ... / Distribution Types
Finance | Project Operations, Human Resources, ...
Answered

Distribution Types

(0) ShareShare
ReportReport
Posted on by Rosemary 10

Good day,

I am looking for some information regarding 'distribution types' and what happens when it is changed.

There are two scenarios,  a user in AP may change the Payables account number and leave the type as Pay.

 The user may change the type from Pay and maintain the Payables account number.

I read something regarding this sometime ago and now can't seem to find it. 

Regards  

Rosemary

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Rosemary Profile Picture
    Rosemary 10 on at
    RE: Distribution Types

    Thank you much appreciated

  • Verified answer
    Cheryl Waswick Profile Picture
    Cheryl Waswick on at
    RE: Distribution Types

    The PAY/REC type on the distribution getting changed has no impact to the amount getting booked to the GL account selected.   As mentioned before, it is used in the validation for the system to sum up the distribution amounts to make sure they equal what was keyed on the document in those fields (so if enter PURCHASES = 100.00, then the PURCH distribution lines must equal 100.00 or else it won't let you post it.)

    The TYPES in the distribution window default in based on what was keyed on the document, and typically are not changed.  You can click F1 to view the HELP file in the distribution window, and clicking the DEFAULT button in the distribution window will set it back the same way as it was (or what the main window wants).   I don't know of any troubleshooting documentation on these, as they typically are not changed.

    The only troubleshooting documentation I know of for the reconcile to GL tool is all in KB 866570.

    Hope that helps,

    Cheryl

  • Rosemary Profile Picture
    Rosemary 10 on at
    RE: Distribution Types

    Thank you for your response. The Reconcile to GL is something our Accounts staff use, I know it's just an 'aid', but the report is usually spot on and if there were issues it identified where we could find the error.

    Of late the differences are large, we also started to use the Credit Card facility and the document you mentioned did highlight an issue there which was also taken into consideration.

    I have read of two scenarios the PAY/REC is changed and the account maintains the default accounts.

    The accounts are changed and the PAY/REC  remains, what impact does this have on the respective default accounts if any at all.

    Is there also any documentation where this is identified?

    Regards

  • Suggested answer
    Cheryl Waswick Profile Picture
    Cheryl Waswick on at
    RE: Distribution Types

    Hello,

    I believe the distribution Type such as PAY/PURCH is used to correlate the amounts from the document to the distribution window, as Elena suggested.  It is also used to help find the default posting account for that distribution line.  So if you change the GL account after the fact, that should be fine and still post correctly. *

    If you change the PAY/PURCH types, there is a verification that the amounts for each type need to sum up to the original amount on the document, so you may get errors on the validation.   The distribution lines for TAX need to total the tax amount on the document, the PURCH line needs to match the amount in the PURCHASES field on the document, the PAY line needs to total the TOTAL or net paid amount on the document, etc...

    *If you change the GL accounts and leave the PAY/PURCH, please note that the 'reconcile to GL' utility uses the PAY/REC lines to pull distributions on to the Excel spreadsheet, so if you use this tool to help reconcile RM or PM to GL, it could impact that tool. (which is only an 'aid' to help reconcile).   You can read more about that in 'Q8' in the 3rd bullet at the bottom of this KB article:

    support.microsoft.com/.../866570

    Hope that helps.   Please mark as 'answer' if this is helpful to you.

    Thank you,

    Cheryl Waswick

    Microsoft Support

  • Rosemary Profile Picture
    Rosemary 10 on at
    RE: Distribution Types

    Good day,

    Thank you for your response, what happens when the distribution types are changed and the GL account is maintained.

    Regards

    Rosemary

  • Verified answer
    Leng Papio Profile Picture
    Leng Papio 855 on at
    RE: Distribution Types

    Open the distribution window in GP, Press F1, then click the Fields (I think), it should open a window that gives specific explanation on the fields on that window. If nothing appears, someone may have deleted the chm files in the GP code folder. If this is the case, you will want to find another station that has the CHM files in the GP code folder (where GP is installed)

    Changing the accounts should not be an issue. What the distribution types follow are the amounts on the specific fields on the main transaction entry window. For example, the Pay type should have the amount in the field Payable/On Account in the transaction entry window... something like that.

    Hope this helps.

    Elena

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

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…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

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

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,352

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 616 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans