Venice
SInvce::SeekByTrnDocDate
 
Seeks a Sales Invoice by its transfer state and document date.
 
VARIANT_BOOL SeekByTrnDocDate (
    enum eSeekMode eSeekMode,
    DATE dDocDate
)
 
Key information
This method uses key number 6 (See SwapKey).
This key allows duplicates.
This is a null key, only the records where pToTransfer is true are in the index.
 
Key segment information
Segment NameTypeOrderCollation
pDocDateDATE (date)Ascending-
pToTransferVARIANT_BOOLAscending-
 
Parameters
eSeekMode
[in] A value of the 'eSeekMode' enumeration.
dDocDate
[in] The document date of the Sales Invoice you want to seek.
 
Return value
True if the record with the given properties was found, otherwise false.
 
See Also
CreateSInvce
GetDBStatus
GetPrevious
 
Samples
 
C++
 
// Process all documents with a document date before 28/06/2024 that still need to be transferred
pSInvce->SeekByTrnDocDate (smLess, COleDateTime (2024, 6, 28, 0, 0, 0).m_dt);
while (pSInvce->GetDBStatus () == 0)
{
    // Process record data

    pSInvce->GetPrevious ();
}

C#
 
// Process all documents with a document date before 28/06/2024 that still need to be transferred
oSInvce.SeekByTrnDocDate (eSeekMode.smLess, new DateTime (2024, 6, 28));
while (oSInvce.GetDBStatus () == 0)
{
    // Process record data

    oSInvce.GetPrevious ();
}

VBS
 
' Process all documents with a document date before 28/06/2024 that still need to be transferred
Call oSInvce.SeekByTrnDocDate(smLess, #6/28/2024#)
While oSInvce.GetDBStatus() = 0
    ' Process record data

    Call oSInvce.GetPrevious()
Wend

VB.NET
 
' Process all documents with a document date before 28/06/2024 that still need to be transferred
oSInvce.SeekByTrnDocDate(eSeekMode.smLess, #6/28/2024#)
While oSInvce.GetDBStatus() = 0
    ' Process record data

    oSInvce.GetPrevious()
End While