Skip to main content
Solved

Average Days to Pay - Report

  • Mar 8, 2022 7:00 PM UTC
  • 6 replies
  • 1672 views
  • Translate All
shellie40
Freshman I

Is there an existing report in Acumatica that calculates the Average Days to Pay for Customers?   Needing a report that shows the metrics of payments for our Net 30 accounts.    

Best answer by Kandy Beatty

Hi @shellie40  There is currently nothing out of the box. You could create a Generic Inquiry for that. There is one in the Sales Demo dashboard. Here is the GI for it in the XML form and this is what it would look like:

 

View original
Shellie Lambert

    6 replies

    Kandy Beatty
    Captain II
    Forum|alt.badge.img+18
    • Kandy Beatty
    • Captain II
    • Answer
    • Mar 8, 2022 7:45 PM UTC

    Hi @shellie40  There is currently nothing out of the box. You could create a Generic Inquiry for that. There is one in the Sales Demo dashboard. Here is the GI for it in the XML form and this is what it would look like:

     

    Translate
    Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
      LeanneM
      Semi-Pro III
      Forum|alt.badge.img+4
      • LeanneM
      • Semi-Pro III
      • May 10, 2023 4:14 AM UTC

      By chance can you please also post the inquiries it has navigation too whic is GI000094 and GI000092

      Thanks so much

      Translate
        Jr Varsity III
        Forum|alt.badge.img
        • srengdahl
        • Jr Varsity III
        • Jul 30, 2024 1:24 PM UTC

        Thank you! 

        Translate
        Freshman I
        • Ob11
        • Freshman I
        • Dec 6, 2024 3:09 AM UTC

        This is good, anyone have the xml for the navigation GIs (GI000094 and GI000092)

        Translate
        Freshman II
        • SunnyM
        • Oct 15, 2025 7:40 PM UTC

        Anyone come across an issue with the widget for one user vs another is showing up blank. User only has access to one branch vs me having access to all. 

        Translate
        Freshman I
        • mmaran
        • Freshman I
        • Jun 2, 2026 8:08 PM UTC

        How do I use the XML file above in Acumatica to create this report?

         

        Translate
        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