This method will retrieve the next sales document number from Microsoft Dynamics GP.
Class
Microsoft.Dynamics.GP.eConnect.GetSopNumber
Syntax
public string GetNextSopNumber(
int sopTypeKey,
string docIdKey,
string connString
)
Parameters
Name |
Data type |
Description |
|---|---|---|
sopTypeKey |
integer |
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: string
This method returns a string that contains the requested SOP number
Examples
The following Visual Basic .NET example uses the GetNextSopNumber method to retrieve a sales invoice number from 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;Initial Catalog=TWO;"
'Instantiate a GetSopNumber object
Dim SopNumberObject As New GetSopNumber
'Get the next SOP number
SopNumber = SopNumberObject.GetNextSopNumber(3, "STDINV", ConnectionString)