Skip to main content
Question

Trouble with join field on a generic Inquiry

  • May 28, 2026
  • 2 replies
  • 9 views
S
Freshman I

Been struggling for a couple days to create a GI to extract Cash Receipts and Cash payments for projects.  Question is:

"In Acumatica 25R1   I am building a Generic Inquiry joining PMProject, ARPayment, APPayment, PMTran and PRPayment. Getting error: Conversion failed when converting nvarchar value 'X' to data type int. Join is PMProject.ContractCD = ARPayment.ContractCD. What is the correct join field?"

    2 replies

    lauraj46
    Captain II
    Forum|alt.badge.img+9
    • lauraj46
    • Captain II
    • May 28, 2026

    Hi ​@swhitley ,

    I believe the correct join is PMProject.ContractID = ARPayment.ProjectID

    Hope this helps!

    Laura

    Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
    BenjaminCrisman
    Acumatica Employee
    Forum|alt.badge.img+4

    ​@swhitley Try joining on ContractID. The non-project code is by default X, so it seems like it’s trying to convert ARPayments with non-project code and it can’t, but typically the ID field is the best to join on. From the GI Data Sources tab you can click on the table to open the DAC Schema Browser and check the key linking fields to use.

    You can also navigate to Merged DAC Relations screen and enter a table to see which fields to connect to another table, very useful.

    Terms & ConditionsAccessibility statement
    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