SOP Line Item Document
I'm trying to include SOP Line Item customizations built with Extender on a Report Writer SOP document (Order/Invoice) in GP2013. The field comes up blank.
I can see the key is passing correctly. My key order is Sales Document No first followed by Line Sequence. I am passing:
in the function call. This is correct according to the guide. I dug deeper (found a MS KB) that says if you are in doubt about the key to pass, query the EXT00100 table. I did that, but the table comes up empty. I can see my data in the other EXT tables, but nothing in EXT00100. My invoices are unposted.
Any help would be much appreciated.
The first thing I would recommend doing is making sure the order of the keys in the setup of the window as well as in the EXT01100 where the data is going to be. The EXT01100 is the new table in 2013 that would be the same as the EXT00100 in 2010.
Then, the two calculated fields that you have are going to look something like the following.
Key Fields Calculation:
STRIP(SOP_HDR_WORK.SOP Number) # LNG_STR(SOP_LINE_WORK.Line Item Sequence)
Extender Field Calculation:
FUNCTION_SCRIPT( rw_TableHeaderString 3107 “EXTRA_SOP_INFO” KeyFieldsCalc 0 1 )
In the calculation above, the EXTRA_SOP_INFO would be the ID of your Extender window and the KeyFieldsCalc would be the name or your calculated field for the keys.
Also, you may want to take a look at the document at the following link that outlines all the tables for Extender 2013.
If you would like to submit an answer or comment, please sign in to the eOne portal.