Skip to main content
Answer

Invalid field name error in Report Designer - Customer Statements -Terms

  • April 2, 2025
  • 2 replies
  • 80 views
L
Captain II
Forum|alt.badge.img+5

Adding the Terms defined on the customer to the customer Statement Report.  AR641500

The Customer table is part of the standard report, but when I add any of the Terms_ID fields to the report I get an error saying it is invalid.  Any thoughts?

I have tried all 3 of these with the same results.  This is under Customer in the tree shown in the image below.

 

Best answer by BenjaminCrisman

​@ltussing03 From what I can tell the Terms was removed from the Customer table, this is after refreshing the report schema:

I think you’ll need to join in the Terms table to get the detail needed

 

If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.

    2 replies

    BenjaminCrisman
    Acumatica Employee
    Forum|alt.badge.img+4
    • BenjaminCrisman
    • Acumatica Support Team
    • Answer
    • April 2, 2025

    ​@ltussing03 From what I can tell the Terms was removed from the Customer table, this is after refreshing the report schema:

    I think you’ll need to join in the Terms table to get the detail needed

     

    Chris Hackett
    L
    L
    Captain II
    Forum|alt.badge.img+5
    • ltussing03
    • Author
    • Captain II
    • April 2, 2025

    Thanks!

    If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
    Chris Hackett
    Terms & ConditionsCookie settingsAccessibility 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