Returns the total product sales and refunds for the specified date range.
GetProductTotalSales(StartDate AS Date, EndDate AS Date)
XML String
StartDate = Start date for the records to return. This value must be a date/time value.
EndDate = End date for the records to return. This value must be a date/time value.
Example: If you want to get the total sales for a specific day, the start date should be MM/DD/YYYY 12:00:00 AM and the end date should be MM/DD/YYYY 11:59:59 PM.
This method will return two records. The first is the refunded product totals as the IRefund field indicates. The second record is the product sales totals.
XML String has the following structure:
|
Field |
Type |
Length |
Description |
|
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. |