Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / HELP!!!!! Lost power i...
Microsoft Dynamics GP (Archived)

HELP!!!!! Lost power in the process of applying payment to invoices.

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hello,

I was in the middle of applying manual payment to invoices, and we lost power. Transaction was interrupted, it never posted to gl or anywhere else, except on the vendor level, invoices are marked as closed. When I check invoices in vendor inquire screen it shows invoices as paid, when you go to the next screen to see how is applied it does not give me any info. It wont let me to apply new payment to invoices, and if I try to do Apply payables documents, invoices in question are not listed as open. 

Any ideas how to fix it?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: HELP!!!!! Lost power in the process of applying payment to invoices.

    Will do, but it will take time before we get to it. People that I need to help me are out on vacation.

  • Mick Egan Profile Picture
    Mick Egan 3,557 on at
    RE: HELP!!!!! Lost power in the process of applying payment to invoices.

    Please note this Post took no consideration to the Payables distribution or Tax tables, which may or may not need clearing.

    Mick

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: HELP!!!!! Lost power in the process of applying payment to invoices.

    Good luck, and please post your solution with as much detail as possible so others can learn from your solution .

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: HELP!!!!! Lost power in the process of applying payment to invoices.

    Batch is gone, payment record  ( I have a pmnt #) could not be brought up in reports or inquiry . Tried everything. It has to be fix behind he scene. Ill try Micks suggestion.

    Thank you.

    Lil

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: HELP!!!!! Lost power in the process of applying payment to invoices.

    While I like Mick's suggestion - question pops up - have you attempted (1) to recover the batch (2) have you run the check links on the Payables Transactions?

    I think I might do both of these in a TEST system first - but as I said, Mick's solution to move them may be the only / final choice.

    Good luck.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: HELP!!!!! Lost power in the process of applying payment to invoices.

    Thank you very much. Ill have my IT people help me with this process. Hopefully it will work.

    Lil

  • Mick Egan Profile Picture
    Mick Egan 3,557 on at
    RE: HELP!!!!! Lost power in the process of applying payment to invoices.

    This MUST be tested in a copy of the Live Company and documented.

    PM30200 - Payables History.

    PM20000 - Payables Open.

    PM00400 - PM Keys Table, contains the Document Status

    PM20100 - PM Open Apply, Lost records would exist here.

    PM30300 - PM Apply History - assuming nothing matches in this table

    We would move the records back to Open, and then add the payment and apply.

    PM000400 status changed for those records, Check Links should be ran after moving the records to Open table, before applying.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: HELP!!!!! Lost power in the process of applying payment to invoices.

    Thank you for responding. Yes we would like to move invoices back to Open and apply payment, otherwise they would stay  forever in the vendor file and aging report.

    Please could you point me in more details what has to be done, what tables to go to. Your help is highly appreciated.

    Lil

  • Mick Egan Profile Picture
    Mick Egan 3,557 on at
    RE: HELP!!!!! Lost power in the process of applying payment to invoices.

    This one is always interesting.

    You need to decide whether to move the invoices back to Open and remove those from history so the apply can be created, or just move on.

    It is a bit of work to do and need to consider the PM Keys table status.

    The Payment record status needs to be checked as well.

    If you have good knowledge of the tables then it is possible, otherwise consulting services is required.

    Assuming that Check Links was ran for the Payables Open and History in a restored test environment to check whether it will do automatically.

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