extender

[TheKnee]

I need to print on sop * order form, some information i add in a extender feild how do i retreive this information in report writer

 

[PTina]

create a calculated field using thr RW_TableHeaderString function. The calculated field should be a string and the expression should look something like this:

FUNCTION_SCRIPT (rw_TableHeaderString 3107 "window name" SOP Number 0 1)

Note:
window name - extender window name
SOP Number - key taken from the SOP_HDR_Work file
0 - filler; used instead of SOP Number if key was numeric.
1 - the field number on the extender window.

drag calculated field unto report.

 

[TheKnee]

There is something i don't understand
In the sop long order form, i whant do add a feild after the item number on eache line off the order the one will be linked to itemnumber as well

my extenter form name is location, i need to print feild #1

 

[PTina]

Is your extender window on the Sales Line Items then you have a concatenated key. Do another calculated field to concatenate the key fields and use this new calculated field as the key in script.

Steps to concatenate Field:
1) Name field and set the Result Type to String.
2) Functions tab --> System --> Function: LNG_STR
3) Add function string .
4) Fields tab --> Select table and key field #1.
5) Add field.
6) Operators: CAT
7) Functions tab --> System --> STRIP
8) Add function string.
9) Fields tab --> Select table and key field #2.
10) Add field

The final result should look something like this:
LNG_STR(SOP_Line_Work.Item Number) # STRIP (SOP_LINE_Work.SOP Number)



Steps for rw_TableHeaderString:
1). Name the calculated field and set the Result Type to string.
2) unctions tab --> User Defined --> Core: System --> Function: rw_TableHeaderString.
3. Add the function.
4) Constants tab --> Type: Integer --> Constant: 3107
5) Add the constant.
6) Constants tab --> Type: String --> Constant: location
7) Fields --> Calculated --> soplinekey
8) Add the key field.
9) Constants tab --> Type: Integer --> Constant: 0
10) Constants tab --> Type: Integer --> Constant: 1


Final result in my previous response.