Skip to content


GP Rolling Column

Brian asked 10 years ago
We have numerous sales invoice IDs.  I am developing a new map to import SOP invoices.  When I create a GP rolling column I can only identify a single document ID.  My source data may contain documents that reference multiple IDs.  Do I need to create a map for each document type in order to automatically increment the next number or is there some other process for handling this situation?
Mick Egan replied 10 years ago

You could use the taGetSopNumber econnect stored procedure.  I add this to a my own stored procedure and table before sending to the SOP Transaction map to get all the pre-tasks ready. 

       DECLARE @I_cDOCID char(15)
       DECLARE @O_vSopNumber varchar(21)
       –DECLARE @O_iErrorState int

       SET @I_tSOPTYPE = 3
       SET @I_cDOCID = 'based on some sort of query.

       EXECUTE taGetSopNumber
                ,@O_vSopNumber OUTPUT
                ,@O_iErrorState OUTPUT

–select @O_vSopNumber


Brian replied 10 years ago

Thanks Mick

Brian replied 10 years ago

I'm trying to add taGetSopNumber as a new node under the Node Maintenance and I'm receiving and error 'The node does not exist'.  Is there a reason I cannot add this node? 

Mick, where do I use the code you supplied?  Would I use this outside Smartconnect when I prepare my source data or as a task in the map?  If so, would it be a task before the map or the document?

Best Answer
Chris answered 10 years ago
There is a feature coming out that will allow you to do this all from one map. When you are setting up the rolling column and choosing your document type and IDs it will let you pick your source fields rather than having to choose one hardcoded value.

So you could have a field that has STDINV, STORD, etc and then pick that field in the rolling column setup to use the source data to grab the right number rather than coding it all.

I am not sure if that is out yet, but that might be something I end up doing a Tech Tuesday article on if you follow our blog where I'll go through an example of one.


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