Skip to content
+1-888-319-3663

COMMUNITY FORUM

GP2013: Adding Extender fields to pick list report

jbgrobler asked 8 years ago

Hi,

We have created an Extender window called "ORDER_HEADER" and assigned it to the SOP Entry window. It is set up to use only the SOP Number as a key. The window works as expected and data can be viewed and/or edited from the Additional menu entry in the SOP Entry window.

I have been trying for hours to get the fields to print on the picking ticket report. Just trying the first 2 fields as calculated string fields:

FUNCTION_SCRIPT(rw_TableHeaderString 3107 "ORDER_HEADER" 'SOP_HDR_WORK'.'SOP Number' 0 1)
FUNCTION_SCRIPT(rw_TableHeaderString 3107 "ORDER_HEADER" 'SOP_HDR_WORK'.'SOP Number' 0 2)

However, the fields on the report remain blank.

I also tried to add a calculated field that trims the SOP Number, and use that in the function instead of 'SOP_HDR_WORK'.'SOP Number' but no luck.

Printing just the 'SOP_HDR_WORK'.'SOP Number' field works, and it is the correct SOP number. I have made sure there is data in the Extender window for this particular order.

Does anybody have any suggestions that may help?

Regards,
Jako Grobler

Answers
Best Answer
Nicole answered 8 years ago

There are a couple of things that I can think of to check.
1.  Make sure that you are on build 80 of Extender as this is the only build it will work on. (Microsoft Dynamics GP – Tools – Extender – About Extender)
2.  In your calculation, there shouldn't be the single quotes around the SOP_HDR_WORK.SOP Number.  It should look like the following:

FUNCTION_SCRIPT(rw_TableHeaderString 3107 "ORDER_HEADER" SOP_HDR_WORK.SOP Number 0 1)


If you would like to submit an answer or comment, please sign in to the eOne portal.