EliatpobService

EliatpobService

EliatpobService.asmx

This web service has a method for ATP (available to promise) inquiry.

 

ATPInquiry

This method returns ATP information for an item.

Usage:

ATPInquiryResult = A.ATPInquiry(UserName, UserPassword, ITEM_NO, LOC_CODE, Source)

Parameters UserName and UserPassword are not used at this moment.

 

Input Parameter

Parameter

Length

Type

Upper

Detail

ITEM_NO

15

String

Y

Required.

LOC_CODE

2

String

Y

If this field is blank, this method will summarize quantities from all locations.

Source

1

String

Y

Must be “S,” “P,” “B,” “F,” or blank. If this field is blank, this method will include all sources.

 

ATPInquiryResult Structure

Property

Type

Detail

ReturnCode

Integer

Contains return code. Zero means OK; for other return codes, please see “ElievprcService Return Code” section.

ReturnMsg

String

This is description of return code. For example, if return code is zero, you can expect “OK” in this field.

ITEM_PRICE

Double

 

ITEM_QTY_ON_HAND

Double

 

ITEM_QTY_ALLOC

Double

 

ITEM_QTY_ON_ORDER

Double

 

ATPRecord

DataSet

This data set has a data table "ATPRecords" which contains up to 1000 records with the following columns:

IM_ATP_TRX_DATE (data type: Date)

CustVendNo (data type: String)

RefName (data type: String)

IM_ATP_REC_TYPE (data type: String)

OrderNo (data type: String)

IM_ATP_LOCATION (data type: String)

IM_ATP_QTY_OPEN (data type: Double)

 

Code Example

The following sample code will return ATP information for item number “049” in location “P.”

 

Dim Service As New webServicesatpob.EliatpobService

Dim Result As New webServicesatpob.ATPInquiryResult

Dim ITEM_NO As String = “049”

Dim LOC_CODE As String = “P”

Result = Service.ATPInquiry(“”, “”, ITEM_NO, LOC_CODE, “”)

If Result.ReturnCode = 0 Then

   lblResult.Text = “ATP location: ” + _

   Result.ATPRecord.Tables(0).Rows(0).Item("IM_ATP_LOCATION")

Else

  lblResult.Text = “Error”

   lblErrorCode.Text = Result.ReturnCode.ToString

End If

 

EliatpobService Return Code

0 = OK                               

1 = File Error                       

2 = Item No Missing                   

3 = Table Size Must be <= 1000       

4 = Item Not On File                 

5 = Location Not On File             

6 = Source Invalid (Space, S, B, P, F)

CLS




    • Related Articles

    • Introduction to Available to Promise (ATP)

      Release Date - 6/12/17 What is ATP? ATP (Available to Promise) is an Elliott database that merges all future transactions like sales orders, purchase orders and production orders. It expands the simple quantity allocated and quantity on order ...

    • Feature - Reorder Advice/User Defined CSV Export Example 2 - ATP (Available to Promise)

      Release Date: 08/07/2020 Version: 8.0 & Up Example 2 - ATP (Available to Promise) ATP is a major feature in Elliott that is used to project future inventory balance. The idea of ATP is that the Qty Allocated (or what we call requirement) is a lump ...

    • IM0405 Inventory Management Available To Promise Inquiry

      Available To Promise Inquiry Application Overview This is a powerful tool that is fast and easy to use. Order entry and sales people can use this inquiry to determine future item deliveries, the purchasing manager can use it to plan purchase orders, ...

    • IMATPRSN Inventory Management Available to Promise Report

      Available To Promise Report Application Overview Information for this report comes from the ATP Open Item file, which merges order information from COP, IM, PO, BOMP, and SFC. Order entry and sales people can use this report to determine future item ...

    • The Lessons We Learned from Upgrading Web Service 8.2 to 8.5 in eStore

      Elliott Web Service 8.5 changed ORDER_NO, INV_NO, and other keys from numeric to alphanumeric to accommodate a bigger range. This results in changes in the Web Service interface. This article documents our experience when we upgraded the Web Service ...