web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
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

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

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    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?

  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at

    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 on at

    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans