Skip to main content
Solved

AR Aging - Error: Can't calculate expression node

W
Freshman II

When running the AR Aging report for some accounts it works while for some others it doesn’t. 

 

I get this error: 

6/4/2024 8:18:56 AM Error:
Can't calculate expression node: 'pageHeaderSection2 (PX.Reports.Data.PageSectionNode) dataItem: '.

 

 

Best answer by Laura02

Hello @williamq178 ,

Is your AR Aging report customized?  If so, deactivate any custom versions to determine whether customizations have caused the error.  Users in the Report Designer Role can see the Report Versions tab and de-activate custom versions of the Aging report.

Alternatively, the person who customized the report could correct what is wrong in Page Header Section 2.  You could zip and attach the custom report (if it is indeed customized)  to this thread for further help debugging from report design experts in Acumatica Community.

Laura

View original
    darylbowman
    Laura02
    2 people like this
    • darylbowman
      darylbowman
    • Laura02
      Laura02
    Did this topic help you find an answer to your question?

    Laura02
    Captain II
    Forum|alt.badge.img+19
    • Laura02
    • Captain II
    • 3132 replies
    • Answer
    • June 4, 2024

    Hello @williamq178 ,

    Is your AR Aging report customized?  If so, deactivate any custom versions to determine whether customizations have caused the error.  Users in the Report Designer Role can see the Report Versions tab and de-activate custom versions of the Aging report.

    Alternatively, the person who customized the report could correct what is wrong in Page Header Section 2.  You could zip and attach the custom report (if it is indeed customized)  to this thread for further help debugging from report design experts in Acumatica Community.

    Laura

    Laura ~ Klear Systems, Inc. Irvine, CA. ~ Click my logo to Follow me ~
    Chris Hackett
    W
    2 people like this
    • Chris Hackett
      Chris Hackett
    • W
      williamq178
    W
    Freshman II

    Hi @Laura02 

     

    Thank you for the quick response. I think you pointed me to the right direction. I just check on our sandbox and I can run the report there for the same accounts that fail to run in production. We have several new versions of the report on production. Will try with different versions and will report back with any findings. Thanks!

    Laura02
    Chris Hackett
    2 people like this
    • Laura02
      Laura02
    • Chris Hackett
      Chris Hackett
    W
    Freshman II

    Thank you @Laura02. We were able to find the Issue on HeaderSection2 and fix it. One last thing. How can I uncheck the Answer on the forum to mark your comment as the correct answer? I accidentally marked the wrong post as the answer. 

    Laura02
    Chris Hackett
    2 people like this
    • Laura02
      Laura02
    • Chris Hackett
      Chris Hackett
    Laura02
    Captain II
    Forum|alt.badge.img+19
    • Laura02
    • Captain II
    • June 4, 2024

    Hello @williamq178 ,

    Sometimes it happens, the wrong post gets marked as the answer. We can summon @Chris Hackett , superstar Community Manager, and he will work his magic to change the situation.  😃

     

    Thanks!

     

    Laura

    Laura ~ Klear Systems, Inc. Irvine, CA. ~ Click my logo to Follow me ~
    Chris Hackett
    W
    2 people like this
    • Chris Hackett
      Chris Hackett
    • W
      williamq178
    Chris Hackett
    Community Manager
    Forum|alt.badge.img
    • Chris Hackett
    • Acumatica Community Manager
    • June 4, 2024

    LOL, all fixed @williamq178 

    Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
    W
    1 person likes this
    • W
      williamq178

    Reply


    Most helpful members this week

    Terms & ConditionsCookie settings

    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
    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