Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

POP Prepayment Account

Posted on by

We are trying to start using the new POP Prepayment functionality.  We have enabled the feature in POP Setup and have specified the prepayment account.  The problem we are having is the GL distributions don't work at the end of the process.  For example:

We create a PO to a vendor with a total price of $5000 and a prepayment of $1000.

When we create the manual payment the Vendor Advances account is debited for $1000 and the cash account is credited for $1000.

When we receive the PO, the expense account for the PO line item is debited $5000 and Accrued Purchases is credited for $5000.

When we input the invoice via Enter/Match, Accrued Purchases is debited $5000 and Trade Payables is credited $5000.  Once the invoice is posted, the prepayment moves from the PM20000 (open) table to the PM30200 (history) table and is applied to the invoice.

When we pay the rest of the invoice, Payables is debited $4000 and Cash is credited $4000.

The net result is that the Cash account has a credit balance of $5000 (Correct), the Expense account has a debit balance of $5000 (Correct), the Vendor Advances account has a debit balance of $1000 (Incorrect), and the Trade Payables Account has a credit balance of $1000 (Incorrect).

I've tried running this several times in various test companies and with various vendors.  Are we missing a step somewhere or what is going on that is leaving balances in both Vendor Advances and Trade Payables?

Thanks!

*This post is locked for comments

  • HeatherD Profile Picture
    HeatherD 425 on at
    RE: POP Prepayment Account

    The issue is indeed resolved on 2016 R2 - to my understanding they do not plan to hotfix this on other versions.

  • RCCHULUOTA Profile Picture
    RCCHULUOTA on at
    RE: POP Prepayment Account

    Hello juliolimongi,

    Best I can remember, as it has been years at this point, is that when we were changing some of the account distributions along the way, some of the changes we were making were causing problems with how GL wanted the follow to work.  I don't remember any specifics, though.  Since then we have upgraded a few versions and are currently on 2016 R2 with no known issues relating to this.  Sorry I can't be of more assistance!

    RCCHULUOTA

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: POP Prepayment Account

    Hello! RCCHULUOTA

    Did I solve this problem? I need this functionality but I have not been able to solve that last part of the process.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: POP Prepayment Account
    hi! everyone,
    
    How did you solve the problem ?, I have the same problem and I could not make it work well.

    Thanks.


  • Suggested answer
    HeatherD Profile Picture
    HeatherD 425 on at
    RE: POP Prepayment Account

    Confirmation - this is CR88815 which is fixed on 2016 R2 - I was testing on RTM.

    Heather

  • HeatherD Profile Picture
    HeatherD 425 on at
    RE: POP Prepayment Account

    If anyone wants my bug/repro steps - let me know.  I took a shortcut and did screenshots and as a newbie - having difficulty trying to get numbering and screenshots to work on the forum.

  • HeatherD Profile Picture
    HeatherD 425 on at
    RE: POP Prepayment Account

    We are experiencing similar problems - I have opened a case with Microsoft.  We have found if you pay the entire invoice up front (using terms of discount) , enter the shipment and invoice separately recognizing the discount then that the prepaid ap is not relieved and it relieves ap instead - leaving an outstanding balance in prepaid and creating a negative in ap.  I will update everyone when I hear back. 

    Heather (Davidson) Maneiro

    Senior Consultant

    MCP, MSLIS
    Implementation Specialists, Inc.

  • DebN Profile Picture
    DebN 3,954 on at
    RE: POP Prepayment Account

    Okay - thank you for the response!  We're just having trouble with the posting accounts on a payment type of Manual Payment with a Credit Card.  The amount doesn't appear to get reversed out of the PO Prepayments account.

  • RCCHULUOTA Profile Picture
    RCCHULUOTA on at
    RE: POP Prepayment Account

    Hello, Deborah!  You are really stretching my memory here!  I talked this over with the member of the finance team that I was working with on this originally and the best we can remember, we ended up figuring out that we were incorrectly manipulating the GL account numbers on transactions and that was throwing things off at the end of the process.  Sorry I can't provide any more details!  If I happen to remember anything more specific or find any notes I had on the issue, I'll certainly let you know.

  • DebN Profile Picture
    DebN 3,954 on at
    RE: POP Prepayment Account

    Hello!  Did you ever get these prepayment distributions figured out?  I'm also having trouble getting the G/L accounts correct.  The amounts don't ever seem to clear the Prepayment account.

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans