80
W7043.GP-error2.jpg"/resized-image.ashx/__size/550x0/__key/CommunityServer-Components-UserFiles/00-00-04-04-55-Attached+Files/6740.GP-error1.jpg" border="0" />
This is only happening on one of our companies so is not a global GP issue.
Can anybody assist on how to resolve this issue?
Thanks in advance.
*This post is locked for comments
Looks like an interesting issue with Analytical Accounting! Do you have it incorrectly installed?
However, go to SQL Server and locate a table called "PM00200" and try to type the vendor information at the SQL level, if it works then you will need to perform SQL Profiler trace and get the exact stored procedure that causes the error, and then try to replace the stored procedure from one of your working companies.
Otherwise if the operation failed to save -which is probably the case- at the SQL level then it will be a corrupted trigger at the PM00200 that prevents the data from being added, disable the trigger and the issue will be resolved, most probably it is an issue with a trigger called "aagTR_PM00200Ins".
Disabling the trigger is not the final answer, your partner must investigate and find out what was the reason behind not being able to work with analytical accounting along with vendors and try to fix this out.
Hope that this helps.
Thanks for the suggestion Richard but I'm afraid that it isn't doing the trick.
I have contacted our partner so hopefully I will be able to post a solution soon!
If it is happening in one company but the same user on the same workstation can create a vendor in other companies, it sounds like a stored procedure in the company's data base was corrupted. Try rebuilding Stored Procedures. (If you are not 100% comfortable with this, call your partner!!!!). First make a backup of the company db. Then login to the company in GP. Under Maintenance, select SQL Maintenance (BE VERY CAREFUL HERE!) Set the db to the desired company, and locate and highlight the vendor tables in the list. Checki Drop Auto Procedure AND Create Auto Procedure. Then click Process.
Everyone needs to be out of the company db when this is done! Again, backup first and call your partner if you are not completely comfortable doing this.
Sorry, meant to say that we are running GP 10.0.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (