- BizeeBuy API Introduction
- V1
- Authentication
- Masters
- Purchase
- GRN
- Inventory
- Production
- Sales
- TrueGradient
Material Consumption
POST
https://api.bizeebuy.com/v1/production/material-consumption
Request
Header Params
Authorization
string
optional
Example:
Bearer 3e4b6e748d872a95aa39483ca54b27cb49eb464f
Body Params application/json
version
string
required
from_date
string
required
to_date
string
required
Example
{
"version":"DETAILED",
"from_date":"2024-01-01",
"to_date":"2025-01-31"
}
{
"version":"SUMMARY",
"from_date":"2024-01-01",
"to_date":"2025-01-31"
}Responses
🟢200Success
application/json
Body
product_sku
string
required
product_name
string
required
batch_no
string
required
batch_date
string
required
warehouse
string
required
batch_qty
string
required
Batch_UOM
string
required
damaged_wastage
string
required
total_prd_qty
string
required
category_name
string
required
material_name
string
required
material_code
string
required
Mat_UoM
string
required
item_qty
string
required
item_Val
string
required
wastage_item_qty
string
required
wastage_item_Val
string
required
Item_qty_bom
string
required
item_qty_short
string
required
item_qty_rej
string
required
item_qty_ret
string
required
Total_consumption
string
required
Item_Val_bom
string
required
item_Val_short
string
required
item_Val_rej
string
required
item_Val_ret
string
required
Total_consumption_Val
string
required
Examples
{
"data": [
{
"product_sku": "PAIC988776",
"product_name": "labels INV New",
"batch_no": "BT/24/00002",
"batch_date": "2024-01-15",
"warehouse": "Central",
"batch_qty": "10",
"Batch_UOM": "Nos",
"damaged_wastage": "0.00",
"total_prd_qty": "10",
"category_name": "Laminates",
"material_name": "labels SFG New",
"material_code": "LABEL-SFG/0001",
"Mat_UoM": "Piece",
"item_qty": "15.0000000000",
"item_Val": "375.0000",
"wastage_item_qty": "0.00",
"wastage_item_Val": "0.00",
"Item_qty_bom": "15",
"item_qty_short": "0",
"item_qty_rej": "0",
"item_qty_ret": "0",
"Total_consumption": "15",
"Item_Val_bom": "375.00",
"item_Val_short": "0.00",
"item_Val_rej": "0.00",
"item_Val_ret": "0.00",
"Total_consumption_Val": "375.00"
},
{
"product_sku": "PAIC988776",
"product_name": "labels INV New",
"batch_no": "BT/24/00002",
"batch_date": "2024-01-15",
"warehouse": "Central",
"batch_qty": "10",
"Batch_UOM": "Nos",
"damaged_wastage": "0.00",
"total_prd_qty": "10",
"category_name": "Miscellaneous",
"material_name": "Other Costs",
"material_code": "MSCGSOTH",
"Mat_UoM": null,
"item_qty": "10.0000000000",
"item_Val": "5.0000",
"wastage_item_qty": "0.00",
"wastage_item_Val": "0.00",
"Item_qty_bom": "10",
"item_qty_short": "0",
"item_qty_rej": "0",
"item_qty_ret": "0",
"Total_consumption": "10",
"Item_Val_bom": "5.00",
"item_Val_short": "0.00",
"item_Val_rej": "0.00",
"item_Val_ret": "0.00",
"Total_consumption_Val": "5.00"
},
{
"product_sku": "PAIC988776",
"product_name": "labels INV New",
"batch_no": "BT/24/00002",
"batch_date": "2024-01-15",
"warehouse": "Central",
"batch_qty": "10",
"Batch_UOM": "Nos",
"damaged_wastage": "0.00",
"total_prd_qty": "10",
"category_name": "Miscellaneous",
"material_name": "GSTN & Other Taxes",
"material_code": "MSCGSTXN",
"Mat_UoM": null,
"item_qty": "10.0000000000",
"item_Val": "5.0000",
"wastage_item_qty": "0.00",
"wastage_item_Val": "0.00",
"Item_qty_bom": "10",
"item_qty_short": "0",
"item_qty_rej": "0",
"item_qty_ret": "0",
"Total_consumption": "10",
"Item_Val_bom": "5.00",
"item_Val_short": "0.00",
"item_Val_rej": "0.00",
"item_Val_ret": "0.00",
"Total_consumption_Val": "5.00"
},
{
"product_sku": "PAIC988776",
"product_name": "labels INV New",
"batch_no": "BT/24/00002",
"batch_date": "2024-01-15",
"warehouse": "Central",
"batch_qty": "10",
"Batch_UOM": "Nos",
"damaged_wastage": "0.00",
"total_prd_qty": "10",
"category_name": "Miscellaneous",
"material_name": "Manpower Cost",
"material_code": "MSCMANCST",
"Mat_UoM": null,
"item_qty": "10.0000000000",
"item_Val": "5.0000",
"wastage_item_qty": "0.00",
"wastage_item_Val": "0.00",
"Item_qty_bom": "10",
"item_qty_short": "0",
"item_qty_rej": "0",
"item_qty_ret": "0",
"Total_consumption": "10",
"Item_Val_bom": "5.00",
"item_Val_short": "0.00",
"item_Val_rej": "0.00",
"item_Val_ret": "0.00",
"Total_consumption_Val": "5.00"
},
{
"product_sku": "PAIC988776",
"product_name": "labels INV New",
"batch_no": "BT/24/00002",
"batch_date": "2024-01-15",
"warehouse": "Central",
"batch_qty": "10",
"Batch_UOM": "Nos",
"damaged_wastage": "0.00",
"total_prd_qty": "10",
"category_name": "Miscellaneous",
"material_name": "Transportation & Shipping cost",
"material_code": "MSCTNSHIP",
"Mat_UoM": null,
"item_qty": "10.0000000000",
"item_Val": "5.0000",
"wastage_item_qty": "0.00",
"wastage_item_Val": "0.00",
"Item_qty_bom": "10",
"item_qty_short": "0",
"item_qty_rej": "0",
"item_qty_ret": "0",
"Total_consumption": "10",
"Item_Val_bom": "5.00",
"item_Val_short": "0.00",
"item_Val_rej": "0.00",
"item_Val_ret": "0.00",
"Total_consumption_Val": "5.00"
},
{
"product_sku": "PAIC988776",
"product_name": "labels INV New",
"batch_no": "BT/24/00003",
"batch_date": "2024-01-15",
"warehouse": "Central",
"batch_qty": "15",
"Batch_UOM": "Nos",
"damaged_wastage": "0.00",
"total_prd_qty": "15",
"category_name": "Laminates",
"material_name": "labels SFG New",
"material_code": "LABEL-SFG/0001",
"Mat_UoM": "Piece",
"item_qty": "22.5000000000",
"item_Val": "562.5000",
"wastage_item_qty": "0.00",
"wastage_item_Val": "0.00",
"Item_qty_bom": "22.5",
"item_qty_short": "0",
"item_qty_rej": "0",
"item_qty_ret": "0",
"Total_consumption": "22.5",
"Item_Val_bom": "562.50",
"item_Val_short": "0.00",
"item_Val_rej": "0.00",
"item_Val_ret": "0.00",
"Total_consumption_Val": "562.50"
},
{
"product_sku": "PAIC988776",
"product_name": "labels INV New",
"batch_no": "BT/24/00004",
"batch_date": "2024-01-15",
"warehouse": "Central",
"batch_qty": "5",
"Batch_UOM": "Nos",
"damaged_wastage": "0.00",
"total_prd_qty": "5",
"category_name": "Laminates",
"material_name": "labels SFG New",
"material_code": "LABEL-SFG/0001",
"Mat_UoM": "Piece",
"item_qty": "7.5000000000",
"item_Val": "187.5000",
"wastage_item_qty": "0.00",
"wastage_item_Val": "0.00",
"Item_qty_bom": "7.5",
"item_qty_short": "0",
"item_qty_rej": "0",
"item_qty_ret": "0",
"Total_consumption": "7.5",
"Item_Val_bom": "187.50",
"item_Val_short": "0.00",
"item_Val_rej": "0.00",
"item_Val_ret": "0.00",
"Total_consumption_Val": "187.50"
},
{
"product_sku": "SGA00001",
"product_name": "Sales Gross Product",
"batch_no": "BT/24/00001",
"batch_date": "2024-01-16",
"warehouse": "Central",
"batch_qty": "5",
"Batch_UOM": "Nos",
"damaged_wastage": "0.00",
"total_prd_qty": "5",
"category_name": "Poultry Equipment",
"material_name": "New Rapper",
"material_code": "MET0012212",
"Mat_UoM": "Nos",
"item_qty": "5.0000000000",
"item_Val": "50.0000",
"wastage_item_qty": "0.00",
"wastage_item_Val": "0.00",
"Item_qty_bom": "5",
"item_qty_short": "0",
"item_qty_rej": "0",
"item_qty_ret": "0",
"Total_consumption": "5",
"Item_Val_bom": "50.00",
"item_Val_short": "0.00",
"item_Val_rej": "0.00",
"item_Val_ret": "0.00",
"Total_consumption_Val": "50.00"
},
{
"product_sku": "SGA00001",
"product_name": "Sales Gross Product",
"batch_no": "BT/24/00001",
"batch_date": "2024-01-16",
"warehouse": "Central",
"batch_qty": "5",
"Batch_UOM": "Nos",
"damaged_wastage": "0.00",
"total_prd_qty": "5",
"category_name": "Seeds",
"material_name": "Test Material One",
"material_code": "NewTEST0001",
"Mat_UoM": "Pack",
"item_qty": "2.5000000000",
"item_Val": "10.0000",
"wastage_item_qty": "0.00",
"wastage_item_Val": "0.00",
"Item_qty_bom": "2.5",
"item_qty_short": "0",
"item_qty_rej": "0",
"item_qty_ret": "0",
"Total_consumption": "2.5",
"Item_Val_bom": "10.00",
"item_Val_short": "0.00",
"item_Val_rej": "0.00",
"item_Val_ret": "0.00",
"Total_consumption_Val": "10.00"
},
{
"product_sku": "SGA00001",
"product_name": "Sales Gross Product",
"batch_no": "BT/24/00001",
"batch_date": "2024-01-16",
"warehouse": "Central",
"batch_qty": "5",
"Batch_UOM": "Nos",
"damaged_wastage": "0.00",
"total_prd_qty": "5",
"category_name": "Test Product Cat",
"material_name": "Tea Ginger Masala",
"material_code": "SORETSEM01",
"Mat_UoM": "Nos",
"item_qty": "6.2500000000",
"item_Val": "195.6000",
"wastage_item_qty": "0.00",
"wastage_item_Val": "0.00",
"Item_qty_bom": "6.25",
"item_qty_short": "0",
"item_qty_rej": "0",
"item_qty_ret": "0",
"Total_consumption": "6.25",
"Item_Val_bom": "195.60",
"item_Val_short": "0.00",
"item_Val_rej": "0.00",
"item_Val_ret": "0.00",
"Total_consumption_Val": "195.60"
},
{
"product_sku": "BTSKU0221",
"product_name": "Demo New Semi FG",
"batch_no": "BT/24/00005",
"batch_date": "2024-01-16",
"warehouse": "Central",
"batch_qty": "13",
"Batch_UOM": "Nos",
"damaged_wastage": "0.00",
"total_prd_qty": "13",
"category_name": "Agro Chemicals",
"material_name": "zsdfv ms",
"material_code": "8765789",
"Mat_UoM": "Nos",
"item_qty": "15.0000000000",
"item_Val": "150.0000",
"wastage_item_qty": "0.00",
"wastage_item_Val": "0.00",
"Item_qty_bom": "15",
"item_qty_short": "0",
"item_qty_rej": "0",
"item_qty_ret": "0",
"Total_consumption": "15",
"Item_Val_bom": "150.00",
"item_Val_short": "0.00",
"item_Val_rej": "0.00",
"item_Val_ret": "0.00",
"Total_consumption_Val": "150.00"
},
{
"product_sku": "BTSKU0221",
"product_name": "Demo New Semi FG",
"batch_no": "BT/24/00005",
"batch_date": "2024-01-16",
"warehouse": "Central",
"batch_qty": "13",
"Batch_UOM": "Nos",
"damaged_wastage": "0.00",
"total_prd_qty": "13",
"category_name": "Processing Equipments",
"material_name": "dfjgns md",
"material_code": "Item Code0001",
"Mat_UoM": "Nos",
"item_qty": "10.0000000000",
"item_Val": "210.0000",
"wastage_item_qty": "0.00",
"wastage_item_Val": "0.00",
"Item_qty_bom": "10",
"item_qty_short": "0",
"item_qty_rej": "0",
"item_qty_ret": "0",
"Total_consumption": "10",
"Item_Val_bom": "210.00",
"item_Val_short": "0.00",
"item_Val_rej": "0.00",
"item_Val_ret": "0.00",
"Total_consumption_Val": "210.00"
},
{
"product_sku": "RES-MH-00003-V2",
"product_name": "Demo product Ladoo V2",
"batch_no": "BAT-500010",
"batch_date": "2024-01-29",
"warehouse": "Central",
"batch_qty": "0",
"Batch_UOM": "Piece",
"damaged_wastage": "0.00",
"total_prd_qty": "0",
"category_name": "Agro Chemicals",
"material_name": "zsdfv ms",
"material_code": "8765789",
"Mat_UoM": "Nos",
"item_qty": "20.0000000000",
"item_Val": "200.0000",
"wastage_item_qty": null,
"wastage_item_Val": null,
"Item_qty_bom": "20",
"item_qty_short": "0",
"item_qty_rej": "0",
"item_qty_ret": "0",
"Total_consumption": "20",
"Item_Val_bom": "200.00",
"item_Val_short": "0.00",
"item_Val_rej": "0.00",
"item_Val_ret": "0.00",
"Total_consumption_Val": "200.00"
},
{
"product_sku": "RES-MH-00003-V2",
"product_name": "Demo product Ladoo V2",
"batch_no": "BAT-500010",
"batch_date": "2024-01-29",
"warehouse": "Central",
"batch_qty": "0",
"Batch_UOM": "Piece",
"damaged_wastage": "0.00",
"total_prd_qty": "0",
"category_name": "Processing Equipments",
"material_name": "dfjgns md",
"material_code": "Item Code0001",
"Mat_UoM": "Nos",
"item_qty": "4.0000000000",
"item_Val": "84.0000",
"wastage_item_qty": null,
"wastage_item_Val": null,
"Item_qty_bom": "4",
"item_qty_short": "0",
"item_qty_rej": "0",
"item_qty_ret": "0",
"Total_consumption": "4",
"Item_Val_bom": "84.00",
"item_Val_short": "0.00",
"item_Val_rej": "0.00",
"item_Val_ret": "0.00",
"Total_consumption_Val": "84.00"
},
{
"product_sku": "RES-MH-00003-V2",
"product_name": "Demo product Ladoo V2",
"batch_no": "BAT-500010",
"batch_date": "2024-01-29",
"warehouse": "Central",
"batch_qty": "0",
"Batch_UOM": "Piece",
"damaged_wastage": "0.00",
"total_prd_qty": "0",
"category_name": "Poultry Equipment",
"material_name": "New Rapper",
"material_code": "MET0012212",
"Mat_UoM": "Nos",
"item_qty": "20.0000000000",
"item_Val": "200.0000",
"wastage_item_qty": null,
"wastage_item_Val": null,
"Item_qty_bom": "20",
"item_qty_short": "0",
"item_qty_rej": "0",
"item_qty_ret": "0",
"Total_consumption": "20",
"Item_Val_bom": "200.00",
"item_Val_short": "0.00",
"item_Val_rej": "0.00",
"item_Val_ret": "0.00",
"Total_consumption_Val": "200.00"
},
{
"product_sku": "RES-MH-00003-V2",
"product_name": "Demo product Ladoo V2",
"batch_no": "BAT-500010",
"batch_date": "2024-01-29",
"warehouse": "Central",
"batch_qty": "0",
"Batch_UOM": "Piece",
"damaged_wastage": "0.00",
"total_prd_qty": "0",
"category_name": "Diapers",
"material_name": "New Batch MAtOne",
"material_code": "NEMET0012212",
"Mat_UoM": "Nos",
"item_qty": "60.0000000000",
"item_Val": "900.0000",
"wastage_item_qty": null,
"wastage_item_Val": null,
"Item_qty_bom": "60",
"item_qty_short": "0",
"item_qty_rej": "0",
"item_qty_ret": "0",
"Total_consumption": "60",
"Item_Val_bom": "900.00",
"item_Val_short": "0.00",
"item_Val_rej": "0.00",
"item_Val_ret": "0.00",
"Total_consumption_Val": "900.00"
},
{
"product_sku": "RES-MH-00003-V2",
"product_name": "Demo product Ladoo V2",
"batch_no": "BAT-500010",
"batch_date": "2024-01-29",
"warehouse": "Central",
"batch_qty": "0",
"Batch_UOM": "Piece",
"damaged_wastage": "0.00",
"total_prd_qty": "0",
"category_name": "Seeds",
"material_name": "Test Material One",
"material_code": "NewTEST0001",
"Mat_UoM": "Pack",
"item_qty": "30.0000000000",
"item_Val": "120.0000",
"wastage_item_qty": null,
"wastage_item_Val": null,
"Item_qty_bom": "30",
"item_qty_short": "0",
"item_qty_rej": "0",
"item_qty_ret": "0",
"Total_consumption": "30",
"Item_Val_bom": "120.00",
"item_Val_short": "0.00",
"item_Val_rej": "0.00",
"item_Val_ret": "0.00",
"Total_consumption_Val": "120.00"
},
{
"product_sku": "RES-MH-00003-V2",
"product_name": "Demo product Ladoo V2",
"batch_no": "BAT-500010",
"batch_date": "2024-01-29",
"warehouse": "Central",
"batch_qty": "0",
"Batch_UOM": "Piece",
"damaged_wastage": "0.00",
"total_prd_qty": "0",
"category_name": "Poultry Equipment",
"material_name": "KJhbd dsid",
"material_code": "PRODSM0001",
"Mat_UoM": "Nos",
"item_qty": "1.0000000000",
"item_Val": "2.3600",
"wastage_item_qty": null,
"wastage_item_Val": null,
"Item_qty_bom": "1",
"item_qty_short": "0",
"item_qty_rej": "0",
"item_qty_ret": "0",
"Total_consumption": "1",
"Item_Val_bom": "2.36",
"item_Val_short": "0.00",
"item_Val_rej": "0.00",
"item_Val_ret": "0.00",
"Total_consumption_Val": "2.36"
},
{
"product_sku": "RES-MH-00003-V2",
"product_name": "Demo product Ladoo V2",
"batch_no": "BAT-500010",
"batch_date": "2024-01-29",
"warehouse": "Central",
"batch_qty": "0",
"Batch_UOM": "Piece",
"damaged_wastage": "0.00",
"total_prd_qty": "0",
"category_name": "Test Product Cat",
"material_name": "Tea Ginger Masala",
"material_code": "SORETSEM01",
"Mat_UoM": "Nos",
"item_qty": "40.0000000000",
"item_Val": "800.0000",
"wastage_item_qty": null,
"wastage_item_Val": null,
"Item_qty_bom": "40",
"item_qty_short": "0",
"item_qty_rej": "0",
"item_qty_ret": "0",
"Total_consumption": "40",
"Item_Val_bom": "800.00",
"item_Val_short": "0.00",
"item_Val_rej": "0.00",
"item_Val_ret": "0.00",
"Total_consumption_Val": "800.00"
},
{
"product_sku": "RES-MH-00003-V1",
"product_name": "Demo product Ladoo V1",
"batch_no": "BCT-0001",
"batch_date": "2024-01-29",
"warehouse": "Central",
"batch_qty": "0",
"Batch_UOM": "Piece",
"damaged_wastage": "0.00",
"total_prd_qty": "0",
"category_name": "Agro Chemicals",
"material_name": "zsdfv ms",
"material_code": "8765789",
"Mat_UoM": "Nos",
"item_qty": "50.0000000000",
"item_Val": "500.0000",
"wastage_item_qty": null,
"wastage_item_Val": null,
"Item_qty_bom": "50",
"item_qty_short": "0",
"item_qty_rej": "0",
"item_qty_ret": "0",
"Total_consumption": "50",
"Item_Val_bom": "500.00",
"item_Val_short": "0.00",
"item_Val_rej": "0.00",
"item_Val_ret": "0.00",
"Total_consumption_Val": "500.00"
}
],
"_links": {
"self": {
"href": "http://127.0.0.1/bizeebuy/rest/web/v1/production/material-consumption?page=1"
},
"first": {
"href": "http://127.0.0.1/bizeebuy/rest/web/v1/production/material-consumption?page=1"
},
"last": {
"href": "http://127.0.0.1/bizeebuy/rest/web/v1/production/material-consumption?page=21"
},
"next": {
"href": "http://127.0.0.1/bizeebuy/rest/web/v1/production/material-consumption?page=2"
}
},
"_meta": {
"totalCount": 402,
"pageCount": 21,
"currentPage": 1,
"perPage": 20
}
}