How to create a custom eConnect "Requester Document Type" to retrieve the Comment_1 information for a transaction in Sales Order Processing in Microsoft Dynamics GP


INTRODUCTION

This article describes how to create a custom eConnect Requester Document Type to retrieve the Comment_1 information for a transaction in Sales Order Processing in Microsoft Dynamics GP.

MORE INFORMATION

Note In this example, the eConnect Transaction Requester Service is used to gather the Comment_1 information for a Sales Order Processing transaction and to put the data into the eConnect_Out table. The new custom Requester Document Type must pull data from the Sales Line Comment Work and History table. The data will be retrieved from the SOP10202 table.

To create and to test a custom Requester Document Type, follow these steps:
1. Copy the following SQL script into SQL Query Analyzer. Then, run the script against the company database to create the settings that you want for this new Requester Document Type.
INSERT INTO eConnect_Out_Setup(QUEUE_ENABLED, DOCTYPE, INSERT_ENABLED, UPDATE_ENABLED, DELETE_ENABLED, TABLENAME, ALIAS, MAIN, PARENTLEVEL, ORDERBY,REQUIRED1, INDEX1, INDEX2, INDEX3, INDEX4, INDEXCNT, TRIGGER1, TRIGGER2, TRIGGER3, TRIGGER4,TRIGGERCNT, DATACNT, DATA1)VALUES     (0, 'SopComment', 1, 1, 0, 'SOP10202', 'SopComment', 1, 0, 0, 'COMMENT_1','SOPNUMBE', 'SOPTYPE', 'CMPNTSEQ', 'LNITMSEQ', 4, 'SOPNUMBE', 'SOPTYPE','CMPNTSEQ','LNITMSEQ', 4, 1, 'COMMENT_1') 
2. After the new Requester Document Type has been created in the eConnect_Out_Setup table, test the new Requester Document Type. To do this, click Sales on the Transactions menu, and then click Sales Transaction Entry .
3. Create a new invoice or order, and then add an item number to the transaction in Sales Order Processing.
4. Click the Item Number expansion button to open the Sales Item Detail Entry window. Click the Comment ID expansion button, and then add a comment. Click OK .

Note The Item Number expansion button is the arrow icon to the right of Item Number . The Comment ID expansion button is the arrow icon to the right of Comment ID .
5. In the Sales Item Detail Entry window, click Save .
6. Query the eConnect_Out table to verify that you have a record for the Requester Document Type SopComment.