Autofill field based on another field

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi,

I have following problem, i need to fill Document Date and Shipment Date based on Posting Date, kind of like set those two fields default values to Posting Date,But if users wants they can change dates.

Does anyone know how to manage that? Its Microsoft table 36 and pages 42, 43.

Thank you!

*This post is locked for comments

All responses (2)

Answers (1)

Community Member Microsoft Employee on at

Like (1)

Report

RE: Autofill field based on another field

Thanks, i found solution yesterday and it was exact same code, you understood my question correctly :)

Thanks!
Verified answer

Marcellus 2,735 on at

Like (0)

Report
RE: Autofill field based on another field

Hi Linards,

I think that's how standard NAV works. When you create a new order the Shipment Date, Order Date and the Posting Date will be set to the workdate and the users can change them.

In the InitRecord() method in the Sales Header table 36 you can see this code snippets (these are just lines from the method this is not what it actually looks like):

IF "Document Type" IN ["Document Type"::Order,"Document Type"::Invoice,"Document Type"::Quote] THEN BEGIN "Shipment Date" := WORKDATE; "Order Date" := WORKDATE; END;

IF NOT ("Document Type" IN ["Document Type"::"Blanket Order","Document Type"::Quote]) AND ("Posting Date" = 0D) THEN "Posting Date" := WORKDATE;

"Document Date" := WORKDATE;

I apologise if I don't understand your question correctly.