Retrieves stock adjustments from a specific date

Request

Fetches stock adjustments recorded from a given date onward.

Path

datestringrequired
The date in YYYY-MM-DD format.

Example: 2020-01-01
Default:

Query

limitinteger (int32)
Maximum number of results to return (default: 100).

Example: 1
Default: 100
offsetinteger (int32)
Offset for pagination (default: 0).

Example: 0
Default: 0

Responses

Returns the details of the business object

Body application/json

get /api/stock-adjustments/from-date/{date}

curl -X GET \
  https://www.beehexa.com/_mock/api/sql-account-rest-api/customized-by-beehexa/api/stock-adjustments/from-date/2020-01-01

const url = 'https://www.beehexa.com/_mock/api/sql-account-rest-api/customized-by-beehexa/api/stock-adjustments/from-date/2020-01-01';
const options = {method: 'GET'};

try {
  const response = await fetch(url, options);
  const data = await response.json();
  console.log(data);
} catch (error) {
  console.error(error);
}

const fetch = require('node-fetch');

const url = 'https://www.beehexa.com/_mock/api/sql-account-rest-api/customized-by-beehexa/api/stock-adjustments/from-date/2020-01-01';
const options = {method: 'GET'};

try {
  const response = await fetch(url, options);
  const data = await response.json();
  console.log(data);
} catch (error) {
  console.error(error);
}

import requests

url = "https://www.beehexa.com/_mock/api/sql-account-rest-api/customized-by-beehexa/api/stock-adjustments/from-date/2020-01-01"

response = requests.get(url)

print(response.json())

OkHttpClient client = new OkHttpClient();

Request request = new Request.Builder()
  .url("https://www.beehexa.com/_mock/api/sql-account-rest-api/customized-by-beehexa/api/stock-adjustments/from-date/2020-01-01")
  .get()
  .build();

Response response = client.newCall(request).execute();

using System.Net.Http.Headers;
var client = new HttpClient();
var request = new HttpRequestMessage
{
  Method = HttpMethod.Get,
  RequestUri = new Uri("https://www.beehexa.com/_mock/api/sql-account-rest-api/customized-by-beehexa/api/stock-adjustments/from-date/2020-01-01"),
};
using (var response = await client.SendAsync(request))
{
  response.EnsureSuccessStatusCode();
  var body = await response.Content.ReadAsStringAsync();
  Console.WriteLine(body);
}

<?php

$curl = curl_init();

curl_setopt_array($curl, [
  CURLOPT_URL => "https://www.beehexa.com/_mock/api/sql-account-rest-api/customized-by-beehexa/api/stock-adjustments/from-date/2020-01-01",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "GET",
]);

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  echo $response;
}

package main

import (
	"fmt"
	"net/http"
	"io"
)

func main() {

	url := "https://www.beehexa.com/_mock/api/sql-account-rest-api/customized-by-beehexa/api/stock-adjustments/from-date/2020-01-01"

	req, _ := http.NewRequest("GET", url, nil)

	res, _ := http.DefaultClient.Do(req)

	defer res.Body.Close()
	body, _ := io.ReadAll(res.Body)

	fmt.Println(res)
	fmt.Println(string(body))

}

Response

application/json

[
  {
    "DOCKEY": 1,
    "DOCNO": "AJ-00001",
    "DOCDATE": "2024-06-30T00:00:00",
    "POSTDATE": "2024-06-30T00:00:00",
    "DESCRIPTION": "Stock Adjustment - Bedding Accessories",
    "WRITEOFF": "F",
    "CANCELLED": "F",
    "DOCAMT": -1170,
    "ATTACHMENTS": "",
    "AUTHBY": "",
    "REASON": "",
    "REMARK": "",
    "NOTE": "",
    "UPDATECOUNT": "",
    "PRINTCOUNT": 0,
    "cdsDocDetail": [
      {
        "DTLKEY": 3,
        "DOCKEY_1": 1,
        "SEQ": 1000,
        "STYLEID": "",
        "NUMBER": "",
        "ITEMCODE": "MF-Bolster",
        "LOCATION": "----",
        "BATCH": "",
        "PROJECT": "----",
        "DESCRIPTION_1": "Microfiber Soft Bolster with 100% cotton fabric",
        "DESCRIPTION2": "",
        "DESCRIPTION3": "",
        "BOOKQTY": 30,
        "PHYSICALQTY": 29,
        "QTY": -1,
        "SUOMQTY": 0,
        "UOM": "UNIT",
        "RATE": 1,
        "SQTY": -1,
        "UNITCOST": 129,
        "AMOUNT": -129,
        "PRINTABLE": "T",
        "REMARK1": "",
        "REMARK2": ""
      },
      {
        "DTLKEY": 4,
        "DOCKEY_1": 1,
        "SEQ": 2000,
        "STYLEID": "",
        "NUMBER": "",
        "ITEMCODE": "PMF-Pillow",
        "LOCATION": "----",
        "BATCH": "",
        "PROJECT": "----",
        "DESCRIPTION_1": "Premium Memory Foam Pillow",
        "DESCRIPTION2": "",
        "DESCRIPTION3": "",
        "BOOKQTY": 20,
        "PHYSICALQTY": 21,
        "QTY": 1,
        "SUOMQTY": 0,
        "UOM": "UNIT",
        "RATE": 1,
        "SQTY": 1,
        "UNITCOST": 59,
        "AMOUNT": 59,
        "PRINTABLE": "T",
        "REMARK1": "",
        "REMARK2": ""
      },
      {
        "DTLKEY": 5,
        "DOCKEY_1": 1,
        "SEQ": 3000,
        "STYLEID": "",
        "NUMBER": "",
        "ITEMCODE": "SPM-Queen",
        "LOCATION": "----",
        "BATCH": "",
        "PROJECT": "----",
        "DESCRIPTION_1": "Queen Size 12inch Signature Double Posture Spring Mattress",
        "DESCRIPTION2": "",
        "DESCRIPTION3": "",
        "BOOKQTY": 30,
        "PHYSICALQTY": 29,
        "QTY": -1,
        "SUOMQTY": 0,
        "UOM": "UNIT",
        "RATE": 1,
        "SQTY": -1,
        "UNITCOST": 1100,
        "AMOUNT": -1100,
        "PRINTABLE": "T",
        "REMARK1": "",
        "REMARK2": ""
      }
    ]
  }
]

Retrieves stock adjustments from a specific date

Request

Path

Query

Responses200400

Body application/json

Body application/json

Responses