Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Manual Payments not posting

Posted on by 35

I am using GP 10 and recently started doing manual payments. When I first started doing them all was fine, they were posting and applying without issue. Now all of a sudden they are not posting to the G/L and they are not showing as waiting to be posted in the financial posting section, this is my first problem.

Second problem is that I partially applied a manual payment to an invoice leaving a balance on the manual payment. After I posted more invoices I went back in to finish applying the manual payment but the system is not letting me apply to any other invoice unless I post first. First off there is nothing to post and second why would I post when the payment is not fully applied?

Third problem is that the manually payment that I am fully applying are not posting either. When I first started doing this process in Apply Payable Documents I would apply the payment and when I clicked OK it would automatically post the payment to the G/L. It is no longer doing that, it just sitting in Apply Payable Document as fully applied, but again not hitting the G/L.

Any ideas?

*This post is locked for comments

  • Lela Profile Picture
    Lela 35 on at
    RE: Manual Payments not posting

    Susan thank you for getting back to me. I made the change under posting but unfortunately this did not fix my entire problem. Now I am posting to both ledgers but my invoices are not posting as paid.  I am really not sure where else to go. There is nothing in series post that pertains to these manual payments. When I enter the manual payments I enter them in a batch and then post the batch which posts to the sub ledger without a problem. I go back later and apply this manual payment to multiple invoices until the manual payment is $0. The problem now is that these manual payments once applied are not posting to the invoices so it is as if they are still open. The payment is still showing in Apply Payable Documents as $0 avail.

    As far as applying the manual payments, they did cross into different months. Our month ended on 6/15 and some of these were not applied until July (as the invoices were not yet available for applying to the manual payment in June).

    I need to know how to unapply a partial payment. I applied part of a $10k manual payment to an invoice for $5. The remaining $9,995 will not apply to any other invoice, nor can I unapply it from the $5 invoice until the other is posted, but I don’t know how to post it. Here is the error I get

    Just to recap:

    1. I need to know how to get the manila payment to post so that the invoices show as HIST and not as OPEN

    2. I need to know how to unapply a partially applied manual payment.

    Any help can give is much appreciated.

  • sueconrod Profile Picture
    sueconrod 335 on at
    RE: Manual Payments not posting

    1.  Go to TRX>>Purchasing>>Series Post

    Is there anything showing here that should be getting posted.  If so look at the trx and then post into Great Plains.

    I am assuming that you post after every document or are you entering all the manual payments into a batch?

    2.  Then go to Tools>>Setup>>Posting>>Posting  then series Purchasing, then origin Payment Entry, you should have it marked on the far left to:

    a.  Post to General Ledger (which means it will post in the subledger and stop and wait to be manually posted  to the GL

    b.   Post through General Ledger Files:  will post to sub-ledger and post right thru to the GL.

    If neither of these is marked, that is your issue, you are posting to nothing, neither the sub-ledger or the GL.

    3.  When you mention you are using the Apply Payable Document, you are not creating the manual payment and then applying it, you are taking two documents (or more) and just matching them up.  They have both already been posted to the sub ledger (AP)  and possibly the General Ledger  when they were originally entered.  The one issue you would have in terms of reconciliation at the end of the month is to make sure that the Apply Date is correct.  You don't want to be crossing months.  

    4.  Are you doing a monthly reconciliation of A/P?  Printing out a Historical Aged Trial Balance as of the end of the month and making sure that all the open invoices listed total up to what you say you have in the A/P account at the end of the month?

    And does this reconcile?  

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,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans