GP Purchasing All-in-One View

(0) Share

Report

Posted on by Community Member

We are in the process of upgrading from GP 2010 to GP 2015. During this process we have decided to disable unused modules. We ran into an interesting issue after disabling the Project Accounting Module.

When a voucher number is clicked on the "Purchasing All-in-One View" a message is displayed stating "Invalid Product ID 258.". This is the product id for Project Accounting. We used another one of our environments to determine what form this link was trying to open and found it is the "Payables Transaction Entry Zoom". We also found that this same window (Payables Transaction Entry Zoom) can be opened from the "Payables Transaction Inquiry - Vendor" form without any issues.

I have checked the list of Alternate/Modified forms and reports multiple times to make sure that all of the entries had a form set.

Any help is appreciated.

*This post is locked for comments

All responses (18)

Answers (1)

coquisalsa 2,725 on at

Like (0)

Report

RE: GP Purchasing All-in-One View

Michael,

I am glad I was able to help.

Thanks
Community Member on at

Like (0)

Report

RE: GP Purchasing All-in-One View

Thank you Jorge!

The problem was that the module was still registered.
Verified answer

coquisalsa 2,725 on at

Like (1)

Report

RE: GP Purchasing All-in-One View

Michael,

There is no doubt that GP Power Tools is a great tool.

I doubt the problem you are having is 'directly' related to alternate forms. If you remove a product from GP and don’t change the security in the ‘Alternate Modified/Forms and Reports’ window for the related alternate form(s) of the product you are removing, you will get this error each time you try open one of these forms:

I believe this is the error you are getting:

Since you have Project Accounting installed, I assume your Project Accounting is registered. Un-tick the checkbox Project Accounting from the Registration window. This should solve your problem.

You will also have to 'Revert to Default' all Project Accounting alternate forms using the GP out of the box ‘Alternate Modified/Forms and Reports’ window or GP Power Tools.

Optionally, if you also want to remove all SQL objects related to Project Accounting, check this link:

How to uninstall Project Accounting in Microsoft Dynamics GP when you use SQL Server

This link also shows how to revert the Project Accounting alternate forms.

After following the instructions from the above link you will still be left with some Project Accounting tables which you will have to remove using SQL, though there is no harm to leave them in the database(s).

I hope this help.
Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: GP Purchasing All-in-One View

Beat Bucher ... GP Power tools is just amazing !! The security profiler has always been my favorite, I can't ever live without it.

winthropdc Thanks for such masterpiece ;)
Bill Campbell on at

Like (0)

Report

RE: GP Purchasing All-in-One View

Thanks for the technical componant to my reply - I can always count on you Beat to get the 'fuller' answer out there.

This is exactly what I was talking about and the type of situation where this tool would be very - very useful.

Thanks again. And hope this helps answer the issue.
Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (2)

Report

RE: GP Purchasing All-in-One View

Hi Michael,

Bill gave you some interesting hints to follow ... We do use Project accounting and the sad truth is that when it gets installed, lots of security roles & tasks get modified for the 'alternate' forms / reports to work with the equivalent Project Accounting resources in GP..

The trick here is that you need to go through all the roles and tasks that your users are using and figure out where there is actually a pointer to one of the alternate resources used by the PA258.DIC & PAFORM.DIC (the PAREPT.DIC does not exist by default, unless you've done some customizations to the PA module reports).

Your best friend to do this would be the GP Power Tools from David Musgrave (can be downloaded as a trial from Mekorma) and with the security profiler and security tool, you will quickly spot the tasks and roles making use of PA alternate resources.

The screen capture below from the GP Power Tools gives you an idea on how this works. From there you can directly double-click on the Alternate Access control name and change the selection back from "Project Accounting" to "Microsoft Dynamics GP"

According to my table SY10800 (which holds the alternate security assignment), there are 77 resources that are assigned to the module 258. This number can vary depending on the modules installed along in your GP system...

Hope this helps.

EDIT: actually you don't even need to bother with roles & tasks, just focus on the Alternate/Modified Forms and Reports security to fix your issue.
coquisalsa 2,725 on at

Like (0)

Report

RE: GP Purchasing All-in-One View

Terry,

Can you please clarify what you mean with 'project registered'?
Terry R Heley Microsoft Employee on at

Like (0)

Report

RE: GP Purchasing All-in-One View

We have not seen it be a problem with a LIVE company, if you are having those issues, then we should create a case to further review your install. If you have project registered, then you should be installing it as that could be part of the problem as well and we would not code around unmarking items based on use.

Thanks

Terry
coquisalsa 2,725 on at

Like (0)

Report

RE: GP Purchasing All-in-One View

Hi Michael,

From my testing you have to have PA installed to make All-in-One View work without errors.

I didn't have PA installed in my GP2015R2 but after installing it the problem disappeared.

Thanks

Jorge
Community Member on at

Like (0)

Report

RE: GP Purchasing All-in-One View

Terry,

We are getting this error after disabling project accounting. Does this issue mean that it is not possible to disable the project accounting module and still have the Purchasing All-in-One View work?

This will be a live company database after the upgrade and the project accounting module has not been used.