Solved

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

  • 24 May 2022
  • 3 replies
  • 192 views

Userlevel 3

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

 

icon

Best answer by ChrisWeidner 24 May 2022, 20:33

View original

3 replies

Userlevel 3

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. 

 

Userlevel 3

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. 

 

Userlevel 7
Badge +7

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:

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

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

Reply


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 — 2022  Acumatica, Inc. All rights reserved