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.

  • Verified answer
    Xenia Watterson Profile Picture
    30 on at
    RE: Trying to find a date created field for Customer Invoices

    Thank you!  This was all very helpful

  • Suggested answer
    Inge M. Bruvik Profile Picture
    999 Moderator on at
    RE: Trying to find a date created field for Customer Invoices

    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.

  • Suggested answer
    YUN ZHU Profile Picture
    78,978 Super User 2025 Season 1 on at
  • Suggested answer
    ew98000 Profile Picture
    225 on at
    RE: Trying to find a date created field for Customer Invoices

    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.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,025 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,837 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans