ArticlesArticles Most Helpful ArticlesMost Helpful Articles Language SettingsLanguage Settings LoginLogin
RSS Feeds
DrillDown Icon Table of Contents Back
 . . . . . . . . . . . . .
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 Purchase Order API
DrillDown Icon PO Main API
DrillDown Icon PO Main Add
DrillDown Icon PO Main Edit
DrillDown Icon PO Main Get
DrillDown Icon PO Items API
DrillDown Icon PO Schedule 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
  Email This ArticlePrint PreviewPrint Current Article and All Sub-Articles
 
PO Main Add

The PO add function is used to add a new PO. An item must be added to the PO tables as well. Scheduling does not need to be added at this point.

URL-{Root URL}/api/PO/Add/{API KEY}

Parameters

Parameter Description Required Comment
supName Supplier Name Y  
confirmName Confirm Name N User Input, No validation
poDate Purchase order date. N If not entered manually will default to today’s date
FreightIncluded Freight Included N Can be 1 or 0, default is 0.
buyerName Name of the Buyer N Has to be entered in the following format [LastName, FirstName]. Must be a buyer in the system.
remitToLink The link to the Remit to address N If entered it must be a valid link.
confirmToLink The link to the Confirm to Address N
receiveToLink The link to the receiving address N If entered it must be a valid link
deliveryTime The delivery time for the receiving address N Must be in a 24 hour format, e.g. ‘13:00’
Terms Payment terms for the supplier. N Can be NET 10, NET 15, NET 30, NET 30/2% 10, NET 45, COD, NONE
FOB   N  
shipVia The method of shipping N  
shipCharge
N  
shippingAmount   N Default 0, Entered manually
isShippingTaxable Choose whether or not the shipping is taxable N Can be 0 or 1, default 0
shippingTaxPct The amount of the shipping tax N Default 0.00. If a value is entered here isShippingTaxable must be set as 1
billToLink This links the record to the supplier's billing address. N If entered, it has to be a valid link.
POItemsList N 
POITTYPEPurchase Order Item Type
YCan be INVT PART, MRO, or Services
part_no
Part Number
Y
Used to choose a part
UNIQ_KEY
Part Identifier Key
N
Can be used instead of part number and revision
RevPart Revision
NRequired if Part_no is used
UniqMfgrhdManufacturer Key
NCan be used in place of partmfgr and mfgr_pt_no
PARTMFGRPart Manufacturer
NCan be used to specify a manufacturer for a part. Must be an existing manufacturer for the part
MFGR_PT_NOManufacturer Part Number
NCan be used instead of part_no to choose an item
ORD_QTYOrder Qty
YThe amount ordered
PoitschdList N 
SCHD_QTYScheduled Qty
NMust be equal to or less than order quantity
SCHD_DATESchedule DateNWill default to current date or enter in MM-DD-YYYY format

Example PO Add String-

URL-{Root URL}/api/PO/Add/{API Key}

JSON

{

"supName":supName",

"PoItemsList":

[{

"POITTYPE":"POITTYPE",

"UNIQ_KEY":"UNIQ_KEY",

"part_no":"part_no",

"Rev":"Rev",

"UniqMfgrhd":"UniqMfgrhd",

"PARTMFGR":"PARTMFGR",

"MFGR_PT_NO":"MFGR_PT_NO",

"ORD_QTY":"ORD_QTY",

"PoitschdList":

[{

"SCHD_QTY":"SCHD_QTY",

"SCHD_DATE":"SCHD_DATE"

}]

}]

}

Article ID: 5786