Hi Anil ,
Thanks for the quick response, I tried with "“1"” as well and it didn’t worked, just for the reference i am attaching the Json, where field is to be updated.
{
"data": {
"name": "SAL-ORD-2023-00001",
"owner": "Guest",
"creation": "2023-10-04 18:49:43.131098",
"modified": "2023-11-25 09:32:12.652036",
"modified_by": "admin@leaffarms.net",
"docstatus": 1,
"idx": 0,
"title": "{customer_name}",
"naming_series": "SAL-ORD-.YYYY.-",
"customer": "PF-PASSION FRUIT LLC",
"customer_name": "PF-PASSION FRUIT LLC",
"order_type": "Sales",
"posted_in_qb": 0,
"transaction_date": "2023-10-04",
"delivery_date": "2023-10-04",
"company": "Leaf Farms",
"skip_delivery_note": 0,
"currency": "USD",
"conversion_rate": 1,
"selling_price_list": "Standard Selling",
"price_list_currency": "USD",
"plc_conversion_rate": 1,
"ignore_pricing_rule": 0,
"total_qty": 340,
"total_net_weight": 0,
"base_total": 0,
"base_net_total": 0,
"total": 0,
"net_total": 0,
"tax_category": "",
"exempt_from_sales_tax": 0,
"base_total_taxes_and_charges": 0,
"total_taxes_and_charges": 0,
"base_grand_total": 0,
"base_rounding_adjustment": 0,
"base_rounded_total": 0,
"base_in_words": "USD Zero only.",
"grand_total": 0,
"rounding_adjustment": 0,
"rounded_total": 0,
"in_words": "USD Zero only.",
"advance_paid": 0,
"disable_rounded_total": 0,
"apply_discount_on": "Grand Total",
"base_discount_amount": 0,
"additional_discount_percentage": 0,
"discount_amount": 0,
"customer_address": "PF #26-1-Shipping",
"address_display": "1305 W Dr Martin Luther King Jr Blvd<br>\nUnit 1<br>Plant City, FL 33563<br>",
"customer_group": "Commercial",
"territory": "United States",
"shipping_address_name": "PF #1-Shipping",
"shipping_address": "6711 Bland St<br>\nSpringfield, VA 22150<br>",
"status": "Draft",
"delivery_status": "Not Delivered",
"per_delivered": 0,
"per_billed": 0,
"per_picked": 0,
"billing_status": "Not Billed",
"amount_eligible_for_commission": 0,
"commission_rate": 0,
"total_commission": 0,
"loyalty_points": 0,
"loyalty_amount": 0,
"group_same_items": 0,
"language": "en",
"is_internal_customer": 0,
"doctype": "Sales Order",
"taxes": [],
"pricing_rules": [],
"packed_items": [],
"payment_schedule": [
{
"name": "5d81c448d6",
"owner": "Guest",
"creation": "2023-10-04 18:49:43.626406",
"modified": "2023-11-25 09:32:12.652036",
"modified_by": "admin@leaffarms.net",
"docstatus": 1,
"idx": 1,
"due_date": "2023-10-04",
"invoice_portion": 100,
"discount": 0,
"payment_amount": 0,
"outstanding": 0,
"paid_amount": 0,
"discounted_amount": 0,
"base_payment_amount": 0,
"parent": "SAL-ORD-2023-00001",
"parentfield": "payment_schedule",
"parenttype": "Sales Order",
"doctype": "Payment Schedule"
}
],
"items": [
{
"name": "11f1735c47",
"owner": "Guest",
"creation": "2023-10-04 18:49:43.131098",
"modified": "2023-11-25 09:32:12.652036",
"modified_by": "admin@leaffarms.net",
"docstatus": 1,
"idx": 14,
"item_code": "WM",
"ensure_delivery_based_on_produced_serial_no": 0,
"delivery_date": "2023-10-04",
"item_name": "WINTER MELON",
"description": "WM",
"item_group": "Products",
"image": "",
"qty": 4,
"stock_uom": "Nos",
"uom": "Nos",
"conversion_factor": 1,
"stock_qty": 4,
"price_list_rate": 0,
"base_price_list_rate": 0,
"margin_type": "",
"margin_rate_or_amount": 0,
"rate_with_margin": 0,
"discount_percentage": 0,
"discount_amount": 0,
"base_rate_with_margin": 0,
"rate": 0,
"amount": 0,
"base_rate": 0,
"base_amount": 0,
"stock_uom_rate": 0,
"is_free_item": 0,
"grant_commission": 1,
"net_rate": 0,
"net_amount": 0,
"base_net_rate": 0,
"base_net_amount": 0,
"billed_amt": 0,
"valuation_rate": 0,
"gross_profit": 0,
"delivered_by_supplier": 0,
"weight_per_unit": 0,
"total_weight": 0,
"warehouse": "Stores - LF",
"against_blanket_order": 0,
"blanket_order_rate": 0,
"projected_qty": 0,
"actual_qty": 0,
"ordered_qty": 0,
"planned_qty": 0,
"production_plan_qty": 0,
"work_order_qty": 0,
"delivered_qty": 0,
"produced_qty": 0,
"returned_qty": 0,
"picked_qty": 0,
"page_break": 0,
"item_tax_rate": "{}",
"transaction_date": "2023-10-04",
"parent": "SAL-ORD-2023-00001",
"parentfield": "items",
"parenttype": "Sales Order",
"doctype": "Sales Order Item"
}
],
"sales_team": []
}
}
