PicksToInvoiceQuery [PICK011]

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

Calls 2 stored procedures:
proc_ListPickSlipForInvoicing - this is specific to carton picking used by Jonsson and ASCO
proc_PickingSlipsReadyToInvoice - returns Picking Slips with lines in tblPalletReserved that are in status CHECKED

The results are combined into a Data Table with 2 columns:
PickingSlipNumber
PickingStrategyCode

Returns:
Response - Success
Response Result set to True
Response Object: Data Table of Picking Slips mentioned above or an empty table if nothing is found.
Response - Failure
Response Result set to False
Response Message - Error generated
Response Object: Empty Data Table

For a detailed overview on working with DATASCOPE PREMIUM WMS Business Objects, refer to https://datascopewms.atlassian.net/wiki/spaces/TG/pages/58130437

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

None

No Specification

Description

Business Object - Returns a list of Picking slips ready to be Shipped and/or Invoiced

Code

PICK011

Name

PicksToInvoiceQuery

Module

Picking

Functional Area

OrderPicking

Name Space/Class

DATASCOPE.SDK.BusinessObjects.Picking.OrderPicking

Release Date

03/07/2020

Release Version

v5.0.14.x

Prerequisites

None

SYSPRO Objects

None

Parameters

Name

Description

Mandatory field

Data Type

Default Value

Name

Description

Mandatory field

Data Type

Default Value

 

 

 

 

Technical Specification

<sample code>