Returns the total product sales and refunds for the specified client during the specified date range.
GetProductTotalSalesForClientId(StartDate AS Date, EndDate AS Date, IncludeVoided AS Boolean, ClientId AS String)
XML String
StartDate = Start date for the records to return.
EndDate = End date for the records to return.
IncludeVoided = Select to include voided records in the results.
ClientId = Search string for client search.
XML String has the following structure:
|
Field |
Type |
Length |
Description |
|
nTotalQty |
Decimal |
7,2 |
Total quantity sold. |
|
nTotal |
Decimal |
8 |
Total product sales. |
|
nEmpCharge |
Decimal |
8 |
Total of product employee charges. |
|
nHouseCharge |
Decimal |
8 |
Total of product house charges. |
|
lRefund |
Boolean |
1 |
Indicates whether the record contains the refund totals. A TRUE value indicates that the record's values are for products refunded. |