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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Payments in Dynamics GP that were created as prepayments on PO's need to be removed

(0) ShareShare
ReportReport
Posted on by 163

I have a client who tried to start using prepayments on PO's about 5 years ago.  They created only 3 prepayments on 3 PO's for one vendor and did not use it any more.  I think because they did not really know how to use it.  They created the PO with the prepayment as a manual payment using a Credit Card set up as a bank card.  The payments were created without issue.  They then did their shipment receipt, but never did an invoice receipt because the prepayment paid the entire invoice amount (there were no shipping charges or taxes).  They have now decided to try to clean this up.  The vendor is showing the 3 open payments with no invoices outstanding.  The vendor balance should be zero.  When I look at the 3 PO's they are all showing closed and in history.  I don't know how they got in history since their status should be received since an invoice receipt was not done that I can see in PO inquiry.  We can't now create invoices since the PO's are in history.  If we can void them (not sure if that will go through but it does let me mark the void box), I think that will probably void the withdrawal transactions which was created as part of the debit card payment and cause an issue with their bank reconciliation.  We can't post anything to history since it was so long ago.  Basically we want to just make the payments go away since the vendor was paid, the goods were received, and the PO is in history.  We will have to make some GL adjustments since the prepayment amounts are still in the account that was set up as the prepayment account.  Any suggestions on how to fix this mess?  Thanks!

*This post is locked for comments

I have the same question (0)
  • kmalone43 Profile Picture
    894 on at

    Sounds like quite the mess indeed.  If you/your client are content w/ making JEs and it's just 3... What about just creating a debit memo to apply to the pending payments and then truing up the G/L separate (or with the debit memo distributions).  With proper documentation and the fact that the original transactions are ~5 years old, I can't imagine this would be too big of a deal.

  • Shirley McCutcheon Profile Picture
    163 on at

    Thank you for the input.  We have already tried creating an invoice which is the sum of the 3 payments.  But the problem is that you do not see payments created as PO prepayments in the apply window so that they can be applied to the invoice.

  • Verified answer
    kmalone43 Profile Picture
    894 on at

    Ah, missed point there.

    So just quickly digging deep in some support cases that I've handled in past regarding POP Prepayments, give a few of these a whirl.

    Set PO Status to Change Order, Process, Save.  Set PO Status back to Closed, Process, Save.  This process MAY move the prepayment balance to regular A/P to then apply as normal.  This may not be doable w/ Purchase Orders that have already been moved to history and the balance may not transfer to regular A/P (as it typically does when closing a PO w/ existing prepayment amount).

    If this doesn't work...

    Here's a convoluted process that we've used in the past and it's worked...

    - Setup customer account

    - Transfer balance to AR using Customer/Vendor consolidation process

    - Transfer balance back to AP (now standard PM transaction)

    - Key your dummy invoice/debit memo

    - Apply

    If you're looking for info on the customer/vendor consolidation process, I posted a video (I apologize for strange audio) a few months back @

    There may be other solutions and your scenario may vary slightly from what we had when using the 2 options above.  There isn't a whole lot that these processes could hurt (outside of being ugly) but running through in a test environment first might be a good idea.

    Let me know how it goes.

    Thanks,

    Kyle

  • Verified answer
    Shirley McCutcheon Profile Picture
    163 on at

    Thank you Kyle.  The customer/vendor consolidation trick worked.

  • kmalone43 Profile Picture
    894 on at

    Quite the process isn't it? Addressing the underlying issue might be worth a recommendation to Microsoft at some point...

  • Mutahir Khan Profile Picture
    5 on at

    I am also facing this issue but in my case prepayment PO was cancelled and the amount was not be returned as per deal with purchaser how i can manage this amount in GP 2018

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans