Skip to main content
Solved

AR631000 into GI

  • March 27, 2026
  • 3 replies
  • 62 views
M
Freshman I

Hi everybody ! 

 

By any chance, does anyone have the AR631000.rpx in the Generics Inquiry?
We’d like to add the AR value to our dashboards with the age date set to a specific date.

 

Thank you in advance,

Best answer by KrunalDoshi

Hi ​@MargauxCella,

You can apply similar formula in GI as per the AR Aging report (AR631000). I have created similar GI and it was working as expected. Below screenshot will help you, where [AgingDate] is the Today’s date GI parameter.

One such formula is below for your easy reference.

=IIf( DateDiff( 'd', ISNULL([ARInvoice.DueDate],[ARInvoice.DocDate]), [AgingDate] )>0  AND DateDiff( 'd', ISNULL([ARInvoice.DueDate],[ARInvoice.DocDate]), [AgingDate] )<31 , IIf( [ARInvoice.DocType]='CRM' OR  [ARInvoice.DocType]='PMT' OR  [ARInvoice.DocType]='PPM', -[ARInvoice.DocBal], [ARInvoice.DocBal]), 0)

 

      3 replies

      nickcerri32
      Captain II
      Forum|alt.badge.img+7
      • nickcerri32
      • Captain II
      • March 27, 2026

      ​@MargauxCella  This thread has an AR Aging GI.  Take a gander and see if it’ll work for you.  AR aging Report to Generic Inquiry | Community

      Nick - If we helped give us a Like. If we answered your question, select the Best Answer option.
        M
        Freshman I
        • MargauxCella
        • Author
        • Freshman I
        • March 30, 2026

        Thank you for your response!

        Unfortunately, we already have something very similar, and we’re specifically looking for an AR Aging GI that uses the same AgeDate parameters as the one in the Report Designer. I’ve tried several combinations, but the results between the Report Designer and the GI are always different because of the date handling. :( 

        KrunalDoshi
        Varsity III
        Forum|alt.badge.img+6
        • KrunalDoshi
        • Varsity III
        • Answer
        • March 30, 2026

        Hi ​@MargauxCella,

        You can apply similar formula in GI as per the AR Aging report (AR631000). I have created similar GI and it was working as expected. Below screenshot will help you, where [AgingDate] is the Today’s date GI parameter.

        One such formula is below for your easy reference.

        =IIf( DateDiff( 'd', ISNULL([ARInvoice.DueDate],[ARInvoice.DocDate]), [AgingDate] )>0  AND DateDiff( 'd', ISNULL([ARInvoice.DueDate],[ARInvoice.DocDate]), [AgingDate] )<31 , IIf( [ARInvoice.DocType]='CRM' OR  [ARInvoice.DocType]='PMT' OR  [ARInvoice.DocType]='PPM', -[ARInvoice.DocBal], [ARInvoice.DocBal]), 0)

         

        Krunal D - Acumatica Developer | www.linkedin.com/in/onlyleader | https://krunaldoshi.com/
          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