Skip to main content
Answer

Aging Report not working from Customer screen & shows "Invalid Field" when run directly

  • August 19, 2025
  • 5 replies
  • 174 views
T
Captain I
Forum|alt.badge.img+3

I’m facing an issue with the Aging report in Acumatica.

  • When I run it from the Customer screen, it doesn’t work as expected (no results / broken behavior).

     

  • When I run the report directly, it prints an error: "Invalid field".

  •  

It seems like the report is missing or misconfigured fields/parameters when launched from both places.

Has anyone experienced this before? Do I need to adjust the report parameters (like OrgBAccountID, CustomerID, or others) to fix this issue?

Any guidance or examples would be greatly appreciated.

Thanks in advance!

Best answer by bwhite49

This looks like somebody customized the report and removed the org parameter and changed the terms ID from the invoice to the customer terms.

You can add the parameter back to match the below...

You can also change the termsID to be ARInvoice.TermsID rather than from the customer master

 

You can also revert back to the original report by going into the version tab and deselecting the updated versions

 

1 Attachments
Taha Yab Ali

5 replies

bwhite49
Captain II
Forum|alt.badge.img+10
  • bwhite49
  • Captain II
  • Answer
  • August 20, 2025

This looks like somebody customized the report and removed the org parameter and changed the terms ID from the invoice to the customer terms.

You can add the parameter back to match the below...

You can also change the termsID to be ARInvoice.TermsID rather than from the customer master

 

You can also revert back to the original report by going into the version tab and deselecting the updated versions

 

Chris Hackett
A
T
Captain I
Forum|alt.badge.img+3
  • tahayabali
  • Author
  • Captain I
  • August 20, 2025

​@bwhite49 I have made changes you suggested above but there is another error 

 

Taha Yab Ali
bwhite49
Captain II
Forum|alt.badge.img+10
  • bwhite49
  • Captain II
  • August 20, 2025

I’m sure there is.  I would reset the report to stock by unselecting all report versions as shown in the last screenshot of my prior post.

Chris Hackett
mohammadnawaz51
Jr Varsity I
Forum|alt.badge.img+4

Hi ​@tahayabali 

Is this customized report? which version you are checking this?

https://www.acumatica.com/acumatica-marketplace/global-payex-ap-accounts-payable-automation-solution/
Chris Hackett
T
Captain I
Forum|alt.badge.img+3
  • tahayabali
  • Author
  • Captain I
  • August 21, 2025

​@mohammadnawaz51 are you talking report version or acumatica build?

Taha Yab Ali
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