Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

GL Distribution - Vendor setup

Posted on by 45

The software I previously used, you were able to default the GL distribution based on account #. For example, you may have numerous account #'s for utilities with numerous GL distributions. You aren't able to default the GL for vendor but you could for account #. Are you able to do this in GP?

Categories:
  • Suggested answer
    JodeRuiter Profile Picture
    JodeRuiter 978 User Group Leader on at
    RE: GL Distribution - Vendor setup

    In other words, it won't default based on the Vendors Account Number, you can set up a listing of accounts to choose from.  If you MUST have it default by Vendor's Account Number you will need to set up multiple vendors for the same vendor and set their default accounts as Mark described below (not optimal).  If you have to go this route, there is a third party for Payables National Accounts that could help with reporting.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: GL Distribution - Vendor setup

    You would put the most commonly needed account in the purchases field and the others behind the ellipses. They would come up as possible accounts during data entry.

  • talee Profile Picture
    talee 45 on at
    RE: GL Distribution - Vendor setup

    Thank you Richard.

    So for example, a vendor Hydro One has the following accounts:

    account #1234         GL#123456 and GL#654321
    account #5678         GL#789987
    account #9876         GL#444444 and GL#555555 and GL#111111
    account #4321         GL#234567

    These can all be created in the vendor setup you have suggested?    

            pastedimage1571943451943v2.png        

    pastedimage1571943470546v3.png   

                                         

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: GL Distribution - Vendor setup

    You can go to Cards->Purchasing->Vendors and pull up the vendor. Click on the Accounts button and you can assign defaults accounts to be used for the vendor. Next to purchases there is a series of ellipses when you can enter multiple expense accounts.

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans