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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Trying to find a date created field for Customer Invoices

(0) ShareShare
ReportReport
Posted on by 30

We are relatively new to using Business Central for Accounting system.  Our process is to create a Customer (Sales Invoice) and hold the invoice as an unposted Sales Invoice until we are able to send it to the Customer.  Mostly that is immediately but sometimes we hold an invoice for a period of time while waiting for an increase to our agreed Not to Exceed Amount or until the Customer sends us their PO#, so there is a difference between the date the invoice is created and the date the invoice is posted.  We currently manage this in a manual process of noting the original document date and when we post the invoice and it becomes a Posted Sales Invoice with the document date changing to match the Posted Date as the current date.  This is obviously messy and leaves room for human error and manipulation.  Every other database system I've ever interacted with has a system controlled "Date Created" but while looking through the fields visible I do not see this field.  I feel certain this has to exist but I am confused at hit somehow being unavailable to use for use in tracking when the invoice was actually created.

Also, if this field does exist would it carry from the Sales Invoice to the Posted Sales Invoice?

Thank you for your help.

I have the same question (0)
  • Suggested answer
    ew98000 Profile Picture
    229 on at

    Taking the example of a sales order document, there is an 'order date' field. This date does not change when you update the posting date to current date. The sales invoice document page does have the 'order date' field as well but it does not seem to be available to add to the page with personalization. I would hope that this field would behave the same way as on the sales order document. You would need ask a developer to make the order date field available to add to the page so that you could see it.

    Yes the order date carries through to the posted document but to see the field, it needs to be unhidden.

    What also can be helpful is to inspect the page and data using the question mark on the top right then selecting 'help & support'. This opens up a list of all the fields in the table on the right pane. Filter on 'created' and you will see the created date.

  • Suggested answer
    YUN ZHU Profile Picture
    95,729 Super User 2025 Season 2 on at
  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,111 Moderator on at

    As we9900 says, every record in Business Central are date and time stamped when created and modified. Also saving information about the user who created the record and last modified it.

    There fields are normally hidden in pages but you can have a developer make them visible if you need them. But you can also filter on them even if they are hidden. And all hidden fields can be inspected using page inspection. CTRL+ALT+F1.

  • Verified answer
    Xenia Watterson Profile Picture
    30 on at

    Thank you!  This was all very helpful

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…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,468

#2
YUN ZHU Profile Picture

YUN ZHU 923 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 607

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans