Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Sue Barrett]

Can anyone please help me revisit why the “Document Date” on a purchase invoice is replaced by the “Posting Date”?
For us – the “Document Date” is the vendor invoice date on which the payment terms are applied and the “Due Date” calculated.
We have an approvals system however; and the invoice is not posted until the final approval has been obtained – at which time the “Posting Date” is edited to reflect the date the purchase invoice is actually posted to the ledgers in NAV.
When the “Posting Date” is changed however; the “Document Date” is also changed to the value in the “Posting Date” field and the “Due Date” is automatically recalculated.
The “Document Date” then needs to be manually edited back to the original static vendor invoice date – very annoying.
Can anyone please provide some insight as to why NAV works in this way?

——————————
ES Barrett
NAV Project Manager
Sudbury
——————————

[David Wiser]

There is a line of code in table 38 (Purchase Header) which sets the Document Date to the Posting Date whenever the Posting Date is changed but only if there are no Incoming Documents attached to the order.  If there is at least one Incoming Document Entry assigned to the invoice, you can change the posting date and it will not change the document date.

Now the problem is that not too many companies use the Incoming Document feature.  Because of this, you should have your partner (or you can do it if you have access to the C/AL code) comment out the line in the code which tests for this.  The lines in question are shown below (shown already commented out).  Please remember to test this beforehand.

——————————
Dave Wiser
Controller
Beckwith & Kuffel
Seattle WA
——————————
——————————————-

[Kim Dallefeld]

So Dave, are you saying that the approval counts as an ‘incoming document’? I didn’t realize that happens, good to know. Thank you.

——————————
Kim Dallefeld
NAV Consultant
Past NAVUG Chair
NAVUG Programming Committee
Ft Worth, TX
Kim@Dallefeld.com
——————————
——————————————-