Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Average Days to pay ca...
Microsoft Dynamics GP (Archived)

Average Days to pay calculation

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Our average days to pay calculation seems to be off periodically for specific vendors.

A year ago I worked with MSFT to get a Receivables Average Days to Pay Recalc tool installed and this seemed to recalculate the avg days and LTD figures. Recently AR brought up an issue with a specific vendor so I naturally ran the utility and saw the avg days grow from 20 days to 23. However I am told that the vendor never pays less than 40-45 days.

As I drilled down I noticed that there are credits applied. How would having credits applied impact the aging for this specific vendor? The credits appear to be unapplied.

Could anyone elaborate the impact this would have on aging and or any other areas I could be looking at to identify as the cause of the ltd/ytd averages to be off.

Thank you

Mark

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Average Days to pay calculation

    Looks like the voided dates may have skewed the report.

    We are going to recalc a few manually, per MSFT I have obtained the following.

    Thank you Leslie!

    Mark

    One way to calculate Life-To-Date would be to use all non-voided posted Sales invoices that are fully applied. Use the Date Invoice Paid off field less the document date.  You can find this data using the Receivables Transactions object in SmartList (Dynamics GP > SmartList).

    Make sure the following columns are present:

    Customer Number, Document Number, Document Date, Date Invoice Paid Off, Document Type, Document Status, Original Trx Amount, Current Trx Amount.

    For Life-To-Date, set the following in the search Criteria:

    • Customer Number= Enter the Customer ID

    • Document Status is not equal to Work

    • Document Type=Sales/Invoice

    • Current Trx Amount = 0.00

  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Average Days to pay calculation

    Hi,

    I do not think you can change the calculation. I think you would have to write your own calculation and then overwrite the field value.

    Kind regards,

    Leslie

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Average Days to pay calculation

    If the CR memos are in fact the culprit, what can be done so that the memos do now skew the actual days to pay figure?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans