Unable to open Project Quote listing after upgrading to 2020R2

  • 30 January 2021
  • 1 reply

We upgraded to version 20.207.0012.  The upgrade path was:

from 19.205.0023 to 19.206.0036

then to 20.201.0051

then to 20.202.0043

finally to 20.207.0012

We did all of these update is one night and did not test inbetween updates.

Testing seems to show most things are fine, however we now cannot open the Project Quotes listing page.  We are able to open the Project Quotes form (PM304500) and we can open existing quotes using that form, but any attempt to visit the Project Quotes listing (PM3045PL) results in this error:

A table with the alias Owner cannot be found.


We have in the past applied a customization project pertaining to quotes, but we unpublished before the upgrade and have not yet republished.  Those customization projects did not affect PM3045PL, but they did make changes to PM304500 and they did add a couple of columns to the CROpportunitiesProducts database table.  Of course, those columns are still in the database.

Any help sorting this out would be much appreciated.


Best answer by martyjensen61 1 February 2021, 14:04

View original

1 reply

We sorted this out, thanks to our consultant, Bill at Premier Computing.  He helped us understand that there was a relation defined for the PM-Quotes generic inquiry referencing the Owner table.  I am not sure how or when that relation came about, but disabling the relation fixed the problem.  Apparently the Owner table is no longer a thing in 2020 R2.  All of this is very closely related to this post:  



About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved