Venice
Sales::SeekByBookDate
 
Seeks a Sales Document by its book date.
 
VARIANT_BOOL SeekByBookDate (
    enum eSeekMode eSeekMode,
    DATE dBookDate
)
 
Key information
This method uses key number 4 (See SwapKey).
This key allows duplicates.
 
Key segment information
Segment NameTypeOrderCollation
pBookDateDATE (date)Ascending-
 
Parameters
eSeekMode
[in] A value of the 'eSeekMode' enumeration.
dBookDate
[in] The book date of the Sales Document you want to seek.
 
Return value
True if the record with the given properties was found, otherwise false.
 
See Also
CreateSales
GetDBStatus
GetNext
 
Samples
 
C++
 
// Seek all documents with book date = 28/06/2024
COleDateTime odtBookDate;
odtBookDate.SetDate (2024, 6, 28);
pSales->SeekByBookDate (smEqual, odtBookDate);
while (pSales->GetDBStatus () == 0 && (DATE)pSales->pBookDate == odtBookDate)
{
    // Process record data

    pSales->GetNext ();
}

C#
 
// Seek all documents with book date = 28/06/2024
DateTime dtBookDate = new DateTime (2024, 6, 28);
oSales.SeekByBookDate (eSeekMode.smEqual, dtBookDate);
while (oSales.GetDBStatus () == 0 && (DateTime)oSales.pBookDate == dtBookDate)
{
    // Process record data
    
    oSales.GetNext ();
}

VBS
 
' Seek all documents with book date = 28/06/2024
Dim dtBookDate
dtBookDate = #6/28/2024#
Call oSales.SeekByBookDate(smEqual, dtBookDate)
While oSales.GetDBStatus() = 0 And oSales.pBookDate = dtBookDate
    ' Process record data

    Call oSales.GetNext()
Wend

VB.NET
 
' Seek all documents with book date = 28/06/2024
Dim dtBookDate As Date
dtBookDate = #6/28/2024#
oSales.SeekByBookDate(eSeekMode.smEqual, dtBookDate)
While oSales.GetDBStatus() = 0 And oSales.pBookDate = dtBookDate
    ' Process record data

    oSales.GetNext()
End While