Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Due date of sales retu...
Microsoft Dynamics GP (Archived)

Due date of sales returns and credits

(1) ShareShare
ReportReport
Posted on by Amelie 65

Payment terms on our sales transactions are set up so that invoices become due on the last day of the month the invoices is dated from (i.e. all March invoices are due on March 31).  

Due dates for sales returns & credits should follow the same payment terms, but for some reason, their due date is always = date of sales return.

Sales return are thus not aged properly and fall into the wrong categories when we look at our aging.  

Is it possible to age sales return with the same payment terms as invoices?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Due date of sales returns and credits

    Same issue here. Please let us know how to resolve. Otherwise, the credit will be incorrectly reducing an older aging column and could result in under reserving of bad debt.

  • Amelie Profile Picture
    Amelie 65 on at
    RE: Due date of sales returns and credits

    In case this might help someone else, I have come up with the following solution:

    In the Receivables Management Setup window:

    - Check "age unapplied credit amounts"

    - Choose age by document date

    - I then change the aging buckets every month before I run the aging of receivables so that all of one months invoices & credits are in the same bucket.  For example, for end of February 2015, my buckets were as follows:

    Current: 0-27

    31-60 Days: 28-58

    61-90 Days: 59-89

    91-120 Days: 90-119

    120 Days and Over: 120-999

    Regards,

    Amelie

  • Verified answer
    Justin Thorp Profile Picture
    Justin Thorp 2,265 on at
    RE: Due date of sales returns and credits

    Hi,

    As per the Receivables management pdf, and the built in help:

    Unapplied credit amounts are aged if you marked Age Unapplied Credit Amounts

    in the Receivables Management Setup window.

    If you mark this option, the receivables aging process will age unapplied credit amounts based on the document date in relation to the aging date, and how you set up your aging periods in Receivables Management. If you age documents by due date and you mark this option, the due date for credit documents will be the same as the document date.

    So it seems like the short answer to your question is, unfortunately, no.

    Thanks,

    Justin

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans