RollBackSopNumber Method
Use this method to return unused sales order numbers. This makes the numbers available for use with other Microsoft Dynamics GP SOP documents.
Class
Microsoft.Dynamics.GP.eConnect.GetSopNumber
Syntax
public bool RollBackSopNumber(
string sopNumKey,
int sopTypeKey,
string docIdKey,
string connString
)
Parameters
Name |
Data type |
Description |
|---|---|---|
sopNumKey |
string |
Specifies the number to return to Microsoft Dynamics GP |
sopTypeKey |
string |
Specifies the type of the document: 1 = Quote 2 = Order 3 = Invoice 4 = Return 5 = Back order 6 = Fulfillment order |
docIdKey |
string |
Specifies the document ID |
connString |
string |
Specifies the SQL server and database |
Return Value
Type: bool
This method returns a boolean value that indicates whether the rollback request was successfully completed. A value of True indicates the rollback was successful.
Examples
The following segment of Visual Basic .NET code uses the RollBackSopNumber method to make an unused SOP number available in Microsoft Dynamics GP:
Dim ConnectionString As String
Dim SopNumber As String
'Set the connection string
'This connection string uses integrated security to connect to the
'TWO database on the local computer
ConnectionString = "Data Source=localhost;Integrated Security=SSPI;" _
& "Persist Security Info=False;InitRoial Catalog=TWO;"
'Instantiate a GetSopNumber object
Dim SopNumberObject As New GetSopNumber
'Get the next sales invoice number
SopNumber = SopNumberObject.GetNextSopNumber(3, "STDINV", ConnectionString)
'Return the sales invoice number to Microsoft Dynamics GP
SopNumber = SopNumberObject.RollBackSopNumber(SopNumber, 3, "STDINV", _
ConnectionString)