Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

AP - Setting a defined Distribution Account

Posted on by Microsoft Employee

Hi Everyone,

Thank you in advance for any and all help provided.

Background: GP 2013, Multi-entity Management (centralized AP check setup)

Problem:

When users in our accountant payable department enter batches the Distribution set-up is not selecting the appropriate default AP account. The account structure has been set up such that ####-###-#####-## the first 4 numbers indicate a facility 1000, the second 3 numbers a department 000 balance sheet, third 5 numbers an account 20000 accounts payable , and last 2 payor. 1000-000-20000-00 = Accounts Payable for facility # 1000. I have setup Microsoft Dynamics GP -> Tools -> Setup -> Posting ->Posting Accounts that says "Accounts Payable" to 1000-000-20000-00 however now whenever a batch is done for another facility 1001 it defaults the Pay account to 1000-000-2000-00 instead of 1001-000-20000-00.

I was wondering if there was something I missed setting up either in MEM or other place that tells it to pull the account respective to its facility/ checkbook? Each facility has its own checkbook defining its cash account.

Thank you and Happy Holidays.

Michael Veno

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: AP - Setting a defined Distribution Account

    Thanks Neil that's exactly what my issue was.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: AP - Setting a defined Distribution Account

    Michael, in the MEM setup area, go to the section titled "Disable Account Substitution". I suspect that you have the AP account substitution disabled; simply uncheck that box and the entity segment will sustitute properly on both the expense and AP accounts. If you can't find it, email me at neil@binarystream.com and I will find some time to assist you.

    Neil MacDonald

    Solutions Consultant

    Binary Stream Software

    604 522 6300 ext 106

    neil@binarystream.com

  • Lyn Barr Profile Picture
    Lyn Barr on at
    RE: AP - Setting a defined Distribution Account

    You can actually do it right through their website, if you like: http://binarystream.com/contact/

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: AP - Setting a defined Distribution Account

    Hi Lyn,

    Thanks for the advice, how do you go about contacting the folks at Binary Stream? I am relatively new to the whole GP world.

    Thank you,

    Michael Veno

  • Lyn Barr Profile Picture
    Lyn Barr on at
    RE: AP - Setting a defined Distribution Account

    I'll defer to someone with more experience in using MEM, but wanted to suggest that you also ask this question of the Binary Stream folks. They may have a quicker answer for you.

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,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,104 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans