Skip to content
+1-888-319-3663

COMMUNITY FORUM

Sales Transaction SOP Rolling GP Column

Dan Kelley asked 9 months ago
We are importing Sales Orders via Smartconnect and now want to import returns. We are able to get returns to Import by modifying the Sales Import and setting it to Return instead and adding the Quantity to the correct column… but when it comes to the “Document Number”, selecting the GP nextnumber option just adds one to the SOPNUMBE field like another sales order. 
When manually creating a return in GP it auto generates a number like “RETURN00000016632” rather than just the next available SOPNUMBE. 
How can I replicate this behavior in SmartConnect and get the next available return number?
Thank you!
Answers
Patrick Roth Staff answered 9 months ago
I would suspect that while you fixed your SOP Type value, you didn’t fix your GP Rolling Column.  There it is still set to “order” and not “return”.
patrick

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