web
You’re offline. This is a read only version of the page.
close
Skip to main content
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
I have the same question (0)
  • Verified answer
    Abhinav Mehra Profile Picture
    Abhinav Mehra on at
    RE: Date Consideration for Aging bucket

    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
    RE: Date Consideration for Aging bucket

    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
    RE: Date Consideration for Aging bucket

    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

Responsible AI policies

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

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

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

#1
Sumit Singh Profile Picture

Sumit Singh 2,163

#2
OussamaSabbouh Profile Picture

OussamaSabbouh 1,908

#3
YUN ZHU Profile Picture

YUN ZHU 1,878 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans