Margin Report
To view Margin of Sales/Sales Return
Margin Report
POST {{apiUrl}}master/reports/margin_report
Request Body
start_date*
String
Start Date of the report. Must be less than equals to current Date or End Date.
Format = YYYY-MM-DD
end_date*
String
End Date of the report. Must be greater than equals to Start Date and less than equals to current Date.
Format = YYYY-MM-DD
The duration between End Date and Start Date must be less than equals to 31 days.
apikey*
String
Authentication token
view_by
String
item_wise | bill_item_wise
bill_item_wise: Show the margin on Sales bills.
item_wise: Show the margin on items.
Default Value: bill_item_wise
requested_by
String
sales | sale_return
sales: Show Sales Margin Report.
sale_return: Show Sales Return Margin Report.
Default: sales
tags
String
["headache", "painkiller"]
filter by tags in the bill_item_wise report.
child_chemist_code
String
chemist_code of Child Chemist.
It will show the margin report of the child chemist.
{
"status_code": "1",
"status_message": "Success",
"datetime": "2023-01-09 15:06:22",
"data": {
"type": "sales",
"current_page": 1,
"summary": {
"total_purchase": 138.88,
"total_sell": 225.6,
"total_net_gst": 4.56,
"profit": 82.16,
"margin": 38.5
},
"results": [
{
"order_id": "hXdqB4ImyDFgNkqnvDQfSg==",
"created_date": "2022-11-08 18:48:23",
"patient_name": "Poojan Mehta",
"bill_no": "23",
"patient_id": "jbe37VCyuofdSgqVfzUAEA==",
"medicine_id": "gv0GokYn9w4zFL51eouS2g==",
"total_quantity_sold": 10,
"gstpercentage": 5,
"mrp": 112,
"discount": 10,
"current_stock": 90, // present stock
"total_selling_price": 100.8,
"total_landing_price": 10.08,
"total_sales_gst": 4.8,
"order_by_id": "+93Y8e1zYBSOwcnRNboSJw==",
"order_by_entity": "chemist",
"tag": [
"headache"
],
"medicine_name": "Ltk 50 Tablet",
"manufacturer_name": "Unison Pharmaceuticals Pvt Ltd",
"size": 10,
"pack_size": "10 Tablets",
"total_purchase_gst": 0.48,
"total_net_gst": 4.32,
"taxable_purchase_amount": 9.6,
"taxable_sales_amount": 96,
"profit": 86.4,
"margin": 90
},
{
"order_id": "yl4XZ5EZ9HHUEil31DBWzw==",
"created_date": "2022-12-01 18:09:48",
"patient_name": "Ronak Dunzo",
"bill_no": "24",
"patient_id": "zRC97Kh3xOMVdHZKkyZRVA==",
"medicine_id": "BXGcaezmfzcQEdh7fZVmUg==",
"total_quantity_sold": 15,
"gstpercentage": 12,
"mrp": 24,
"discount": 0,
"current_stock": 607,
"total_selling_price": 24,
"total_landing_price": 16.8,
"total_sales_gst": 2.57,
"order_by_id": "+93Y8e1zYBSOwcnRNboSJw==",
"order_by_entity": "chemist",
"tag": [
"headache"
],
"medicine_name": "LTK-H Tablet 5",
"manufacturer_name": "Unison Pharmaceuticals Pvt Ltd",
"size": 15,
"pack_size": "15 Tablet",
"total_purchase_gst": 1.8,
"total_net_gst": 0.77,
"taxable_purchase_amount": 15,
"taxable_sales_amount": 21.43,
"profit": 6.43,
"margin": 30
},
{
"order_id": "3+uJ2X8XmtbtDwKB1Pa+BQ==",
"created_date": "2022-11-08 17:13:59",
"patient_name": "Poojan Mehta",
"bill_no": "22",
"patient_id": "jbe37VCyuofdSgqVfzUAEA==",
"medicine_id": "gv0GokYn9w4zFL51eouS2g==",
"total_quantity_sold": 10,
"gstpercentage": 5,
"mrp": 112,
"discount": 10,
"current_stock": 90,
"total_selling_price": 100.8,
"total_landing_price": 112,
"total_sales_gst": 4.8,
"order_by_id": "+93Y8e1zYBSOwcnRNboSJw==",
"order_by_entity": "chemist",
"tag": [
"headache"
],
"medicine_name": "Ltk 50 Tablet",
"manufacturer_name": "Unison Pharmaceuticals Pvt Ltd",
"size": 10,
"pack_size": "10 Tablets",
"total_purchase_gst": 5.33,
"total_net_gst": -0.53,
"taxable_purchase_amount": 106.67,
"taxable_sales_amount": 96,
"profit": -10.67,
"margin": -11.11
}
]
}
}Last updated
Was this helpful?