Home » Listing Details
Top Websites
  1. Dynamics GP Help
    Over 6500 resources listed.
  2. Mark Polino's DynamicAccounting.net
    Over 5100 resources listed.
  3. Rose Business Solutions Blog New
    Over 2200 resources listed.
  4. Developing for Dynamics GP - By David Musgrave and the MS GP Dev Support Team
    Over 1100 resources listed.
  5. Mariano Gomez at The Dynamics GP Blogster
    Over 1000 resources listed.
  6. Microsoft Dynamics Partner Community Blog
    Over 900 resources listed.
  7. Christina Phillips, Steve Endow & Lorren Zemke at Dynamics GP Land
    Over 700 resources listed.
  8. Mohammad Daoud's Dynamics GP Blog
    Over 600 resources listed.
  9. Vaidy Mohan at Dynamics GP - Learn & Discuss
    Over 500 resources listed.
  10. Inside Microsoft Dynamics GP Official Blog
    Over 500 resources listed.
  11. eOne Business Solutions Blog
    Over 400 resources listed.
  12. About Dynamics, Development and Life
    Over 300 resources listed.
  13. Frank Hamelly at GP2theMax
    Over 300 resources listed.
  14. Dynamics CPM
    Over 300 resources listed.
  15. BKD Dynamics GP Insights Blog
    Over 200 resources listed.
  16. Leslie Vail at Dynamics Confessor Blogspot
    Over 200 resources listed.
  17. Victoria Yudin's Dynamics GP Website
    Over 200 resources listed.
    Victoria Yudin
  18. Janakiram M.P. at DynamicsBlogger
    Over 100 resources listed.
  19. VS Tools Forum
    Over 100 resources listed.
    Your Resource for Visual Studio Tools for Dynamics GP
  20. Inside Microsoft Dynamics GP Official Blog
    Over 100 resources listed.
  21. US Dynamics GP Field Team Blog
    Over 100 resources listed.
  22. Catherine Eibner MBS Developer Evangelist
    Over 100 resources listed.
  23. Sivakumar Venkataraman at Interesting Findings & Knowledge Sharing
    Over 100 resources listed.
  24. Dynamics Small Business
    Over 100 resources listed.
  25. Belinda, The GP CSI
    Over 100 resources listed.

Title:Business Portal – Invalid Object Name errors

When the user launched the Business Portal website, and navigated to enter a purchase requisition for this new company, they could create the requisition header just fine. They clicked on the Add Item field to open the item selection window. Did a look up on the item numbr field, to display a list of the available items in GP…all fine so far. However, once they selected an item and clicked Select, they got the following message:

The multi-part identifier “T2.Null.[CMPTITNM]6″ could no be bound. ORDER BY items must appear in the select list if the statement contains a UNION, INTERSECT or EXCEPT operator. The multi-part identifier  “T2.Null.[CMPITUOM]7″ could no be bound. ORDER BY items must appear in the select list if the statement contains a UNION, INTERSECT or EXCEPT operator.

The source of this issue was the database compatibility level. It was set to 90 (MSQL 2005) …and should have been 80 (MSSQL 2000).

To change compatibility levels, open MSSQL enterprise manager and log in. Select the database you want to change, click on Properties, and then click on Options. The database compatibility is displayed in a drop down list box. Simply select a new value and save.

Once done a new error message appeared at exactly the same spot:

‘Invalid Object Name ‘company database name’ ..IV_Item_Quantities.

This time, the issue was that there are a number of BP views that need to be created in each company database. These had not been created for this company. To find these, expand the company database in MSSQL Enterprise Manager and click on Views. If you get an Invalid Object Name Error, it will be followed by the actual object name that is causing the problem. Check if this is listed in Views.

Missing views can be created very easily. On whatever server BP is installed on, go to the following directory:  C:\Program Files\Microsoft Business Solutions\Business Portal\Utilities\SQL\Company\GP_COMMON (Replace Microsoft Business Solutions with Dynamics for versions after V8). Here will be listed a number of MSSQL queries which are named as per the objects they create. Open the one you need, and copy its contents into a SQL query window on the MSSQL Server. Run the query against the company database to create the view. Once done, run the Grant.sql query to be sure, to be sure.

If you can’t locate the GP_COMMON folder at the path above, just do a search on the BP Server, they will be there somewhere depending on the original install path chosen.

Link Owner:
Date Added:June 17, 2010 02:06:36 AM
Number Hits:10
RatingsAverage rating: (0 votes)

No Reviews Yet.