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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Date Consideration for...
Small and medium business | Business Central, N...
Answered

Date Consideration for Aging bucket

(0) ShareShare
ReportReport
Posted on by Gopinadh 15

Hi,

Please explain me how the aging bucket considering dates from the posting?

In Business Central we have only Work Date as posting date, here can we use invoice date or due date as posting date? Please suggest me the better approach to have correct aging periods in the report.

Here we were migrated the data from GP and the Due dates are from 2017 onwards and all these data migrated to BC on 12/01/2019 hence all these transactions are coming under 60days bucket. Can we use the actual due dates as posting date?

pastedimage1581577517454v1.png

Thanks,

GE

Categories:
Dynamics 365 Business Central
Dynamics 365 Business Central
Dynamics 365 Business Central
  • Verified answer
    Abhinav Mehra Profile Picture
    Abhinav Mehra on at

    Hi,

    As per the Sales & receivable Setup, Default Posting date has given Workdate which means whenever you will create sales Document at that time Posting date will get filled as Workdate.

    If you choose No date as Default Posting date in setup at that time Posting date will come blank.

    Regrading aging, If you are managing due date based on payment terms then your Due date will calculate Posting date+Payment terms.

    So basically Your

    Posting Date = Workdate

    Due Date = Workdate + Payment Terms

    You can extract your aging report based on posting date as well as Due date.

    I hope this will help you to understand the scenarios.

    Regards,

    Abhinav Mehra

  • Gopinadh Profile Picture
    Gopinadh 15 on at

    Thanks Abhinav,

    Can the end user enter past dates (if we select No date) manually while we are posting the Invoice.

    Regards

    GE

  • Verified answer
    Abhinav Mehra Profile Picture
    Abhinav Mehra on at

    Hi,

    Yes, You can select Past dates also but at that time system will just through warning message & allow you to post the document on past date If you did not restricted to post past dated entries.

    Regards,

    Abhinav Mehra

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the September Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 795 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 561 Super User 2026 Season 2

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 323 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans