Ideas for Acumatica

Feedback processing: We do not reply to all messages, but we do read them, analyze them, and work to improve Acumatica based on the feedback we receive. Ideas and comments may not appear immediately. Some legitimate ideas are flagged as spam and will be added when we review the spam folders.
Content: This portal is for product ideas and feedback only. If you need customer service assistance, contact your Acumatica Support Partner, submit a support case, or get assistance from community resources: LinkedIn Group or StackOverflow
No Reliance: Information is maintained on a best-efforts basis and may be changed without notice. Acumatica cannot guarantee the accuracy of the information provided or guarantee completion of features/ideas described on this portal.

Average Days to Pay

Add a field Average Days for Payment in Customer Screen AR303000 to show average payment date in general (from invoice date)

Example:
Invoice 1 was paid 5 days after the invoice date. Invoice 2 was paid 10 days after the invoice date. Invoice 3 was paid 15 days after the invoice date. Divide this figure by the number of closed invoices - 30/3 - equals 10 as the average days to pay.

  • Nick Heuer
  • Jul 21 2017
  • Shortlisted
  • Attach files
  • Douglas Johnson commented
    13 May 17:09

    Workaround: in the latest SalesDemo we added 3 Average Days to Pay inquiries. (1) Average Days to Pay across all customers by date, (2) Average Days to Pay by customer - you can specify invoice dates, (3) Average Days to Pay Detail. All reports weigh partial payments ($10 down payment + $90 payment in 10 days = 9 average days to pay).

    Dashboards for AR Clerk and Controller in SalesDemo display inquiry results.

    Acumatica Partners can get the queries by downloading SalesDemo Dashboards 2020 R1 from https://portal.acumatica.com/services/acumatica-implementation-tools/.

  • david john commented
    September 23, 2019 04:35

    nicce

  • Jonathan McDole commented
    February 21, 2019 15:32

    We receive credit references all the time from other vendors who share our customers and this is always a question. Date account opened, high balance and average days to pay. This was standard functionality on our previous antiquated system. 

  • Steffany Plotts commented
    December 17, 2018 19:31

    Really need this functionality with having credit customers.  Would be nice to see an Average Days to Pay Year to Date and Life to Date calculation.  This is very helpful for collection purposes.

  • Melanie commented
    December 06, 2018 18:42

    When will this be available?

  • Jeffrey Patch commented
    June 25, 2018 22:59

    Suggest to include options to have weighted days to pay (sum of the (amount * days) / sum(amount)) and to consider multiple payments.

  • steven Hirsch commented
    April 06, 2018 15:47

    We created a Days Sales Outstanding report that lists the customer, invoice document date and closed date.  The detailed report includes all items, the # of days and an average, the summary report is just the average.  We thought about keeping it as a GI only but decided on a full report.  I wonder if we used a GI if a new field could be created in the customer record and pull the average in from the GI.

  • Jeffrey Patch commented
    September 02, 2017 04:53

    From due date and from transaction date

  • and 5 more