You’re offline. This is a read only version of the page.
Announcements
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:
These are the past fixes they have tried:
Has anyone resolved this before in the Accounts Receivable module or know a possible fix?
*This post is locked for comments
Hello Thomas,
This is resolved by enabling multi-currency and running check links
Donnette
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.
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!
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?
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?
#1
André Arnaud de Cal...
293,440
Super User 2025 Season 1
#2
Martin Dráb
232,575
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (