Finance | Project Operations, Human Resources, ...

Data Entity Containing Sales Invoice Due Dates

(0) Share

Report

Posted on by Neil Cotton

Good afternoon all,

I am trying to find a data entity that simply contains the due date of a sales invoice, that appears on the Sales Invoice Header.

There is Due Date on Customer Invoice Journal Lines, but these are only for journalled invoices, and not regular posted sales invoices.

Is there anyway to get at the due date for the sales order invoices? I can't understand why it's not on the Sales Invoice Header entity. It's boggling.

Many thanks in advance for your support.

Regards
Neil

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Alireza Eshaghzadeh 14,679 Super User 2025 Season 2 on at

Like (0)

Report

Hi

There is field "FIXEDDUEDATE" on 'Sales order headers V2' entity that presents due date defined for the sales order.

Was this reply helpful? Yes No
Neil Cotton 74 on at

Like (0)

Report

Hi Alireza Eshaghzadeh ,

Thanks for your reply. The FixedDueDate entity value comes from the Sales Order Header : Due Date field. Unfortunately, in our system this field is not populated. I don't know why this is the case, what this field should/could do. I'm assuming it's functionality that calculates Due Date on the date that the sales order was raised + payment terms (as the Due Date on a Sales Order is 1:1)

This is a Sales Order (that has already been invoiced).

However, the payment due date of an invoice is actually the Invoice Date + Payment Terms, as one Sales Order could generate many invoices.

You can see below the invoice of the above SO, the invoice date of the 10th December (US Date Format) has a due date of 8th February (10 December + 60 Days [60D shown in the SO Payment terms above])

This Due date, is the field I need

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,679 Super User 2025 Season 2 on at

Like (0)

Report

Hi Neil,

Provided field for due date is related to customer transaction that unfortunately there is not a standard entity for this in D365FO. So, you need to go for customized entity for CustTrans.

Was this reply helpful? Yes No
Neil Cotton 74 on at

Like (0)

Report

Hi Alireza,

That seems to be worryingly true. I find it so difficult to understand why such a vital piece of information isn't in the standard entity (or ANY entity).

Regards

Neil

Was this reply helpful? Yes No