Returns the total product sales and refunds for each product class during the specified date range.
GetProductTotalSalesByClass(StartDate AS Date, EndDate AS Date, IncludeVoided AS Boolean)
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.
XML String has the following structure:
|
Field |
Type |
Length |
Description |
|
iClassId |
Integer |
8 |
Product Class Id. Foreign key to Product Class iId. |
|
cClassName |
String |
30 |
Product class name. |
|
nTotalQty |
Decimal |
7,2 |
Total quantity. |
|
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. |