Sales Summary MOS Wise
URL
misdashboard/salessummary_mos
Method
POST
Request Media type
application/json
Response Media type
application/json
Request Parameters
| Parameter | Data Type | Min | Max | M/O | Sample Value | Comments |
|---|---|---|---|---|---|---|
| key | String | 32 | 32 | M | rQJrkTqtTeYvtFubKuTDVBzoLezl2opR | Key obtained from authentiaction. |
| fromdate | String | M | 2021-04-03 | Edate from gst_sales(YYYY-MM-DD) | ||
| todate | String | M | 2023-04-01 | Edate from gst_sales(YYYY-MM-DD) | ||
| firmids | String | M | 1,2 | Firm id from gst_sales | ||
| firmtypecodes | String | M | CU,Y | One or more firmtype Ids can be given as comma separated value; eg: CU,Y (Crusher and Yard) If no input given then it treated as include all firm Types. (If firmids value is provided then firmtype will not be considered) |
Response Values
| Name | Data Type | Min Length | Max Length | M/O | Sample Value | Comments |
|---|---|---|---|---|---|---|
| productsummaryfetchdata | Array | M | Product summary fetchdata from gst_salesd | |||
| amount | Decimal | M | ||||
| roundoff | Decimal | M | ||||
| netamount | Decimal | M | ||||
| productsale | Decimal | M | ||||
| lorryrent | Decimal | M | ||||
| mos | String | M | C | mode of sales from gst_salesd. | ||
| quantity | Decimal | M | 0.0 | Quantity from gst_salesd | ||
| discount | Decimal | M | 0.0 | Discount from gst_salesd | ||
| taxablevalue | Decimal | M | 0.0 | Taxable value from gst_salesd | ||
| taxamount | Decimal | M | 0.0 | Sum of cgstamt ,igstamt,sgstamt from gst_salesd | ||
| totalamount | Decimal | M | 0.0 | Sum of cgstamt ,igstamt,sgstamt,cessamt,taxable_value from gst_salesd | ||
| mosname | String | M | Cash Sales | Mode of Sales name | ||
| firmname | String | M | NAKAKATH-Q SAND | Firmname | ||
| averagerate | Decimal | M | 0.0 | Avreage rate, | ||
| firmtypecode | String | M | ||||
| firmtype | String | M |
Sample Request
{
"key": "QH7LlQ3wQMK9oYEKjeG5QOIVJQT4emeq",
"fromdate": "2021-04-03",
"todate": "2023-04-01",
"firmids": "1,2",
"firmtypecodes": "CU,Y"
}
Sample Success Response
{
"productsummaryfetchdata": [
{
"amount": "",
"roundoff": "",
"netamount": "",
"productsale": "",
"lorryrent": "",
"mos": "C",
"quantity": "0.0",
"discount": "0.0",
"taxablevalue": "0.0",
"taxamount": "0.0",
"totalamount": "0.0",
"mosname": "Cash Sales",
"firmname": "NAKAKATH-Q SAND",
"averagerate": "0.0",
"firmtypecode": "",
"firmtype": ""
}
],
"e": 200,
"msg": "Success"
}
Sample Failure Responses
{
"e": 400,
"msg": "Bad Request."
}