Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

AP - Setting a defined Distribution Account

(0) ShareShare
ReportReport
Posted on by

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
    on at
    RE: AP - Setting a defined Distribution Account

    Thanks Neil that's exactly what my issue was.

  • Verified answer
    Community Member Profile Picture
    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
    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
    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
    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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Featured topics

Product updates

Dynamics 365 release plans