web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / PM Apply transactions ...
Microsoft Dynamics GP (Archived)

PM Apply transactions with more than one control account

(0) ShareShare
ReportReport
Posted on by Lou_Spevack 425

We use more than one accounts payable control account to track payables for different divisions.  If we apply a credit memo for one division to an invoice for another division it creates issues with the GL control accounts because the correct GL entries do not get created.

In case 1, I applied a credit memo for division 2 against a posted voucher for division 1.  The distribution only reflected the credit memo transaction and did not show the adjustment to div. 1 accounts payable.

In case 2 I posted the above documents seperately and then used the apply payables documents window.  When i closed the window no posting journal was created.

Is there a way in GP to reflect the distribution accross multiple control accounts in payables management apply transactions?

Thanks.

*This post is locked for comments

I have the same question (0)
  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    In GP, the apply function does not of itself generate GL Distributions.  When the invoice is posted, distributions are generated.  When the payment is posted, distributions are generated.  When the apply is performed (either later OR at the time the payment was entered) there are no GL Distributions!

    Yes, different AP accounts can be associated with different vendors.  In this case, a division one invoice and division one payment (for the same vendor) should hit the same payables account.  If one vendor spans divisions, you have a problem and I do not think that GP supports this without manual adjustments to the distribution accounts.

    Perhaps there is  third party product that can help.

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at

    Hi,

    You could use Control Account management to set up multiple divisional a/p accounts, yet management them from a central A/P. Run a routine at the end of the month and it will divide your a/p by division (as you define), and create a reversing entry to put everything back into your regular a/p account.

    Would this kind of thing help you do what you are trying to accomplish?

    Kind regards,

    Leslie

  • Lou_Spevack Profile Picture
    Lou_Spevack 425 on at

    We determined from additional requirements gathering that we need a custom approach.  GP by default applies the oldest document first and our business rules require apply priority by division.  Also, we will have rules that will allow netting between some divisions but not others.  Control Account Management works only if your business process fits with the application design and we have a mismatch.  Thank you for the feedback.

  • L Vail Profile Picture
    L Vail 65,271 on at

    Hi Lou,

    Thanks for following up!  Sounds like you have some pretty unique (and interesting) requirements.

    Kind regards,

    Leslie

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

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans