420
We have a vendor that shows information from another vendor in another year. The payment is an invoice number to vendor A that was paid back in 2010. This payment is showing up in vendor B as well. Has anyone ever seen this? We recently upgraded from GP v10 to v11 and everything went well with that. Not sure if this has anything to do with the upgrade.
*This post is locked for comments
I would add one thing to this.
1) In a backup company run this is SSMS DELETE PM00400(this will empty the PM Key Master table)
2) Then run Check Links
You will get a long list but hopefully this will correct the issue. I am suggesting to clear the PM00400 just in case there are other irregulariities in there.
Hi Richard. I wanted to let you know what MS wants me to do. Here's what they said after having me run some queries:
Thanks for sending in the results for the payment 741438. I see that the payment is in the history tables. The payment was for $235, and it shows that it is applied to two invoices. The first was invoice 125419 for $87, and the second invoice was 125387 for $148. That all looks correct. What does seem incorrect though is that there were no results from the PM00400 table. It appears that there is no keys record in the PM00400 for the payment, which would cause issues. Checklinks should add back a keys record for any transactions that are missing them. I would recommend either running through the steps below in a test company with a copy of live data or after a restorable backup is in place.
1. Go to Tools | Maintenance | Checklinks
2. Select the Purchasing series
3. Select the Payables Transaction Logical Files and Payables History Logical Files
4. Click OK.
5. Review that the records were created on the Checklinks report and confirm that the payments can be accessed in GP
The issue started when you noticed the same payment being applied to two different vendors. So we looked at Vendor A and located the payment. We then looked at vendor B and found the same document number but for this vendor is was an invoice. So we then went to the checkbook and pulled up this check. For all checks cut on 12/27/2012 we were not able to zoom back to the payables document. So it appears for every check cut in that run the link back to the payables document is broken. This link needs to be restored. This is in addition to incorrect application of a check cut in 2010 being applied to an invoice that was entered in December of 2012.
Richard, thanks for your help earlier today. Can you do me a favor and tell me yet again what it is I should tell Microsoft is going on as it relates to what they had me to a few weeks ago to fix the issue Barbara was having with that check batch for two weeks in a row? I'm very new to GP and so a lot of it doesn't make sense to me.
I am here now. Please call.
The user is leaving at noon today, so in just over one hour. If we can do it now vs. later that's the only way she'll be available. If it's necessary that she be available I'm good with rescheduling next week sometime. Just let me know.
It would be helpful to have this user available. I will be at this number today. 518-877-8518. Just ask for me. I have another call coming in at 2pm today so the closer we can start to 1pm the better. I will make sure I am here. Click on the link I sent you jsut prior to calling and be prepared to give me the partner ID it gives you.
Sounds good. Is there a number we can call to get you on the phone while we're doing this? Also, we'll do this from one of our Applications Developer's PC's. Do we need anything from the user who is seeing this problem or do you know everything you need to in order to possibly resolve the issue? I'm just wondering if we should have the user on standby.
We are in the same time zone. Can we try for right after lunch on Friday, say around 1:30pm EST? If so, please click on this link www.rbsolutions.com/RBS_Support.exe
I spoke with my manager and she's okay with it. I'll want to coordinate doing this at the user's desk who's seeing this issue herself and we'll need to maintain control of the keyboard and mouse. Let me know when tomorrow or Monday might be good for you. We're in the Eastern time zone. Also let me know how you'd like to do this - whether you have a WebEx account or something or if we need to use something on our end. Thanks.
#1
André Arnaud de Cal...
292,468
Super User 2025 Season 1
#2
Martin Dráb
231,287
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
