Standard Json format for sales order through rest api

[jithendra]

I have a XLSX sheet which has the orders data…I want to read the xlsx and create the Sales Order using rest api…
what is the json format for successful creation of sales order…

Currently i have tried previously created Sales Order Json format ,But i am getting "ValidationError: Please enter ‘Expected Delivery Date’ " Error.

[KanchanChauhan]

Try this:

[
{
“advance_paid”: 0.0,
“company”: “_Test Company”,
“conversion_rate”: 1.0,
“currency”: “INR”,
“customer”: “_Test Customer”,
“customer_group”: “_Test Customer Group”,
“customer_name”: “_Test Customer”,
“delivery_date”: “2013-02-23”,
“doctype”: “Sales Order”,
“base_grand_total”: 1000.0,
“grand_total”: 1000.0,
“naming_series”: “_T-Sales Order-”,
“order_type”: “Sales”,
“plc_conversion_rate”: 1.0,
“price_list_currency”: “INR”,
“items”: [
{
“base_amount”: 1000.0,
“base_rate”: 100.0,
“description”: “CPU”,
“doctype”: “Sales Order Item”,
“item_code”: “_Test Item Home Desktop 100”,
“item_name”: “CPU”,
“parentfield”: “items”,
“qty”: 10.0,
“rate”: 100.0,
“warehouse”: “_Test Warehouse - _TC”,
“stock_uom”: “_Test UOM”,
“conversion_factor”: 1.0,
“uom”: “_Test UOM”
}
],
“selling_price_list”: “_Test Price List”,
“territory”: “_Test Territory”,
“transaction_date”: “2013-02-21”
}
]

[jithendra]

hi @KanchanChauhan
Thanks for the reply…i tried that format…Now I am getting following error

Traceback (most recent call last):
File “/home/jithendra/frappe-bench/apps/frappe/frappe/app.py”, line 61, in application
response = frappe.api.handle()
File “/home/jithendra/frappe-bench/apps/frappe/frappe/api.py”, line 116, in handle
data.update({
AttributeError: ‘list’ object has no attribute ‘update’

I am using following rest api “http://192.168.0.109:8000/api/resource/Sales Order” and “Post” method

[KanchanChauhan]

Please go through these links, might help you:

https://frappe.github.io/erpnext/current/models/selling/sales_order

Using rest api saving order

hi i am trying to insert sales invoice using rest api using https://frappe.github.io/erpnext/current/models/accounts/sales_invoice as guidelines the data i am sending is data{ “selling_price_list”:“Standard Selling”, “source”:“Existing Customer”, “posting_date”:“2016-09-26”, “due_date”:“2016-10-21”, “items”:{ “qty”:1, “stock_uom”:“Nos”, “warehouse”:“Finished Goods - PSM”, “item_name”:“product name”, “rate”:“100”, “amount”:100, “base_rate”:“100”, “item_code”:“sero-2469” }, “is…

[jithendra]

thanks @KanchanChauhan

Now i am passing this json;

{
“data”: {
“advance_paid”: 0.0,
“company”: “Merit System Private Limited”,
“conversion_rate”: 1.0,
“currency”: “INR”,
“customer”: “Mani V”,
“customer_group”: “Commercial”,
“customer_name”: “Mani V”,
“delivery_date”: “2017-03-28”,
“doctype”: “Sales Order”,
“base_grand_total”: 85490.0,
“grand_total”: 85490.0,
“naming_series”: “SO-”,
“order_type”: “Sales”,
“plc_conversion_rate”: 1.0,
“price_list_currency”: “INR”,
“items”: [{
“base_amount”: 85490.0,
“base_rate”: 85490.0,
“description”: “Lenovo Yoga 710 (14") Yoga 710 (14") 14" LAPTOP FOR ON-THE-GO CONNECTIVITY”,
“doctype”: “Sales Order Item”,
“item_code”: “Lenovo Yoga 710 (14") Yoga 710 (14") 14" LAPTOP FOR ON-THE-GO CONNECTIVITY”,
“item_name”: “Lenovo Yoga 710 (14") Yoga 710 (14") 14" LAPTOP FOR ON-THE-GO CONNECTIVITY”,
“parentfield”: “items”,
“qty”: 1.0,
“rate”: 85490.0,
“warehouse”: “Finished Goods - MSPL”,
“stock_uom”: “Unit”,
“conversion_factor”: 1.0,
“uom”: “Unit”
}],
“delivery_date”: “2017-03-30”,
“selling_price_list”: “Standard Selling”,
“territory”: “India”,
“transaction_date”: “2017-03-22”,
“cust_address”:“Mani V”
}
}

As you can see i am passing “delivery_date” but i am getting error “ValidationError: Please enter ‘Expected Delivery Date’”

Please help with this

[KanchanChauhan]

You are sending in delivery_date twice. Can you delete one of it.

[jithendra]

@KanchanChauhan
Ya ,i have deleted it…that error still persists…

if i pass json in the below format

{
“advance_paid”: 0.0,
“company”: “Merit System Private Limited”,
“conversion_rate”: 1.0,
“currency”: “INR”,
“customer”: “Mani V”,
“customer_group”: “Commercial”,
“customer_name”: “Mani V”,
“delivery_date”: “2017-03-28”,
“doctype”: “Sales Order”,
“base_grand_total”: 85490.0,
“grand_total”: 85490.0,
“naming_series”: “SO-”,
“order_type”: “Sales”,
“plc_conversion_rate”: 1.0,
“delivery_date”: “2017-03-29”,
“price_list_currency”: “INR”,
“items”: [{
“base_amount”: 85490.0,
“base_rate”: 85490.0,
“description”: “Lenovo Yoga 710 (14") Yoga 710 (14") 14" LAPTOP FOR ON-THE-GO CONNECTIVITY”,
“doctype”: “Sales Order Item”,
“item_code”: “Lenovo Yoga 710 (14") Yoga 710 (14") 14" LAPTOP FOR ON-THE-GO CONNECTIVITY”,
“item_name”: “Lenovo Yoga 710 (14") Yoga 710 (14") 14" LAPTOP FOR ON-THE-GO CONNECTIVITY”,
“parentfield”: “items”,
“qty”: 1.0,
“rate”: 85490.0,
“warehouse”: “Finished Goods - MSPL”,
“stock_uom”: “Unit”,
“conversion_factor”: 1.0,
“uom”: “Unit”
}],

"selling_price_list": "Standard Selling",
"territory": "India",
"transaction_date": "2017-03-22",
    "cust_address":"Mani V"

}

i.e removing one braces (extra object)…i will get following error

Traceback (most recent call last):
File “/home/jithendra/frappe-bench/apps/frappe/frappe/app.py”, line 61, in application
response = frappe.api.handle()
File “/home/jithendra/frappe-bench/apps/frappe/frappe/api.py”, line 120, in handle
“data”: frappe.get_doc(data).insert().as_dict()
File “/home/jithendra/frappe-bench/apps/frappe/frappe/model/document.py”, line 194, in insert
self._validate()
File “/home/jithendra/frappe-bench/apps/frappe/frappe/model/document.py”, line 401, in _validate
self._validate_links()
File “/home/jithendra/frappe-bench/apps/frappe/frappe/model/document.py”, line 626, in _validate_links
invalid_links, cancelled_links = self.get_invalid_links()
File “/home/jithendra/frappe-bench/apps/frappe/frappe/model/base_document.py”, line 494, in get_invalid_links
setattr(self, df.fieldname, values.name)
AttributeError: ‘NoneType’ object has no attribute ‘name’

[jithendra]

@KanchanChauhan : As you suggested we have tried with all the solution but still error persist. @makarand_b can you clear about this .

[makarand_b]

@jithendra,

following simple post request for sales order worked for me

URL: http://localhost:8000/api/resource/Sales Order
Data: data ={
	"customer": "Customer",
	"delivery_date": "2017-03-22",
	"items": [{
		"item_code": "Item code",
		"qty": 2,
		"rate": 200002
	}]
}
Thanks,
Makarand

[jithendra]

Hi @makarand_b

My url : http://192.168.0.109:8000/api/resource/Sales Order
my json data : {
“customer”: “Mani V”,
“delivery_date”: “2017-03-30”,
“cust_address”: “Mani V”,
“items”: [{
“item_code”: “Lenovo Yoga 710 (14") Yoga 710 (14") 14" LAPTOP FOR ON-THE-GO CONNECTIVITY”,
“qty”: 2,
“rate”: 90000
}]
}

But I am Still getting the same error

  	Server Error

Traceback (most recent call last):
File “/home/jithendra/frappe-bench/apps/frappe/frappe/app.py”, line 61, in application
response = frappe.api.handle()
File “/home/jithendra/frappe-bench/apps/frappe/frappe/api.py”, line 120, in handle
“data”: frappe.get_doc(data).insert().as_dict()
File “/home/jithendra/frappe-bench/apps/frappe/frappe/model/document.py”, line 194, in insert
self._validate()
File “/home/jithendra/frappe-bench/apps/frappe/frappe/model/document.py”, line 401, in _validate
self._validate_links()
File “/home/jithendra/frappe-bench/apps/frappe/frappe/model/document.py”, line 626, in _validate_links
invalid_links, cancelled_links = self.get_invalid_links()
File “/home/jithendra/frappe-bench/apps/frappe/frappe/model/base_document.py”, line 494, in get_invalid_links
setattr(self, df.fieldname, values.name)
AttributeError: ‘NoneType’ object has no attribute ‘name’

if i use
URL: http://localhost:8000/api/resource/Sales Order
instead of URL : http://192.168.0.109:8000/api/resource/Sales Order
I will get the error as

		Not Permitted

You do not have enough permissions to complete the action

[D_N_Srinath]

hi @makarand_b can u please tell that, do we need to write separate api for retrieving data from database. If yes, how to write and how to integrate this api to erpnext. I’m new to erpnext, if i get reply it will more helpful for me.

Thanks in advance

[vignesh_b]

How can i set value for table multiselect(Two values)

[clarkej]

Welcome to ERPNext @vignesh_b

Have you found and tried these for clues and pointers?

How to add Multiselect dropdown?

Hi Team, In Item doc there is one custom field that is company,when user create a new item he want to select company but right now he can only select one company .i want to multiple companies here so how this acheived?can any one help me for this ? [New%20Item%201%20-%20New%20Item%201%20(1)] how select multiple company here? Thanks

Table MultiSelect feature (sponsored by Seibert Media)

Dear All, Happy to share that Seibert Media (@Martin_Seibert) has sponsored the development of Table MultiSelect feature. This was frequently requested by many community members as this is very intuitive and quick and results in better user experience. [Search results for 'multi select' - ERPNext Forum] Instead of a child table and ‘Add Row’ button, you can simply select multiple values in the same field. This feature has been developed by @netchampfaris and is available in the latest devel…

If you remain stuck, start a new thread with specific details, that may get you pointers to try…

[vignesh_b]

I cant able to set default data for tablemultiselect field in install_fixtures.py can anybody help me

{‘doctype’:‘Default Data Setup’,
‘default_name’:_(‘Default Data’),
‘date’:“2020-05-28”,
‘email’:“vignesh@gmail.com”,
‘date_time’:“2020-05-28 06:15:26.021900”,
‘select’:“External”,
‘time’:“06:15:26”,
‘currency’:“USD”,
‘password’:“123”,
“mobile”:“987654321”,
‘is_company’:1,
‘rating’:3,
‘percent’:“99”,
‘read’:“Hello”,
‘naming_series’:“80000”,
‘image_3’:“/assets/erpnext/images/erp-icon2.svg”,
“table_multi”:“”
},

[aliriocastro]

Hello,

It seems you are not performing the request correctly.

Must be a POST request with form-data and key name data.