Skip to main content
Solved

Cannot resolve the table name: [PX.Objects.CR.CRLeadContactValidationProcess+Contact2]


ChrisWeidner
Varsity I
Forum|alt.badge.img

We are unable to print Paystubs (PR.64.10.15) after upgrading to 2021R2 build 21.209.0034. I cannot find this as a known issue, but assume that anyone using Payroll on this version would be impacted.

Error: Cannot resolve the table name: [PX.Objects.CR.CRLeadContactValidationProcess+Contact2]  

Trace: empty

 

Best answer by ChrisWeidner

SOLUTION: 

1. you can open the report pr641000.rpx in report designer
2. Go to File>Build Schema
3. Load Schema
4. click on Refresh All
5. Remove Contact2 from Tables added on the right and add it again

6. save the report.

 

@mikedavidson07 , Unfortunately this is related to the tables in the Report Designer. So I am unable to view the report versions on the Acumatica interface. The Paystub report was not customized though, so it seems to be an issue with something else. 

 

View original
Did this topic help you find an answer to your question?

4 replies

Forum|alt.badge.img
  • Acumatica Employee
  • 46 replies
  • December 17, 2024

When it comes to this kind of errors, if possible, user could test by reverting report back to the out of box report, which would also resolve the issue, this would make use of the default report 


Irina
Community Manager
Forum|alt.badge.img+8
  • Acumatica Support Analyst
  • 524 replies
  • May 25, 2022

Hello everyone,

This usually happens when out-of-the-box report was customized before the upgrade: the upgrade procedure only changes uncustomized out-of-the-box reports to preserve changes, and the custom reports should be adjusted by the customizer.

There are plenty of examples in our KB, here is one of them:

https://community.acumatica.com/reports-and-generic-inquires-83/how-to-resolve-the-cannot-resolve-the-table-name-px-objects-ap-selectedvendorlocation-error-on-custom-check-forms-after-acumatica-erp-has-been-upgraded-to-version-2020-r2-or-later-3779

Also, there are techniques collected on how to review and include changes between major versions in your customized reports:

https://community.acumatica.com/maintenance-and-troubleshooting-15/how-to-resolve-errors-on-custom-reports-and-generic-inquiries-after-acumatica-erp-has-been-upgraded-4844

We are woking on providing better tools to resolve such issues.


ChrisWeidner
Varsity I
Forum|alt.badge.img
  • Author
  • Varsity I
  • 27 replies
  • Answer
  • May 24, 2022

SOLUTION: 

1. you can open the report pr641000.rpx in report designer
2. Go to File>Build Schema
3. Load Schema
4. click on Refresh All
5. Remove Contact2 from Tables added on the right and add it again

6. save the report.

 

@mikedavidson07 , Unfortunately this is related to the tables in the Report Designer. So I am unable to view the report versions on the Acumatica interface. The Paystub report was not customized though, so it seems to be an issue with something else. 

 


mikedavidson07
Jr Varsity II
Forum|alt.badge.img+1

Hi Chris,

Do you have a customized version of the stub?  If yes, you could try the original version of the stub.  I would also recommend you contact your business partner as they can open a support case with Acumatica. 

If you want to see version of the form, you will need to have the ReportDesigner role.  Then expose the from to the payroll desk top by opening the site map, search for PR..64.10.15.  In the Workspaces column select Payroll, the Category column select Reports and save.  This places the from in the Reports section of the payroll desktop.  This will allows you to open the from control and you can view the REPORT VERSIONS tab. 

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings