cancel
Showing results for 
Search instead for 
Did you mean: 

how can i fill the lines of a document automatically

vasileiosfasolis
Active Contributor
0 Kudos

Dear all!

i am interesting to complete the lines of a document with the same values while fill the first line of the document.

is there any way?

Accepted Solutions (0)

Answers (3)

Answers (3)

frank_wang6
Active Contributor
0 Kudos

u can use Ctrl + M to duplicate current line. If it is not too many lines, u can try this.

vasileiosfasolis
Active Contributor
0 Kudos

Hi Frank

I do not want to copy all the data of the line to another line. i am interested to copy the data of one column to all the lines

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

By using FMS, you can copy same value into rows while creating new item items.

It is not possible fill automatically by filling first row. You may need SDK help. For example, if you enter delivery date at header level, system will update automatically all rows.

Thanks

Former Member
0 Kudos

Hi,

I didn't get you. Can you explain it in detail

vasileiosfasolis
Active Contributor
0 Kudos

lets consider that i have a sales invoice

there is a column named date

if i fill the first line of the doucument, the rest of the lines(if it is consider that there are 50 lines) to completed automatically with the same value

Former Member
0 Kudos

Try to use FMS or use copy paste option (only for 9.1)

Former Member
0 Kudos

Hi Vasileios,

Do you mean all the 50 lines should copy same Date automatically?

Thanks,

Rahul

vasileiosfasolis
Active Contributor
0 Kudos

yeap....

Former Member
0 Kudos

Okay, Then follow the below procedure.

1. Create a UDF with Date as datatype on header level of the document.

2. Create a FMS to copy this date in UDF on Date field of Row level Date

3. Apply this FMS on Row level Date field and keep auto refresh on some field which can bring this date in UDF date to Row Level Date field.

Hope this will resolve your problem.

Thanks,

Rahul

vasileiosfasolis
Active Contributor
0 Kudos

is it possible by this way to complete 2 different columns of the same document?

if the first column named date1 and the second column date2, the udf on the header named header_date

if i change the header_date, the date1 and date2 will be filled automatically?

also, if i want the date 1 to be completed only by date2 because i make a dateadd() function, will it work?

Former Member
0 Kudos

Yes.

It should work as per my logic.

Thanks,

Rahul