Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: PM Apply transactions with more than one control account

    Hi Lou,

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

    Kind regards,

    Leslie

  • Lou_Spevack Profile Picture
    Lou_Spevack 425 on at
    RE: PM Apply transactions with more than one control account

    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.

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: PM Apply transactions with more than one control account

    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

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    RE: PM Apply transactions with more than one control account

    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.

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans