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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
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

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

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    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?

  • Community Member Profile Picture
    Community Member on at

    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 on at

    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!

  • Verified answer
    Thomas Newcomb Profile Picture
    Thomas Newcomb 1,810 on at

    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 on at

    Hello Thomas,

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

    Donnette

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans