PickQuery [PICK015]

DATASCOPE.SDK.BusinessObjects.Picking.OrderPicking.PickQuery()

A Business Object to return a list of items that still need to be picked on a Picking Slip.

It is designed to be used with several other Picking objects within DATASCOPE WMS. These objects can re-create the entire Order Picking process within the core system. This object forms one of the first steps in the process, namely listing the stock required to be picked for a particular Picking Slip.

The Business Object matches the Items tab within the core Picking module and will allow third-party developers to pull information about items to be picked. This can be used in multiple ways, either to show users the items OR in a more automated process to run through the lines and process them using the other Order Picking Business Objects.

image-20240729-123115.png
Sales Pick to TrackID / Items Tab

This object falls under the Order Picking functional area and this is specific to Sales Order Picking and not Job or Work in Progress.

For a detailed overview on working with DATASCOPE PREMIUM WMS Business Objects, refer to E.Net Business Objects

If you don’t like reading, you can watch the video.

None

No Specifications

RELEASE NOTES

  • Release notes 24R2 (Ticket # 8382) - PickQuery Business Object development.

Description

This is a query Business Object and works slightly different than the standard Post Business Objects, as it will return the data within the Results Business Object of the call. It will allow a 3rd party application or script to pull the list of information from the system, by simply providing the pick slip number. The same information provided in the Items tab will be provided to the 3rd party caller.

Code

PIK015

Name

PickQuery

Module

Picking

Functional Area

OrderPicking

Name Space/Class

DATASCOPE.SDK.BusinessObjects.Picking.OrderPicking.PickQuery()

Release Date

August 2024

Release Version

v24.2

Prerequisites

None

SYSPRO Objects

 

Parameters

s BO performs a functional perspective matching of the core HTML5 picking screens.
Returns:
Response - Success
Response Result set to True
Response Message "Query Successful"
Response Object "A list Pick Slip Line Items"

Response - Failure
Response Result set to False
Response Message - Error generated

Name

Description

Mandatory field

Data Type

Default Value

Name

Description

Mandatory field

Data Type

Default Value

pReferenceType

Can only be set to PICK_SLIP/MASTER_SHIPMENT_NUMBER/CARTON_NUMBER indicating the Type of data to load corresponding to Sales Pick to Pick Slip, Sales Pick to Track ID, Sales Order MSN Picking or Sales Order Carton Picking. If not supplied or outside of the eNum types will cause a Error

YES

eNum

0

pReferenceNumber

Should be populated with the applicable Pick Slip Number, Master Shipment Number or Carton Number, based on the respective PICK_SLIP/MASTER_SHIPMENT_NUMBER/CARTON_NUMBER supplied in the pReferenceType field. Must be a valid Reference, if not, an Error will be generated.

YES

string

<blank>

Validation

The following validation must happen.

  • Reference Number - the Reference number must match the options in Reference Type, which is PICK_SLIP, MASTER_SHIPMENT_NUMBER, and CARTON_NUMBER

Technical Specification

<sample code>

Testing the BO

The Business Object Harness application should be used to assist in troubleshooting and testing any of the DATASCOPE WMS Business Objects.

  • Ensure you followed the installation process to install and configure the Business Object Harness application.

  • To test the Business Object

o   Open the Business Object Harness

image-20240822-134104.png

o   Enter the Company ID you would like to login to, followed by a valid Operator, along with its password and company password (if any). Clicking the Login button will then attempt to log in to the system using the WebAPI.

o   The first step in posting an object is to select and add it to the main content window.

o   Now you are ready to start testing the Business Object.