Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Suggested answer

Unpayable AR invoice after check links removed glitched payment

Posted on by 120

We are running a local deployment of GP 2018 on SQL Server 2014 with each user running a local install of GP.

So here is an odd one. Our AR specialist created a payment under the national account and went to apply it to three invoices from three different child accounts. The payment was applied but something glitched in the process. We had to run check links and the payment record was removed and the invoices themselves all show as unpaid. However, from the apply payment window when creating a new payment under the national account the invoices do not show in the window and the payment can not be applied.

We ran the vendor reconcile tool on both the national account and the child account with no errors or fixes. We also ran checklinks again with no errors.

We created another invoice for the child account and this invoice does show up to be checked in the apply payments window.

I looked at both invoices in the RM20101, RM10101, GL2000, MC020102, RM00401 tables and the transactions attributes are all identical. Is there a different table I should be looking at. I ignored the SOP and IV tables.

The check links removed the payment record from the RM Apply Open File table, RM Distribution Work file and the RM Key File. There is no record of the payment as i ran a script searching for the payment number with no records returned.

I know the easiest fix is to just have them void and recreate the invoices, but curiosity has gotten the better of me and I want to know why this is occurring.

Any help would be greatly appreciated.

  • Suggested answer
    agaber Profile Picture
    agaber on at
    RE: Unpayable AR invoice after check links removed glitched payment

    Hi Richard-

    Thank you for posting your question on the Forums.  The tables we would typically gather when troubleshooting an RM issue like yours would be the following:

    **  RM00401 - RM Key File

    **  RM10101 -   RM Distribution Work/Open File

    **  RM10201 -   RM Cash Receipts Work File

    **  RM10301 -   RM Sales Work File

    **  RM10501 -   RM Commission Work File

    **  RM10601 -   RM Tax Work File

    **  RM20101 -   RM Open File

    **  RM20201 -   RM Appl]y Work/Open File

    **  RM30101 -   RM History File

    **  RM30301 -   Receivables GL Distribution History

    **  RM30201 -   RM Apply History File

    **  RM30501 -   RM Commission History

    GL:

    ** GL10000 - Transaction Work

    ** GL10001 - Transaction Amounts Work

    ** GL20000 - Year-to-Date Transaction Open

    ** GL30000 - Account Transaction History

    Multicurrency:

    **  MC020102 -  Multicurrency Receivables Transactions

    **  MC020104 -  Multicurrency RM Revaluation Activity

    Bank Reconciliation:

    **  CM20200 - CM Transaction

    **  CM20300 -   CM Receipt

    I hope this information is helpful, but always best to open a support case before deleting/updating any data in SQL.  Be sure to always attempt troubleshooting in a TEST company first and make a good restorable backup before proceeding in LIVE.

    Have a great day!

    Adam G.

    Microsoft Dynamics GP.

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,537 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,520 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans