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 Sales Order API
DrillDown Icon Sales Order
DrillDown Icon Add
DrillDown Icon Edit
DrillDown Icon Get
DrillDown Icon Sales Order Item
DrillDown Icon Sales Order Item Price
DrillDown Icon Sales Order Item Due Date
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
 
Add

Functions

Add API is used to add a new sales order

URL:{Root URL}/API/SO/Add/{API Key}

Parameters

Parameter Description Required Comment
SoNo Sales Order Number Y Must be Unique. When adding a new sales order can be left blank. 
custNo Customer Number Y Ten digits, padded to the left with '0'
blinkAdd Billing Link N >
slinkAdd Shipping Address Link N
orderDate Order Date Y Defaults to the Current date. Can be changed using MM-DD-YYYY forma
POAck Purchase Order Acknowledgement N Can be 1 or 0
PoNo Purchase Order Number N Enter the purchase order number related to the sales order.
SONote Sales Order Note N User Input
FOB FOB N Can be ORIGIN-CUSTOMER P/U, ORIGIN-SHIP, DESTINATION
ShipVia Ship Via N Defaults with customer. Can be 'COMPANY TRUCK', 'CUST PICK UP', 'UPS-GRND TRACK', 'UPS-BLUE', 'UPS-RED', 'FEDX-P1', 'FEDX-STD'.
shipCharge Shipping Charge N Can be NO CHARGE, PREPAY/BILL CUS, SET RATE:UPS-BR, SET RATE:UPS-BL, SET RATE:UPS-RD, FEDX-1
SoFoot  Sales Order Footnote N User Entry, attaches a footnote to the Sales Order
DELIV_TIME Delivery Time N
Buyer Buyer Name N Must be a pre-existing customer.
ATTENTION Attention Person N Must Be a contact for the customer.
SOAMTDSCT Sales Order Discount N
SOAPPROVAL Sales Order Approval N Can be 0 or 1. If 1 must enter SOAPPRVINIT
SOAPPRVINIT Sales Order Approval Initial N Must be an approved user's initial.
SOAPPRVDT Sales Order Approval Date N System automatically uses the current date.
ACKPO_DOC Acknowledge PO Doc N Adds a PO acknowledge doc
TERMS Terms N Defaults from customer info, can be changed by user.
BILLACCOUNT Bill Account N System uses default from customer information, can be changed by user.

Example Strings

New Sales Order, No items

URL- ?SoNo=SONO?custNo=CUSTNO

JSON-

{

'SoNo':'SONO',

'custNo':'CUSTNO'

}

A successful add returns the following

{

"$id":"1",

"Code":200,

"Message":"Sales Order added successfully.",

"SessionId":null,

"IsValidUser":true,

"ResponseObject":null

}

Common Errors

URL Error

If there is a problem with 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/SOAdd/123456789'.",

"MessageDetail": "No type was found that matches the controller named 'SOAdd'."

}

API Key Error

{

"$id": "1",

"Code": 403,

"Message": "Invalid API Key.",

"SessionId": null,

"IsValidUser": false,

"ResponseObject": null

}

Parameter Error

If there is an error with a parameter the system will return an error message detailing the error.

{

"$id": "1",

"Code": 403,

"Message": "Sales Order add failed.Customer does not exists.",

"SessionId": null,

"IsValidUser": true,

"ResponseObject": null

}

Article ID: 5757