Update Method (ReceiptLot)
- Last UpdatedNov 06, 2025
- 2 minute read
The Update() method updates all columns for the specified receipt lot record in Receipt_Lot table.
A receipt lot record is uniquely identified by its row ID or by the combination of the purchase order ID, date received, item ID, and lot number.
'Declaration
Public Shared Sub Update( _
ByVal sessionId As Integer, _
ByVal rowId As Integer, _
ByVal poId As String, _
ByVal dateReceivedUtc As Date, _
ByVal itemId As String, _
ByVal lotNo As String, _
ByVal sublotNo As String, _
ByVal quantity As Double, _
ByVal uomId As Nullable(Of Integer), _
ByVal transId As Nullable(Of Integer), _
ByRef lastEditAt As Date _
)
'Usage
Dim sessionId As Integer
Dim rowId As Integer
Dim poId As String
Dim dateReceivedUtc As Date
Dim itemId As String
Dim lotNo As String
Dim sublotNo As String
Dim quantity As Double
Dim uomId As Nullable(Of Integer)
Dim transId As Nullable(Of Integer)
Dim lastEditAt As Date
ReceiptLot.Update(sessionId, rowId, poId, dateReceivedUtc, itemId, lotNo, sublotNo, quantity, uomId, transId, lastEditAt)
public static void Update(
int sessionId,
int rowId,
string poId,
DateTime dateReceivedUtc,
string itemId,
string lotNo,
string sublotNo,
double quantity,
Nullable<int> uomId,
Nullable<int> transId,
ref DateTime lastEditAt
)
Parameters
- sessionId
- Required. Holds the session ID and thus the user who is making this method call.
- rowId
- Required. Holds the unique row ID for the record that is being updated.
- poId
- Required. Holds the ID of a purchase order with which the goods received are associated.
- dateReceivedUtc
- Required. Holds the date and time when the goods were received, in UTC.
- itemId
- Required. Holds the ID of the item for the goods received.
- lotNo
- Required. Holds the lot number of the goods received.
- sublotNo
- Required. Holds the sublot number of the goods received.
- quantity
- Required. Holds the quantity of the goods received
- uomId
- Required. Holds the identifier of the unit of measure for the goods received.
- transId
- Required. Holds the transfer identifier for the goods received.
- lastEditAt
Required. Holds the date/time when this record was added or last updated, for optimistic concurrency control. The passed value must match the lastEditAt value in the record for the update to succeed.
Output. Holds the date/time value when the record was updated by this called method.
The following parameters are used to uniquely identify the corresponding record in the Receipt table: poId, itemId, and dateReceivedUtc. When changing any of these parameters, make sure that you are still specifying the target Receipt record that you want to update.
Observe the following input parameter rules:
- Required non-DB* parameters: Must pass a value. Cannot be empty or null.
- Required DB* parameters: Must pass a value. To enter an empty value for the parameter, pass DB*.null (e.g., DBInt.null).