How to copy data from repetaive area field into header area field

[Former Member]

Dear All,

In my invoice pld i have to display delivery date.so,

I created two database fields in repetative area.

Field1-A/R invoice->Base document key

Field2-Delivery->posting date

then in field2 content tab i related to field1.

Its working properly.

But i need this information on pld header.

for that,if am following the above procedure in header level.

Field1 executed succesfully

Field2 creates repetation on repetative area that is same item displayed multiple times.

finally,I come to the point.

i want to retrive the values of field2 from repetative area into header field and field2 in repetative area is invisible.

Help me out.

Regards,

Guru

Edited by: Vijay Guru on Sep 17, 2008 1:17 PM

[Former Member · Accepted solution]

Vijay,

If you put a field from Delivery on the Invoice header, it will always multiple the rows so this is not the way to the solution.

Why don't you put the AR Invoice - Rows: Base Document Number field simply in the header? In this case even if you have more than one Deliveries as base documents, the one relevant to the first row of the invoice will be displayed.

Not a perfect solution if you summarise several Deliveries into one Invoice but quite straightforward.

Regards,

Nat

[Former Member]

I already tried it susa

Ex, repetative area field=field_20

header field(formula field) = field_21 means,

in formula editor if am giving field_20 it shows as a text

its not working ...

[Former Member]

kalai we cant relate a field from one area to another area.if i do as per ur suggestion it shows an error fields belong to another part

[former_member583013]

Try to add a formula field on the Header and in the formula area just add the Repetitive area field

Example: Field_2

[Former Member]

Hi

Make that field2 invisible, copy and paste the same field and drag that to header. i hope this will work

[Former Member]

i want to retrive the values of field2 from repetative area into header field and field2 in repetative area is invisible

This is not possible because the Header Area is first Evaluated and Printed in PLD. Then only repetitive area is evaluated and printed.

So as a work around you can create a UDF in Marketing Document called 'DelDate' and write a FMS for this in the delivery screen to get the date.

When you use CopyTo from Delivery to Invoice, this value in the UDF is also copied to the Invoice Screen.

Now display the UDF in the PLD.

This would be the simple workaround.

[former_member186095]

Hi Vijay,

Pls post your message to this thread:

Rgds,