question

dynamics nav · 2016-07-28

I have to create a form using sales invoice line table,but there are three fields customer no, from date, to date and the fields from that table are below. but condition is when i put data in above three fields i mean customer no, from date and to date then all fields should retrieve automatically.I added a new field name purchase date and expiry date. so suggest me which type of form should i create and how, if any code need to write then please explain me?

archer89 · 2016-07-28

to fill fields automatically you can write the needed code into the validate triggers of the first 3 fields in that case, e.g. "customer no" - onvalidate:
"purchase date" := <what you want to write here>
...

you could also work with flowfields.

normally sales invoice line is connected with the sales invoice header table on a form, like in the posted sales invoice form. please check this form before you start.

dynamics nav · 2016-07-29

In sales invoice line i added two fields i.e, purchase date and expiry date and created a form with sales invoice header as a main form and sub form as sales invoice line. the header consists of customer no, from date and to date. sub form consists of fields like document no,line no, item no,sell-to customer no,display purchase date and to date.
Now my condition is that when i enter the fields in header i.e, customer no, from date and to date then the information should retrieve automatically in the sub form.
Information in the sub form should be displayed by filtering the from date and to date to purchase date field in sub form.
If there is any standard form please say me I am using nav 2009 r2

Jan_Veenendaal · 2016-07-29

[ looks a lot like this thread from same poster: forum.mibuso.com/discussion/67064/coding ]

question

Answers

Categories