ArticlesArticles Most Helpful ArticlesMost Helpful Articles Language SettingsLanguage Settings LoginLogin
RSS Feeds
DrillDown Icon Table of Contents Back
 . . . . . . . . . . . . .
DrillDown Icon MX
DrillDown Icon MANUALS and Other Info for SQL MANEX Client Server
DrillDown Icon Hardware and Software Requirements for Installing SQL Server
DrillDown Icon List of Modules Converted to MANEX Client Server
DrillDown Icon Installing SQL Server
DrillDown Icon System Administrator
DrillDown Icon SQL Backup Options
DrillDown Icon Setup the OLE DB(ADO) for SQL Crystal Reports
DrillDown Icon APIs
DrillDown Icon Item Master
DrillDown Icon Work Order API
DrillDown Icon KIT API
DrillDown Icon Shop Floor Tracking API
DrillDown Icon Inventory Handling API
DrillDown Icon Inventory Handling Receive API
DrillDown Icon Inventory Handling Transfer API
DrillDown Icon Inventory Handling Issue API
DrillDown Icon Purchase Order API
DrillDown Icon Sales Order API
DrillDown Icon Customer API
DrillDown Icon Q & A API's
DrillDown Icon Code that could be used to find Last Table Modified within SQL
DrillDown Icon Configure SQL Server 2008 R2 to allow Network Connections
DrillDown Icon How to detach and attached databases using the SQL Server Management Studio
DrillDown Icon Restore SQL DB from Backup
DrillDown Icon Setup a SQL Test/Sandbox Database
DrillDown Icon SQLManex Client Server Setup Instructions
DrillDown Icon Setup Folder Permissions to Write "ini" File
DrillDown Icon Setup the ODBC for SQL Crystal Reports
DrillDown Icon Setup a SQL Database Maintenance Plan
DrillDown Icon Setup Task Scheduler to Auto Run MRP
DrillDown Icon Selecting the Authentication Mode
DrillDown Icon Window 10 - Network Disconnect
DrillDown Icon Setup Work Stations
DrillDown Icon Security System
DrillDown Icon Accounting Setup
DrillDown Icon System Setup
DrillDown Icon Operations Manuals
DrillDown Icon System Utilities
DrillDown Icon SQL Server Memory Settings and Performance
DrillDown Icon Definitions
DrillDown Icon How to schedule and automate backups of SQL Server databases in SQL Server Express
DrillDown Icon SQL_FAQ's
DrillDown Icon Customer Relationship Management (CRM)
DrillDown Icon ManEx Minute
DrillDown Icon ManEx Component Exchange
DrillDown Icon ManEx Supplier Directory & Rankings
  Email This ArticlePrint PreviewPrint Current Article and All Sub-Articles
 
Inventory Handling Receive API

Functions

Receiving API is used to receive items into Inventory.

URL: {Root URL}/API/InventoryHandling/receive/{API Key}

Parameters

Parameters Description Required Comment
Part_sourc Source of the Part Y Can be 'MAKE', 'BUY', or 'CONSG'
uniq_key Use to identify the part Y When uniq_key is used you do not need part_no
part_no Part number you wish to transfer Y Part_no can be used if you do not have the uniq_key
revision Part revision level N Required when you use part_no if the part has a revision
custpartno Customer Part Number N Use instead of part_no if the part_sourc is CONSG
custrev Customer revision level N Required if custpartno is used and the part has a revision
Partmfgr Part Manufacturer N Used to specify part manufacturer
Mfgr_pt_no Manufacturer part number N Used with partmfgr
Uniqmfgrhd Manufacturer identification N Can be used in place of partmfgr and mfgr_pt_no.
Warehouse Warehouse Name Y Choose which warehouse the part will be received into.
Location Location Name N Used when the part is being received into a specific location in the warehouse.
Uniqwh Warehouse identifier Y Choose which warehouse the part will be received into. Can be used in place of warehouse. Needs location.
WhNo Warehouse Number Y Choose which warehouse the part will be received into. Can be used in place of warehouse and uniqwh. Needs location.
W_Key Inventory Unique Identifier Key Y Choose which warehouse the part will be received into.
LotcodeAndSerialNo
Lot Code or Serialized N Required if the part is lotcoded or Serialized
expDate Expiration Date N Required if the part is lot coded. Use MM-DD-YYYY format.
internalLotReference Internal Lot Reference N Only needed if the part is lot coded
cserialNo Serial No N Required of the part is serialized
QtyRec Received Quantity Y The amount of the part you are receiving
qtyPerPackage
Reason Reason for transfer Y Can be: 'BEGINNING RAW MATL. INV.', 'CONSIGNED MATERIAL', 'FREE SAMPLES', 'MATERIAL ON TRIAL', 'REPAIR RETURN FROM VENDOR', 'WARRANTY REPLACEMENT'
gl_nbr General Ledger Number Y Used to add a record of the transaction to the general ledger
transactionReference Transaction Reference Y User defined field

Example Strings

No Lot Code, No Serialization

URL- ?part_sourc=BUY&part_no=PARTNUMBER&revision=REVISION&W_Key=WKEY&QtyRec=1&reason=CONSIGNED MATERIAL&TransactionReference=New Customer Inventory&Gl_Nbr=GENERALLEDGERNUMBER

JSON-

{

'part_sourc':'BUY',

'part_no':'PARTNUMBER',

'revision':'REVISION',

'W_Key':'WKEY',

'QtyRec':'1',

'reason':'CONSIGNED MATERIAL',

'transactionReference':'New Customer Inventory',

'Gl_Nbr':'GENERALLEDGERNUMBER'

}

Lot Code, Serialization

URL- ?part_sourc=BUY&UNIQ_KEY=UNIQKEY&LotCodeAndSerialNo=LOTCODE@SERIALNUMBER&EXPDATE=MM-DD-YYYY&W_Key=WKEY&QtyRec=1&reason=CONSIGNED MATERIAL&transactionReference=New Customer Inventory&Gl_Nbr=0000000-00-00

JSON-

{

'part_sourc':'BUY',

'UNIQ_KEY':'UNIQKEY',

'lotCodeAndSerialNo':'LOTCODE@SERIALNUMBER',

'EXPDATE':'MM-DD-YYYY',

'W_Key':'WKEY',

'QtyRec':'1',

'reason':'CONSIGNED MATERIALS',

'transactionReference':'New Customer Inventory',

'Gl_Nbr','0000000-00-00'

}

 

Lot Code with Multiple Serial Numbers 

"LotcodeAndSerialNo":"LotCode1@1230120,234455,33333" 

 

Lot Code, No Serialization

Example 1: user provides uniq_key, uniqmfgrhd, no part-no and no mpn

{
 "Part_Sourc":"BUY",
    "uniq_key":"_01F15SZAH",
    "uniqmfgrhd":"_01F15T9BZ",
    "WareHouse" :"MAIN1",
    "Location":"",
    "QtyRec":"16",
    "expDate":"09/04/2017",
 "REFERENCE":"test21",
    "GL_NBR":"1430000-00-00",
    "LotcodeAndSerialno":"Lot-10"

}
Example 2:  User provides uniq_key, uniqmfgrhd, and mpn

{
 "Part_Sourc":"BUY",
    "uniq_key":"_01F15SZAH",
    "uniqmfgrhd":"_01F15T9BZ",
    "partmfgr":"AVX",
    "WareHouse" :"MAIN1",
    "Location":"",
    "QtyRec":"15",
    "mfgr_pt_no":"CR10-2610FT",
 "expDate":"09/04/2017",
 "REFERENCE":"test21",
    "GL_NBR":"1430000-00-00",
    "LotcodeAndSerialno":"Lot-09"
}
Example 3:  user provides Part_no, revision, MPN, no uniq_key,uniqmfgrhd

{
 "Part_Sourc":"BUY",
    "Part_No":"101-0001707",
    "Revision":"",
    "partmfgr":"AVX",
    "WareHouse" :"MAIN1",
    "Location":"",
    "QtyRec":"1",
    "mfgr_pt_no":"CR10-2610FT",
   "expDate":"09/04/2017",
   "REFERENCE":"test21",
    "GL_NBR":"1430000-00-00",
    "LotcodeAndSerialno":"Lot-09"
}

 

No Lot Code, Serialized

URL- ?Part_sourc=BUY&part_no=PARTNUMBER&lotcodeAndSerialNo=000000000000000000000000000000&W_KEY=WKEY&QtyRec=1&reason=CONSIGNED MATERIAL&transactionReference=New Customer Inventory&Gl_Nbr=0000000-00-00

JSON

{

'part_sourc':'BUY',

'part_no':'PARTNUMBER',

'lotCodeAndSerialNo':'000000000000000000000000000000',

'W_Key':'WKEY',

'QtyRec':'1',

'reason','CONSIGNED MATERIAL',

'transactionReference':'New Customer Inventory',

'Gl_Nbr':'0000000-00-00'

}

Successful requests should return the following:

{

"$id":"1",

"Code":200,

"Message":"Inventory added successfully.",

"SessionId":null,

"IsValidUser":true,

"ResponseObject":null

}

Common Errors

API Key Error

If there is an error with the entered API key the system will return an error describing it.

{

"$id": "1",

"Code": 403,

"Message": "Invalid API Key.",

"SessionId": null,

"IsValidUser": false,

"ResponseObject": null

}

Incorrect Parameter

If an incorrect parameter value is used the system will return an error describing the incorrect parameter.

{

"$id": "1",

"Code": 403,

"Message": "Failed:Please provide valid GL_NBR.",

"SessionId": null,

"IsValidUser": true,

"ResponseObject": null

}

 

The GL_nbr parameter for the "Receive" API has to be on the list for the Inventory Handling GL Defaults for  'Receiving'. 



URL Error

If there is an error within the URL the system will return a HTTP error.

{

"$id": "1",

"Message": "No HTTP resource was found that matches the request URI 'http://localhost/api/InventoryHandling/Receiv/123456789'.",

"MessageDetail": "No action was found on the controller 'InventoryHandling' that matches the name 'Receiv'."

}

 

​Keep in mind that if you were to create a new location when transferring you need the following checked.

Inventory Control Management Module, the MFGR that you creating the new location under, needs to have "Allow Auto Creating Location at Receiving" checked.  


Under Sql Setting the warehouse you are receiving into also needs " Allow Auto Create Location at Receiving" checked. 

Article ID: 5745