Skip to main content
Solved

Average Days to Pay - Report

  • March 8, 2022
  • 6 replies
  • 1605 views
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:

 

Shellie Lambert

    6 replies

    Kandy Beatty
    Captain II
    Forum|alt.badge.img+18
    • Kandy Beatty
    • Captain II
    • Answer
    • March 8, 2022

    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:

     

    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

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

      Thanks so much

        S
        Jr Varsity III
        Forum|alt.badge.img
        • srengdahl
        • Jr Varsity III
        • July 30, 2024

        Thank you! 

        O
        Freshman I
        • Ob11
        • Freshman I
        • December 6, 2024

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

        S
        Freshman II
        • SunnyM
        • October 15, 2025

        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. 

        M
        Freshman I
        • mmaran
        • Freshman I
        • June 2, 2026

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

         

        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