Warehouse Worksheet Lines API

Overview

The WMS Warehouse Worksheet Lines API is a Business Central API page designed to manage warehouse worksheet line data. This API allows external systems to interact with warehouse worksheet lines, providing functionality for creating, reading, and updating worksheet line information.

API Details

Publisher: smart
API Group: wms
API Version: v2.0
Entity Name: whseWorksheetLine
Entity Set Name: whseWorksheetLines
Source Table: Whse. Worksheet Line

Fields

The following fields are exposed in the API:

Field Name	Source Field	Required	Description
`templateName`	`Whse. Worksheet Line."Worksheet Template Name"`	Yes	Name of the worksheet template.
`name`	`Whse. Worksheet Line.Name`	Yes	Name of the worksheet.
`lineNo`	`Whse. Worksheet Line."Line No."`	No	Line number of the worksheet.
`locationCode`	`Whse. Worksheet Line."Location Code"`	Yes	Code of the location.
`itemNo`	`Whse. Worksheet Line."Item No."`	Yes	Item number associated with the line.
`fromZoneCode`	`Whse. Worksheet Line."From Zone Code"`	No	Code of the source zone.
`toZoneCode`	`Whse. Worksheet Line."To Zone Code"`	No	Code of the destination zone.
`fromBinCode`	`Whse. Worksheet Line."From Bin Code"`	No	Code of the source bin.
`toBinCode`	`Whse. Worksheet Line."To Bin Code"`	No	Code of the destination bin.
`description`	`Whse. Worksheet Line.Description`	No	Description of the worksheet line.
`variantCode`	`Whse. Worksheet Line."Variant Code"`	No	Variant code of the item.
`unitOfMeasure`	`Whse. Worksheet Line."Unit of Measure Code"`	No	Unit of measure for the item.
`quantity`	`Whse. Worksheet Line.Quantity`	Yes	Quantity of the item.
`lotNo`	`LotNo`	No	Lot number associated with the item.

Notes

The lotNo field is optional but required when tracking items by lot.

Example Usage

Create a New Warehouse Worksheet Line

POST host/instance/api/smart/wms/v2.0/companies(companyId)/whseWorksheetLines
Content-Type: application/json

{
    "templateName": "DEFAULT",
    "name": "Worksheet001",
    "lineNo": 10000,
    "locationCode": "MAIN",
    "itemNo": "ITEM001",
    "quantity": 10,
    "lotNo": "LOT001"
}

Retrieve a Warehouse Worksheet Lines

GET host/instance/api/smart/wms/v2.0/companies(companyId)/whseWorksheetLines

Table of Contents