Skip to content
+1-888-319-3663

COMMUNITY FORUM

Update source with GP Rolling Column

Jim asked 4 years ago
I’ve got a map to create cash receipt and apply records.  The source is a sql table.  Is it possible to update the source with the value from a GP Rolling Column on success?  The GP Payment Number in this specific instance.  The source table includes a field for the GP payment number value as well as a boolean field to flag processed records.  I’ve got a document success task that is flipping the processed flag, but it would be nice to get the payment number updated as well.
Jim replied 4 years ago

I was able to accomplish this with a second query that references the RM keys table, but it would be nice to know if there is a way to achieve this with the GP Rolling Column value.

Answers
Lorren Zemke Staff answered 4 years ago
Jim, This KB article describes how to use the “Use For Global Variable” option to set a value into SQL table with the Document Number that was generated. https://www.eonesolutions.com/next-dynamics-gp-document-number-smartconnect/
If the source is not a SQL table, you would need to write some .NET code to update that source with the document number.
 
Lorren

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