Add Method (SoLine)
- Last UpdatedNov 06, 2025
- 3 minute read
The Add() method adds a new sales order line item record to the SO_Line table.
'Declaration
Public Shared Sub Add( _
ByVal sessionId As Integer, _
ByVal custId As String, _
ByVal poId As String, _
ByVal soLineNo As Integer, _
ByVal itemId As String, _
ByVal customerItemId As String, _
ByVal quantity As Double, _
ByVal uomId As Nullable(Of Integer), _
ByVal minQuantity As Nullable(Of Double), _
ByVal maxQuantity As Nullable(Of Double), _
ByVal linePrice As Nullable(Of Double), _
ByVal requiredByLocal As Nullable(Of Date), _
ByVal spare1 As String, _
ByVal spare2 As String, _
ByVal spare3 As String, _
ByVal spare4 As String, _
ByVal lastEditComment As String, _
ByRef modId As String _
)
'Usage
Dim sessionId As Integer
Dim custId As String
Dim poId As String
Dim soLineNo As Integer
Dim itemId As String
Dim customerItemId As String
Dim quantity As Double
Dim uomId As Nullable(Of Integer)
Dim minQuantity As Nullable(Of Double)
Dim maxQuantity As Nullable(Of Double)
Dim linePrice As Nullable(Of Double)
Dim requiredByLocal As Nullable(Of Date)
Dim spare1 As String
Dim spare2 As String
Dim spare3 As String
Dim spare4 As String
Dim lastEditComment As String
Dim modId As String
SoLine.Add(sessionId, custId, poId, soLineNo, itemId, customerItemId, quantity, uomId, minQuantity, maxQuantity, linePrice, requiredByLocal, spare1, spare2, spare3, spare4, lastEditComment, modId)
public static void Add(
int sessionId,
string custId,
string poId,
int soLineNo,
string itemId,
string customerItemId,
double quantity,
Nullable<int> uomId,
Nullable<double> minQuantity,
Nullable<double> maxQuantity,
Nullable<double> linePrice,
Nullable<DateTime> requiredByLocal,
string spare1,
string spare2,
string spare3,
string spare4,
string lastEditComment,
out string modId
)
Parameters
- sessionId
- Required. Holds the session ID and thus the user who is making this method call.
- custId
- Required. Holds the customer ID, from the SO table.
- poId
- Required. Holds the ID of the customer's purchase order, from the SO table.
- soLineNo
- Required. Holds a number that identifies the line in the sales order.
- itemId
- Required. Holds the ID of the item being ordered.
- customerItemId
- Optional. Holds the ID used by the customer to identify the item being ordered.
- quantity
- Required. Holds the nominal amount of the item being ordered.
- uomId
- Optional. Holds the ID of the unit of measure for the item.
- minQuantity
- Optional. Holds the minimum quantity that, once shipped, will allow the order to be completed. If null is supplied, the value defaults to the quantity value.
- maxQuantity
- Optional. Holds the maximum quantity that may be shipped against this line item. A null value indicates no limit.
- linePrice
- Optional. Holds the total price for this line item.
- requiredByLocal
- Optional. Holds the date when the goods for this line are required in the local time of the entity from which the goods are shipped, specified by the ship_from column in the SO's record. If a ship-from entity is not specified, the default time zone will be used to determine the local time.
- spare1
- Optional. Holds the contents of the user-defined spare1 field.
- spare2
- Optional. Holds the contents of the user-defined spare2 field.
- spare3
- Optional. Holds the contents of the user-defined spare3 field.
- spare4
- Optional. Holds the contents of the user-defined spare4 field.
- lastEditComment
- Optional. Holds comments that describes why this record is being added.
- modId
- Output. Holds the modification ID assigned to this record when it is added. The modId parameter is used by other methods that modify or delete this type of record for optimistic concurrency control.
Observe the following input parameter rules:
- Required non-DB* parameters: Must pass a value. Cannot be empty or null.
- Optional non-DB* parameters: Either enter a value or pass a null. If passing a null and a default value has been defined, the default value will be used for the parameter.
- Required DB* parameters: Must pass a value. To enter an empty value for the parameter, pass DB*.null (e.g., DBInt.null).
- Optional DB* parameters: To enter no value for the parameter, pass DB*.null (e.g., DBInt.null). To use the default value for the parameter if one has been defined for the object being added, pass a null.