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)

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

I have the same question (0)
  • Lyn Barr Profile Picture
    1 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.

  • 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
    1 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/

  • 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

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

    Thanks Neil that's exactly what my issue was.

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