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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GP Purchasing All-in-O...
Microsoft Dynamics GP (Archived)

GP Purchasing All-in-One View

(0) ShareShare
ReportReport
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

I have the same question (0)
  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 12 on at
    RE: GP Purchasing All-in-One View

    I have seen this when a dictionary is not loaded on a 'test' machine correctly.  Even though the report is not modified if it had been in the past, the system still looks for the path to the modified report dictionary before going onto the Dynamics dictionary and continuing.  The solution in our case was to restore the reports dictionary, allow the system to find it - then looking at the security, we removed the reference to that modified report.

    I know you are looking at "forms" but, I am wondering if the same rule might hold here.  If when Project Accounting was installed, it installed an alternate form for this 'view' and now that you have removed it - it could be the system is unable to know what to do with the missing link in the security.

    If you disabled the module, did you disable the reports and forms for that module as well?

    Anyway, hope this helps you think of a different approach.  Send more details and see who else has a better or alternate suggestion for you.

  • Community Member Profile Picture
    Community Member on at
    RE: GP Purchasing All-in-One View

    I did try re-enabling the Project Accounting feature and then verifying that none of the Project Accounting forms or reports were being used. Interestingly I did not see the Payables Transaction Entry Zoom listed in the Modified Forms/Reports window.

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 12 on at
    RE: GP Purchasing All-in-One View

    While I know I said, Modified - in this case it is an Alternate form - there is not a modification or copy of the orginal as such, but at some point, somewhere in the security window for the PA Users there must be something that points it to that 'alternate' choice.

    I know that not all users of PA have to view the same windows - we have had situations where databases 1 users PA and database 2 does not - the users of 2 do not have PA security settings and to the best of my knowledge, do not see the alternate forms.

    My suggestion would be to look at the user security and ensure that they do not have PA security selected/granted and if they do, remove the pointers to that module prior to removing or disabling accessing.

    Hope this helps.

  • Community Member Profile Picture
    Community Member on at
    RE: GP Purchasing All-in-One View

    To respond to your suggestion about checking user security, the two users that I am testing with are sa and my own user which has only the POWERUSER role.

    My first thought was also that there was an alternate/modified form or report that was still pointing to the project accounting window. But, even after re-enabling the project accounting feature and then carefully checking the alternate form settings I was still unable to find any forms that were still using the Project Accounting module.

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at
    RE: GP Purchasing All-in-One View

    I have to do a bit of research on this - but I will post to the forum later tonight - sorry client time comes first.

  • coquisalsa Profile Picture
    coquisalsa 2,725 on at
    RE: GP Purchasing All-in-One View

    I have upgraded GP10 (without PA installed) to GP2015R2 build 14.00.0817 (Release Date 9/21/2015 - latest build available as now) and during the testing of Purchasing All-in-One View I got exactly the same error you are getting.

    Since I thought the problem was related to the GP upgrade, I reviewed the tables DB_Upgrade, DU000010, DU000020, PA tables in the DBs. I have also run SQL Profiler, Script.log...and I couldn't find anything wrong except for the truncated text "Invalid Product ID 25" in the log script.

    Scrip log with PA:

    'PM_InvoiceSection_Scroll SCROLL_FILL on form PM_VendorAnalysis'
    'PM_InvoiceSection_Scroll Zoom Button_CHG on form PM_VendorAnalysis'
        'PA_PO_OpenEEInquiry', "00000000000000302", 0
            'SQLPath', 258, 6, 22016, ""

    Scrip log without PA:
    'PM_InvoiceSection_Scroll SCROLL_FILL on form PM_VendorAnalysis'
    'PM_InvoiceSection_Scroll Zoom Button_CHG on form PM_VendorAnalysis'
        'SuppressException', 0, 0, 2, 0, 1834, 6, 44, 27, -3001, 124, "Invalid Product ID 25"
            'IsServiceMode()', 0

    Then I decided to test a new GP2015R2 install (with PA installed) using Fabrikam test company, All-in-One View worked ok, but soon after I removed PA from the Dynamics.set file I got the error Invalid Product ID 258.

    It is very likely the problem is related to a bug in "Purchasing All-in-One View" and will need to be reported to Microsoft.

  • Suggested answer
    Terry R Heley Profile Picture
    Terry R Heley Microsoft Employee on at
    RE: GP Purchasing All-in-One View

    This is Terry from Microsoft, I just want a put a note on this forum that we know about the issue and it will not be fixed.  This is ONLY a problem in Fabrikam sample company, due to the sample data and we would not fix this as we would assume in sample company for demo purposes you would have project accounting installed. 

    You do not receive this error in your LIVE company databases.  Thanks

    Terry Heley
    Microsoft

  • coquisalsa Profile Picture
    coquisalsa 2,725 on at
    RE: GP Purchasing All-in-One View

    Hi Terry,

    Unfortunately the problem not only occurs in Fabrikam sample company, but also in all our company databases.

    Thanks,

    Jorge

  • Community Member Profile Picture
    Community Member on at
    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.

  • coquisalsa Profile Picture
    coquisalsa 2,725 on at
    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

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans