Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Cannot Apply Payments ...
Microsoft Dynamics GP (Archived)

Cannot Apply Payments in Reoccurring Invoices

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

We have a customer where this condition exists:

GP2013 R2

The errors are

1.  A Primary Key violation in the AR Reoccurring batch.

2.  Cannot apply payment to an invoice in Batch Recovery when no batch is in Batch recovery. 

 

Current condition of AR is:

  1. Invoices in AR Open tables they cannot apply payments to.
  2. These invoices are generated in reoccurring batches.
  3. The reoccurring batches for AR appear to have some level of data corruption in the AR transactions tables
  4.  The problem affects multiple customers throughout AR.
  5. The problem has existed for a number of months.

 

These are the past fixes they have tried:

 

  1. Check links on the entire AR module.
  2. Reconcile on the affected AR customers.
  3. Fixing the stuck batch when posting failed for the reoccurring batch. 

Has anyone resolved this before in the Accounts Receivable module or know a possible fix?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Cannot Apply Payments in Reoccurring Invoices

    Hello Thomas,

    This is resolved by enabling multi-currency and running check links

    Donnette

  • Verified answer
    Thomas Newcomb Profile Picture
    Thomas Newcomb 1,810 on at
    RE: Cannot Apply Payments in Reoccurring Invoices

    Hi Donnette,

    Does your Customer have Multi-currency enabled?

    When you look at the invoice in the RM20101 table does it have a Currency ID?

    If the invoice does not have a currency id and the payment cannot see the Invoice when you create the cash receipt you are most likely running into the Quality issue I mentioned in the thread you had linked.

    The only way to resolve this issue would be to enable Multi-Currency and run checklinks which should assign the invoices a Currency ID Or post the cash receipt and then apply it it.

    I hope this helps!

    ~Thomas Newcomb

    GCFA Great Plains Support Specialist.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Cannot Apply Payments in Reoccurring Invoices

    I cannot confirm it based on the limited information given here, and wondered if you had a test environment that you could process the suggested workaround steps in order to see if it resolves your issue?

    The current work arounds for this issue are located below.

    1. Post the cash receipt and apply it as you already are.

    2. Enable Multicurrency if it is not already enabled, and run check links. (This should set the currency correctly for the cash receipt)

    If it doesn't work in the test environment, then we can attempt other things, and if it does, perhaps there is a way to apply the fix or patch before upgrading to 2015...?? I look for patterns in the common invoices and Customers and data to see if there are clues to the source of the hang up....Hope this helps!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Cannot Apply Payments in Reoccurring Invoices

    Dear Donnette:

    I am wondering what type of 'data corruption' you referred to in #3 above under current situation? The solution would depend on the source of that corruption, or violation of the pre-programmed rules that caused the postings to error out...for example, if they were posting to a certain G/L Account, and the G/L Account was inactivated, or a Group of Customers had their default set ups changed in between creating the re-occuring batch and posting it, or a thousand other possibilities. Can you please get more specific to the type of invoice and what it was supposed to do, including the tables involved?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Cannot Apply Payments in Reoccurring Invoices

    All,

    I have discovered some tables reference a currency code while other do not with SQL queries.

    I believe this is caused by Quality issue 68836 referenced here:

    community.dynamics.com/.../142841

    Confirmation anyone?

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