Home
Home
  1. Inventory
  • BizeeBuy API Introduction
  • V1
    • Authentication
      • Generate Access Token
      • Refresh Access Token
    • Masters
      • Get Warehouse List
      • Finished Goods List
      • Material List
    • Purchase
    • GRN
    • Inventory
      • FG Stock Status
        POST
      • Material Stock Status
        POST
    • Production
      • Batch List
      • Material Consumption
    • Sales
      • Sales Order Dispatch
      • Sales Order Status
      • Turnover & Gross Margin Report
      • FG Demand Status Report
      • Get Sales
      • Get Sales Invoices
    • TrueGradient
      • Item Master - FG
      • Sales Order Status
      • FG Inventory-Batchwise
      • Open Purchase Orders
      • Item Master - Materials
      • FG BoM
  1. Inventory

Material Stock Status

POST
https://api.bizeebuy.com/v1/inventory/mat-stock-status
This API provides the stage wise movement of the Material [RM/PM etc] Inventory along with their current Stock Status. Its specifies the Opening & Closing Stock along with the Stock Value during the specified date range.

Request

Header Params
Authorization
string 
required
Example:
Bearer 3e4b6e748d872a95aa39483ca54b27cb49eb464f
Warehouse
string  | null 
required
Example:
95aa39483ca54b27cb49eb464f
Body Params application/json
type
string 
required
Packaging Material or Raw Material
from_date
string 
required
From date
to_date
string 
required
To Date
Example
{
    "type":"PCK",
    "from_date":"2024-12-01",
    "to_date":"2025-01-31"
}

{
    "type":"RAW",
    "from_date":"2024-12-01",
    "to_date":"2025-01-31"
}

Responses

🟢200Success
application/json
Body
Date_period
string 
required
MaterialCode
string 
required
MaterialName
string 
required
UoM
string 
required
primary_category
string 
required
Category
string 
required
Opening_qty
string 
required
Opening_val
string 
required
Opening_val_tax
string 
required
Receipts_qty
string 
required
Receipts_val
string 
required
Receipts_val_tax
string 
required
Consumption_qty
string 
required
Consumption_val
string 
required
Consumption_val_tax
string 
required
Reject_qty
string 
required
Reject_val
string 
required
Reject_val_tax
string 
required
Shortage_qty
string 
required
Shortage_val
string 
required
Shortage_val_tax
string 
required
Transfer_qty
string 
required
Transfer_val
string 
required
Transfer_val_tax
string 
required
MovetoBad_qty
string 
required
MovetoBad_val
string 
required
MovetoBad_val_tax
string 
required
Trashed_qty
string 
required
Trashed_val
string 
required
Trashed_val_tax
string 
required
Hold_qty
string 
required
Hold_val
string 
required
Hold_val_tax
string 
required
Active_qty
string 
required
Active_val
string 
required
Active_val_tax
string 
required
Closing_qty
string 
required
Closing_val
string 
required
Closing_val_tax
string 
required
warehouse
string 
required
Examples
{
    "data": [
        {
            "Date_period": "-60",
            "MaterialCode": "TLWAD001",
            "MaterialName": "Transparent Label With Adhesive",
            "UoM": "Piece",
            "primary_category": "Packaging Material",
            "Category": "Labels",
            "Opening_qty": "1.02",
            "Opening_val": "1002.6716",
            "Opening_val_tax": "644.2127",
            "Receipts_qty": "0",
            "Receipts_val": "0",
            "Receipts_val_tax": "0",
            "Consumption_qty": "0",
            "Consumption_val": "0",
            "Consumption_val_tax": "0",
            "Reject_qty": "0",
            "Reject_val": "0",
            "Reject_val_tax": "0",
            "Shortage_qty": "0",
            "Shortage_val": "0",
            "Shortage_val_tax": "0",
            "Transfer_qty": "0",
            "Transfer_val": "0",
            "Transfer_val_tax": "0",
            "MovetoBad_qty": "0",
            "MovetoBad_val": "0",
            "MovetoBad_val_tax": "0",
            "Trashed_qty": "0",
            "Trashed_val": "0",
            "Trashed_val_tax": "0",
            "Hold_qty": "0",
            "Hold_val": "0",
            "Hold_val_tax": "0",
            "Active_qty": "1.02",
            "Active_val": "1002.6716",
            "Active_val_tax": "644.2127",
            "Closing_qty": "1.02",
            "Closing_val": "1002.6716",
            "Closing_val_tax": "644.2127"
        },
        {
            "Date_period": "-60",
            "MaterialCode": "LEAF.PF.001",
            "MaterialName": "Promotional flier - Leqaflet",
            "UoM": "Nos",
            "primary_category": "Packaging Material",
            "Category": "Leaflet",
            "Opening_qty": "0",
            "Opening_val": "0",
            "Opening_val_tax": "10669.3",
            "Receipts_qty": "0",
            "Receipts_val": "0",
            "Receipts_val_tax": "0",
            "Consumption_qty": "0",
            "Consumption_val": "0",
            "Consumption_val_tax": "0",
            "Reject_qty": "0",
            "Reject_val": "0",
            "Reject_val_tax": "0",
            "Shortage_qty": "0",
            "Shortage_val": "0",
            "Shortage_val_tax": "0",
            "Transfer_qty": "0",
            "Transfer_val": "0",
            "Transfer_val_tax": "0",
            "MovetoBad_qty": "0",
            "MovetoBad_val": "0",
            "MovetoBad_val_tax": "0",
            "Trashed_qty": "0",
            "Trashed_val": "0",
            "Trashed_val_tax": "0",
            "Hold_qty": "0",
            "Hold_val": "0",
            "Hold_val_tax": "0",
            "Active_qty": "0",
            "Active_val": "0",
            "Active_val_tax": "10669.3",
            "Closing_qty": "0",
            "Closing_val": "0",
            "Closing_val_tax": "10669.3"
        },
        {
            "Date_period": "-60",
            "MaterialCode": "CART0001",
            "MaterialName": "Material Cartoon",
            "UoM": "Nos",
            "primary_category": "Packaging Material",
            "Category": "Monocarton",
            "Opening_qty": "3056.725",
            "Opening_val": "47803.685",
            "Opening_val_tax": "54823.0977",
            "Receipts_qty": "0",
            "Receipts_val": "0",
            "Receipts_val_tax": "0",
            "Consumption_qty": "0",
            "Consumption_val": "0",
            "Consumption_val_tax": "0",
            "Reject_qty": "0",
            "Reject_val": "0",
            "Reject_val_tax": "0",
            "Shortage_qty": "0",
            "Shortage_val": "0",
            "Shortage_val_tax": "0",
            "Transfer_qty": "0",
            "Transfer_val": "0",
            "Transfer_val_tax": "0",
            "MovetoBad_qty": "0",
            "MovetoBad_val": "0",
            "MovetoBad_val_tax": "0",
            "Trashed_qty": "0",
            "Trashed_val": "0",
            "Trashed_val_tax": "0",
            "Hold_qty": "0",
            "Hold_val": "0",
            "Hold_val_tax": "0",
            "Active_qty": "3056.725",
            "Active_val": "47803.685",
            "Active_val_tax": "54823.0977",
            "Closing_qty": "3056.725",
            "Closing_val": "47803.685",
            "Closing_val_tax": "54823.0977"
        },
        {
            "Date_period": "-60",
            "MaterialCode": "RAPER0001",
            "MaterialName": "Material Rapper",
            "UoM": "Nos",
            "primary_category": "Packaging Material",
            "Category": "Plastic Laminates",
            "Opening_qty": "1096.75",
            "Opening_val": "7221",
            "Opening_val_tax": "7278.75",
            "Receipts_qty": "0",
            "Receipts_val": "0",
            "Receipts_val_tax": "0",
            "Consumption_qty": "0",
            "Consumption_val": "0",
            "Consumption_val_tax": "0",
            "Reject_qty": "0",
            "Reject_val": "0",
            "Reject_val_tax": "0",
            "Shortage_qty": "0",
            "Shortage_val": "0",
            "Shortage_val_tax": "0",
            "Transfer_qty": "0",
            "Transfer_val": "0",
            "Transfer_val_tax": "0",
            "MovetoBad_qty": "0",
            "MovetoBad_val": "0",
            "MovetoBad_val_tax": "0",
            "Trashed_qty": "0",
            "Trashed_val": "0",
            "Trashed_val_tax": "0",
            "Hold_qty": "0",
            "Hold_val": "0",
            "Hold_val_tax": "0",
            "Active_qty": "1096.75",
            "Active_val": "7221",
            "Active_val_tax": "7278.75",
            "Closing_qty": "1096.75",
            "Closing_val": "7221",
            "Closing_val_tax": "7278.75"
        },
        {
            "Date_period": "-60",
            "MaterialCode": "PACK.bottel.100",
            "MaterialName": "Transparent Bottle",
            "UoM": "Nos",
            "primary_category": "Packaging Material",
            "Category": "Rigid Pack",
            "Opening_qty": "9627",
            "Opening_val": "23653",
            "Opening_val_tax": "27895.42",
            "Receipts_qty": "0",
            "Receipts_val": "0",
            "Receipts_val_tax": "0",
            "Consumption_qty": "0",
            "Consumption_val": "0",
            "Consumption_val_tax": "0",
            "Reject_qty": "0",
            "Reject_val": "0",
            "Reject_val_tax": "0",
            "Shortage_qty": "0",
            "Shortage_val": "0",
            "Shortage_val_tax": "0",
            "Transfer_qty": "0",
            "Transfer_val": "0",
            "Transfer_val_tax": "0",
            "MovetoBad_qty": "0",
            "MovetoBad_val": "0",
            "MovetoBad_val_tax": "0",
            "Trashed_qty": "0",
            "Trashed_val": "0",
            "Trashed_val_tax": "0",
            "Hold_qty": "0",
            "Hold_val": "0",
            "Hold_val_tax": "0",
            "Active_qty": "9627",
            "Active_val": "23653",
            "Active_val_tax": "27895.42",
            "Closing_qty": "9627",
            "Closing_val": "23653",
            "Closing_val_tax": "27895.42"
        }
    ],
    "_links": {
        "self": {
            "href": "http://127.0.0.1/bizeebuy/rest/web/v1/inventory/mat-stock-status?page=1"
        },
        "first": {
            "href": "http://127.0.0.1/bizeebuy/rest/web/v1/inventory/mat-stock-status?page=1"
        },
        "last": {
            "href": "http://127.0.0.1/bizeebuy/rest/web/v1/inventory/mat-stock-status?page=1"
        }
    },
    "_meta": {
        "totalCount": 5,
        "pageCount": 1,
        "currentPage": 1,
        "perPage": 20
    }
}
Previous
FG Stock Status
Next
Batch List
Built with